MyBatis-Plus框架搭建

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

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

    		<dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.3.1</version>
        </dependency>
    
    
      
      
      
      
      
    

    		<dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
            <version>3.5.5</version>
        </dependency>
    
    
      
      
      
      
      
    

    server:
      port: 9003
      servlet:
    context-path: /mp
    
    
    mybatis-plus:
      type-aliases-package:     #  别名扫描包
      mapper-locations: classpath*:mapper/**/*.xml          # mapper.xml
      configuration:
    map-underscore-to-camel-case: true  # 开启下划线和驼峰的映射
    cache-enabled: false   # 是否开启二级缓存
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
      global-config:
    db-config:
      id-type: assign_id  # id为雪花算法生成
      update-strategy: not_null  # 更新策略:只更新非空字段
    
    spring:
      datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/mp?serverTimezone=UTC&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    

    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @MapperScan("com.example.mybatisplusdemo.mapper")
    @SpringBootApplication
    public class MybatisplusDemoApplication {
    
    public static void main(String[] args) {
        SpringApplication.run(MybatisplusDemoApplication.class, args);
    }
    }
    
    
      
      
      
      
      
      
      
      
      
      
      
      
    

    @Configuration
    @MapperScan("com.example.mybatisplusdemo.mapper")
    public class MybatisPlusConfig {
    
    /** * 添加分页插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));//如果配置多个插件,切记分页最后添加
        //interceptor.addInnerInterceptor(new PaginationInnerInterceptor()); 如果有多数据源可以不配具体类型 否则都建议配上具体的DbType
        return interceptor;
    }
    }
    
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    

    public interface PersonMapper extends BaseMapper<Person> {
    
     Integer insertBatch( @Param("list") List<Person> list);
    
     Integer updateBatch (@Param("list") List<Person> list);
    }
    
    
      
      
      
      
      
      
    

    	<insert id="insertBatch" >
        insert into tb_user (username,address) values
        <foreach collection="list" item="person" index="index" separator="," >
            (#{person.username}, #{person.address})
        </foreach>
    </insert>
    
    <update id="updateBatch">
        <foreach collection="list" index="index" item="person" separator=";">
            update tb_user
              <set>
                  username = #{person.username},
                  address = #{person.address}
              </set>
            where id = #{person.id}
        </foreach>
    </update>
    
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    

    	<insert id="insertAddress" keyProperty="id" useGeneratedKeys="true">
        INSERT INTO address ( province, city, mobile ) VALUES ( #{province}, #{city}, #{mobile} )
    </insert>
    
    
      
      
      
    

    @Repository
    public interface AddressMapper extends BaseMapper<Address> {
    
    int insertAddress(Address address);
    
    }
    
    
      
      
      
      
      
      
    

    	@Test
    void contextLoads() {
        Address address = new Address();
        address.setMobile("123456");
        address.setCity("武汉");
        address.setProvince("湖北省");
        addressMapper.insertAddress(address);
        System.out.println("address.getId() = " + address.getId());
    }