摸爬滚打

1、dataObject/** * 复合主键 */@Datapublic class ProjectCompanyKeys implements Serializable{ private String projectNo;//项目编号 private String companyNo;//实施单位编号}/** * * 实体类 */@Data@...

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="transD

merge into table_a a using table_b b on(a.id=b.id)when not matched then insert(a.id,a.col,a.col2.....) values(b.id,b.col,b.col2.......)列子：（mybatis中的xml）入参：对象表b根据入参创建，然后判断表b跟表a的主键是否冲...

merge into test_id a using (select id , name from test_id ) b on (a.id = b.id) WHEN MATCHED THEN UPDATE SET a.name = b.name WHEN NOT MATCHED THEN INSERT (a.id, a.nam...

SELECT ( CASE WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 0 THEN '离线' WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 1 THEN '在线' END ) status, COUNT( * ) rs, 100 * round( COUNT( * ) / SUM( COUNT( * )) OVER (), 2 )...

1、将number类型的时间值转换为时间格式的字符串    a、SUBSTR( numtodsinterval ( 30600, 'second' ), 12, 8 ) // 30600是从当天零点开始的秒数，此结果为（08：30：00）    b、REPLACE ( SUBSTR( numtodsinterval ( 30600, 'second' ), 12, 8 ), ':', ''...