dbconnection.java

来自「用j2ee开发的b/s通讯录. 欢迎各位使用」· Java 代码 · 共 88 行

package y2javaee.xmal1.common;

import java.sql.*;

public class DBConnection {
	
	private static Connection conn;

	private static final String DRIVER_CLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

	private static final String DATABASE_URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=addressBook";

	private static final String DATABASE_USRE = "sa";

	private static final String DATABASE_PASSWORD = "kf";

	/**
	 * 返回连接
	 * 
	 * @return Connection
	 */
	public static Connection getConnection() {

		try {
			Class.forName(DRIVER_CLASS);
			conn = DriverManager.getConnection(DATABASE_URL,
					DATABASE_USRE, DATABASE_PASSWORD);

		} catch (Exception e) {
			e.printStackTrace();
		}

		return conn;
	}

	/**
	 * 关闭数据库连接
	 * 
	 */
	public static void closeConnection(){
		try{
			if(conn!=null)
				conn.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	/**
	 * 关闭Statement对象
	 * 
	 * @param stm
	 */
	public static void closeStatement(Statement stm){
		try{
			if(stm!=null)
				stm.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	/**
	 * 关闭PreparedStatement对象
	 * 
	 * @param ps
	 */
	public static void closeStatement(PreparedStatement ps){
		try{
			if(ps!=null)
				ps.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	/**
	 * 关闭ResultSet结果集对象
	 * 
	 * @param rs
	 */
	public static void closeResultSet(ResultSet rs){
		try{
			if(rs!=null)
				rs.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
}