springboot使用mybatis

首先先加入依赖

 <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.2.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.30</version>
        </dependency>
        <dependency>
            <groupId>commons-beanutils</groupId>
            <artifactId>commons-beanutils</artifactId>
            <version>1.9.4</version>
        </dependency>
    </dependencies>

springboot启动类，MapperScan注解代表要扫描的包

@SpringBootApplication
@MapperScan(basePackages = "com.wyx.shopping.mapper")
public class ShoppingApplication {
    public static void main(String[] args) {
        SpringApplication.run(ShoppingApplication.class, args);
    }
}

创建实体类，这里用了Lombok

@NoArgsConstructor
@AllArgsConstructor
@ToString
@Data
public class User {
    private Integer id;
    private String username;
    private String password;
    private String email;
    private String tel;
    /**
     * 0代表男，1代表女
     */
    private Integer sex;
    /**
     * 0代表用户，1代表管理员，2代表超级管理员
     */
    private Integer level;
}

配置文件application.yml

servr:
  port: 8080
spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/shopping?serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml
  //代表类路径下mapper中任意以Mapper结尾的XML文件

Mapper层

@Repository
public interface UserMapper {
    public String selectPwdByName(String username);
}

<?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.wyx.shopping.mapper.UserMapper">
    <select id="selectPwdByName" parameterType="string" resultType="string">
        select password from user where username = #{username}
    </select>
</mapper>

service层

public interface UserService {
    public String selectPwdByName(String userName);
}

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserMapper userMapper;
    @Override
    public String selectPwdByName(String userName) {
        return userMapper.selectPwdByName(userName);
    }
}

controller层

@RestController
public class UserController {

    @Autowired
    private UserServiceImpl userService;
    @PostMapping("/test")
    public Result login(){
        return userService.selectPwdByName("wwww");
    }
}

目录结构