数据库连接池如何使用?
最近在学习数据库操作,写了一个jdbc的程序,其中连接数据库的类代码如下:
package com.extend.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.sql.DataSource;
public class GetConn {
static Connection getConn() {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/tjm_test";
String username = "root";
String password = "";
Connection conn = null;
try {
Class.forName(driver); //classLoader,加载对应驱动
conn = (Connection) DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
想把这段代码用连接池Datasource代替,该怎么改,是用c3p0吗,注:我这是java project不是web程序