EndCapUtilities.java

package ProdDatabase;
import java.sql.*;
import java.util.*;

public class EndCapUtilities implements SCTDBInfo, endcapMetrologyData {

//************************************************************************************
   public static Vector getXYMetrologyData(String testno) throws Exception {
// generate report of single XY metrology data measurement
      Vector itemList = new Vector();
      Vector theLine = new Vector();
      theLine.addElement("Parameter");
      theLine.addElement("Description");
      theLine.addElement("Data");
      itemList.addElement(theLine);

      StringBuffer sqlStat = new StringBuffer("SELECT ");
      for(int i=0;i<xyEndCapMetrologyParameters.length;i++) {
              if(i>0) sqlStat.append(",");
              sqlStat.append(xyEndCapMetrologyParameters[i]);
              }
      sqlStat.append(" FROM TSTMODXY WHERE test_no = "+testno);
      Statement statement = SCTDBInterface.getInstance().connection.createStatement();
//     System.out.println(sqlStat.toString());
     ResultSet resultSet = statement.executeQuery(sqlStat.toString());
     for(boolean n = resultSet.next() ; n==true ; n=resultSet.next() ){
          for(int i=0;i<xyEndCapMetrologyParameters.length;i++) {
             theLine = new Vector();
             String theData = resultSet.getString(i+1);
             theLine.addElement(xyEndCapMetrologyParameters[i]);
             theLine.addElement(xyEndCapDescriptions[i]);
             theLine.addElement(theData);
             itemList.addElement(theLine);
             }
           }
      statement.close();
      return itemList;
      }

//************************************************************************************
   public static Vector getZMetrologyData(String testno) throws Exception {
// generate report of single Z metrology data measurement
      Vector itemList = new Vector();
      Vector theLine = new Vector();
      theLine.addElement("Parameter");
      theLine.addElement("Description");
      theLine.addElement("Data");
      itemList.addElement(theLine);

      StringBuffer sqlStat = new StringBuffer("SELECT ");
      for(int i=0;i<zEndCapMetrologyParameters.length;i++) {
              if(i>0) sqlStat.append(",");
              sqlStat.append(zEndCapMetrologyParameters[i]);
              }
      sqlStat.append(" FROM TSTMODZ WHERE test_no = "+testno);
      Statement statement = SCTDBInterface.getInstance().connection.createStatement();
//     System.out.println(sqlStat.toString());
     ResultSet resultSet = statement.executeQuery(sqlStat.toString());
     for(boolean n = resultSet.next() ; n==true ; n=resultSet.next() ){
          for(int i=0;i<zEndCapMetrologyParameters.length;i++) {
             theLine = new Vector();
             String theData = resultSet.getString(i+1);
             theLine.addElement(zEndCapMetrologyParameters[i]);
             theLine.addElement(zEndCapDescriptions[i]);
             theLine.addElement(theData);
             itemList.addElement(theLine);
             }
           }
      statement.close();
      return itemList;
      }


}

---