08 2022 档案

navicat生成数据字典sql

摘要：USE INFORMATION_SCHEMA; SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_COMMENT, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 阅读全文

posted @ 2022-08-29 11:54 Arborblog 阅读(164) 评论(0) 推荐(0) 编辑

jpaDSL分页，排序

摘要：//排序 JPAQuery<Customer> orderBy = customer.orderBy(QCustomer.qcustomer.createTime.desc()); //分页 JPAQuery<Customer> limit = orderBy.offset(customerInpu 阅读全文

posted @ 2022-08-27 23:42 Arborblog 阅读(156) 评论(0) 推荐(0) 编辑

dsl查询queryResults转page

摘要：@Data public class RestPage<T> implements Serializable { /** * */ private static final long serialVersionUID = 1L; //元素内容 private List<T> content; //是阅读全文

posted @ 2022-08-27 23:38 Arborblog 阅读(81) 评论(0) 推荐(0) 编辑

jpaJAVASql

摘要：QCarInfo qCarInfo = QCarInfo.qCarInfo; BooleanExpression expression = qCarInfo.valid.eq(true); if(StringUtils.isNotEmpty(carListPCInputParam.getSnCode 阅读全文

posted @ 2022-08-24 19:07 Arborblog 阅读(25) 评论(0) 推荐(0) 编辑

查询Myql的连接

摘要：SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name; 阅读全文

posted @ 2022-08-24 17:04 Arborblog 阅读(17) 评论(0) 推荐(0) 编辑

QueryDSL文档

摘要：spring-date-jpa的javasql 动态条件查询 <build> <plugins> <plugin> <dependencies> <dependency> <groupId>com.querydsl</groupId> <artifactId>querydsl-apt</artifa 阅读全文

posted @ 2022-08-18 19:59 Arborblog 阅读(395) 评论(0) 推荐(0) 编辑

javaString上引号内的正则写法

摘要：两个斜杠后加特殊符号四个反斜杠表示一个匹配一个特殊符号的反斜杠（?<=匹配的内容）这个表示向后匹配这个表示向前匹配（?=）阅读全文

posted @ 2022-08-06 19:54 Arborblog 阅读(35) 评论(0) 推荐(0) 编辑