mybatisplus 复合主键(多主键) CRUD示例详解

<dependency>

      <groupId>com.github.jeffreyning</groupId>

      <artifactId>mybatisplus-plus</artifactId>

      <version> 1.5 . 1 -RELEASE</version>

</dependency>

<dependency>

      <groupId>com.baomidou</groupId>

      <artifactId>mybatis-plus-boot-starter</artifactId>

      <version> 3.1 . 0 </version>

  </dependency>

  <dependency>

      <groupId>com.baomidou</groupId>

      <artifactId>mybatis-plus-generator</artifactId>

      <version> 3.1 . 0 </version>

  </dependency>

package com.youxue.model.lesson;

import com.baomidou.mybatisplus.annotation.TableField;

import com.baomidou.mybatisplus.annotation.TableName;

import com.fasterxml.jackson.databind.annotation.JsonDeserialize;

import com.fasterxml.jackson.databind.annotation.JsonSerialize;

import com.fasterxml.jackson.datatype.jsr310.deser.LocalDateTimeDeserializer;

import com.fasterxml.jackson.datatype.jsr310.ser.LocalDateTimeSerializer;

import com.github.jeffreyning.mybatisplus.anno.MppMultiId;

import com.youxue.sharding.annotation.TableIndex;

import com.youxue.sharding.annotation.TableIndices;

import com.youxue.sharding.model.BaseShardingPo;

import io.swagger.annotations.ApiModel;

import io.swagger.annotations.ApiModelProperty;

import lombok.Data;

import lombok.EqualsAndHashCode;

import lombok.experimental.Accessors;

import java.io.Serializable;

import java.time.LocalDateTime;

/**

  * <p>

  *     用户观看视频时长

  * <p/>

  *

  * @author dx

  * @since 2021/6/22

  */

@Data

@EqualsAndHashCode (callSuper = false )

@Accessors (chain = true )

@TableName ( "UserWatchVideoLog" )

@ApiModel (value= "UserWatchVideoLogPo对象" , description= "用户观看视频时长表" )

@TableIndices ({

         @TableIndex (name = "IX_USERID" ,ddl = "CREATE NONCLUSTERED INDEX [IX_USERID] ON UserWatchVideoLog ( [UserId] DESC)" ),

         @TableIndex (name = "IX_LESSONITEMID_USERID" ,ddl = "CREATE NONCLUSTERED INDEX [IX_LESSONITEMID_USERID] ON UserWatchVideoLog (LessonItemId ASC,UserId ASC)" )

})

public class UserWatchVideoLogPo implements Serializable, BaseShardingPo {

     @MppMultiId // 复合主键

     @TableField ( "userId" )

     @ApiModelProperty (value = "用户id" )

     private Integer userId;

     @TableField ( "lessonItemId" )

     @ApiModelProperty (value = "子课程id" )

     private Integer lessonItemId;

     @ApiModelProperty (value = "观看时长 单位秒（s）" )

     @TableField ( "seconds" )

     private Integer seconds;

     @ApiModelProperty (value = "科目id" )

     @TableField ( "subjectId" )

     private Integer subjectId;

     @ApiModelProperty (value = "视频观看时长  单位秒（s）" )

     @TableField ( "VideoProgress" )

     private Integer videoProgress;

     @ApiModelProperty (value = "视频来源 默认 0 " )

     @TableField ( "[Resource]" )

     private Integer resource;

     @ApiModelProperty (value = "类型  默认 0 " )

     @TableField ( "[Type]" )

     private Integer type;

     @ApiModelProperty (value = "创建时间" )

     @TableField ( "CreateTime" )

     @JsonFormat (pattern = "yyyy-MM-dd HH:mm:ss" )

     @JsonDeserialize (using = LocalDateTimeDeserializer. class )

     @JsonSerialize (using = LocalDateTimeSerializer. class )

     private LocalDateTime createTime;

     @ApiModelProperty (value = "修改时间" )

     @TableField ( "UpdateTime" )

     private LocalDateTime updateTime;

}

package com.youxue.service.lesson;

import com.github.jeffreyning.mybatisplus.service.IMppService;

import com.youxue.model.lesson.UserWatchVideoLogPo;

/**

  * <p>

  * 用户观看视频记录 服务类

  * </p>

  *

  * @author dx

  * @since 2021-06-22

  */

public interface IUserWatchVideoLogService extends IMppService<UserWatchVideoLogPo> {

}

package com.youxue.service.lesson.impl;

import com.github.jeffreyning.mybatisplus.service.MppServiceImpl;

import com.youxue.dao.lesson.UserWatchVideoLogMapper;

import com.youxue.model.lesson.UserWatchVideoLogPo;

import com.youxue.service.lesson.IUserWatchVideoLogService;

import org.springframework.stereotype.Service;

/**

  * <p>

  * 用户观看视频记录 服务类实现类

  * </p>

  *

  * @author dx

  * @since 2021/6/22

  */

@Service

public class UserWatchVideoLogServiceImpl extends MppServiceImpl<UserWatchVideoLogMapper, UserWatchVideoLogPo> implements IUserWatchVideoLogService {

}

package com.youxue.dao.lesson;

import com.github.jeffreyning.mybatisplus.base.MppBaseMapper;

import com.youxue.model.lesson.UserWatchVideoLogPo;

/**

  * <p>

  * 用户观看视频记录 Mapper 接口

  * </p>

  *

  * @author dx

  * @since 2021-06-22

  */

public interface UserWatchVideoLogMapper extends MppBaseMapper<UserWatchVideoLogPo> {

}

@Autowired

private IUserWatchVideoLogService userWatchVideoLogService;

@Test

public void testUserWatchVideo() {

         UserWatchVideoLogPo userWatchVideoLogPo = new UserWatchVideoLogPo()

                 .setUserId( 6202238 )

                 .setLessonItemId( 56303 )

                 .setSeconds( 8888 )

                 .setResource( 11 );

         boolean create = userWatchVideoLogService.save(userWatchVideoLogPo);

         System.out.println(create);

         System.out.println( "create result :" + create);

         System.out.println( "================ create end ==================" );

         // 断点01

         UserWatchVideoLogPo watchVideoLogPo = userWatchVideoLogService.selectByMultiId(userWatchVideoLogPo);

         System.out.println(watchVideoLogPo.toString());

         System.out.println( "================ retrieve end ==================" );

         userWatchVideoLogPo.setSeconds( 99999 );

         userWatchVideoLogPo.setResource( 22 );

         // 断点03       

         boolean upd = userWatchVideoLogService.updateByMultiId(userWatchVideoLogPo);

         System.out.println( "upd result :" + upd);

         System.out.println( "================ update end ==================" );

         // 断点03

         boolean remove = userWatchVideoLogService.deleteByMultiId(userWatchVideoLogPo);

         System.out.println( "remove result :" + remove);

         System.out.println( "================ remove end ==================" );

}