mahesh parmar -3 Newbie Poster
<%@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 + ", ");
}-->
masijade commented: Don't ressurect dead threads, especially to just dump completely unrelated "code". -3