SpringBoot - MyBatis - MySql集成

只是简单记录一下整体流程 jdk版本1.8 springboot 版本号2.3.1

dependency

<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>

application.properties

spring.datasource.url=jdbc:mysql://192.168.99.100:32769/durian
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

mybatis.mapperLocations=classpath:dao/*.xml

controller

import com.yuange.durian.model.User;
import com.yuange.durian.service.UserService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

//如果您使用的是@RestController 则不需要在方法上加@ResponseBody
@RestController
@RequestMapping(path = "/user")
@Slf4j
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping(path = "/getUser", method = RequestMethod.GET)
    //@ResponseBody
    public String getUser(String accountNo){
        User user = userService.getUserByAccountNo(accountNo);
        return user.toString();
    }
}

service

interface:

import com.yuange.durian.model.User;

import java.util.List;

public interface UserService {

    public User getUserByAccountNo(String accountNo);
}

impl

import com.yuange.durian.dao.UserDao;
import com.yuange.durian.model.User;
import com.yuange.durian.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class UserServiceImpl implements UserService {

//如果使用Autowired userDao飘红 可以选择使用Resource 
//个人测试如果飘红 并不影响使用 建议使用Autowired
//    @Autowired
    @Resource
    private UserDao userDao;

    @Override
    public User getUserByAccountNo(String accountNo) {
        return userDao.queryByAccountNo(accountNo);
    }
}

dao
interface

import com.yuange.durian.model.User;

import java.util.List;

public interface UserDao {
    User queryByAccountNo(String accountNo);
}

xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yuange.durian.dao.UserDao">

    <select id="queryByAccountNo" resultType="com.yuange.durian.model.User" parameterType="java.lang.String">
        select * from user where accountNo = #{accountNo}
    </select>
</mapper>

Model

import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

@Getter
@Setter
@ToString
public class User {
    private String name;
    private int age;
    private String address;
    private String accountNo;
    private String password;
}

启动类

@SpringBootApplication
//需要加入扫描注解
@MapperScan("com.yuange.durian.dao")
public class DurianApplication {

	public static void main(String[] args) {
		SpringApplication.run(DurianApplication.class, args);
	}

}

请求路径

http://localhost:8080/user/getUser?accountNo=abcdefg

结语

以上即为本次记录的内容 希望能对您有所帮助.谢谢!