1. tomcat中添加jndi数据源,修改server.xml文件中标签的内容,如下所示
- <Context docBase="TestDevon" path="/TestDevon"
- reloadable="true" source="org.eclipse.jst.j2ee.server:TestDevon">
- <Resource auth="Container" name="jdbc/mysql" type="javax.sql.DataSource" />
- <ResourceParams name="jdbc/mysql">
- <parameter>
- <name>maxWaitname>
- <value>5000value>
- parameter>
- <parameter>
- <name>maxActivename>
- <value>20value>
- parameter>
- <parameter>
- <name>factoryname>
- <value>
- org.apache.commons.dbcp.BasicDataSourceFactory
- value>
- parameter>
- <parameter>
- <name>urlname>
-
- <value>
- jdbc:mysql://localhost:3306/testdevon?autoReconnect=true
- value>
- parameter>
- <parameter>
- <name>driverClassNamename>
- <value>
- com.mysql.jdbc.Driver
- value>
- parameter>
- <parameter>
- <name>maxIdlename>
- <value>10value>
- parameter>
- <parameter>
- <name>usernamename>
- <value>rootvalue>
- parameter>
- <parameter>
- <name>passwordname>
- <value>lgcnschinavalue>
- parameter>
- ResourceParams>
- Context>
-
2. 确认MySql驱动是否存放在tomcat下的common\lib文件夹中
3. 测试数据源的配置是否成功
(1) 在web.xml中添加如下代码
- <resource-ref>
- <description>DataSourcedescription>
- <res-ref-name>jdbc/mysqlres-ref-name>
- <res-type>javax.sql.DataSourceres-type>
- <res-auth>Containerres-auth>
- resource-ref>
- (2) 测试数据源
-
-
- test jndi
-
-
- <%
- Context initCtx = new InitialContext();
- Context ctx = (Context) initCtx.lookup("java:comp/env"); DataSource ds = (DataSource) ctx.lookup("jdbc/mysql");
- Connection conn = ds.getConnection();
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("select * from user_info");
- while (rs.next()) {
- %>
- <%=rs.getInt(1)%>
- <%
- }
- rs.close();
- stmt.close();
- conn.close();
- %>
-
-
阅读(544) | 评论(0) | 转发(0) |