← Back to branch summary

~mortenoh/+junk/dhis2-detailed-import-export

« back to all changes in this revision

Viewing changes to local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/Kerala/Kcontroliec.jsp

  • Committer: larshelge at gmail
  • Date: 2009-03-03 16:46:36 UTC
  • Revision ID: larshelge@gmail.com-20090303164636-2sjlrquo7ib1gf7r
Initial check-in

Show diffs side-by-side

added added

removed removed

Lines of Context:
local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/Kerala/Kcontroliec.jsp
 
1
<%@ page import="java.sql.*,java.util.*" %>
 
2
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
3
<%
 
4
      Connection con=null;
 
5
      
 
6
      // for Performance in the Reporting Month
 
7
      Statement st=null;
 
8
      ResultSet rs=null;
 
9
      
 
10
      // for selected OrgUnit Name and Population
 
11
      Statement st1=null;
 
12
      ResultSet rs1=null;
 
13
      
 
14
      // for Performance in Corresponding month Last Year
 
15
      Statement st2=null;
 
16
      ResultSet rs2=null;
 
17
      
 
18
      // for Cumulative Performance till Current Month
 
19
      Statement st4=null;
 
20
      ResultSet rs4=null;
 
21
     
 
22
      // for Cumulative Performance till corresponding month of Last Year
 
23
      Statement st3=null;
 
24
      ResultSet rs3=null;
 
25
 
 
26
      // for Taluk Name and Id
 
27
      Statement st5=null;
 
28
      ResultSet rs5=null;
 
29
 
 
30
      // for District Name and Id
 
31
      Statement st6=null;
 
32
      ResultSet rs6=null;
 
33
 
 
34
     // for PHC Name and Id
 
35
      Statement st8=null;
 
36
      ResultSet rs8=null;
 
37
 
 
38
     // for CHC Name and Id
 
39
      Statement st9=null;
 
40
      ResultSet rs9=null;
 
41
 
 
42
     // for PHC Population Estimates
 
43
      Statement st10=null;
 
44
      ResultSet rs10=null;
 
45
 
 
46
     // for Data Period Start Date and End Date
 
47
      Statement st11=null;
 
48
      ResultSet rs11=null;
 
49
      
 
50
     // for DataElement ids based on DataElement code
 
51
      Statement st12=null;
 
52
      ResultSet rs12=null;
 
53
     
 
54
      
 
55
      String userName = "dhis";           
 
56
      String password = "";           
 
57
      String urlForConnection = "jdbc:mysql://localhost/kl_dhis2";
 
58
          
 
59
      int talukID = 0;
 
60
      String talukName = "";
 
61
      int districtID = 0; 
 
62
      String districtName = ""; 
 
63
      int CHCID = 0;
 
64
      String CHCName ="";
 
65
      int PHCID = 0;
 
66
      String PHCName ="";          
 
67
      int totPHCPopulation = -1;
 
68
      int totSCPopulation = -1;
 
69
 
 
70
          OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
71
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
72
          int selectedOrgUnitID =  Integer.parseInt( selectedId );
 
73
        
 
74
      
 
75
          String startingDate  =  (String) stack.findValue( "startingPeriod" );
 
76
          String endingDate  =    (String) stack.findValue( "endingPeriod" );
 
77
 
 
78
          String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
79
          int periodTypeID =  Integer.parseInt( monthlyPeriodId );
 
80
 
 
81
               
 
82
          int lastYear = 0;
 
83
      
 
84
          String selectedOrgUnitName = "";
 
85
          String selectedDataPeriodStartDate = "";
 
86
          String selectedDataPeriodEndDate = "";
 
87
          String lastDataPeriodStartDate = "";
 
