Tomcat配置JNDI

1.新建context.xml文件，放到WebRoot/META-INF/目录下，context.xml文件样例

<?xml version="1.0" encoding="UTF-8"?>
<Context>
      <Resource name="test" 
				auth="Container" 
				type="javax.sql.DataSource" 
				driverClassName="oracle.jdbc.driver.OracleDriver" 
				url="jdbc:oracle:thin:@127.0.0.1:1521:orcl" 
				username="test" 
				password="test" 
				maxActive="20" 
				maxIdle="10" 
				maxWait="1000"/>
</Context>

2.修改web.xml文件，新加以下代码

  <resource-ref>
  	<description>Oracle DB connection</description>
  	<res-ref-name>test</res-ref-name>
  	<res-type>javax.sql.DataSource</res-type>
  	<res-auth>Container</res-auth>
  </resource-ref>

3.配置数据库连接池 另外将ojdb14.jar置于tomcat安装目录的lib下面
4.配置成功，编写测试类

public class TestPool extends DispatchAction{
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		try {
			Context envContext;
			DataSource ds ;
			try {
				envContext = new InitialContext();
				envContext = (Context) envContext.lookup("java:comp/env");
				ds = (DataSource) envContext.lookup("test"); //查找配置	
				Connection conn=ds.getConnection();
				Statement stm = conn.createStatement();
				ResultSet rs = stm.executeQuery("select * from student where age='24'");
				while(rs.next()){
					System.out.println(rs.getString(1));
					System.out.println(rs.getString(2));
					System.out.println(rs.getString(3));
				}
			} catch (NamingException e) {
				e.printStackTrace();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}