MybatisPlus

编辑启动类

@SpringBootApplication
@MapperScan("com.jt.mapper")//包扫描代替了@Mapper接口
public class SpringbootDemo2Application {
    public static void main(String[] args) {
        SpringApplication.run(SpringbootDemo2Application.class, args);
    }
}

编辑POJO类

@Data
@Accessors(chain = true)//链式加载
@NoArgsConstructor//无参构造
@AllArgsConstructor//全参构造
@TableName("user")//表示对象与数据库表名的映射关系，如果表名和对象的名称一致,可省略不写
public class User {
    @TableId(type = IdType.AUTO)//id属性是主键自增
    private Integer id;
    //@TableField(value = "name") //标识字段和属性
    private String name;
    private Integer age;
    private String sex;

    /*链式加载源码
    *public User setId(INteger id){
    *   this.id=id;
    *   return this;
    * }
    * */
}

编辑Mapper

//@Mapper   MybatisPlus内置Mapper,可省略不写此注解

/**
 * 接口要继承BaseMapper<T>,其中T为封装的POJO类
 */
public interface UserMapper extends BaseMapper<User> {
    //@Select("select id,name,age,sex from user")
    List<User> findAll();
}

常用逻辑运算符

    @Test
    /*
    *需求：查询年龄=18用户 同时性别为女
    * 条件构造器的作用 用来拼接where条件
    * sql：xxx where age>18 and age<2000 and sex=“女”
    * 逻辑运算符： =eq, > gt,< lt,>=ge,<= le
    */
     void select02() {
         QueryWrapper<User> queryWrapper=new QueryWrapper<>();
         queryWrapper.gt("age",18)
                    .lt("age",2000)
                    .eq("sex","女");
         List<User> userList=userMapper.selectList(queryWrapper);
         System.out.println(userList);
    }