ServiceInit.java
772 字节
package com.espeed.yxy.tool;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.http.HttpServlet;
public class ServiceInit extends HttpServlet{
private Connection conn;
private ResultSet rs;
private PreparedStatement pst;
//项目初始化
public void init(){
//更新待发邮件状态
try {
//获取数据库链接
conn=DBUtil.getConnection();
String sql="update yxy_send_mail_master set isuse=0";
pst=conn.prepareStatement(sql);
pst.executeUpdate();
System.out.println("服务启动初始化成功!");
} catch (Exception e) {
System.out.println("服务启动初始化失败!");
}finally{
DBUtil.close(rs, pst, conn);
}
}
}