?? 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(); } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -