第三方--Quartz管理定时任务

package 

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;



/**
 * 
 *
 */
public class QuartzActiveJob implements Job {

    public QuartzActiveJob() {
    }

    public void execute(JobExecutionContext context) throws JobExecutionException {
    
        /**  servlet 层创建connection 将conn传入dao层 一次请求只创建一个conn  **/
        Connection conn = null;
        try {
            conn = DbUtil.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
            DataShopPostUtil.logOper("数据库连接失败");
            return;
        }
        
        try{
           //do some            
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            /**  关闭conn  **/
            if(conn !=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }             
        }
    
    }
}