response.setContentType("text/html;charset=UTF-8");
ConfigSpecStructure configSpec = new ConfigSpecStructure();
Rdbms rdbm = new Rdbms();
boolean isConnected = false;
try {
isConnected = rdbm.startRdbms("labplanet", "LabPlanet");
Logger.getLogger(this.getClass().getName()).log(Level.SEVERE, null, ex);}
LabPLANETArray labArr = new LabPLANETArray();
Object[][] configSpecTestingArray
= new Object[numTesting
][6];
if (inumTesting<numTesting){
String tableName
="analysis_method";
fieldToRetrieve = labArr.addValueToArray1D(fieldToRetrieve, "analysis");
fieldToRetrieve = labArr.addValueToArray1D(fieldToRetrieve, "analysis");
fieldToRetrieve = labArr.addValueToArray1D(fieldToRetrieve, "analysis");
fieldToRetrieve = labArr.addValueToArray1D(fieldToRetrieve, "analysis");
configSpecTestingArray[inumTesting][0]=schemaPrefix;
configSpecTestingArray[inumTesting][1]=tableName;
configSpecTestingArray[inumTesting][2]=userName;
configSpecTestingArray[inumTesting][3]=fieldName;
configSpecTestingArray[inumTesting][4]=fieldValue;
configSpecTestingArray[inumTesting][5]=fieldToRetrieve;
inumTesting++;
}
/* TODO output your page here. You may use following sample code. */
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet " + "</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet TestingDbQueries at " + request.getContextPath() + "</h1>");
out.println("</body>");
out.println("</html>");
out.println("<table>");
out.println("<th>Test#</th><th>Schema Prefix</th><th>Function Being Tested</th><th>Field Name</th><th>Field Value</th><th>Evaluation</th>");
for (Integer i
=0;i
<configSpecTestingArray.
length;i
++){
//if (configSpecTestingArray[i][2]==null && configSpecTestingArray[i][3]==null){
out.println("<tr>");
userName=null;
String[] fieldsToRetrieve
=null;
if (configSpecTestingArray
[i
][0]!=null){schemaPrefix
= (String) configSpecTestingArray
[i
][0];}
if (configSpecTestingArray
[i
][1]!=null){tableName
= (String) configSpecTestingArray
[i
][1];}
if (configSpecTestingArray
[i
][2]!=null){userName
= (String) configSpecTestingArray
[i
][2];}
if (configSpecTestingArray
[i
][3]!=null){fieldName
= (String[]) configSpecTestingArray
[i
][3];}
if (configSpecTestingArray
[i
][4]!=null){fieldValue
= (Object[]) configSpecTestingArray
[i
][4];}
if (configSpecTestingArray
[i
][5]!=null){fieldsToRetrieve
= (String[]) configSpecTestingArray
[i
][5];}
out.
println("<td>"+i
+"</td><td>"+schemaPrefix
+"</td><td>"+tableName
+"</td><td>"+Arrays.
toString(fieldName
)+"</td><td><b>"+Arrays.
toString(fieldValue
)+"</b></td>");
dataSample = rdbm.getRecordFieldsByFilter(rdbm, schemaPrefix, tableName, fieldName, fieldValue, fieldsToRetrieve);
if ((dataSample[0][3].toString().equalsIgnoreCase("FALSE"))){
out.println("<td>"+dataSample[0][3].toString()+": "+dataSample[0][5].toString()+"</td>");
}else{
out.println("<td>"+"Records returned: " + dataSample.length+"</td>");
}
//out.println("<td>"+dataSample[0].toString()+". "+dataSample[1].toString()+". "+dataSample[2].toString()+". "+dataSample[3].toString()+". "+dataSample[4].toString()+". "+dataSample[5].toString()+"</td>");
out.println("</tr>");
}
out.println("</table>");
rdbm.closeRdbms();
}
Logger.getLogger(this.getClass().getName()).log(Level.SEVERE, null, ex);
}
}