package mybeans;
package mybeans;
import java.sql.*;
import java.lang.*;
import java.text.*;
import java.io.*;

public class newbean
{
Statement stmt = null;
Connection conn;
ResultSet rset = null;
String S_date = new String();
String temp = new String();
String lot_id = new String();
String result = new String();
String SQL_String = new String();
String crap = new String();
double yield;
int bad_cnt;

public void connect()
{
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection
("jdbc:oracle:thin:@klmomnidb:1521:OMNIDB","omni",
"omni");
}
catch(SQLException sqle)
{ //System.err.println("Error connecting: " + sqle);
//return(null);
System.out.println("Caught SQL Exception: " + sqle.toString() + "<br>");
}


}

static double roundDouble(double toBeRounded, int fractionDigits)
{
NumberFormat format = NumberFormat.getInstance();
format.setMaximumFractionDigits(fractionDigits);
String tempDouble = format.format(toBeRounded);
return Double.parseDouble(tempDouble);
}

public void startquery(String S_date)
{
try
{

SQL_String = "SELECT LOT_ID, FLOW_ID, TST_TEMP, MODE_COD, RTST_COD, 
PART_CNT, GOOD_CNT, OPER_NAM, JOB_REV, PROC_ID, START_T, FACIL_ID, 
TSTR_TYP, NODE_NAM FROM LOT where START_T > TO_DATE('"+ S_date 
+ "','MM/DD/YYYY') AND TST_TEMP <='" + temp+"' order by START_T";

stmt = conn.createStatement();
rset = stmt.executeQuery (SQL_String);
}
catch(SQLException sqle)
{
System.err.println("Error executin query: " + sqle);

}
}

public String displaySQL()
{
return SQL_String;
}

public String displayresult()
{
try
{
if (!rset.next())
{
result ="No records found matching seach criteria.";
}

else while (rset.next())
{
bad_cnt = Integer.parseInt(rset.getString(6)) - Integer.parseInt
(rset.getString(7));
yield = (Double.parseDouble(rset.getString(7)) / Double.parseDouble
(rset.getString(6))) *
100;

result= "<TR>";
result = result + "<TD><a href=coolpage.jsp?LOT_ID=" + rset.getString(1)
+ ">" + rset.getS
tring(1) + "</A></TD>";
result = result + "<TD>" + rset.getString(2) + "</TD>";
result = result + "<TD>" + rset.getString(3) + "</TD>";
result = result + "<TD>" + rset.getString(4) + "</TD>";
result = result + "<TD>" + rset.getString(5) + "</TD>";
result = result + "<TD>" + rset.getString(6) + "</TD>";
result = result + "<TD>" + rset.getString(7) + "</TD>";
result = result + "<TD>" + bad_cnt + "</TD>";
result = result + "<TD>" + roundDouble(yield,2) + "%</TD>";
result = result + "<TD>" + rset.getString(8) + "</TD>";
result = result + "<TD>" + rset.getString(9) + "</TD>";
result = result + "<TD>" + rset.getString(10) + "</TD>";
result = result + "<TD>" + rset.getString(11) + "</TD>";
result = result + "<TD>" + rset.getString(12) + "</TD>";
result = result + "<TD>" + rset.getString(13) + "</TD>";
result = result + "<TD>" + rset.getString(14) + "</TD>";
result = result + "</TR>";
return(result);
}
}

catch(SQLException sqle)
{
//System.err.println("Error executin query: " + sqle);
//System.out.println("Query is : " + SQL_String + "\n\n");

System.out.println("Caught SQL Exception: " + sqle.toString() + "<br>");
}

return(result);
}

}

public void disconnect()
{
try
{
conn.close();
}
catch(SQLException sqlex)
{
System.err.println( "Unable to Disconnect" );

}
}

}