88
          
 
89
           String dataElementCodes[] = {
 
90
 
 
91
                                                                                // WATER SAMPLES COLLECTED MONTHLY                                      
 
92
                                                                                "'JPHN/JHI_DE99'",
 
93
                                                                                // WATER SAMPLES COLLECTED YEARLY
 
94
                                                                                "'JPHN/JHI_DE99'",
 
95
                                                                                // WELLS CHOLORINATED MONTHLY
 
96
                                                                                "'JPHN/JHI_DE98'",
 
97
                                                                                // WELLS CHOLORINATED YEARLY
 
98
                                                                                "'JPHN/JHI_DE98'",
 
99
 
 
100
                                                                                // HEALTH TALK MONTHLY
 
101
                                                                                "'JPHN/JHI_DE108'",
 
102
                                                                                // HEALTH TALK YEARLY
 
103
                                                                                "'JPHN/JHI_DE108'",
 
104
 
 
105
                                                                                
 
106
                                                                                //GROUP DISCUSSION MONTHLY
 
107
                                                                                "'JPHN/JHI_DE109'",
 
108
                                                                                
 
109
                                                                                //GROUP DISCUSSION YEARLY
 
110
                                                                                "'JPHN/JHI_DE109'",
 
111
 
 
112
                                                                                //PARTICIPANTS IN THE GROUP DISCUSSION MONTHLY
 
113
                                                                                "'JPHN/JHI_DE111'",
 
114
                                                                                //PARTICIPANTS IN THE GROUP DISCUSSION YEARLY
 
115
                                                                                "'JPHN/JHI_DE111'",
 
116
                                                                                
 
117
                                                                
 
118
                                                                                // MOTHERS MEETING MONTHLY
 
119
                                                                                "'JPHN/JHI_DE110'",
 
120
                                                                                
 
121
                                                                                // MOTHERS MEETING YEARLY
 
122
                                                                                "'JPHN/JHI_DE110'",
 
123
 
 
124
                                                                                // MIKE PUBLICITY MONTHLY
 
125
                                                                                "'JPHN/JHI_DE115'",
 
126
                                                                                // MIKE PUBLICITY YEARLY
 
127
                                                                                "'JPHN/JHI_DE115'",
 
128
 
 
129
                                                                                // MSS MEETING MONTHLY
 
130
                                                                                "'JPHN/JHI_DE118'",
 
131
                                                                                
 
132
                                                                                // MSS MEETING YEARLY
 
133
                                                                                "'JPHN/JHI_DE118'",
 
134
 
 
135
                                                                                                                   
 
136
                                                                };
 
137
 
 
138
                 
 
139
        int dataElementIDs[] = new int[dataElementCodes.length+5];  
 
140
        int entryNumberValues[]=  new int[dataElementCodes.length+5];     
 
141
        int entryValuesForLastYear[]= new int[dataElementCodes.length+5];      
 
142
        int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];      
 
143
        int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];     
 
144
        
 
145
        String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September","October", "November", "December" };  
 
146
        
 
147
        String query = "";
 
148
        
 
149
        List childOrgUnitIDs = new ArrayList(); 
 
150
        List childOrgUnitNames = new ArrayList();       
 
151
        
 
152
        int tempval[] = new int[dataElementCodes.length+5];
 
153
        int total[] = new int[dataElementCodes.length+5];
 
154
 
 
155
                
 
156
        int childOrgUnitCount = 0;      
 
157
        int count = 0;          
 
158
        int i=0;
 
159
        int totpopulation=0;
 
160
 
 
161
%>
 
162
 
 
163
<%
 
164
     try
 
