dbutils.java

来自「通讯录一个供大家参考」· Java 代码 · 共 42 行

package com.lideedu.huang.addressBook.dao;

import java.sql.*;
import com.lideedu.huang.addressBook.exceptions.DataAccessException;

public class DBUtils {
	
	//getConnection
	public static Connection getConnection() throws DataAccessException {
		
		  Connection con = null;
		
		  try {			  
			  Class.forName("net.sourceforge.jtds.jdbc.Driver");
			  con = DriverManager.getConnection(
					   "jdbc:jtds:sqlserver://localhost:1433/addressbook", "sa","");			   
		  }catch (ClassNotFoundException e) {			  
			  throw new DataAccessException("数据库加载驱动失败！",e);
		  }catch (SQLException e) {			  
			  throw new DataAccessException("数据库连接失败！",e);			
		  }
		
		  return con;
	}
	
	
	//releaseDBResource
	public static void releaseDBRes(Connection con, PreparedStatement psta,
			                               ResultSet rs) throws DataAccessException {		
		  try {			  
			  if(rs != null)				 
				  rs.close();			  				 
			  if(psta != null)				  			  
			      psta.close();	
			  if(con != null)
				  con.close();			  			  
		  }catch (SQLException e) {			  
			  throw new DataAccessException("数据库关闭失败！",e);
		  }
	}
}