?? myconnectionpool.java
字號:
package com.bookstore.pool;import java.sql.SQLException;import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSource;public class MyConnectionPool { private static String strDriver = "com.mysql.jdbc.Driver"; private static String strURL = "jdbc:mysql://localhost/bookstore"; private static BasicDataSource ds; public static DataSource getDataSource() { ds = new BasicDataSource(); System.out.println("Setting up data source."); ds.setDriverClassName(strDriver); ds.setUsername("root"); ds.setPassword("clsjz"); ds.setUrl(strURL); ds.setInitialSize(2); ds.setMaxActive(4); System.out.println("Done."); return ds; } public void printDataSourceStats() throws SQLException { System.out.println("NumActive: " + ds.getNumActive()); System.out.println("NumIdle: " + ds.getNumIdle()); } public static void shutdownDataSource(DataSource ds) throws SQLException { BasicDataSource bds = (BasicDataSource) ds; bds.close(); }}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -