http://download.csdn.net/download/tonmingjun/5975661 如果需要代码请去我所在的csdn下载,也能给我一些分。
jndi的连接方式要比jdbc的好是因为有地址池是的连接可以更大化,但是实际上因为现在服务器的硬件支撑其实直接用jdbc就行了,我公司就是这样的
//index.jsp
<%@ page language="java" import="java.util.*,java.sql.*,javax.naming.*,javax.sql.*" pageEncoding="ISO-8859-1"%>
<%
/*
* @author Evangelion
* @date
* @version V 1.0
*/
Connection conn = null;
PreparedStatement psmt=null;
ResultSet rs = null;
DataSource ds=null;
String url;
try{
Context ctx=new InitialContext();//上下文对象 初始化
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/AiomniDB");//反回绑定的对象,looup后括号内容和 tomcat文件下的 context.xml里面设置的名字要一致
conn=ds.getConnection();
String sql="select * from flex_data where type='mx_data201101'";
psmt=conn.prepareStatement(sql);
rs=psmt.executeQuery();
out.println("<?xml version='1.0' encoding='utf-8'?><root>");
while (rs.next())
{
System.out.println(rs.getString(1));
}
out.println("</root>");
rs.close();
psmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
rs.close();
psmt.close();
conn.close();
}
%>
//tomcat下的context.xml
<!-- The contents of this file will be loaded for each web application -->
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
<!-- Uncomment this to enable Comet connection tacking (provides events
on session expiration as well as webapp lifecycle) -->
<!--
<Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
-->
<Resource name="jdbc/AiomniDB" auth="Container" type="javax.sql.DataSource" username=" " password=" " //请填写你数据库的相应数据 driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:orcl" maxActive="100" maxIdle="2" maxWait="500" removeAbandoned="true" removeAbandonedTimeout="360000" logAbandoned="true" />
<Resource name="jdbc/touch" auth="Container" type="javax.sql.DataSource" username=" " password=" " driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:orcl" maxActive="100" maxIdle="2" maxWait="500" removeAbandoned="true" removeAbandonedTimeout="360000" logAbandoned="true" />
</Context>
//web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<welcome-file-list>//默认打开的页面
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<resource-ref>
<description>JNDI DataSource</description>
<res-ref-name>jdbc/AiomniDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>