環境需求：eclipse（springboot，Tomcat，maven）和MySQL數據庫

1.首先配置pom文件和application.yml文件

application.yml

server:port: 8080 spring:datasource:url: jdbc:mysql://localhost:3306/test_1?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=truepassword: rootusername: root #useUnicode 允許使用自定義字符編碼

pom.xml
：

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.3.4.RELEASE</version><relativePath /> <!-- lookup parent from repository --></parent><groupId>com.example</groupId><artifactId>demo</artifactId><version>0.0.1-SNAPSHOT</version><name>demo</name><description>Demo project for Spring Boot</description><properties><java.version>1.8</java.version></properties><dependencies><!-- mysql --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency><!-- Java Persistence API --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency><!-- thymeleaf --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-thymeleaf</artifactId></dependency><!-- web --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web-services</artifactId></dependency><!-- websocket --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-websocket</artifactId></dependency><!-- mybatis --><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.3</version></dependency><!-- 數據庫連接池jar包坐標 --><dependency><groupId>commons-dbcp</groupId><artifactId>commons-dbcp</artifactId><version>1.4</version></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>

2.插入數據庫數據

create database test_1 character set utf8; use test_1; create table user( id int primary key auto_increment, username varchar(10), password varchar(10)); insert into user values(null,'libai','123456'),(null,'tom','admin');

3.添加以下文件

代碼如下：
User.class

package com.example.demo.entity;import java.sql.Date; import javax.persistence.Entity; import javax.persistence.Table;@Entity @Table(name="user") public class User implements java.io.Serializable{private long id;private String Username;private String Password;private Date createdate;public User() {}public long getId() {return id;}public void setId(long id) {this.id = id;}public String getUsername() {return Username;}public void setUsername(String username) {Username = username;}public String getPassword() {return Password;}public void setPassword(String password) {Password = password;}public Date getCreatedate() {return createdate;}public void setCreatedate(Date createdate) {this.createdate = createdate;}}

DBUtils

package com.example.demo; import java.io.InputStream; import java.sql.Connection; import java.util.Properties;import org.apache.commons.dbcp.BasicDataSource; public class DBUtils {//DBCP連接池(BasicDataSource類)private static BasicDataSource ds;static {Properties p=new Properties();InputStream ips=DBUtils.class.getClassLoader().getResourceAsStream("application.yaml");try {p.load(ips);} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}String driver=p.getProperty("driver");String url=p.getProperty("url");String username = p.getProperty("username");String password = p.getProperty("password");//創建數據庫連接池對象ds = new BasicDataSource();//設置數據庫連接信息ds.setDriverClassName(driver);ds.setUrl(url);ds.setUsername(username);ds.setPassword(password);//設置初始連接數量ds.setInitialSize(3);//設置最大連接數量ds.setMaxActive(10000); }public static Connection getConn()throws Exception {//從連接池中獲取連接 拋異常Connection conn = ds.getConnection();return conn;} }

DemoApplication

package com.example.demo;import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement;import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication public class DemoApplication {public static void main(String[] args) {SpringApplication.run(DemoApplication.class, args);//獲取連接try (Connection conn=DBUtils.getConn();) {//創建SQL執行對象Statement stat = conn.createStatement();String sql = "select username,password from user";ResultSet rs = stat.executeQuery(sql);while(rs.next()) {String name = rs.getString("username");String pw = rs.getString("password");System.out.println("賬號："+name+"---密碼："+pw);}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}}}

運行結果：

這表明連接成功了。

本人菜鳥一仗，請多多支持！
上傳了些專享文件和源碼，有興趣的愛好者 請點擊頭像首頁進行下載

總結

以上是生活随笔為你收集整理的springboot---【jdbc】数据库连接池的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。