connectionmanager.java

使用JSP+MSSQL开发的在线通讯录系统.包含源码

package com.e98.addressbook.common;

import java.sql.*;

import javax.sql.*;

public class ConnectionManager {
	/**
	 * 获取数据库连接
	 * @return
	 */
	public static Connection getConn() {
	 Connection conn =null;
	 try {
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		try {
			conn= DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=addressBook", "sa", "sa123");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	 
	 return conn;
	}
	/**
	 * 关闭连接
	 * @param conn
	 */
	public static void colseConnection(Connection conn){
		try {
			if (conn!=null &&(conn.isClosed()==false)) {
				conn.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	/**
	 * 关闭语句对象
	 * @param pst
	 */
	public static void closePreparedStatement(PreparedStatement pst)
	{
		if(pst!=null)
			try {
				pst.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		
	}
	/**
	 * 关闭结果集
	 * @param rs
	 */
	public static void closeResultSet(ResultSet rs){
		if(rs!= null)
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		
	}
}