Page 886 - 3-2
P. 886
sql = "insert into project(detector,addr,room,fire,spark
,gas,temp) values ("+n+","+addr+","+"'"+room+"',
"+"0,'HIGH','HIGH',0);";
Sedong.R[comboBox.getSelectedIndex()-1]
.setBackground(new Color(0,255,0,100));
Sedong.R[comboBox.getSelectedIndex()-1].repaint();
Sedong.Rn[comboBox.getSelectedIndex()-1]++;
int rs = stmt.executeUpdate(sql);
if(n==ServerMain.cnt_s)
{
sql = "insert into project(detector,addr,room,fire,spark,
gas,temp) values("+4+","+411+","+"'"+room+"',
"+"0,'HIGH','HIGH',0);";
int rs2 = stmt.executeUpdate(sql);
}
//rs.close();
stmt.close();
conn.close();
}catch(SQLException se1){
se1.printStackTrace();
}catch(Exception ex){
ex.printStackTrace();
}finally{
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}
}
}
});
}
}
/*
* 클래스: Place
- 886 -