165
      {
 
166
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
167
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
168
        
 
169
        st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
170
        st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
171
        st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
172
        st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
173
        st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
174
        st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
175
        st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
176
        st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
177
        st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
178
        st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
179
        st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
180
        st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
181
 
 
182
     
 
183
        //rs1 = st1.executeQuery("SELECT organisationunit.name FROM organisationunit WHERE id ="+selectedOrgUnitID);
 
184
        rs1 = st1.executeQuery("SELECT organisationunit.name FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);        
 
185
        if(rs1.next())  {   selectedOrgUnitName = rs1.getString(1);       }
 
186
        else   {        selectedOrgUnitName = "";        }  
 
187
                            
 
188
                //query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period in (select id from period where startdate like '"+startingDate+"' and periodType = 3) AND datavalue.source in ( select id from organisationunit where parent in ( select id from organisationunit where parent ="+selectedOrgUnitID+")) AND dataelement.code in ('SPD_DE1','SPD_DE2','SPD_DE3','SPD_DE4','SPD_DE5','SPD_DE6','SPD_DE7','SPD_DE8')"; 
 
189
                query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid in (select periodid from period where startdate like '"+startingDate+"' and periodtypeid = 3) AND datavalue.sourceid in ( select organisationunitid from organisationunit where parentid in ( select organisationunitid from organisationunit where parentid ="+selectedOrgUnitID+")) AND dataelement.code in ('SPD_DE1','SPD_DE2','SPD_DE3','SPD_DE4','SPD_DE5','SPD_DE6','SPD_DE7','SPD_DE8')";
 
190
        rs11 = st11.executeQuery(query);
 
191
                if(rs11.next())
 
192
                  {
 
193
                  totpopulation=rs11.getInt(1);
 
194
                  }
 
195
 
 
196
//      rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
 
197
//              if(rs11.next())
 
198
//                {
 
199
//                      selectedDataPeriodStartDate =  rs11.getDate(1).toString();
 
200
//                      selectedDataPeriodEndDate   =  rs11.getDate(2).toString();
 
201
//                }
 
202
 
 
203
                selectedDataPeriodStartDate = startingDate;
 
204
                
 
205
                
 
206
                //rs3 =  st3.executeQuery("select id,name from organisationunit where parent = "+selectedOrgUnitID);
 
207
                rs3 =  st3.executeQuery("select organisationunitid,name from organisationunit where parentid = "+selectedOrgUnitID);
 
208
            while(rs3.next())
 
209
                 {
 
210
                        Integer tempInt = new Integer(rs3.getInt(1));
 
211
                        childOrgUnitIDs.add(childOrgUnitCount,tempInt);                 
 
212
                        childOrgUnitNames.add(childOrgUnitCount,rs3.getString(2));                      
 
213
                        childOrgUnitCount++;
 
214
                 } 
 
215
 
 
216
 
 
217
      } // try block end
 
218
     catch(Exception e)  { out.println("exception 1 -"+e.getMessage());  }
 
219
     finally
 
220
       {
 
221
                        try
 
222
                                {
 
223
                                        if(rs1!=null)  rs1.close();                     if(st1!=null)  st1.close();
 
224
                                        if(rs11!=null)  rs11.close();           if(st11!=null)  st11.close();
 
225
                                }
 
226
                        catch(Exception e)   {  out.println("exception 2 - "+e.getMessage());   }
 
227
       } // finally block end           
 
228
 
 
229
        String partsOfDataPeriodStartDate[]  =  selectedDataPeriodStartDate.split("-");
 
230
        lastYear  = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
231
        lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
232
        
 
233
        int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
234
        int tempForYear = 0;
 
235
                
 
236
        if(tempForMonth1 < 4)           {   tempForYear = lastYear;  }
 
237
        else  {   tempForYear = lastYear + 1;           }
 
238
                         
 
239
        String curYearStart = tempForYear+"-04-01";
 
240
        String lastYearStart = (tempForYear-1)+"-04-01";
 
241
        String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
242
         
 
243
    //for district, taluk, CHC names
 
244
    try
 
245
      {
 
246
           //     rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");        
 
247
        //              if(rs8.next())  { PHCID = rs8.getInt(1);PHCName = rs8.getString(2);  } 
 
248
        //              else  {  PHCID = 0; PHCName = "";  } 
 
249
 
 
250
        //              rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")"); 
 
251
        //              if(rs9.next())  { CHCID = rs9.getInt(1);CHCName = rs9.getString(2);  } 
 
252
        //              else  {  CHCID = 0; CHCName = "";  } 
 
253
 
 
254
                        //rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID +")");
 
255
                        rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID +")");      
 
256
                        if(rs5.next())  { talukID = rs5.getInt(1); talukName = rs5.getString(2);  } 
 
257
                        else  {  talukID = 0; talukName = "";  } 
 
258
        
 
259
                    //rs6=st6.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+talukID+")");
 
260
                    rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+talukID+")"); 
 
