</parameter>

          </ResourceParams>

        </Context>

3.在相应用到该连接池的Web-app(部署好的web应用，一般在%TOMCAT_HOME%的webapps目录下，也可以通过编辑server.xml来改变，下同)的WEB-INF下面修改web.xm l，在web-app分支内加入数据源

<resource-ref>

            <description>Oracle Connectiong Pool</description>

            <res-ref-name>jdbc/oracle</res-ref-name>

            <res-type>javax.sql.DataSource</res-type>

            <res-auth>Container</res-auth>

  </resource-ref>

  <resource-ref>

            <description>Oracle Connectiong Pool</description>

            <res-ref-name>jdbc/DB2</res-ref-name>

            <res-type>javax.sql.DataSource</res-type>

            <res-auth>Container</res-auth>

  </resource-ref>  

测试及调用方法

<%

  Connection conn=null;

  Statement stmt =null;

  ResultSet rs=null;

  try{

              Context initContext = new InitialContext();

              Context envContext=(Context)initContext.lookup("java:/comp/env");

              DataSource ds = (DataSource)envContext.lookup("jdbc/DB2");

              conn = ds.getConnection();

              if(conn!=null){

                       System.out.println("create connection  sucess!");

                       stmt = conn.createStatement();

                       if(stmt!=null){

                                 System.out.println("create stmt sucess!");

                                  rs=stmt.executeQuery("select * from WST_TB_CITY");

                                 while(rs.next()){

                                            out.println(rs.getString("CITYNAME")+"<br>");

上一页  [1] [2] [3] [4]  下一页