整合myBatis

参考项目：G:\学习资料\java\a-study\springboot\com.xufei.springboot\com-xf-springboot-mybatis-01

# 1、导包

查看pom

 <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-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>
            <version>2.1.3</version>
        </dependency>

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


        <!--使用Druid这个连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.0</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

# 2、编写配置文件

#sql语句的扫描路径
mybatis.mapper-locations=classpath:mapper/*.xml
#取别名 给这个包下面的类取别名
mybatis.type-aliases-package=com.xf.springboot.pojo

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql:///user
spring.datasource.username=root
spring.datasource.password=123456
#配置连接池
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

server.port=8080

1
2
3
4
5
6
7
8
9
10
11
12
13

# 3、编写config

@SpringBootConfiguration
@ComponentScan(basePackages = {"com.xf.springboot"})
@MapperScan(basePackages = {"com.xf.springboot.mapper"})
public class AppConfig {
}

1
2
3
4
5

# 4、编写controller

@RestController
public class UserController {

    @Autowired
    private IUserService userService;

    Logger logger = LoggerFactory.getLogger(UserController.class);

    @RequestMapping("add")
    public Object addUser() {

        User user = new User(1, "小飞飞", "123");
        logger.trace("用户是" + user);
        logger.debug("日志你好");
        logger.info("日志你好");
        logger.warn("日志你好");
        logger.error("日志你好");
        userService.add(user);
        return "成功啦";
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

# 5、编写service

@Service
public class UserService implements IUserService {

    @Autowired
    private UserMapper userMapper;

    @Override
    public void add(User user) {
        userMapper.add(user);
    }
}

1
2
3
4
5
6
7
8
9
10
11

# 6、编写mapper

public interface UserMapper {
    void add(User user);
}

1
2
3

# 7、编写mapper.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">
<!--
    1：
    nameSpace：这个只能是当前这个实体的mapper接口对应的 全路径
-->
<mapper namespace="com.xf.mapper.UserMapper">

    <select id="add" parameterType="user">
        insert into users(id,username,password1) values(#{id},#{username},#{password1})
    </select>
    
</mapper>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

最近更新: 2024/12/27, 16:46:15

← 自动配置是如何实现的？整合myBatis→