<%@page import="java.util.*"%>
<%@include file="mycon.jsp" %>
<%
String[] weight = request.getParameterValues("weight");
int[] a = (int[]) session.getAttribute("qarray");
int[] b = (int[]) session.getAttribute("qnarray");
double nweight[] = new double[500];
char cat[] = new char[50];
char cat1[] = {'a','b','c','d','e','f','g'};
char cat2[]={'k','l','m','n','o','p'};
int n = 0;
int count = 0, k = 0;
double sum = 0;
double sum1 = 0;
double[] avg = new double[50];
double[] rlb_avg = new double[50];
for (int i = 0; i < a.length; i++) {
if (a[i] == 0) {
break;
}
cat[i] = (char) (65 + i);
n++;
}
/* for (int i = 0; i < n - 1; i++) {
System.out.println(cat[i]);
}*/
out:
for (int i = 0; i < b.length; i++) {
if (b[i] == 0) {
break out;
}
nweight[b[i] - 1] = Double.parseDouble(weight[i]);
}
for (int i = 0; i < n - 1; i++) {
count = 0;
sum = 0;
for (int idx = a[i]; idx < a[i + 1]; idx++) {
if (Double.parseDouble(weight[idx - 1]) != 0) {
count++;
sum = sum + Double.parseDouble(weight[idx - 1]);
}
}
if (count != 0) {
avg[i] = sum / count;
} else {
avg[i] = 0.0;
}
}
/* for (int j = 0; j < 30; j++) {
System.out.println(b[j]+","+nweight[j]);
}*/
System.out.println("Average");
System.out.println(avg[0]);
System.out.println(avg[1]);
System.out.println(avg[2]);
System.out.println(avg[3]);
System.out.println(avg[4]);
System.out.println(avg[5]);
PreparedStatement ps = null;
ResultSet rs = null;
String sql = null;
for (int i = 0; i < n - 1; i++) {
count = 0;
sum1 = 0;
for (int idx = a[i]; idx < a[i + 1]; idx++) {
if ((nweight[idx - 1]) != 0) {
count++;
sum = 0.0;
sql = "Select * from effect where Qno = '" + b[k] + "'";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
if (Integer.parseInt(rs.getString(4)) == 1) {
sum = sum + (nweight[rs.getInt(3) - 1]);
} else {
sum = sum - (nweight[rs.getInt(3) - 1]);
}
}
sum1 = sum1 + sum;
}
k++;
}
if (count != 0) {
rlb_avg[i] = sum1 / count;
} else {
rlb_avg[i] = 0.0;
}
}
System.out.println("Effect Average");
System.out.println(rlb_avg[0]);
System.out.println(rlb_avg[1]);
System.out.println(rlb_avg[2]);
System.out.println(rlb_avg[3]);
System.out.println(rlb_avg[4]);
System.out.println(rlb_avg[5]);
float t_rlb[] = new float[50];
System.out.println("Total Average");
for (int j = 0; j < n - 1; j++) {
t_rlb[j] = (float) (avg[j] + rlb_avg[j]);
System.out.println(t_rlb[j]);
}
float t_qtoq[] = new float[50];
int l = 0;
for (int j = 0; j < n - 1; j++) {
String sql1 = "Select * from qtoq where QAno='" + cat[j] + "'";
PreparedStatement ps1 = con.prepareStatement(sql1);
ResultSet rs1 = ps1.executeQuery();
l = 0;
while (rs1.next()) {
t_qtoq[j] = t_qtoq[j] + t_rlb[l] * Float.parseFloat(rs1.getString(4));
l++;
// System.out.println(t_qtoq[j]);
}
}
System.out.println("Quality to Quality");
for (int i = 0; i < n - 1; i++) {
System.out.println(t_qtoq[i]);
}
float t_qtot[] = new float[7];
for (int j = 0; j < 7; j++) {
String sql1 = "Select * from qtot where TCno='" + cat1[j] + "'";
PreparedStatement ps2 = con.prepareStatement(sql1);
ResultSet rs2 = ps2.executeQuery();
l = 0;
while (rs2.next()) {
t_qtot[j] = t_qtot[j] + t_qtoq[l] * Float.parseFloat(rs2.getString(4));
l++;
// System.out.println(t_qtoq[j]);
}
}
System.out.println("Quality to Tactic");
for (int i = 0; i < 7; i++) {
System.out.println(t_qtot[i]);
}
float t_ttoas[] = new float[6];
for (int j = 0; j < 6; j++) {
String sql1 = "Select * from ttoas where ASno='" + cat2[j] + "'";
PreparedStatement ps3 = con.prepareStatement(sql1);
ResultSet rs3 = ps3.executeQuery();
l = 0;
while (rs3.next()) {
t_ttoas[j] = t_ttoas[j] + t_qtot[l] * Float.parseFloat(rs3.getString(4));
l++;
// System.out.println(t_qtoq[j]);
}
}
System.out.println("Tactict to Arch.......");
for (int i = 0; i < 6; i++) {
System.out.println(t_ttoas[i]);
}
session.removeAttribute("qarray");
session.removeAttribute("qnarray");
%>
<!--
for(Object obj : list){
pack1.Average a = (pack1.Average)obj;
double d = a.getAvg();
out.println((pack1.Average)obj + ", ");
System.out.println(d);
}
session.setAttribute("avgList", list);
list = (LinkedList) session.getAttribute("avgList");
for(Object obj : list){
out.println((Average)obj + ", ");
}-->
mahesh parmar -3 Newbie Poster
masijade commented: Don't ressurect dead threads, especially to just dump completely unrelated "code". -3
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.