I just learned something about mybatis-plus and changed the code written in mybatis to mybatis-plus
Question: MyBatis vs. MyBatis-Plus Implementation问题：MyBatis与MyBatis-Plus实施
I have two implementations of an article management feature using MyBatis and MyBatis-Plus. Below are the respective code snippets for each approach.
Mybatis pivot xml NumberFormatException “[“
I am trying to create a variable column using mybatis pivot xml. It is like the example below.
However, if the string “[” is included, as in the example below, an error occurs.
Caused by: java.lang.NumberFormatException: For input string: “test] It is Test1”
Mybatis
SELECT *
FROM (SELECT job
, deptno
, sal
FROM emp
)
PIVOT ( SUM(sal)
FOR deptno IN (‘[test] It is Test1′,'[test] It is Test2′,'[test] It is Test3’)
)
ORDER BY job
Mybatis3 uses the ${} syntax of OGNL parsing, right?
enter image description here