1、在cofig/server.xml中配置应用
<Context path="/jndi" docBase="C:\workproduct\TestJNDI\web" debug="0"
reloadable="true" crossContext="true" URIEncoding="UTF-8">
<Resource
name="jdbc/mysql"
type="javax.sql.DataSource"
password="2008"
driverClassName="org.gjt.mm.mysql.Driver"
maxIdle="2"
maxWait="50"
username="root"
url="jdbc:mysql://localhost:3306/test"
maxActive="4"/>
</Context>
2、在web.xml中加入
<resource-ref>
<description>test connection</description>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3、将mysql驱动包拷贝至lib目录中。
4、在web目录中新建页面,index.jsp,输入下列内容:
<%@ page
language="java"
contentType="text/html; charset=UTF-8"
import=
"java.io.*,
java.sql.*,
java.util.*,
javax.servlet.*,
javax.naming.*,
javax.servlet.http.*,
javax.sql.*"
%>
<%
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
Connection conn = ds.getConnection();
out.println(conn.toString());
conn.close();
%>
hello!
5、浏览器上输入:http://localhost:8080/jndi/ 显示:jdbc:mysql://localhost:3306/test, UserName=root@localhost, MySQL-AB JDBC Driver hello!