Eclipse连接mysql数据库的三种方式(普通连接方式、C3P0连接方式,dbcp连接方式)
普通连接
需要的jar包:mysql-connector-java-8.0.11
获取连接的代码:
public static String URL = "jdbc:mysql://localhost:3306/test? useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
public static String USERNAME = "root";
public static String PASSWORD = "123456";
public Connection getConnection() {
Connection conn = null;
try {
//加载mysql的驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
C3P0连接
需要的jar包:mysql-connector-java-8.0.11,c3p0-0.9.2.1,mchange-commons-java-0.2.3.4
获取连接的代码:
//创建数据库连接池
private static ComboPooledDataSource dataSource = new ComboPooledDataSource();
//创建连接
public Connection getConnection(){
try {
dataSource.setDriverClass("com.mysql.jdbc.Driver");
} catch (PropertyVetoException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false");
dataSource.setUser("root");
dataSource.setPassword("123456");
try {
return dataSource.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
throw new RuntimeException("数据库池连接失败!");
}
}
dbcp连接
需要的jar包:mysql-connector-java-8.0.11,commons-logging-1.1.3,commons-pool2-2.7.0,commons-dbcp2-2.7.0
获取连接的代码:
Connection connection = null;
try {
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false");
dataSource.setUsername("root");
dataSource.setPassword("123456");
connection = dataSource.getConnection();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}