MS SQL Server2000 数据源配置
(注:sqljdbc.jar下载不到的话,找我索取pengqinghui110@126.com)
1、在项目的WebRoot下的META-INF中新建context.xml文件。内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/sqlserver"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433"
username="sa"
password="123456"
maxActive="20"
maxIdle="10"
maxWait="-1" />
</Context>
2、往项目下的web.xml中新增如下代码:
<resource-ref>
<res-ref-name>jdbc/sqlserver</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3、把sqljdbc.jar放到tomcat的lib目录下
4、编写测试程序如下
<%@ page language="java" import="javax.naming.*,javax.sql.*,java.sql.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>数据源测试</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<pre>
<%
out.println("classpath...");
out.println(System.getProperty("java.class.path"));
Context initCtx = new InitialContext();
DataSource ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/sqlserver");
Connection conn = null;
ResultSet rs = null;
try {
conn = ds.getConnection();
DatabaseMetaData dm = null;
if(null!=conn) {
dm = conn.getMetaData();
out.println("Driver Information ");
out.println("/tDriver Name:" + dm.getDriverName());
out.println("/tDriver Version:" + dm.getDriverVersion());
out.println("/tDatabase Information ");
out.println("/tDatabase Name:" + dm.getDatabaseProductName());
out.println("/tDatabase Version:" + dm.getDatabaseProductVersion());
out.println("Available Catalogs ");
rs = dm.getCatalogs();
while(rs.next()) {
out.println("/tcatalog: " + rs.getString(1));
}
} else {
out.println("Error:No active Connection");
}
} catch(Exception ex) {
ex.printStackTrace();
} finally {
if(null!=rs) {
try {
rs.close();
rs = null;
} catch(Exception ex) {}
}
if(null!=conn) {
try {
conn.close();
conn = null;
} catch(Exception ex) {}
}
}
%>
</pre>
</body>
</html>