Page 898 - 3-2

panel_1.add(btnNewButton);

JButton btnNewButton_1 = new JButton("off");
btnNewButton_1.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent e) {
for(int z=cnt_d;z>0;z--)
{
ServerMain.fire = 0;
switch(z)
{
case 1: ServerMain.firenum = dete; break;
case 2: ServerMain.firenum = dete2; break;
case 3: ServerMain.firenum = dete3; break;
}
ServerMain.fire();
}
Sedong.recall();
dispose();
}
});
panel_1.add(btnNewButton_1);

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

String sql;
sql = "SELECT * FROM project where addr ="+ addr +";";
ResultSet rs = stmt.executeQuery(sql);
//rs.close();
while(rs.next()){
String det = rs.getString("detector");
//dete = Integer.parseInt(det);
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"));
//System.out.println(""+ det + addr + room + fire +

- 898 -