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);
		}
	}
}