??
字號:
Tomcat中通過JNDI配置訪問數據庫
1,所需要的jar文件:commons-pool.jar, commons-dbcp.jar
2,server.xml的配置:
<Resource name="jdbc/hellohibernate" scope="Shareable" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/hellohibernate"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> <!-- DBCP database connection settings --> <parameter> <name>url</name> <value>jdbc:mysql://localhost:3306/test</value> </parameter> <parameter> <name>driverClassName</name><!--<value>com.mysql.jdbc.Driver</value>--> <value>org.gjt.mm.mysql.Driver</value> </parameter> <parameter> <name>username</name> <value>root</value> </parameter> <parameter> <name>password</name> <value></value> </parameter>
<!-- DBCP connection pooling options --> <parameter> <name>maxWait</name> <value>3000</value> </parameter> <parameter> <name>maxIdle</name> <value>100</value> </parameter> <parameter> <name>maxActive</name> <value>10</value> </parameter> </ResourceParams>
3,程序中的調用:
Context ctx = new InitialContext(); if (ctx == null) throw new Exception("Boom - No Context");
DataSource ds = (DataSource) ctx.lookup( "java:comp/env/jdbc/hellohibernate");
if (ds != null) { Connection conn = ds.getConnection();
if (conn != null) { foo = "Got Connection " + conn.toString(); Statement stmt = conn.createStatement(); ResultSet rst = stmt.executeQuery( "select username,id from user"); if (rst.next()) { foo = rst.getString(1); bar = rst.getInt(2); } conn.close(); } }
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -