先导入c3p0及mysql连接jar包
public class JDBCUtil {
//连接数据库的通用方法二:使用properties
public static Connection getConnect(){
Properties pro = new Properties();
Connection conn=null;
try {
//加载外部文件
pro.load(JDBCUtil.class.getClassLoader().getResourceAsStream("jdbc.properties"));
//获取外部文件的key键及值
String jdbcDriver = pro.getProperty("jdbcDriver");
String jdbcUrl=pro.getProperty("jdbcUrl");
String user=pro.getProperty("user");
String password=pro.getProperty("password");
//加载驱动
Class.forName(jdbcDriver);
conn=DriverManager.getConnection(jdbcUrl, user, password);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return conn;
}
// 连接数据库的通用方法一:使用c3p0
public static Connection getConn(){
Connection conn=null;
try {
ComboPooledDataSource dataSource = new ComboPooledDataSource("hello");
conn=dataSource.getConnection();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}