当前位置 博文首页 > 范栩的博客:SpringBoot 整合Mybatis框架

    范栩的博客:SpringBoot 整合Mybatis框架

    作者:[db:作者] 时间:2021-08-31 09:51

    第一步 导入Mybatis依赖 jdbc依赖以及 MySQL驱动

    <!--mybatis-->
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.3</version>
    <!--jdbc-->
            </dependency>
            <dependency>
    		    <groupId>org.springframework.boot</groupId>
    		    <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
    <!--mysql-->
            <dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<scope>runtime</scope>
    		</dependency>
    

    第二步 配置yml文件

    spring:
      datasource:
        username: root
        password: 123456
        #serverTimezone 时区
        url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
        driver-class-name: com.mysql.cj.jdbc.Driver
    
    #整合mybatis
    mybatis:
      #别名设置
      type-aliases-package: com.muyu.pojo
      #设置xml文件mapper的位置  classpath:代表的是resources
      mapper-locations: classpath:mybatis/mapper/*.xml
    

    此时已经可以通过mybatis连通数据库

    加注解

    Mapper中加@Mapper

    @Mapper
    public interface UserMapper {
    	List<User> queryUserList();
    

    service类中要加@Service

    @Service
    public class BookServiceImpl implements BookService {
    
    附mybatis 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.muyu.mapper.UserMapper">
      
    </mapper>
    

    此处注意当参数类型为对象的时候,在进行调用的时候需要写成#{book.bname}
    写成#{bname}的话会报错

    <insert id="addBook" parameterType="Book">
            insert into bms_book(bname,author,type,inventory) VALUES(#{book.bname},#{book.author},#{book.type},#{book.inventory})
        </insert>
    
    cs
    下一篇:没有了