Spring Boot 集成Mybatis

1、在pom.xml中添加Mybatis依赖包和mysql数据库连接依赖

        <dependency>  
            <groupId>org.mybatis.spring.boot</groupId>  
            <artifactId>mybatis-spring-boot-starter</artifactId>  
            <version>1.3.0</version>  
         </dependency> 

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.35</version>
        </dependency> 

 

2、创建User实体类

package com.example.jdbc.mybatis.model;

public class User {

    private Integer  id;
    private String firstName;
    private String lastName;

    public User() {}

    public User(String firstName, String lastName) {
        this.firstName = firstName;
        this.lastName = lastName;
    }
    
    

    public Integer  getId() {
        return id;
    }

    public void setId(Integer  id) {
        this.id = id;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    @Override
    public String toString() {
        return String.format(
                "Customer[id=%s, firstName='%s', lastName='%s']",
                id, firstName, lastName);
    }

}
 

3、创建mapper 实现数据库增删查改

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://www.mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.jdbc.mybatis.mapper.UserMapper">
    <select id="getAllUser"  resultType="com.example.jdbc.mybatis.model.User">
        select first_name firstName,last_name lastName from user
    </select>
    
    <select id="getUserByExample" parameterType="com.example.jdbc.mybatis.model.User" resultType="com.example.jdbc.mybatis.model.User">
        select first_name firstName,last_name lastName from user
        where 1=1
        <if test="firstName != null">
           and first_name=#{firstName}
        </if>
        
       <if test="lastName != null">
           and last_name=#{lastName}
        </if>
    </select>
    
    <delete id="deleteUser" parameterType="Integer">
        delete from user where id =#{id}
    </delete>
    <insert id="addUser" parameterType="com.example.jdbc.mybatis.model.User">
        insert into user(first_name,last_name)values(#{firstName},#{lastName})
    </insert>
</mapper>

 

package com.example.jdbc.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.example.jdbc.mybatis.model.User;

@Mapper
public interface  UserMapper {
    List<User> getAllUser();
    
    
    List<User> getUserByExample(User user);
    
    User deleteUser(Integer id);
    
    void addUser(User user);

}
 

 

5、编写service 类

 

package com.example.jdbc.mybatis.service;

import java.util.List;

import com.example.jdbc.mybatis.model.User;

public interface UserService {
    
    //添加用户
    public User addUser(User user);
    
    //添加用户
    public void deleUser(String firstName);
    
    //获取用户
    public List<User> getAllUser();
    
    public List<User> getUserByExample(User user);

}
 

 

 

 

package com.example.jdbc.mybatis.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.jdbc.mybatis.mapper.UserMapper;
import com.example.jdbc.mybatis.model.User;
import com.example.jdbc.mybatis.service.UserService;

@Service
public class UserServiceImpl implements UserService{
    @Autowired
    private UserMapper userMapper;
    @Override
    public User addUser(User user) {
        userMapper.addUser(user);
        return null;
    }

    @Override
    public void deleUser(String firstName) {
        // TODO Auto-generated method stub
        //return null;
    }

    @Override
    public List<User> getAllUser() {
        // TODO Auto-generated method stub
        List<User> users=userMapper.getAllUser();
        return users;
    }
    
    
    @Override
    public List<User> getUserByExample(User user) {
        // TODO Auto-generated method stub
        List<User> users=userMapper.getUserByExample(user);
        return users;
    }
    
    

}
 

6、properties配置文件修改连接数据库

 

spring.datasource.driver-class-name=net.sf.log4jdbc.DriverSpy
spring.datasource.url=jdbc:log4jdbc:mysql://localhost:3306/test?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456