connectionmanager.java

新闻发布系统

package com.jbaptech.accp.newspublish.db;

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

/**
 * ConnectionManager.
 * <p>Title: </p>  *
 * <p>Description: </p>  *
 * <p>Copyright: Copyright (c) 2005</p>  *
 * <p>Company: 北京阿博泰克北大青鸟信息技术有限公司</p> *
 * @author luohao
 * @version 1.0
 */
public class ConnectionManager {

  /**
   * DRIVER_CLASS
   */
  private static final String DRIVER_CLASS =
      "sun.jdbc.odbc.JdbcOdbcDriver";
  /**
   * DATASOURCE
   */
  private static final String DATASOURCE = "jdbc:odbc:NewsDataSource";
//  private static final String DRIVER_CLASS =
//      "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  /**
   * DATABASE_URL
   */
  private static final String DATABASE_URL =
      "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=News";
  /**
   * DATABASE_USRE
   */
  private static final String DATABASE_USRE = "sa";
  /**
   * DATABASE_PASSWORD
   */
  private static final String DATABASE_PASSWORD = "sa";

  /**
   * getConnction
   * @return Connection
   */
  public static Connection getConnction() {
  Connection dbConnection = null;
    try {
      Class.forName(DRIVER_CLASS);
//      dbConnection = DriverManager.getConnection(DATABASE_URL, DATABASE_USRE,
//                                                 DATABASE_PASSWORD);

      dbConnection = DriverManager.getConnection(DATASOURCE);
    } catch (Exception e) {
      e.printStackTrace();
    }

    return dbConnection;
  }

  /**
   * closeConnection
   * @param dbConnection Connection
   */
  public static void closeConnection(Connection dbConnection) {
    try {
      if (dbConnection != null && (!dbConnection.isClosed())) {
        dbConnection.close();
      }
    } catch (SQLException sqlEx) {
      sqlEx.printStackTrace();
    }

  }

  /**
   * closeResultSet
   * @param res ResultSet
   */
  public static void closeResultSet(ResultSet res) {
    try {
      if (res != null) {
        res.close();
        res = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  /**
   * closeStatement
   * @param pStatement PreparedStatement
   */

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

}