1.建立运行类
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Timer;
import java.util.TimerTask;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
public class DataTranData implements ServletContextListener {
private Timer timer = null;
public void contextInitialized(ServletContextEvent event) {
timer = new Timer(true);
/*
* 这里开始循环执行 MyJob()方法了 schedule(param1, param2,param3)这个函数的三个参数的意思分别是:
* param1:你要执行的方法;param2:延迟执行的时间,单位毫秒;param3:循环间隔时间,单位毫秒
*/
timer.schedule(new MyJob(), 0, 50000000);
}
public void contextDestroyed(ServletContextEvent event) {
timer.cancel();
}
}
package com.cennavi.uti;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.TimerTask;
public class MyJob extends TimerTask{
public void run() {
//连接数据库
Connection c = null;
try {
Class.forName("org.postgresql.Driver");
c = DriverManager.getConnection(
"jdbc:postgresql://localhost:5432/postgres", "postgres",
"123456");
} catch (Exception e) {
e.printStackTrace();
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
System.out.println("Opened database successfully") ;
//查询数据表中的列信息
}
}
2.webconfig里面配置运行类
<listener>
<listener-class>com.cennavi.uti.DataTranData</listener-class>
</listener>