connectionmanager.java~7~

来自「些程序用java实现一个装机程序,不过是一个C/S架构,但是在数据库的设计方面与」· JAVA~7~ 代码 · 共 59 行

package pcdiysystem.Dao;

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

/**
 * <p>Title: 自助装机系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author kamiiiyu
 * @version 1.0
 */
public class ConnectionManager {
  private static final String DRIVER_CLASS="com.microsoft.jdbc.sqlserver";
  private static final String DATABASE_URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=PCDIY";
  private static final String DATABASE_USER="DIYManager";
  private static final String DATABASE_PASEWORD="diy";
  
  public ConnectionManager() {
  }
  
  public static Connection getConnection(){
    Connection dbConnection=null;
    try {
      Class.forName(DRIVER_CLASS);
      dbConnection = DriverManager.getConnection(DATABASE_URL, DATABASE_USER,
                                                 DATABASE_PASEWORD);
    }
    catch (SQLException ex) {
    }
    catch (ClassNotFoundException ex) {
    }
    return dbConnection;
  }
  
  public static void closeConnection(Connection dbConnection){
    try {
      if (dbConnection != null && (!dbConnection.isClosed())) {
        dbConnection.close();
      }
    }
    catch (SQLException ex) {
    }
  }
  
  public static void closeResultSet(ResultSet resultSet){
    if(resultSet!=null){
      resultSet.close();
    }
  }
}