spring boot基础知识 —— spring boot 集成 mybatis

朱雀 2022-12-08 14:13 231阅读 0赞

码云地址：[https://gitee.com/hjc2/springboot.git][https_gitee.com_hjc2_springboot.git]

需要添加的依赖如下：

<dependencies>
        <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>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
    
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
    </dependencies>

配置文件：

server.port=8081
    #配置链接地址
    #用户名
    spring.datasource.druid.username=root
    #密码
    spring.datasource.druid.password=123456
    #连接地址
    spring.datasource.druid.url=jdbc:mysql://localhost:3306/spider_factory?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    #驱动
    spring.datasource.druid.driver-class-name=com.mysql.jdbc.Driver
    #设置mybatis
    #实体映射的包
    mybatis.type-aliases-package=com.dream.entity
    #xml文件所在的包
    mybatis.mapper-locations=classpath:static/mapper/*.xml
    
    #展示SQL
    logging.level.com.dream.dao=debug

controller层：

@RestController
    public class IndexController {
        @Autowired
        IndexService indexService;
    
        @RequestMapping(value = "/index")
        public String index() {
            return String.valueOf(indexService.getCount());
        }
    }

service层：

public interface IndexService {
        int getCount();
    }
    
    实现层：

@Service
    public class IndexServiceImpl implements IndexService {
        @Autowired
        UserMapper UserMapper;
    
        @Override
        public int getCount() {
            return UserMapper.getCount1();
        }
    }

dao层：映射xml文件的需要加注解 @Mapper

@Mapper
    public interface UserMapper {
        int getCount1();
    }

欢迎关注我的微信公众号,更多内容将在微信公众号中发布：

![20201214163531501.jpg][]

[https_gitee.com_hjc2_springboot.git]: https://gitee.com/hjc2/springboot.git
[20201214163531501.jpg]: /images/20221123/2ccddc96a5ff4938971cea3b29c6ae9a.png