Page 634 - 3-2

dout.write( result );
dout.flush();
result = 0;
System.out.println(""+result);
String url = "jdbc:mysql://localhost:3306/mdp?autoReconnect=true&useSSL=false"; / / m y s q l
접속주소
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url,"root","raspberry");
Statement st = conn.createStatement();

String update_s0 = "update mos set Count = "+cs0+" , rank = "+rank[0]+" where Sensor =
's0'";
String update_s1 = "update mos set Count = "+cs1+" , rank = "+rank[1]+" where Sensor =
's1'";
String update_s2 = "update mos set Count = "+cs2+" , rank = "+rank[2]+" where Sensor =
's2'";
String update_s3 = "update mos set Count = "+cs3+" , rank = "+rank[3]+" where Sensor =
's3'";
String update_s4 = "update mos set Count = "+cs4+" , rank = "+rank[4]+" where Sensor =
's4'";
String update_s5 = "update mos set Count = "+cs5+" , rank = "+rank[5]+" where Sensor =
's5'";
String update_s6 = "update mos set Count = "+cs6+" , rank = "+rank[6]+" where Sensor =
's6'";
String update_s7 = "update mos set Count = "+cs7+" , rank = "+rank[7]+" where Sensor =
's7'";
st.execute(update_s0);
st.execute(update_s1);
st.execute(update_s2);
st.execute(update_s3);
st.execute(update_s4);
st.execute(update_s5);
st.execute(update_s6);
st.execute(update_s7);
//dout.close();
//acp_sock.close();
}
catch( Exception e )
{
e.printStackTrace();
}
}
}
}
catch( IOException e )

- 634 -