sunjavaduke
乒乓球国手-张怡宁
发贴: 176
积分: 6
|
于 2006-05-06 23:18
实例讲解:使用连接池连接MS SQL SERVER 2000
连接MS SQL SERVER 2000时要把msbase.jar,mssqlserver.jar,msutil.jar三个文件复制到%Tomcat 5.0%\common\lib中,这是它的驱动程序,然后要设定Tomcat的server.xml,它位于%Tomcat 5.0%\conf\server.xml,需要建立一个站点,代码如下:添加到server.xml中的</host>前面。
<Context path="\Project" reloadable="true" docBase="Project">
<Resource name="jdbc/Project" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Project">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>sunjavaduke</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=Project;user=sa;password=sunjavaduke;</value>
</parameter>
</ResourceParams>
</Context>
server.xml配置完成之后,就可以对数据库进行操作了,具体代码如下:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,javax.naming.*,javax.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>连接池连接MS SQL SERVER 2000<title>
</head>
<body>
<%
out/print("使用连接池连接MS SQL SERVER 2000<br>");
out.println("<br>");
Context ctx=null;
DataSource ds=null;
Statment stmt=null;
ResultSet rs=null;
Connection con=null;
ResultSetMetaData md=null;
try{
ctx=new InitialContext();
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/Project");
con=ds.getConnection();
stmt=con.createStatment();
rs=stmt.excuteQuery("select * from Test");
md=rs.getMetaData();
out.print(md.getColumnLabel(1)+" ");
out.print(md.getColumnLabel(2)+"<br>");
while(rs.next()){
out.print(rs.getInt(1)+" ");
out.print(rs.getString(2)+"<br>");
}
}catch(Exception e){
out.print(e);
}finally{
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con!=null) con.close();
}
%>
</body>
</html>
----------------------------------------------------------------- icd.Neusoft Co,.Ltd. mail:zhangzhongl@neusoft.com tel:13591718127 QQ:176932855 ------------------------------------------------------------------
|