dbconnnection.java

来自「是一个在线通讯录！很好的」· Java 代码 · 共 71 行

package common;

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

public class DBConnnection {
	public static Connection getConnection()
	{
		Connection dbConnection=null;
		try
		{			
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			dbConnection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=addressBook","sa","123456");
			
		}catch(Exception ex)
		{
			ex.printStackTrace();			
		}
		return dbConnection;
		
	}
	
	public static void closeConnection(Connection dbConnection)
	{
		try
		{
			if(dbConnection!=null&&(!dbConnection.isClosed()))
			{
				dbConnection.close();
			}
		}catch(SQLException ex)
		{
			ex.printStackTrace();
		}
		
	}
	
	public static void closeResultSet(ResultSet res)
	{
		try
		{
			if(res!=null)
			{
				res.close();
				res=null;
			}
		}catch(SQLException ex)
		{
			ex.printStackTrace();
		}
	}
	
	public static void closeStatement(PreparedStatement pStatement)
	{
		try
		{
			if(pStatement !=null)
			{
				pStatement.close();
				pStatement=null;
			}
		}catch(SQLException ex)
		{
			ex.printStackTrace();
		}
	}
}