Page 888 - 3-2
P. 888
static private JTextField textField_3;
static private JTextField textField_4;
static private JTextField textField_5;
static private JTextField textField_6;
static private JTextField textField_7;
static private JButton btnNewButton;
public Place() {
Timer timer = new Timer(); //4 초에 한번 클라이언트 접속을 확인.
System.out.println("place");
TimerTask timeTask = new TimerTask(){
@Override
public void run() {
if(ServerMain.v.size()>=1 && ServerMain.cnt>=1)
for(int iz=ServerMain.cnt;iz>0;iz--)
{
System.out.println("cnt"+ServerMain.cnt);
System.out.println("read"+iz);
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 detector ="+(ServerMain.cnt_s-iz+1)+";";
ResultSet rs = stmt.executeQuery(sql);
//rs.close();
while(rs.next()){
String det = rs.getString("detector");
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"));
- 888 -
