dbconnection.java

自己制作的联通CRM,支持客户分类,管理,升级,积分管理等等..

package com.jn0801.tools;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

/**
 * 连接数据库工具类
 * 
 * @author JN0801A组
 * 
 */
public class DBConnection {

	/**
	 * 连接数据库的方法
	 * @return	connection
	 */
	public static Connection getConnection() {
		Connection con = null;
		InitialContext ic;

		try {
			ic = new InitialContext();
			DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/dbcp");
			con = ds.getConnection();
		} catch (NamingException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return con;

	}

	/**
	 *  关闭数据库中打开的属性
	 * @param resultSet				结果集
	 * @param preparedStatement		预编译通道	
	 * @param statement				通道	
	 * @param connection			连接
	 */
	public static void close(ResultSet resultSet,
			PreparedStatement preparedStatement, Statement statement,
			Connection connection) {

		try {
			if (resultSet != null) {
				resultSet.close();
			}
			if (preparedStatement != null) {
				preparedStatement.close();
			}
			if (statement != null) {
				statement.close();
			}
			if (connection != null) {
				connection.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

}