搜索到
81
篇与
的结果
-
QueryWrapper 常用方法 AbstractWrapper 下的方法及使用方法名说明使用allEq(Map<R, V> params)全部 =(或个别 isNull)allEq(params,true)eq=eq("real\_name”,"王昭君”)ne<>ne("nick\_name”,"空想 4”)gt>gt("age”,21)ge>=ge("age”,22)lt<lt("age”,22)le<=le("age”,21")betweencloum between ? and ?between("age”,0,21)notBetweencloum between ? and ?notBetween("age”,0,21)likecloum like '% 王 %’like("real\_name”,"王”)notLikenot like '% 王 %’notLike("real\_name”,"王”)likeLeftlike '% 王’likeLeft("real\_name”,"昭”)likeRightlike '王 %’likeRight("real\_name”,"昭”)isNullis nullisNull("gender”)isNotNullis not nullisNotNull("gender”)inin (1,2,3)in("nick\_name”,lists)notInage not in (1,2,3)notIn("nick\_name”,lists)inSqlage in (1,2,3,4,5,6)inSql("nick\_name”,"'空想 4’,'空想 5’,'空想 6’")notInSqlage not in (1,2,3,4,5,6)notInSql("nick\_name”,"'空想 4’,'空想 5’,'空想 6’")groupBygroup by id,namegroupBy("nick\_name”,"age”)orderByAscorder by id ASC,name ASCorderByAsc("nick\_name”,"age”)orderByDescorder by id DESC,name DESCorderByDesc("age”)orderByorder by id ASC,name ASCorderBy(true,true,"age”)havinghaving sum(age) > 10having("sum(age) > 10”)orid = 1 or name = '老王’eq("nick\_name”,"空想 4”).or(i->i.eq("age”,21) eq("nick\_name”,"空想 4”).or().eq("nick\_name”,"空想 5”)andand (name = '李白’ and status <> '活着’)and(i->i.eq("age”,21))nested(name = '李白’ and status <> '活着’)nested(i->i.eq("age”,21).eq("nick\_name”,"空想 4”))applyid = 1apply("nick\_name = '空想 4’”)last最后添加多个以最后的为准，有 sql 注入风险last("limit 1”)exists拼接 EXISTS (sql 语句)exists("select id from table where age = 1”)notExists拼接 NOT EXISTS (sql 语句)notExists("select id from table where age = 1”) -
MybatisPlus 分页插件 配置//Spring boot方式 @Configuration @MapperScan("com.baomidou.cloud.service.*.mapper*") public class MybatisPlusConfig { // 旧版 @Bean public PaginationInterceptor paginationInterceptor() { return new PaginationInterceptor(); } // 最新版 @Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2)); return interceptor; } } 使用
-
@TableId(type=IdType.AUTO) 声明主键自增长 @TableId(type=IdType.AUTO) //声明主键自增长 @TableField(select = false) //查询时，则不返回该字段的值 @TableField(value = "email") //通过tableField进行字段不一致的映射 @TableField(exist = false) //设置该字段在数据库表中不存在 @TableField(update="now()") //使用数据库时间输出 SQL 为：update 表 set 字段=now() where ... //TableField 注解新增属性 condition 预处理 WHERE 实体条件自定义运算规则，下面会有代码讲解 @TableField(condition = SqlCondition.LIKE) private String name; //输出 SQL 为：select 表 where name LIKE CONCAT('%',值,'%')
-
@TableField 自动填充 如数据库时间的自动更新 实体类上的注解：//插入时填充 @TableField(fill = FieldFill.INSERT) private Date createTime; //插入与更新都填充 @TableField(fill = FieldFill.INSERT_UPDATE) private Date updateTime;处理器的实现：@Slf4j @Component //继承MetaObjectHandler来实现填充 public class MyMetaObjectHandler implements MetaObjectHandler { //插入时的填充策略 @Override public void insertFill(MetaObject metaObject) { log.info("start insert fill..."); //三个参数为 //要设置的属性名字 值 metaObject this.setFieldValByName("createTime",new Date(),metaObject); this.setFieldValByName("updateTime",new Date(),metaObject); } //更新时的填充策略 @Override public void updateFill(MetaObject metaObject) { log.info("start update fill..."); this.setFieldValByName("updateTime",new Date(),metaObject); } }
-
