出处:淘特网
注:转载请注明出处
1.不用tomcat5的管理页面设置(没有设置成功)
首先在tomcat5.0commonlib里面添加mssql的驱动:
msbase.jar,mssqlserver.jar,msutil.jar
2.在tomcat5confserver.xml中添加:
<host>
.......
.......
//下面是添加的内容
<Context path="/pool" docBase="/pool" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/SqlServermidp" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SqlServermidp">
<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=midp</value>
</parameter>
<parameter>
<name>username</name>
<value>zdmilan</value>
</parameter>
<parameter>
<name>password</name>
<value>zd2511052</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
//添加的内容结束
</Host>
3.在tomcat5.0webappspoolWEB-INFweb.xml内容如下:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<resource-ref>
<res-ref-name>
jdbc/SqlServermidp
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
</web-app>
4.tomcat5.0webappspooltestpool.jsp 代码如下:
<html>
<%@page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<body>
this is a tomcat datasource pool example <br>
<%
try
{
DataSource ds = null;
InitialContext ctx=new InitialContext();
if(ctx==null)throw new Exception("没有匹配的上下文环境");
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/SqlServermidp");
if(ds==null)throw new Exception("没有匹配的数据库");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select * from Person_Info";
ResultSet rs = stmt.executeQuery(strSql);
while(rs.next())
{
out.println(rs.getString(1)); %><br>
<%
}
out.println("数据库连接成功!!!");
}
catch(Exception e)
{
out.println("somthing error!");
}
finally
{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(cnnn!=null)
cnn.close();
if(ctx!=null)
ctx.close();
}
%>
</body>
</html>
注:转载请注明出处
1.不用tomcat5的管理页面设置(没有设置成功)
首先在tomcat5.0commonlib里面添加mssql的驱动:
msbase.jar,mssqlserver.jar,msutil.jar
2.在tomcat5confserver.xml中添加:
<host>
.......
.......
//下面是添加的内容
<Context path="/pool" docBase="/pool" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/SqlServermidp" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SqlServermidp">
<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=midp</value>
</parameter>
<parameter>
<name>username</name>
<value>zdmilan</value>
</parameter>
<parameter>
<name>password</name>
<value>zd2511052</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
//添加的内容结束
</Host>
3.在tomcat5.0webappspoolWEB-INFweb.xml内容如下:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<resource-ref>
<res-ref-name>
jdbc/SqlServermidp
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
</web-app>
4.tomcat5.0webappspooltestpool.jsp 代码如下:
<html>
<%@page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<body>
this is a tomcat datasource pool example <br>
<%
try
{
DataSource ds = null;
InitialContext ctx=new InitialContext();
if(ctx==null)throw new Exception("没有匹配的上下文环境");
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/SqlServermidp");
if(ds==null)throw new Exception("没有匹配的数据库");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select * from Person_Info";
ResultSet rs = stmt.executeQuery(strSql);
while(rs.next())
{
out.println(rs.getString(1)); %><br>
<%
}
out.println("数据库连接成功!!!");
}
catch(Exception e)
{
out.println("somthing error!");
}
finally
{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(cnnn!=null)
cnn.close();
if(ctx!=null)
ctx.close();
}
%>
</body>
</html>