在Tomcat的context.xml文件中设置如下代码即可:
<Resource name="jdbc/sql2000ds"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
maxActive="20"
maxIdle="30"
maxWait="10000"
username="用户名"
password="密码"
url="jdbc:sqlserver://localhost:端口;DatabaseName=数据库名"
description="myDataSource for JDBC Applications"/>
调用:
Context ct = (Context) new InitialContext();
DataSource ds = (DataSource) ct.lookup("java:/comp/env/jdbc/sql2000ds");
Connection con = ds.getConnection();