Page 893 - 3-2

}
});

contentPane.add(btnNewButton);

Connection conn = null;
Statement stmt = null;
try{
//System.out.println("try");
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL,USERNAME,PASSWORD);
stmt = conn.createStatement();

String sql;
if(q==0)sql = "SELECT * FROM project where detector ="+n+";";
else sql = "SELECT * FROM project where detector ="+i+";";
ResultSet rs = stmt.executeQuery(sql);
//rs.close();

while(rs.next()){
String addr = rs.getString("addr");
String room = rs.getString("room");
String fire = rs.getString("fire");
String spark = rs.getString("spark");
String gas = rs.getString("gas");
float temp = Float.parseFloat(rs.getString("temp"));
textField.setText(addr+"");
textField_3.setText(room+"");
textField_4.setText(fire+"");
textField_5.setText(spark+"");
textField_6.setText(gas+"");
textField_7.setText(temp+"");
if(gas.equals("LOW") && spark.equals("LOW") && temp>=45){
ServerMain.fire=1;
ServerMain.firenum=Integer.parseInt(addr);
ServerMain.fire();

}
//System.out.println("q"+q);

if(q>0)
{
System.out.println(addr);
for(int x=0;x<6;x++)
{

- 893 -