摘要:
/** * 开始分页 * * @param list * @param current 页码 * @param size 每页大小 * @return */ public class PageUtils { public static <T> List<T> startPage(List<T> li 阅读全文
摘要:
-- 获取表数据量排行SELECTtable_schema ,table_name ,data_free,table_rows ,TRUNCATE ( data_length / 1024 / 1024, 2 ) AS '数据容量(MB)',TRUNCATE ( index_length / 102 阅读全文
摘要:
@GetMapping("/information") @Cacheable(cacheNames = "dfs_screen_information", key = "'lineId=' + #lineId + ',componentName=' + #componentName + ',date 阅读全文
摘要:
// 定义函数式接口 @FunctionalInterface interface MapFunction<A, B, C, D, E, F, R> { R apply(A a, B b, C c, D d, E e, F f); } /** * 定义的策略map */ private Map<St 阅读全文
摘要:
win+R shell:Common startup 打开开机启动文件夹: 准备一个开机启动的脚本放到这个文件夹下: 脚本如下 eg1: D: CD D:\software\nacos\nacos\bin start startup.cmd eg2: D: CD D:\software\redis 阅读全文
摘要:
错误代码: if (!CollectionUtils.isEmpty(warehouseIds)) { lambda.in(StockTransferEntity::getInWarehouseId, warehouseIds).or().in(StockTransferEntity::getOut 阅读全文
摘要:
-- role_id固定为1,插入所有permission_id(给固定角色赋予所有权限)INSERT INTO `sys_role_permission` ( `role_id`, `permission_id` ) (SELECT (1) `role_id`, id AS `permission 阅读全文
摘要:
-- 修改采购需求订单关联表order_id字段类型 call proc_modify_column_if_exist( 'dfs_purchase_request_order_relation', 'order_id', 'ALTER TABLE `dfs_purchase_request_ord 阅读全文
摘要:
LambdaQueryWrapper<CombineTargetEntity> combineTargetQW = new LambdaQueryWrapper<>();combineTargetQW.eq(CombineTargetEntity::getCombineTarget, entity. 阅读全文
摘要:
-- 判断字段不存在则增加该字段 DROP PROCEDURE if EXISTS proc_add_column; delimiter $$ CREATE PROCEDURE `proc_add_column`(in var_table_name varchar(64),in var_column 阅读全文