原始 java 载入数据源 JNDI及直连

Java：

package com.wonders.ips.common;

import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
import com.wonders.ips.sysadmin.ConfigInfo;
import com.wonders.kwoa.common.ConnectPool;

/**
 * <p>Title: DB连接</p>
 * <p>Description: DB连接</p>
 * <p>Copyright: Copyright (c) 2007-1</p>
 * <p>Company: Wondersgroup</p>
 * @author Chen Xiaodong
 * @version 3.0
 */

public class DbConnection {
  Connection conn = null;
  Statement stmt = null;
  PreparedStatement pstmt = null;
  ResultSet rs = null;
  Context ctx = null;
  DataSource ds = null;

  ConfigInfo cfn = null;

  private String sql = ""; //查询字串


  public DbConnection() {

  }


  /** 取得表的最大记录号
   * @param tableName 表名称

   * @return 最大记录号
   */
  public int getMaxId(String tableName) {
    try {
      int MaxId;
      tableName = tableName.toLowerCase();
      sql = "select RC_maxid from tb_rowcount where RC_tablename = '"+ tableName +"'";

      if (stmt == null)
        stmt = conn.createStatement();

      rs = stmt.executeQuery(sql);

      if (rs.next()) {
        MaxId = rs.getInt(1)+1;
        sql = "update tb_rowcount set RC_maxid=" + MaxId + " where RC_tablename = '"+ tableName +"'";
        stmt.executeUpdate(sql);
      }
      else {
        sql = "insert into tb_rowcount values ('"+ tableName +"',2)";
        stmt.executeUpdate(sql);
        MaxId = 1;
      }
      
      return MaxId;
    } catch(Exception e) {
      System.out.println(e.getMessage());
      return 0;
    }
  }


  public Connection getCon() {
    try {

        cfn = new ConfigInfo();
        String strDBConType = cfn.getValue("dbcon_type");
        if ("jndi".equalsIgnoreCase(strDBConType)) {
        	String url = cfn.getValue("jndi");
        	ctx = new InitialContext();
        	ds = (DataSource) ctx.lookup(url);
        	conn = ds.getConnection();
        } 
        else if (strDBConType.equalsIgnoreCase("direct")) {        
          String strUrl = cfn.getValue("dburl");
          String strDBDriver = cfn.getValue("dbdriver");
          String strWebname = cfn.getValue("dbusername");
          String strWebpass = cfn.getValue("dbpassword");

          Class.forName(strDBDriver);
        
          conn = DriverManager.getConnection(strUrl, strWebname, strWebpass);
        }
        else if (strDBConType.equalsIgnoreCase("Connection Pool")) {   

          //String strIniConFac = cfn.getValue("initial_context_factory");
          //String strProUrl = cfn.getValue("provider_url");
          String strJNDI = cfn.getValue("jndi");
          
          /*Hashtable ht = new Hashtable();
          ht.put(Context.INITIAL_CONTEXT_FACTORY,strIniConFac);
          ht.put(Context.PROVIDER_URL,strProUrl);
          ctx = new InitialContext(ht);*/        	

         // ctx = new InitialContext();
        //  ds = (DataSource)ctx.lookup(strJNDI);
        //  conn = ds.getConnection();
          conn = ConnectPool.getInstance().getConnection();
        }
      } catch (Exception e) {
        e.printStackTrace();
      }    
      return conn;
    }
  
  
  public static void main(String[] args) {     

  }

}

配置文件：

<?xml version="1.0" standalone="yes"?>
<config>
	<server_path>G:\\work\\stfb\\WebRoot</server_path>
	<server_path_web>/stfb</server_path_web>
	<webapp_path_prefix>/stfb</webapp_path_prefix>
	<http_path>http://localhost:8010/</http_path><!-- 应用所在目录 不用 -->
	<os>windows</os>
	<test>aaaaa</test>
	<!--
	  <dburl>jdbc:jtds:sqlserver://10.1.41.101:1433/stww</dburl>
	  <dbdriver>net.sourceforge.jtds.jdbc.Driver</dbdriver>
	  <dbusername>sa</dbusername>
	  <dbpassword>sa</dbpassword>
	-->
	<!--
	  <dbcon_type>direct</dbcon_type>
	  <dburl>jdbc:oracle:thin:@10.1.41.158:1521:ORCL</dburl>
	  <dbdriver>oracle.jdbc.driver.OracleDriver</dbdriver>
	  <dbusername>test</dbusername>
	  <dbpassword>test</dbpassword>
	-->
  	<initial_context_factory></initial_context_factory>
  	<provider_url></provider_url>

	<dbcon_type>jndi</dbcon_type>
	<jndi>java:comp/env/stfb</jndi><!-- notice: not "sfpt" -->

</config>