1)下载mm.mysql-2.0.14-bin.jar包，放在tomcat目录下的common/lib文件夹中

2)在tomcat目录下的conf/server.XML中的前加入(注意:全部大写的地方要替换成你自己的东西)

factory org.apache.commons.dbcp.BasicDataSourceFactory driverClassName org.gjt.mm.mysql.Driver url jdbc:mysql://localhost:3306/DATABASE_NAME?autoReconnect=true username DB_USERNAME password DB_PASSword maxActive 100 maxIdle 30 maxWait 10000 这样就算连接完了

3)测试:

DATABASE_NAME:testdb

APPLICATION_NAME:mysqlTest

在testdb数据库里新建表userinfo

id | username1 aaa2 bbb

4)web.XML

MySQL Datasource example jdbc/testdb javax.sql.DataSource Container

5)index.JSP

<%@ page contentType="text/HTML;charset=gb2312" language="java" import="java.sql.*,javax.naming.*"%>

<% Context initCtx = new InitialContext(); Context ctx = (Context) initCtx.lookup("java:comp/env"); Object obj = (Object) ctx.lookup("jdbc/testdb"); javax.sql.DataSource ds = (javax.sql.DataSource)obj; Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); String strSql = "select * from userinfo"; ResultSet rs = stmt.executeQuery(strSql);%>

<%while(rs.next()){%>

<%=rs.getString("username")%>

可以看到输出结果为:

aaabbb