在TOMCAT的配制文件中加入自己的连接池配制,具体位置为:您的站点HOST下的对应的CONTEXT下,
内容如下
TOMCAT5.0中
<Resource name="jdbc/card" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/card">
<parameter>
<name>maxWait</name>
<value>10</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>password</name>
<value>testpwd</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1:3307/testdb</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>testuse</value>
</parameter>
</ResourceParams>
</Context>
<ResourceParams name="jdbc/card">
<parameter>
<name>maxWait</name>
<value>10</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>password</name>
<value>testpwd</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1:3307/testdb</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>testuse</value>
</parameter>
</ResourceParams>
</Context>
TOMCAT5.5及以上
<Resource name="jdbc/card"
type="javax.sql.DataSource"
password="testpwd"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="4"
maxWait="5000"
username="testusr"
url="jdbc:mysql://localhost:3307/testdb?useUnicode=true&characterEncoding=UTF-8"
maxActive="4"/>
上面的各种参数根据自己的不同修改下,帐号,密码,URL等,下列是连接TOMCAT连接池的示例代码
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<html>
<body>
<%
Context ctx = new InitialContext();
Connection conn=null;
ctx = new InitialContext();
DataSource ds =(DataSource)ctx.lookup("java:comp/env/jdbc/card");
conn = ds.getConnection();
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from table1 limit 100";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
<%
out.print(rs.getString(1));
out.print(rs.getString(2));
out.print(rs.getString(3));
}%>
<%
out.print("数据库操作成功,恭喜你");
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<html>
<body>
<%
Context ctx = new InitialContext();
Connection conn=null;
ctx = new InitialContext();
DataSource ds =(DataSource)ctx.lookup("java:comp/env/jdbc/card");
conn = ds.getConnection();
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from table1 limit 100";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
<%
out.print(rs.getString(1));
out.print(rs.getString(2));
out.print(rs.getString(3));
}%>
<%
out.print("数据库操作成功,恭喜你");
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
其中,我们假设testdb中有一表:table1.
运行试试看若还不行,注册在系统中的{$catalina}/common/lib下加上对应的驱动类应该就OK了:)