@Mapper
public interface UserMapper extends BaseMapper<User> {}

/**
  * UserService繼承IService模板提供的基礎(chǔ)功能 
  */
public interface UserService extends IService<User> {}

/**
  * ServiceImpl實(shí)現(xiàn)了IService，提供了IService中基礎(chǔ)功能的實(shí)現(xiàn) 
  * 若ServiceImpl無(wú)法滿足業(yè)務(wù)需求，則可以使用自定的UserService定義方法，并在實(shí)現(xiàn)類(lèi)中實(shí)現(xiàn)
  */
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper,User> implements UserService{}

@Data
@TableName("t_user")
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;
}

mybatis-plus:
  global-config:
    db-config:
      # 設(shè)置實(shí)體類(lèi)所對(duì)應(yīng)的表的統(tǒng)一前綴
      table-prefix: t_

@Data
public class User {
    @TableId(value = "tid")
    private Long uid;
    private String name;
    private Integer age;
    private String email;
}

@Data
public class User {
    @TableId(type = IdType.AUTO)
    private Long uid;
    private String name;
    private Integer age;
    private String email;
}

//指定數(shù)據(jù)庫(kù)字段名稱(chēng)
@TableField(value = "email")
private string mail

// 執(zhí)行的sql語(yǔ)句就變成`關(guān)鍵字`，這樣sql就不會(huì)報(bào)錯(cuò)了
@TableField(value = "`desc`")
private string desc

@TableField(exist = false)
private Boolean checked;

@TableField(select = false)
private String password;

// 實(shí)體注解-實(shí)現(xiàn)模糊查詢(xún)
@TableField(condition = SqlCondition.LIKE)
private String name;
// 業(yè)務(wù)代碼
User user = new User();
user.setName("張");
userService.lambdaQuery(user).list();
// 打印sql
SELECT id,user_name,age FROM user WHERE name LIKE CONCAT('%',?,'%')

userService.lambdaQuery().eq(User::getName,"張").list();

// 方式三：
// 實(shí)體注解-實(shí)現(xiàn)修改字段時(shí)候，前后添加“**” 其中 %s 會(huì)填充為字段
@TableField(update = "CONCAT('**',%s,'**')")
private String name;
// 業(yè)務(wù)代碼
User user = new User();
user.setId(1);
user.setName("張三");
userService.updateById(user);
// 打印sql
UPDATE user SET name=CONCAT('**',name,'**') WHERE id=?

userService.lambdaQuery().eq(User::getName,"張").list();

// 實(shí)體字段注解
@TableField(fill = FieldFill.INSERT)
private Date createTime;
@TableField(fill = FieldFill.INSERT_UPDATE)
private Date updateTime;
// 枚舉類(lèi)
public enum FieldFill {
    /**
     * 默認(rèn)不處理
     */
    DEFAULT,
    /**
     * 插入填充字段
     */
    INSERT,
    /**
     * 更新填充字段
     */
    UPDATE,
    /**
     * 插入和更新填充字段
     */
    INSERT_UPDATE
}

@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
	Date date = new Date();
    @Override
    public void insertFill(MetaObject metaObject) {
        this.strictInsertFill(metaObject, "createTime", Date.class, date);
        this.strictInsertFill(metaObject, "updateTime", Date.class, date);
    }
    @Override
    public void updateFill(MetaObject metaObject) {
        this.strictUpdateFill(metaObject, "updateTime", Date.class, date);
    }
}

public enum FieldStrategy {
    /**
     * 忽略判斷，所有字段都進(jìn)行更新和插入
     * 無(wú)論什么值，直接拼接，沒(méi)有值，則拼接null
     */
    IGNORED,
    /**
     * 只更新和插入非NULL值
     * 相當(dāng)于添加if判斷，不為null才操作
     * <if test="columnProperty != null">column=#{columnProperty}</if>
     */
    NOT_NULL,
    /**
     * 只更新和插入非NULL值且非空字符串
     * 相當(dāng)于添加if判斷，不為null而且不是空字符串才操作
     * <if test="columnProperty != null and columnProperty!=''">column=#{columnProperty}</if>
     */
    NOT_EMPTY,
    /**
     * 默認(rèn)NOT_NULL
     */
    DEFAULT,
    /**
     * 永遠(yuǎn)不進(jìn)行更新和插入
     */
    NEVER
}

