connectionmanager.java

来自「JSP源代码 主要实现网页的交互功能 刚学JAVA」· Java 代码 · 共 55 行

package com.conn;
import java.sql.*;
public class ConnectionManager {
	public static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	public static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=messageManage";
	public static final String DBNAME="sa";
	public static final String DBPASS="sa";
	public static Connection getConnection(){
		Connection conn=null;
		try{
			Class.forName(DRIVER);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}
		try{
			conn=DriverManager.getConnection(URL,DBNAME,DBPASS);
		}catch(SQLException e){
			e.printStackTrace();
		}
		return conn;
	}
	
	public static void closeConnection(Connection conn){
		try{
			if(conn!=null&&conn.isClosed()==false){
				conn.close();
			}
		}catch(SQLException ee){
			ee.printStackTrace();
		}
	}
	
	public static void closeResultSet(ResultSet set){
		try{
			if(set!=null){
				set.close();
				set=null;
			}
		}catch(SQLException ee){
			ee.printStackTrace();
		}
	}
	
	public static void closeStatement(PreparedStatement ment){
		try{
			if(ment!=null){
				ment.close();
				ment=null;
			}
		}catch(SQLException ee){
			ee.printStackTrace();
		}
	}
}