第一步:
去maven官网引入阿里Druid数据库连接池和mysql数据库连接池
找到适配的mysql版本
第二步:
将代码复制到pom.xml文件的dependencies里
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.22</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.48</version>
</dependency>
下载成功
第三步:
建立数据库的连接并测试
import com.alibaba.druid.pool.DruidDataSource;
import java.sql.Connection;
public class MySqlDbUtil {
private DruidDataSource dataSource = null;
private void initDataSource() throws Exception {
if (dataSource == null) {
dataSource = new DruidDataSource();
dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/band2");
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUsername("root");
dataSource.setPassword("z..24872126..");
dataSource.setInitialSize(1);
dataSource.setMinIdle(1);
dataSource.setMaxActive(10);
dataSource.setMaxWait(20000);
dataSource.setTimeBetweenConnectErrorMillis(2000);
dataSource.setValidationQuery("select 'x'");
dataSource.setTestWhileIdle(true);
dataSource.setTestOnBorrow(true);
}
}
public Connection getConnect() throws Exception {
Connection conn = null;
initDataSource();
conn = dataSource.getConnection();
return conn;
}
}
第四步:
测试
import cn.edu.mju.project2.dao.impl.MySqlDbUtil;
import org.junit.Test;
public class TestDataSource {
@Test
public void testConnection() {
try {
new MySqlDbUtil().getConnect();
} catch (Exception e) {
e.printStackTrace();
}
}
}
第五步:
测试成功
总结:
中途过程中出现一次错误,JDBC的地址一定要正确以及用户名和密码,不然会报错