connectionmanager.java~8~

些程序用java实现一个装机程序,不过是一个C/S架构,但是在数据库的设计方面与3层架构的构造方案我想对一些朋友还是否有一定的帮助吧

package pcdiysystem.Dao;

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

/**
 * <p>Title: 自助装机系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author kamiiyu
 * @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){
    try {
      if (resultSet != null) {
        resultSet.close();
      }
    }
    catch (SQLException ex) {
    }
  }

  public static void closeStatement( PreparedStatement pStatement) {
  try {
    if (pStatement != null) {
      pStatement.close();
    }
  } catch (SQLException e) {
    e.printStackTrace();
  }
}
}