SpringBoot整合jdbc和mybatis的方法

CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

public class User {
 private Integer id;
 private String username;
 private String address;
 public Integer getId() { return id; }
 public void setId(Integer id) { this.id = id; }
 public String getUsername() { return username; }
 public void setUsername(String username) { this.username = username; }
 public String getAddress() { return address; }
 public void setAddress(String address) { this.address = address; }
 @Override
 public String toString() {
  return "User{" +
    "id=" + id +
    ", username='" + username + '\'' +
    ", address='" + address + '\'' +
    '}';
 }
}

 com.alibaba
 druid-spring-boot-starter
 1.1.10


 mysql
 mysql-connector-java
 runtime
 8.0.18

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.username=username
spring.datasource.password=password
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mydatabase

 org.springframework.boot
 spring-boot-starter-data-jdbc

@Service
public class UserService {

 @Autowired
 JdbcTemplate jdbcTemplate;

 public Integer addUser(User user) {
  return jdbcTemplate.update("insert into user (username,address) values (?,?);",
    user.getUsername(), user.getAddress());
 }

 /**
  * 查询方式一
  * 当类属性和数据库字段不对应时才这样使用
  * @return
  */
 public List getAllUserFirst() {
  return jdbcTemplate.query("select * from user;", new RowMapper() {
   @Override
   public User mapRow(ResultSet resultSet, int i) throws SQLException {
    User user = new User();
    int id = resultSet.getInt("id");
    String address = resultSet.getString("address");
    String username = resultSet.getString("username");
    user.setId(id);
    user.setUsername(username);
    user.setAddress(address);
    return user;
   }
  });
 }

 /**
  * 查询方式二
  * 当类属性和数据库字段对应时就这样使用啦，比上面的简洁很多
  */
 public List getAllUserSecond() {
  return jdbcTemplate.query("select * from user;", new BeanPropertyRowMapper<>(User.class));
 }
}

@SpringBootTest
class JdbcApplicationTests {

 @Autowired
 UserService userService;

 @Test
 public void addUser() {
  User user = new User();
  user.setUsername("johnson2");
  user.setAddress("colablog.cn");
  userService.addUser(user);
 }

 public void queryUsers() {
  List allUserFirst = userService.getAllUserFirst();
  System.out.println(allUserFirst);
 }
}

 org.mybatis.spring.boot
 mybatis-spring-boot-starter
 2.1.1

@Configuration
@MapperScan(basePackages = "cn.colablog.mybatis.mapper")
public class MyBatisConfig {
}

@SpringBootApplication
@MapperScan(basePackages = "cn.colablog.mybatis.mapper")
public class MybatisApplication {
 public static void main(String[] args) {
  SpringApplication.run(MybatisApplication.class, args);
 }
}

@Mapper
public interface UserMapper {
 List getAllUser();
}
UserMapper.xml#
Copy
<?xml version="1.0" encoding="UTF-8" ?>


 
  select * from user
 

 
  
   
    src/main/java
    
     **/*.xml
    
   
   
    src/main/resources
   
  
  ...