数据库连接DBSource.java类

来源：互联网发布：linux 防御ddos 编辑：程序博客网时间：2024/06/15 13:16

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 连接池
            */

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

        }

}