1> 下载驱动JDBC驱动http://dev.mysql.com/downloads/connector/j/5.0.html , 解压缩得到jar文件,如mysql-connector-java-5.0.4-bin.jar,复制到%tomcat%\common\lib下.
2>建立虚拟目录并配置连接池.
在%tomcat%\conf\Catalina\localhost\目录下建立一个与工程同名的xml文件.这里我的工程叫UpdateTesting,所以我建立叫UpdateTesting.xml文件,打开文件添加如下内容.
<Context path="/UpdateTesting" docBase="D:\Tomcat 5.5\webapps\UpdateTesting" reloadable="true" crossContext="true" debug="0" >
<Resource name="jdbc/mytest" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="liuwen" password="liuwen" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=GBK"/>
</Context>
上 面,您需要更改path为"/<工程名>",docBase为"<该工程路径>",username为数据库用户名, password为数据库密码,url为"jdbc:mysql://<数据库服务器ip>/<数据库名>? useUnicode=true&characterEncoding=GBK".
配置完毕.
3>测试
在工程路径下新建一个jsp文件为test.jsp.
<%@page contentType="text/html;charset=gbk"%>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.*"%>
<html>
<body>
<%try{ Context initCtx=new InitialContext();
DataSource db = (DataSource)initCtx.lookup("java:comp/env/jdbc/mytest");
Connection conn = db.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM admin");
out.println("User-list"+"<br>");
while(rs.next()){
out.print(rs.getString(1)+" ");
out.print(rs.getString(2)+"<br>"); }
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
out.print(e);}%>
</body>
</html>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.*"%>
<html>
<body>
<%try{ Context initCtx=new InitialContext();
DataSource db = (DataSource)initCtx.lookup("java:comp/env/jdbc/mytest");
Connection conn = db.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM admin");
out.println("User-list"+"<br>");
while(rs.next()){
out.print(rs.getString(1)+" ");
out.print(rs.getString(2)+"<br>"); }
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
out.print(e);}%>
</body>
</html>
注意更改为您自己的sql代码.
执行,完毕.
from:superlw的专栏
