李刚的书《轻量级java web企业应用实战》 p33 讲了这个功能。
First, tomcat/conf/context.xml 中加如下代码
<Context>
<Resource name="jdbc/shopping"
auth="Container"
type="javax.sql.DataSource"
description="User database that can be updated and saved"
url="jdbc:mysql://localhost:3306/shopping"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="" />
如果是局部的,只需要
<Context docBase="/home/tomcat/code...">
Second,自己项目的web.xml中</webapp>之前加如下代码,我的是ROOT下,故路径为/tomcat/webapps/ROOT/WEB-INF/web.xml
经过测试,这一步添加的东西不需要
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/myconnect</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Third,加mysql驱动的jar包mysql-connector-java-5.1.31.jar,由于是全局数据源,只需要在tomcat/lib目录下放这个jar包即可
Fourth,hellojsp文件
<%@ page language="java" contentType="text/html;charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="javax.naming.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%
try{
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/shopping");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from mytable");
while(rs.next())
{
out.println(rs.getString(1)+"\t"+rs.getString(2)+"<br/>");
}
conn.close();
}catch(Exception ex)
{
out.println(ex.getMessage());
}
%>
Fifth,数据库名是shopping,表名是mutable
Sixth,这个jsp放在/tomcat/webapps/ROOT/,在浏览器中输入localhost:8080/hello.jsp即可访问
Seventh,将这个jsp放在其他目录或者其他项目目录下,都可以正常访问,只要url路径对即可