tomcat、jboss 连接池配置

-----------------------tomcat------------------------------------------
-----------------------tomcat------------------------------------------

1. tomcat 服务器在配置连接池的时候，首先把需要的jar包放在服务器的lib文件夹下，
   启动服务器时就要调用如(classes12.jar)

2. 具体应用下增加需要的jar包

3. %tomcat_home%\conf\context.xml增加如下内容:
   <Resource name="jdbc/testww"       
                  auth="Container" type="javax.sql.DataSource"  
                  driverClassName="oracle.jdbc.driver.OracleDriver"  
                  maxIdle="20"  
                  maxWait="5000"  
                  username="dw"  
                  password="dw"  
                  url="jdbc:oracle:thin:@137.32.44.176:1521:testww"       
                  maxActive="100"   
                  removeAbandoned="true"  
                  removeAbandonedTimeout="60"  
                  logAbandoned="true"/>

4. web.xml中增加引用内容：
   <resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/testww</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

5.***.java
  
    // 初始化查找命名空间  
    Context initContext = new InitialContext();  
    Context envContext = (Context)initContext.lookup("java:/comp/env");  
    // 找到DataSource  
    DataSource ds = (DataSource)envContext.lookup("jdbc/testww");  
    Connection conn = ds.getConnection();  
   PreparedStatement pst = conn.prepareStatement("select * from area");
    ResultSet rset = pst.executeQuery();
    
    ResultSetMetaData meta = rset.getMetaData();
    //获取每条记录的列名、列类型名
    List<Map<String,String>> columns = new ArrayList<Map<String,String>>();
    for(int i=1; i<=meta.getColumnCount(); i++){
     String columnName = meta.getColumnName(i);
     String columnTypeName = meta.getColumnTypeName(i);
     Map<String,String> map = new HashMap<String,String>();
     map.put("columnName", columnName);
     map.put("columnTypeName", columnTypeName);
     columns.add(map);
    }
    //转换结果集
    List<Map<String,Object>> result = new ArrayList<Map<String,Object>>();
    while(rset.next()){
     Map <String,Object> resultMap = new HashMap<String,Object>();
     for(int i=0; i<columns.size(); i++){
     Map<String,String> tp = (Map<String,String>)columns.get(i);
     String columnName = tp.get("columnName");
     String columnTypeName = tp.get("columnTypeName");