分类
Tomcat 中通过 JNDI 配置访问数据库‖
| <b>2，server.xml的配置：</b> |
| <Resource name="j | dbc/hellohibernate" scope="S | hareable" 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> |
| <b>3，程序中的调用：</b> |
| Context ctx = new InitialContext(); |
| if (ctx == null) |
| thro | w new Exception("Boom - No C | ontext"); |
| DataSource ds = |
| (DataSource) ctx.lookup( |
| "jav | a:comp/env/jdbc/hellohiberna | te"); |
| if (ds != null) { |
| Connection conn | = ds.getConnection(); |
| if (conn != null) { |
| foo = "Got C | onnection " + conn.toString(); |
| | Statement stmt = conn.create | Statement(); |
| ResultSet rst = |
| stmt.executeQuery( |
| "select | username,id from user"); |
| if (rst.next()) { |
| foo = rst.getString(1); |
| bar = rst.getInt(2); |
| } |
| conn.close(); |
| } |
| } |