zlz9455的博客

原创 切面修改方法入参

原创 LocalDateTime根据时区转换案例

public LocalDateTime getUiDate(LocalDateTime dateTime) { if (StrUtil.isNotBlank(GlobalContext.getTimeZone())) { ZoneId australia = ZoneId.of(GlobalContext.getTimeZone()); ZonedDateTime dateAndTimeInSydney = ZonedDateTime...

原创 liquibase简单用法

1：文件目录结构可以如下2：建表<?xml version="1.0" encoding="utf-8"?><databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase

原创 JdbcTemplate 查询sqlServer

1：首先定义JdbcTemplate @Inject private JdbcTemplate yfssLesJdbcTemplate;2：定义sql private String findLineWorkOrderStatisticsForStatusSql = "SELECT Work_Order as order_no,\n" + " STATUS as order_status,\n" + "

原创 springboot+easypoi导出excel

相关依赖<dependency> <groupId>cn.afterturn</groupId> <artifactId>easypoi-base</artifactId> <version>3.2.0</version> </dependency> <dependency>

原创 Mybatisplus lambda写法随笔

Mybatisplus lambda写法随笔构造器写法：Wrappers.lambdaQuery() 后面加功能如：Wrappers.lambdaQuery().orderByDesc(LogVO::getGmtCreate)构造器参数地址：https://baomidou.gitee.io/mybatis-plus-doc/#/wrapper?id=%e6%9d%a1%e4%bb%b6%e5%8f%82%e6%95%b0%e8%af%b4%e6%98%8e...