proxoolaction.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.db;
import java.sql.*;

import org.apache.log4j.*;
public class ProxoolAction {
	private static Connection conn;
	static Logger log=Logger.getLogger("ProxoolAction.class");
	public static Connection getConnection()
	{
	 try
	 {
		conn = DriverManager.getConnection("proxool.MyPool");

	 }catch(Exception e)
	{
		log.error("无法获取数据库连接！"+e);
	}
	 return conn;
	}
	public static void closeConnection(Connection conn)
	{
		if (conn == null) return;
		try
		{
			conn.close();
		}catch(Exception e)
		{
			log.error("不能关闭数据库连接！",e);
		}
	}
	public static void closeStatement(Statement stmt)
	{
		if(stmt==null) return;
		try
		{
			stmt.close();	
		}catch(Exception e)
		{
			log.error("不能关闭statement",e);
		}
	}
	public static void closeResultSet(ResultSet rs)
	{
		if(rs==null) return; 
		try
		 {
	        rs.close();
	     }catch (SQLException e)
	     {
	        log.error("不能关闭 resultset.", e);
	     }
	}
}