server.xml
-------------------------------------
<Host name="localhost" debug="0" appBase="webapps" unpackWARs="true"><Context path="/" docBase="E:\Tomcat\webapps" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="online_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/sqlsvr2k" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/sqlsvr2k">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=classdb</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>testtest</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
</Host>
-------------------------------------web.xml配置
-------------------------------------<resource-ref>
<description>connectDB test</description>
<res-ref-name>jdbc/sqlsvr2k</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
-------------------------------------
test.jspep
-------------------------------
-------------------------------------
<Host name="localhost" debug="0" appBase="webapps" unpackWARs="true"><Context path="/" docBase="E:\Tomcat\webapps" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="online_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/sqlsvr2k" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/sqlsvr2k">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=classdb</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>testtest</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
</Host>
-------------------------------------web.xml配置
-------------------------------------<resource-ref>
<description>connectDB test</description>
<res-ref-name>jdbc/sqlsvr2k</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
-------------------------------------
test.jspep
-------------------------------
-------------------------------
<%@page contentType="text/html; charset=GBK"%>
<%@page import="java.sql.*"%>
<%//@page import="java.util.*"%>
<%@page import="javax.naming.*"%>
<%//@page import="javax.servlet.http.*"%>
<%//@page import="javax.servlet.*"%>
<%@page import="javax.sql.*"%>
<%//@page import="gb.*"%><%
Context ctx=null;
Connection cnn=null;
Statement stmt=null;
ResultSet rs=null;
try
{
ctx=new InitialContext();
if(ctx==null)
throw new Exception("没有匹配的环境");
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/sqlsvr2k");
/*
if(ds==null)
throw new Exception("没有匹配数据库");
cnn=ds.getConnection();
stmt=cnn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from admin");
//读取数据库
if(rs.next()){
out.println(rs.getString("name"));
}
*/
} finally
{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(cnn!=null)
cnn.close();
if(ctx!=null)
ctx.close();
}
%>
-------------------------------