companylistener.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.util;

import java.sql.Connection;

import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;

import com.oa.lp.dao.CompanyDAO;
import com.oa.lp.dao.RoleDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Company;

public class CompanyListener implements ServletContextListener {

	public void contextDestroyed(ServletContextEvent contextEvent) {
		
	}

	public void contextInitialized(ServletContextEvent contextEvent) {	
		ServletContext context = contextEvent.getServletContext();
		Connection conn=null;
		try {
			conn = DataBase.getConnection();
			Company company = new Company();
			CompanyDAO companyDao = new CompanyDAO();
			companyDao.setConn(conn);
			context.setAttribute("companys",companyDao.getCompany(1));	
		
			//事务提交
			DataBase.commit();
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null){
				//关闭连接
				DataBase.releaseConnection(conn);
			}
		}
		   
	}

}