2014个人网站备案,搜索引擎优化服务,免费个人网站建设哪里好,网站开发的岗位与分工转载自 tomcat7.0.42如何设置mysql数据库连接池
如何在tomcat7.0.42中设置mysql数据库连接池????eclipse如何绑定tomcat??按网上教程总不成功!怎么办server.xmlResource namejdbc/test authContainer typejavax.sql.DataSourceResource namejdbc/test authContainer typejavax.sql.DataSource factoryorg.apache.tomcat.jdbc.pool.DataSourceFactory testWhileIdletrue testOnBorrowtrue testOnReturnfalse validationInterval30000 timeBetweenEvictionRunsMillis30000 maxActive100 minIdle10 maxWait10000 initialSize10 removeAbandonedTimeout60 removeAbandonedtrue logAbandonedfalse minEvictableIdleTimeMillis30000 jmxEnabledtrue jdbcInterceptorsorg.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer usernameroot password123 driverClassNamecom.mysql.jdbc.Driver urljdbc:mysql://localhost:3306/test/Host appBasewebapps autoDeploytrue namelocalhost unpackWARstrue
Context docBaseblog3 path/blog3 reloadabletrue sourceorg.eclipse.jst.jee.server:blog3/
/Hostcontext.xmlResourceLink globaljdbc/test namejdbc/test typejavax.sql.DataSource /
Java代码public class DBconn {private static String datasoucename java:comp/env/jdbc/test;Context context null;DataSource ds null;Connection conn null;public Connection getconn() {return initConnection();}public DataSource getDataSource() {try {context new InitialContext();} catch (NamingException e) {System.err.println(连接池上下文不存在! e.getMessage());}try {ds (DataSource) context.lookup(datasoucename);} catch (NamingException e) {System.err.println(数据源没发现! e.getMessage());}return ds;}private Connection initConnection() {try {context new InitialContext();} catch (NamingException e) {System.err.println(连接池上下文不存在! e.getMessage());}try {ds (DataSource) context.lookup(datasoucename);} catch (NamingException e) {System.err.println(数据源没发现! e.getMessage());}try {conn ds.getConnection();} catch (SQLException e) {System.err.println(获取连接失败! e.getMessage());}return conn;}public void freeConnection() {try {conn.close();} catch (Exception e) {System.err.println(释放连接出错! );e.printStackTrace();}}}
