3)测试:
DATABASE_NAME:testdb
APPLICATION_NAME:mysqlTest
在testdb数据库里新建表userinfo
id | username1 aaa2 bbb
4)web.xml
<web-app><resource-ref> <description>MySQL Datasource example</description> <res-ref-name>jdbc/testdb</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref></web-app>
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);%>
<body> <%while(rs.next()){%> <p> <%=rs.getString("username")%> </p> <%}%><body>
可以看到输出结果为:
aaabbb
上一页 [1] [2]
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18