1.JDBC
1.1 导入jar包
根据自己数据库的版本导入合适的jar包,比如我的mysql是8.0的,就去Maven上找到合适的jar包进行下载。
1.2 写代码
1. 方式一(不用properties文件)
public static void main(String[] args) throws Exception {
//注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//创建连接
Connection con = DriverManager.getConnection("" +
"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8&serverTimezone=Asia/Shanghai"
, "root", "123456");
System.out.println(con);
}
2. 方式二(使用properties文件)
properties文件中的内容:
public static void main(String[] args) throws Exception {
//注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
FileInputStream file = new FileInputStream("blog/src/com/jdbc.Properties");
Properties pro = new Properties();
pro.load(file);
//创建连接
Connection con = DriverManager.getConnection("" +
"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8&serverTimezone=Asia/Shanghai"
,pro);
System.out.println(con);
}
2.c3p0连接池
2.1 导入jar包
需要导入3个jar包。
2.2 写代码
c3p0-config.xml文件中的内容:
<c3p0-config>
<!-- 使用默认的配置读取连接池对象 -->
<default-config>
<!-- 连接参数 -->
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC</property>
<property name="user">root</property>
<property name="password">123456</property>
<!-- 连接池参数 -->
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">10</property>
<property name="checkoutTimeout">3000</property>
</default-config>
</c3p0-config>
public static void main(String[] args) throws SQLException {
ComboPooledDataSource dataSource = new ComboPooledDataSource();
Connection con = dataSource.getConnection();
System.out.println(con);
}
3.druid连接池
3.1 导入jar包
3.2 写代码
properties文件中的内容:
username = root
password = 123456
url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
driver = com.mysql.cj.jdbc.Driver
public static void main(String[] args) throws Exception {
Properties pro = new Properties();
pro.load(new FileInputStream("blog/src/com/druid.properties"));
DataSource dataSource = DruidDataSourceFactory.createDataSource(pro);
Connection con = dataSource.getConnection();
System.out.println(con);
}