DBHelp.java:

public class DBHelp<T> {

	private static BasicDataSource ds;

	static{

		InputStream stream = DBHelp.class.getClassLoader().getResourceAsStream("db.properties");

		Properties p = new Properties();
		try {
			p.load(stream);

			ds = new BasicDataSource();
			ds.setUrl(p.getProperty("url"));
			ds.setPassword(p.getProperty("pwd"));
			ds.setDriverClassName(p.getProperty("driver"));
			ds.setUsername(p.getProperty("name"));
			ds.setInitialSize(5);
			ds.setMaxActive(20);
			ds.setMaxWait(5000);
			ds.setMinIdle(8);
		} catch (IOException e) {
			e.printStackTrace();
		}

	}

	/**
	 * 获取数据库连接对象
	 * @return Connection类的对象
	 */
	public Connection getConnection() {
		Connection conn =null;
		try {
			conn = ds.getConnection();
		}  catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}


db.properties:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql:///mydb
name=root
pwd=root