现在假如项目目录名为: test
程序代码:
<Context path="/test" reloadable="true" docBase="test"> <Resource name="jdbc/ JSPtest" auth="Container" type=" Javax.sql.DataSource"/> <ResourceParams name="jdbc/ JSPtest"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>username</name> <value>root</value> </parameter> <parameter> <name>password</name> <value> JSP</value> </parameter> <parameter> <name>driverClassName</name> <value>com. MySQL.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc: MySQL://localhost:3306/ JSPtest?autoReconnect=true</value> </parameter> <parameter> <name>initialSize</name> <value>20</value> </parameter> <parameter> <name>maxActive</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> </ResourceParams> </Context>
程序代码:
package test; import Java.sql.*; import Javax.naming.*; import Javax.sql.DataSource; public class DatabaseConnection { public static Connection getConnection() throws SQLException,NamingException { try { Context initCtx = new Javax.naming.InitialContext(); Context envCtx = (Context) initCtx.lookup(" Java:comp/env"); DataSource ds = (DataSource)envCtx.lookup("jdbc/ JSPtest"); return ds.getConnection(); } catch(SQLException e) { throw e; } catch(NamingException e) { throw e; } } } 写好这个类后,项目中的任何JSP,Servlet都可以把该包进行导入! | |
转载:北天JAVA技术网(www.java114.com) |
mysql连接池连接JSP
最新推荐文章于 2022-08-10 18:44:32 发布