public void testDeleteById(){
    int result = userMapper.deleteById(1527472864163348482L);
    System.out.println(result > 0 ? "刪除成功！" : "刪除失?。?);
    System.out.println("受影響的行數(shù)為：" + result);
}

public void testSelectList(){
    List<User> users = userMapper.selectList(null);
}

 /** 組裝修改條件  將(年齡大于20并且用戶(hù)名中包含有a)或郵箱為null的用戶(hù)信息修改 **/
@Test
public void test01() {
    /*
        UPDATE t_user SET user_name=?, email=?
        age > ? AND user_name LIKE ? OR email IS NOT NULL
     */
    QueryWrapper<User> queryWrapper = new QueryWrapper<>();
    queryWrapper.gt("age", 20)
            .like("user_name", "a")
            .or()
            .isNotNull("email");
    User user = new User();
    user.setName("小明");
    user.setEmail("test@atguigu.com");
    int result = userMapper.update(user, queryWrapper);
    System.out.println("result = " + result);
}
/** 條件優(yōu)先級(jí)  將用戶(hù)名中包含a并且(年齡大于20或郵箱為null)的用戶(hù)信息修改 **/
@Test
public void test02() {
    // lambda中條件優(yōu)先級(jí)
    /*
        UPDATE t_user SET user_name=?, email=?
        WHERE user_name LIKE ? AND (age > ? OR email IS NULL)
     */
    QueryWrapper<User> queryWrapper = new QueryWrapper<>();
    queryWrapper.like("user_name", "a")
            .and(i -> i.gt("age", 20).or().isNull("email"));
    User user = new User();
    user.setName("小紅");
    user.setEmail("test@atguigu.com");
    int result = userMapper.update(user, queryWrapper);
    System.out.println("result = " + result);
}

@Test
public void test3() {
    /*
        SELECT uid AS id,user_name AS name,age,email,is_deleted FROM t_user
        WHERE user_name LIKE ? AND age <= ?
     */
    String username = "a";
    Integer ageBegin = null;
    Integer ageEnd = 30;
    //組裝set子句
    LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
    //避免使用字符串表示字段，防止運(yùn)行時(shí)錯(cuò)誤
    queryWrapper.like(StringUtils.isNotBlank(username), User::getName, username)
            .gt(ageBegin != null, User::getAge, ageBegin)
            .le(ageEnd != null, User::getAge, ageEnd);
    List<User> list = userMapper.selectList(queryWrapper);
    list.forEach(System.out::println);
}
@Test
public void test4() {
    /*
        UPDATE t_user SET user_name=?,email=?
        WHERE user_name LIKE ? AND (age > ? OR email IS NULL)
     */
    LambdaUpdateWrapper<User> updateWrapper = new LambdaUpdateWrapper<>();
    updateWrapper.like(User::getName, "a")
            //lambda表達(dá)式內(nèi)的邏輯優(yōu)先運(yùn)算
            .and(i -> i.gt(User::getAge, 20).or().isNull(User::getEmail)); 
    updateWrapper.set(User::getName, "小黑").set(User::getEmail, "abc@atguigu.com");
    int result = userMapper.update(null, updateWrapper);
    System.out.println("result = " + result);
}

 @Test
 public void test1(){
 	 // 單個(gè)查詢(xún)，多個(gè)報(bào)錯(cuò)
     User user = userService.lambdaQuery().eq(User::getName, "Tom").one();
	 // 集合查詢(xún)
     List<User> userList = userService.lambdaQuery().like(User::getName, "J").eq(User::getAge,20).list();
     // 記錄數(shù)查詢(xún)
     Integer count = userService.lambdaQuery().like(User::getAge, 20).select(User::getName, User::getAge).count();
  }

  @Test
  public void test2() {
	  // set修改某些屬性
      userService.lambdaUpdate().eq(User::getName, "Tom").set(User::getId, 110).set(User::getAge, 15).update();
      // 修改整個(gè)對(duì)象
      User user = new User();
      user.setId(110L);
      user.setAge(15);
      userService.lambdaUpdate().eq(User::getName, "Tom").update(user);
      // 根據(jù)名稱(chēng)刪除
      userService.lambdaUpdate().eq(User::getName, "Jack").remove();
   }

@Test
void testDbGet() {
    User user = Db.getById(1L, User.class);
    System.out.println(user);
}
?
@Test
void testDbList() {
    // 利用Db實(shí)現(xiàn)復(fù)雜條件查詢(xún)
    List<User> list = Db.lambdaQuery(User.class)
            .like(User::getUsername, "o")
            .ge(User::getBalance, 1000)
            .list();
}
?
@Test
void testDbUpdate() {
    Db.lambdaUpdate(User.class)
            .set(User::getBalance, 2000)
            .eq(User::getUsername, "Rose");
}

/**
* 根據(jù)年齡查詢(xún)用戶(hù)列表，分頁(yè)顯示
*/
Page<User> selectPageVo(@Param("page") Page<User> page,@Param("age") Integer age);

<select id="selectPageVo" resultType="User">
    select id,username as name,age,email from t_user where age > #{age}
</select>

@Test
public void testSelectPageVo(){ //設(shè)置分頁(yè)參數(shù)
    Page<User> page = new Page<>(1, 5); 
    userMapper.selectPageVo(page, 20);
    //獲取分頁(yè)數(shù)據(jù)
    List<User> list = page.getRecords(); 
    list.forEach(System.out::println); 
    System.out.println("當(dāng)前頁(yè):"+page.getCurrent()); 
    System.out.println("每頁(yè)顯示的條數(shù):"+page.getSize()); 
    System.out.println("總記錄數(shù):"+page.getTotal()); 
    System.out.println("總頁(yè)數(shù):"+page.getPages()); 
    System.out.println("是否有上一頁(yè):"+page.hasPrevious()); 
    System.out.println("是否有下一頁(yè):"+page.hasNext());
}

@Select("select * from student where age = #{age} and user_name = #{userName}")
Student getStudent( @Param("age") Integer age, @Param("userName") String userName);

// 單表查詢(xún)
@Select("select * from student ${ew.customSqlSegment}")
Student getStudentById( @Param("ew") QueryWrapper<Student> wrapper);
// 多表查詢(xún)
@Select("SELECT u.* FROM student u INNER JOIN address a ON u.id = a.student_id ${ew.customSqlSegment}")
List<Student> queryStudentListByWrapper(@Param("page") Page<Student> page, @Param("ew")QueryWrapper<User> wrapper);

// 情況1：如果查詢(xún)條件中有address的字段，比如模糊查詢(xún)地址名稱(chēng)
// 情況2：如果查詢(xún)條件的字段，兩個(gè)表都有，這里會(huì)有問(wèn)題
// 自動(dòng)分頁(yè)的查詢(xún)count(*)時(shí)候，就會(huì)拋出以上異常
@Select("SELECT u.* FROM student u LEFT JOIN address a ON u.id = a.student_id ${ew.customSqlSegment}")
List<Student> queryStudentListByWrapper(@Param("page") Page<Student> page, @Param("ew")QueryWrapper<User> wrapper);

@Select("SELECT * FROM (SELECT u.* FROM student u LEFT JOIN address a ON u.id = a.student_id) as result ${ew.customSqlSegment}")
List<Student> queryStudentListByWrapper(@Param("page") Page<Student> page, @Param("ew")QueryWrapper<User> wrapper);

// 分頁(yè)查詢(xún)
Page<UserEntity> userPage = super.lambdaQuery().page(new Page<>(request.getCurrent(), request.getSize()));
// entity轉(zhuǎn)換為vo
IPage<UserVO> infoResPage = userPage.convert(item -> Convert.convert(UserVO.class, item));

// 方式一
List<String> nameList = SimpleQuery.list(
        new LambdaQueryWrapper<Student>().like(Student::getUserName, "張"),
        Student::getUserName
);
// 方式二
List<Student> list = studentService.list();
List<String> nameList2 = SimpleQuery.list2List(list, Student::getUserName);

List<String> nameList = SimpleQuery.list(
        new LambdaQueryWrapper<Student>().like(Student::getUserName, "李"),
        Student::getUserName,
        new Consumer<Student>() {
            @Override
            public void accept(Student student) {
                student.setUserName("**"+student.getUserName()+"**");
            }
        }
);

Map<String, Integer> map = SimpleQuery.map(
        new LambdaQueryWrapper<>(), 
        Student::getUserName, 
        Student::getAge
);

Map<String, List<Student>> group = SimpleQuery.group(
        new LambdaQueryWrapper<Student>(), 
        Student::getUserName
);

@Data
@TableName(value = "student")
public class Student extends Model<Student> {
    /**
     * 主鍵id
     */
    private Long id;
    /**
     * 姓名
     */
    private String userName;
    /**
     * 年齡
     */
    private Integer age;
}
@Test
void activeRecordAddQ{
	Student student = new Student();
	student.setUserName("李四");
	student.setAge(12);
	student.insert();
}

@Configuration
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        //注意使用哪種數(shù)據(jù)庫(kù)
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}