声明;本人使用的JDK9 ,MYSQL数据库8;项目结构如下;
使用c3p0开发;
工具类;
package utils;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
/**
* @auther SyntacticSugar
* @data 2018/9/14 0014下午 8:50
*/
public class JdbcUtils {
private static Connection conn = null;
PreparedStatement statement = null;
/**
* 获取连接
*
* @return
*/
public static Connection getConnection() {
try {
ComboPooledDataSource source = new ComboPooledDataSource();//创建连接池,获取数据源
conn = source.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void release(PreparedStatement statement, Connection conn) {
try {
if (statement != null) {
statement.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
测试类;
package test;
import org.junit.Test;
import utils.JdbcUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;