Timerタイミング監視データベースについて
Timerタイミングアクセスデータベースを作成します.
Demo:
Demo:
public class Test {
private final Timer timer = new Timer("");
public static Connection getConnection() throws SQLException,java.lang.ClassNotFoundException {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/test_db?useUnicode=true&characterEncoding=UTF-8";
String username = "root";
String password = "root";
Connection con = DriverManager.getConnection(url, username, password);
return con;
}
public String getGreeting() {
String rename = "";
try{
Test test = new Test();
Connection con = test.getConnection();
Statement sql_statement = con.createStatement();
String query = "select * from mytest";
ResultSet result = sql_statement.executeQuery(query);
while (result.next())
{
int number = result.getInt("id");
String name1 = result.getString("name");
if(name1.equals("name")){
rename = name1;
System.out.println(rename);
}else{
rename = "";
}
}
sql_statement.close();
con.close();
}catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException");
System.err.println(e.getMessage());
} catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
return rename;
}
public void start(){
timer.schedule(new TimerTask(){
public void run(){
getGreeting();
}
},0, 1000);
}
public static void main(String[] args){
Test test = new Test();
test.start();
}
}