📄 tempmeasure.java
字号:
import java.sql.*;
import java.util.*;
public class TempMeasure implements Runnable
{
static Thread thread;
public TempMeasure(){
}
public void run()
{
int i=1,rows;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection conn = DriverManager.getConnection("jdbc:odbc:test2000");
Statement st = conn.createStatement();
while(true){
Calendar calendar = Calendar.getInstance();
String date = new String(calendar.get(Calendar.YEAR)+"-"+(calendar.get(Calendar.MONTH)+1)+"-"+calendar.get(Calendar.DATE));
String time = new String(calendar.get(Calendar.HOUR)+":"+calendar.get(Calendar.MINUTE)+":"+calendar.get(Calendar.SECOND));
int t1 = getTemp(0);
int t2 = getTemp(1);
int t3 = getTemp(2);
int t4 = getTemp(3);
String datetime = new String(date+" "+ time);
rows = st.executeUpdate("insert into security values("+i+",'"+datetime+"',"+t1+","+t2+","+t3+","+t4+")");
System.out.println("Thread: "+i);
try{
thread.sleep(1000*60*60);
}catch(Exception e){ e.printStackTrace(); }
i++;
}
}catch(Exception e) { e.printStackTrace(); }
}
public int getTemp(int i){
int t[] ={100,105,100,100};
return t[i];
}
public static void main(String args[]){
TempMeasure tm = new TempMeasure();
thread = new Thread(tm);
thread.start();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -