SpringBoot整合Jdbc

SpringBoot整合Jdbc

 

（1）、添加相关依赖

 1        <dependency>
 2             <groupId>org.springframework.boot</groupId>
 3             <artifactId>spring-boot-starter-jdbc</artifactId>
 4         </dependency>
 5 
 6         <dependency>
 7             <groupId>mysql</groupId>
 8             <artifactId>mysql-connector-java</artifactId>
 9             <version>8.0.14</version>
10         </dependency>

（2）、在配置文件中配置数据源相关信息

1 spring.datasource.username=root
2 spring.datasource.password=123456
3 spring.datasource.url=jdbc:mysql://localhost:3306/JdbcDemo?serverTimezone=UTC
4 spring.datasource.driver-class-name=com.mysql.jdbc.Driver

（3）、编写service、dao（为了方便我就写在一起了）

 1 package cn.coreqi.service;
 2 
 3 import cn.coreqi.entities.User;
 4 import org.springframework.beans.factory.annotation.Autowired;
 5 import org.springframework.jdbc.core.BeanPropertyRowMapper;
 6 import org.springframework.jdbc.core.JdbcOperations;
 7 import org.springframework.jdbc.core.RowMapper;
 8 import org.springframework.stereotype.Service;
 9 
10 import java.util.ArrayList;
11 import java.util.List;
12 
13 @Service
14 public class UserService {
15     @Autowired
16     private JdbcOperations jdbcOperations;
17     public void addUser(User user){
18         jdbcOperations.update("insert into users(UserName,PassWord,Enabled) values (?,?,?)"
19         ,user.getUserName(),user.getPassWord(),user.getEnabled());
20     }
21     public void addUserList(List<User> users){
22         List<Object[]> datas = new ArrayList<>();
23         for (User s : users){
24             datas.add(new Object[]{s.getUserName(),s.getPassWord(),s.getEnabled()});
25         }
26         jdbcOperations.batchUpdate("insert into users(UserName,PassWord,Enabled) values (?,?,?)"
27         ,datas);
28     }
29     public User getUserById(Integer id){
30         RowMapper<User> rowMapper = new BeanPropertyRowMapper<>(User.class);
31         return jdbcOperations.queryForObject("select * from users where Id = ?",rowMapper,id);
32     }
33     public List<User> getUsers(){
34         RowMapper<User> rowMapper = new BeanPropertyRowMapper<>(User.class);
35         return jdbcOperations.query("select * from users",rowMapper);
36     }
37     public Long getUsersSize(){
38         return jdbcOperations.queryForObject("select count(Id) from users",Long.class);
39     }
40 }

（4）controller调用即可

作者：奇

出处：https://www.cnblogs.com/fanqisoft/

本文版权归作者和博客园共有，欢迎转载，但必须给出原文链接，并保留此段声明，否则保留追究法律责任的权利。