server.xml
<!-- Myweb -->
<Context path="/myweb" docBase="myweb" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
<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>test</value>
</parameter>
<parameter>
<name>password</name>
<value>1234</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs</value>
</parameter>
</ResourceParams>
</Context>------------------
web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<display-name>My Web</display-name>
<servlet-mapping>
<servlet-name>invoker</servlet-name>
<url-pattern>/servlet/*</url-pattern>
</servlet-mapping>
<resource-ref>
<res-ref-name>jdbc/mydb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>-------------
jsp<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%><%
DataSource ds = null;
Connection conn = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("jdbc/mydb"); conn = ds.getConnection();
if(conn!=null)
out.println("Connection is OK!");
else
out.println("Connection Failed!");
}catch(Exception e){
out.println(e.getMessage());
}
%>-----
servlet
import java.sql.*;
import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;public class JDBCPoolServ extends HttpServlet
{
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,IOException {
DataSource ds=null;
Connection con=null;
String val="null",title="JDBC Pooling Test";
try{
Context initCtx = new InitialContext();
// if(initCtx == null )
// throw new Exception("Boom - No Context");
ds = (DataSource)initCtx.lookup(
"java:comp/env/jdbc/mydb");
if (ds != null){
con = ds.getConnection();
if (con != null){
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from authors");
rs.next();
val=rs.getString("au_id");
rs.close();
stmt.close();
}
con.close();
}
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>" + title + "</title>");
out.println("</head>");
out.println("<body bgcolor=\"white\">");
out.println("<h1>" + val + "</h1>");
out.println("</body>");
out.println("</html>");
}
}-------------
<!-- Myweb -->
<Context path="/myweb" docBase="myweb" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
<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>test</value>
</parameter>
<parameter>
<name>password</name>
<value>1234</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs</value>
</parameter>
</ResourceParams>
</Context>------------------
web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<display-name>My Web</display-name>
<servlet-mapping>
<servlet-name>invoker</servlet-name>
<url-pattern>/servlet/*</url-pattern>
</servlet-mapping>
<resource-ref>
<res-ref-name>jdbc/mydb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>-------------
jsp<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%><%
DataSource ds = null;
Connection conn = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("jdbc/mydb"); conn = ds.getConnection();
if(conn!=null)
out.println("Connection is OK!");
else
out.println("Connection Failed!");
}catch(Exception e){
out.println(e.getMessage());
}
%>-----
servlet
import java.sql.*;
import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;public class JDBCPoolServ extends HttpServlet
{
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,IOException {
DataSource ds=null;
Connection con=null;
String val="null",title="JDBC Pooling Test";
try{
Context initCtx = new InitialContext();
// if(initCtx == null )
// throw new Exception("Boom - No Context");
ds = (DataSource)initCtx.lookup(
"java:comp/env/jdbc/mydb");
if (ds != null){
con = ds.getConnection();
if (con != null){
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from authors");
rs.next();
val=rs.getString("au_id");
rs.close();
stmt.close();
}
con.close();
}
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>" + title + "</title>");
out.println("</head>");
out.println("<body bgcolor=\"white\">");
out.println("<h1>" + val + "</h1>");
out.println("</body>");
out.println("</html>");
}
}-------------
如果有,你也把它加到COMMON\LIB下了,那你要确认一下你下载的JAR的版本也TOMCAT版本有没关系?(偶配的是TOMCAT4.1.12,里面已经有那两个包了~)
commons-collections.jar
这个包里有org/apache/commons/collections/CursorableLinkedList
LOOKLOOK~