MyBatis
文章平均质量分 53
zhangdaopin2016
Java攻城狮
最讨厌在写代码的时候写注释, 最讨厌别人的代码里面不写注释.
展开
-
Mybatis-Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of th
一开始没有配置SSL的选项,日志中有个WARN警告:Wed Aug 04 10:10:55 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by d...原创 2021-08-04 10:39:13 · 258 阅读 · 0 评论 -
Mybatis - tk.mybatis deleteByPrimaryKey无法正确识别主键
contentVisitSourceMapper.deleteByPrimaryKey(v.getId());JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3cd9a44f] will not be managed by Spring==> Preparing: DELETE FROM xxx WHERE id = ? AND cid = ? AND xxx_id = ? AND xxx_num = ? AND created = ? .原创 2021-06-23 13:54:11 · 1448 阅读 · 0 评论 -
Mybatis - if test条件判断,踩坑记录
由于需求的变化,需要在查询的时候增加判断的逻辑,原来是: WHERE type!='CUSTOM' <if test="type!='' and type!=null "> AND t.type= #{type} </if>需求要求,在leix原创 2021-06-08 11:17:57 · 972 阅读 · 0 评论 -
Mybatis - NoSuchMethodError: net.sf.jsqlparser.statement.select.SetOperationList.getSelects()Ljava/
Handler processing failed; nested exception is java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.SetOperationList.getSelects()Ljava/util/List;java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.SetOperationList.getSelects()Ljava/原创 2021-05-28 11:06:52 · 2188 阅读 · 0 评论 -
MySQL - 新增数据时想要得到新增数据的自增ID,怎么办???
我们在实际逻辑编写时,往往会有,想要使用我们刚刚插入数据的自增ID,来做另外一件事情;这时候我们是可以通过查询刚才插入数据的某个字段作为条件,来查出这条数据的ID,但是总感觉太麻烦效率不高; 当然,我们通过SQL层面也是有类似的办法; 例如:SELECT max(mid) FROM table_0001;select @@IDENTITYSELECT LAST_INSERT_ID() ...原创 2021-05-27 14:05:41 · 1628 阅读 · 0 评论