jndi示范演示

jndi示例演示

1、找到Tomcat安装目录下的conf文件夹中的context.xml

<Context>

      <WatchedResource>WEB-INF/web.xml</WatchedResource>

   <Resource name="jdbc/news"

                      auth="Container"

                      type="javax.sql.DataSource"  maxActive="100" 

                      maxIdle="30"

                      maxWait="10000"

                      username="tom"

                      password="tom"

                      driverClassName="oracle.jdbc.driver.OracleDriver" 

                   url="jdbc:oracle:thin:@localhost:1521:accp" />

</Context>

2、在项目的web.xml文件中加入以下代码：

<resource-ref>

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

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

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

       </resource-ref>

3、在Demo.java文件中加入以下代码:

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.sql.DataSource;

publicclass Demo {

   Connection conn = null;

   PreparedStatement ps = null;

   ResultSet rs = null;

   publicvoid getJndi() {

     try {

        Context ic = new InitialContext();

        DataSource source = (DataSource) ic

             .lookup("java:comp/env/jdbc/news");

        Connection connection = source.getConnection();

        System.out.println("OK");

        ps = connection.prepareStatement("SELECT * FROM BS_USERINFO ");

        ResultSet results = ps.executeQuery();

        while(results.next()){

           System.out.println(results.getString(1));

        }

     } catch (Exception e) {

        e.printStackTrace();

     }

   }

}

4、 在index.jsp中加入以下代码：

<%

     Demo demo = new Demo();

     demo.getJndi();

   %>

5、在工程下加入oracle驱动包、如果有问题，把jar包放到tomcat的bin目录

1楼dianzikuangjie前天 11:18

ssss