本文详细介绍如何在Tomcat中配置SQL Server数据库连接，包括所需驱动包的安装、连接池设置、JNDI资源引用及页面测试代码。
1．配置驱动包
将如下三个sql2000的驱动jar包复制到tomcat-root/common/lib目录下
msbase.jar
mssqlserver.jar
msutil.jar
（注：tomcat-root：tomcat的根目录）
2．配置连接池
在tomcat-root/conf/server.xml里添加以下红色代码片段：
|
<!-- 上面省略 -->
<Host name="localhost" appBase="webapps" unpackWARs="true"
autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false">
<Context path="/connPoll" docBase="connPoll" debug="5"
reloadable="true" crossContext="true">
<Resource name="jdbc/EmployeeDB" auth="Container"
type="javax.sql.DataSource" username="sa" password=""
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"
maxActive="8" maxIdle="4" />
</Context>
</Host>
<!-- 下面省略 -->
|
3．在web.xml里添加JNDI资源的引用，代码如下：
|
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<resource-ref>
<description>
Resource reference to a factory for java.sql.Connection
instances that may be used for talking to a particular
database that is configured in the server.xml file.
</description>
<res-ref-name>jdbc/EmployeeDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
|
4．页面测试
test.jsp
|
<%@ page language="java" import="java.util.*" contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Tomcat5.5连接池测试</title>
</head>
<body>
<%
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/EmployeeDB");
Connection conn = ds.getConnection();
Statement sta = conn.createStatement();
ResultSet rs = sta.executeQuery("select * from authors");
while (rs.next()) {
out.println(rs.getString("au_lname") + "<br>");
}
conn.close();
%>
</body>
</html>
|
扫一扫
140
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
