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();    }  }}