Amy_Queen的博客

jpa 原生insert的sql语句： @Modifying @Query(value = "insert into t_sys_org_user(org_id,user_id) values(?1,?2)",nativeQuery = true) int addUserToOrg(Long orgId,Long userId);jpa 原生delete的sql语句： @Mod

根据某字段的枚举值排序，例如：SELECT * FROM `t_advertisement` ORDER BY FIELD(ad_status,'WAITING','RELEASE','REMOVE'),id desc;获取上一条insert语句执行后的自增主键ID,作为下一条SQL的的字段值INSERT INTO `database_name`.`table_name` (col...