springboot整合mybatis即使用 **mapper.xml 02

系统管理员 2022-10-01 05:43 151阅读 0赞

### 1.如何在springboot中整合Mybatis，并使用 \*\*mapper.xml ？ ###

一、导入相关依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
    
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</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>
        </dependency>
        
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
        </dependency>
    复制代码

二、编写配置文件

spring:
      datasource:
        url: jdbc:mysql://localhost:3306/数据库名?characterEncoding=utf-8&useSSL=false
        username: 用户名
        password: 密码
        driver-class-name: com.mysql.jdbc.Driver
    #配置mybatis 所需映射的mapper.xml 文件的位置
    mybatis:
      mapper-locations: classpath:mapper/*.xml
      #type-aliases-package: com.fancy.account.spu.dbobject
    
    复制代码

三、开始写数据库表对应的java对象，写操作数据库的接口 （同时与相应的 \*\*mapper.xml）文件相映射 Eg:

接口：
    //@Mapper
    public interface TSpuDao {
    
        void addSpu(@Param("spuName") String spuName, @Param("spuHeadphoto") String spuHeadphoto, @Param("spuDetailphoto") String spuDetailphoto, @Param("spuDecphoto") String spuDecphoto,@Param("spuStatus") int spuStatus);
    
    }
    复制代码

对应的\*\*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">
        <mapper namespace="com.fancy.account.spu.dao.TSpuDao">
        
            <insert id="addSpu" parameterType="com.fancy.account.spu.dbobject.TSpu">
                insert into t_spu (spu_name,spu_headphoto,spu_detailphoto,spu_decphoto,spu_status)
                values (#{spuName},#{spuHeadphoto},#{spuDetailphoto},#{spuDecphoto},#{spuStatus})
            </insert>
        
        </mapper>
    复制代码

四、在写一个controller访问即可

转载于:https://juejin.im/post/5cbb14926fb9a0685a3f00a8