310
數據庫連接DBSource.java類
DBSource.java
package com.aspboy.base.database;
/*
* 創建日期 2007-1-22
*
* TODO 要更改此生成的文件的模板，請轉至
* 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
數據庫聯係類，提供了取數據庫聯接的方法
*/
public class DBSource
{
/**
靜態方法，取數據庫聯接
*/
public static Connection getConnection() throws Exception
{
Connection conn = null;
try
{
/*
//start 連接池
context = new InitialContext();
InitialContext context = new InitialContext();
ds = (DataSource)context.lookup("jdbc/OracleDS");
conn = ds.getConnection();
//end 連接池
*/
/*
//這是odbc方式連接方式
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:newjchtdb";
String username="sa";
String password="";
*/
//這裏通過配置文件實現數據庫連接參數的設置
String url=(String)ConfigUtil.getConfigInfo().get("url");
//System.out.println("url100="+url);
String driver=(String)ConfigUtil.getConfigInfo().get("driver");
//System.out.println("driver="+driver);
String username=(String)ConfigUtil.getConfigInfo().get("user");
//System.out.println("user="+username);
String password=(String)ConfigUtil.getConfigInfo().get("password");
//System.out.println("password="+password);
Class.forName(driver);
conn = DriverManager.getConnection(url,username,password);
}
catch(SQLException se)
{
//throw new ServletException(se);
}
catch (Exception e)
{
e.printStackTrace();
conn = null;
}
return conn;
}
public static Connection getConnectionFromSession() throws Exception
{
Connection conn = null;
try
{
/*
//start 連接池
context = new InitialContext();
InitialContext context = new InitialContext();
ds = (DataSource)context.lookup("jdbc/OracleDS");
conn = ds.getConnection();
//end 連接池
*/
/*
//這是odbc方式連接方式
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:newjchtdb";
String username="sa";
String password="";
*/
//這裏通過配置文件實現數據庫連接參數的設置
String url=(String)ConfigUtil.getConfigInfo().get("url");
//System.out.println("url100="+url);
String driver=(String)ConfigUtil.getConfigInfo().get("driver");
//System.out.println("driver="+driver);
String username=(String)ConfigUtil.getConfigInfo().get("user");
//System.out.println("user="+username);
String password=(String)ConfigUtil.getConfigInfo().get("password");
//System.out.println("password="+password);
Class.forName(driver);
conn = DriverManager.getConnection(url,username,password);
}
catch(SQLException se)
{
//throw new ServletException(se);
}
catch (Exception e)
{
e.printStackTrace();
conn = null;
}
return conn;
}
public static Connection getConnectionFromPool() throws Exception
{
Connection conn = null;
try
{
conn = DriverManager.getConnection("proxool.myweb2008");
}
catch(SQLException se)
{
//throw new ServletException(se);
}
catch (Exception e)
{
e.printStackTrace();
conn = null;
}
return conn;
}
public static void main(String[] args)
{
try {
System.out.println("conn="+DBSource.getConnectionFromPool());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
最後更新：2017-04-02 03:13:28