261
                    if(rs6.next()) {  districtID = rs6.getInt(1); districtName = rs6.getString(2);}
 
262
                        else {districtID = 0; districtName = "";}      
 
263
 
 
264
                        //rs10=st10.executeQuery("SELECT sum(datavalue.value) FROM organisationunit INNER JOIN (dataelement INNER JOIN datavalue ON dataelement.id = datavalue.dataElement) ON organisationunit.id = datavalue.source WHERE organisationunit.parent = "+PHCID+" AND dataelement.name like 'Total Population'");
 
265
                        rs10=st10.executeQuery("SELECT sum(datavalue.value) FROM organisationunit INNER JOIN (dataelement INNER JOIN datavalue ON dataelement.dataelementid = datavalue.dataelementid) ON organisationunit.organisationunitid = datavalue.sourceid WHERE organisationunit.parentid = "+PHCID+" AND dataelement.name like 'Total Population'");
 
266
                        if(rs10.next()) { totPHCPopulation = rs10.getInt(1);}
 
267
                        else {totPHCPopulation = 0;}      
 
268
       
 
269
       }   // try block end              
 
270
     catch(Exception e)  { out.println(e.getMessage());  }
 
271
    
 
272
       
 
273
    %>
 
274
 
 
275
<html>
 
276
 
 
277
<head>
 
278
<title>communicable diseases/iec activieits</title>
 
279
</head>
 
280
 
 
281
<body>
 
282
 
 
283
<FONT face="Arial" size="2"><center>Consolidation Report of Activities for prevention and control of Communicable Diseases/IEC Activities of the <br>CHC/Block PHC-<b><u><%=selectedOrgUnitName%></u> </b> for the month of<b><%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%></font></center><br><br>
 
284
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
 
285
  <tr>
 
286
    <td width="50%"><FONT face="Arial" size="2">Total Population :<%=totpopulation%></Font></td>
 
287
    <td width="50%"><FONT face="Arial" size="2">District :<%=districtName%></Font></td>
 
288
  </tr>
 
289
</table><br>
 
290
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
 
291
  <tr>
 
292
    <td align="center"  width="3%" rowspan="3"><FONT face="Arial" size="2">Sl.No</Font></td>
 
293
    <td align="center"  width="49%" rowspan="3"><FONT face="Arial" size="2">Name of the Mini PHC</Font></td>
 
294
    <td align="center"  width="48%" colspan="16"><FONT face="Arial" size="2">IEC</Font></td>
 
295
  </tr>
 
296
  <tr>
 
297
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Water samples collected</Font></td>
 
298
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Wells Chlorinated</Font></td>
 
299
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Health Talk</Font></td>
 
300
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Group Discussion</Font></td>
 
301
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Participants in the Group discussion</Font></td>
 
302
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Mothers Meeting</Font></td>
 
303
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">Mike publicity</Font></td>
 
304
    <td align="center"  width="6%" colspan="2"><FONT face="Arial" size="2">MSS Meeting</Font></td>
 
305
  </tr>
 
306
  <tr>
 
307
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
308
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
309
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
310
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
311
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
312
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
313
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
314
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
315
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
316
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
317
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
318
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
319
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
320
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
321
    <td align="center"  width="3%"><FONT face="Arial" size="2">Monthly</Font></td>
 
322
    <td align="center"  width="3%"><FONT face="Arial" size="2">Yearly</Font></td>
 
323
  </tr>
 
324
   <%
 
325
                        
 
326
                        try
 
