Java定时刷新数据库,另一个方法怎么获取到刷新的内容,
//获取数据库内容
public class shuXinText {
public static List getlist(){
String invid = null;
String result_sign=null;
ArrayList list=new ArrayList();
try {
java.sql.Connection conn;
conn = new DatabaseConnection().getConnection();
PreparedStatement st=conn.prepareStatement("select inv_id, result_sign from io_invoice_title where result_sign=0");
st.execute();
ResultSet rs=st.getResultSet();
while (rs.next()) {
invid=rs.getString("inv_id");
result_sign=rs.getString("result_sign");
// System.out.println(invid);
list.add(invid);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
}
///定时刷新数据库
public class CourseAction {
int count = 0;
public List showTimer() {
final shuXinText shuXinText=new shuXinText();
//final InvoicetitleServlet servlet =new InvoicetitleServlet();
//servlet.sendvoidmessage();
TimerTask task = new TimerTask() {
@Override
public void run() {
shuXinText shuXinText=new shuXinText();
shuXinText.getlist();
++count;
System.out.println("时间=" + new Date() + " 执行了" + count + "次");
}
};
//设置执行时间
Calendar calendar = Calendar.getInstance();
int year = calendar.get(Calendar.YEAR);
int month = calendar.get(Calendar.MONTH);
int day = calendar.get(Calendar.DAY_OF_MONTH);//每天
calendar.set(year, month, day, 00, 00, 00);
Date date = calendar.getTime();
Timer timer = new Timer();
System.out.println(date);
int period = 5* 1000;
timer.schedule(task, date, period);
return null;
}
}
现在我要获取刷新的inv_id 在另外 一个方法应该怎么接收过来?还是调用 shuXinText方法还是 CourseAction才能取到。CourseAction 刷新是不是shuXinText这个方法的内容也就刷新了?直接用shuXinText方法的到?有大神给我说说嘛。
现在做的工作是刷新数据库,有新的 数据就拼报文发送到url,获取到返回的值在加入到数据库 。本人新手。没人带,求教