Timerタイミング監視データベースについて

2053 ワード

Timerタイミングアクセスデータベースを作成します.
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();
		
	 }	 	 
}