327
                          {
 
328
                                  count = 0;
 
329
                                  while(count < childOrgUnitCount)
 
330
                                   {                               
 
331
                                        Integer temp1 = (Integer) childOrgUnitIDs.get(count);
 
332
                                        int currentChildID = temp1.intValue();                  
 
333
                                        for(i=0;i<dataElementCodes.length;i++)
 
334
                                         {                      
 
335
                                                
 
336
                                                if(i==0 || i==2 || i==4 || i==6 || i==8 || i==10 || i==12 || i==14)
 
337
                                                  //query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period  in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.source in (select id from organisationunit where parent = "+currentChildID+")  AND dataelement.code in ("+dataElementCodes[i]+")";
 
338
                                                  query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid  in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.sourceid in (select organisationunitid from organisationunit where parentid = "+currentChildID+")  AND dataelement.code in ("+dataElementCodes[i]+")";
 
339
                                                else   
 
340
                                                  //query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period  in (select id from period where startdate between '"+curYearStart+"' and '"+startingDate+"') AND datavalue.source in (select id from organisationunit where parent = "+currentChildID+")  AND dataelement.code in ("+dataElementCodes[i]+")";
 
341
                                                  query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid  in (select periodid from period where startdate between '"+curYearStart+"' and '"+startingDate+"') AND datavalue.sourceid in (select organisationunitid from organisationunit where parentid = "+currentChildID+")  AND dataelement.code in ("+dataElementCodes[i]+")";                                           
 
342
                                                rs4 = st4.executeQuery(query);
 
343
                                                                                                                                                
 
344
                                                if(!rs4.next())  {  tempval[i] = 0;      }
 
345
                                                else   {  tempval[i] = rs4.getInt(1);  }
 
346
                                                total[i] += tempval[i];
 
347
                                         }      
 
348
                    %>
 
349
 
 
350
  <tr>
 
351
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=(count+1)%></Font>&nbsp;</td>
 
352
    <td width="49%"><FONT face="Arial" size="2"><%=childOrgUnitNames.get(count)%></Font>&nbsp;</td>
 
353
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[0]%></Font>&nbsp;</td>
 
354
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[1]%></Font>&nbsp;</td>
 
355
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[2]%></Font>&nbsp;</td>
 
356
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[3]%></Font>&nbsp;</td>
 
357
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[4]%></Font>&nbsp;</td>
 
358
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[5]%></Font>&nbsp;</td>
 
359
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[6]%></Font>&nbsp;</td>
 
360
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[7]%></Font>&nbsp;</td>
 
361
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[8]%></Font>&nbsp;</td>
 
362
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[9]%></Font>&nbsp;</td>
 
363
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[10]%></Font>&nbsp;</td>
 
364
   <td align="center"   width="3%"><FONT face="Arial" size="2"><%=tempval[11]%></Font>&nbsp;</td>
 
365
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[12]%></Font>&nbsp;</td>
 
366
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[13]%></Font>&nbsp;</td>
 
367
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[14]%></Font>&nbsp;</td>
 
368
    <td align="center"  width="3%"><FONT face="Arial" size="2"><%=tempval[15]%></Font>&nbsp;</td>
 
369
  </tr>
 
370
  <%                                    
 
371
                                        count++;
 
372
                                   }    // while loop end
 
373
                          } // try block end
 
374
                        catch(Exception e)  { out.println(e.getMessage());  }
 
375
      finally
 
376
       {
 
377
                 try
 
378
                          {
 
379
                            if(rs5!=null)  rs5.close();                 if(st5!=null)  st5.close();
 
380
                            if(rs6!=null)  rs6.close();                 if(st6!=null)  st6.close();
 
381
                            if(rs8!=null)  rs8.close();                 if(st8!=null)  st8.close();   
 
382
                            if(rs9!=null)  rs9.close();                 if(st9!=null)  st9.close();
 
383
                            if(rs10!=null)  rs10.close();                       if(st10!=null)  st10.close();                                                                                                                
 
384
                          }
 
385
                catch(Exception e)   {  out.println(e.getMessage());   }
 
386
       }  // finally block end  
 
387
                %>
 
388
 
 
389
 
 
390
</table>
 
391
 
 
392
</body>
 
393
 
 
394
</html>
 
 
b'\\ No newline at end of file'