resourcemanager.java

来自「Jsp网站开发四库全书中的blog网站设计」· Java 代码 · 共 54 行

package cn.wanfeng.myblog.jdbc;

import java.sql.*;
import javax.sql.*;
import javax.naming.*;

public class ResourceManager
{
	public static synchronized Connection getConnection()
	throws NamingException, SQLException
	{
		InitialContext initCtx = new InitialContext();
		Object obj = initCtx.lookup( "java:comp/env/jdbc/myblog" );
		DataSource ds = (DataSource) obj;
		return ds.getConnection();
	}


	public static void close(Connection conn)
	{
		try {
			if (conn != null) conn.close();
		}
		catch (SQLException sqle)
		{
			sqle.printStackTrace();
		}
	}

	public static void close(PreparedStatement stmt)
	{
		try {
			if (stmt != null) stmt.close();
		}
		catch (SQLException sqle)
		{
			sqle.printStackTrace();
		}
	}

	public static void close(ResultSet rs)
	{
		try {
			if (rs != null) rs.close();
		}
		catch (SQLException sqle)
		{
			sqle.printStackTrace();
		}

	}

}