Tomcat设立JNDI

Tomcat设置JNDI

1、拷贝数据库驱动到tomcat的lib目录
2、打开conf/context.xml
加入

<Resource name="jdbc/test"    auth="Container"      type="javax.sql.DataSource"      username="jtzt" password="jtzt"      driverClassName="oracle.jdbc.driver.OracleDriver"       url="jdbc:oracle:thin:@localhost:1521:xe"       maxActive="100"       maxIdle="30"       maxWait="10000"/>  

3、打开web.xml
加入

<resource-ref>     <description>OracleDataSource</description>     <res-ref-name>jdbc/test</res-ref-name>     <res-type>javax.sql.DataSource</res-type>     <res-auth>Container</res-auth> </resource-ref>

4、程序访问JDBC数据源

// Obtain our environment naming contextContext initCtx = new InitialContext();Context envCtx = (Context) initCtx.lookup("java:comp/env");// Look up our data sourceDataSource ds = (DataSource)  envCtx.lookup("jdbc/test");// Allocate and use a connection from the poolConnection conn = ds.getConnection();... use this connection to access the database ...conn.close();

或者

// Obtain our environment naming contextContext initCtx = new InitialContext();// Look up our data sourceDataSource ds = (DataSource)  envCtx.lookup("java:comp/env/jdbc/test");// Allocate and use a connection from the poolConnection conn = ds.getConnection();... use this connection to access the database ...conn.close();

查看更多 下一篇