資料庫連接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();
   }
         
        }

   

}