<select id="getPipeAgeAnalysis" parameterType="java.util.Map" resultType="java.util.Map">
<![CDATA[
select key as "key",value as "value"
from(
select
sum(case when a.years<=5 then 1 else 0 end) as "5"
,sum(case when a.years>=6 and a.years<=8 then 1 else 0 end) as "6-8"
,sum(case when a.years>=9 and a.years<=11 then 1 else 0 end) as "9-11"
,sum(case when a.years>=12 and a.years<=14 then 1 else 0 end) as "12-14"
,sum(case when a.years>=15 then 1 else 0 end) as "15"
from (
select months_between(sysdate,BUILD_DATE)/12 years
from PL_EQPIPE_T
where 1=1
]]>
<if test="companyCode != null and companyCode != ''">
and company_code=#{companyCode}
</if>
) a) v
unpivot
(value for key in ("5","6-8","9-11","12-14","15"))
</select>
放到plsql中可以運行，mybatis中報錯，錯誤資訊堆疊：
nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual FOR pos 516, line 18, column 10, token FOR : select key as "key",value as "value"
from(
select
sum(case when a.years<=5 then 1 else 0 end) as "5"
,sum(case when a.years>=6 and a.years<=8 then 1 else 0 end) as "6-8"
,sum(case when a.years>=9 and a.years<=11 then 1 else 0 end) as "9-11"
,sum(case when a.years>=12 and a.years<=14 then 1 else 0 end) as "12-14"
,sum(case when a.years>=15 then 1 else 0 end) as "15"
from (
select months_between(sysdate,BUILD_DATE)/12 years
from PL_EQPIPE_T
where 1=1
) a) v
unpivot
(value for key in ("5","6-8","9-11","12-14","15"))]
uj5u.com熱心網友回復：
用了druid資料源的校驗功能？uj5u.com熱心網友回復：
嗯 不進行資料源驗證的話系統可能會用無效連接
是這個原因導致的么？
uj5u.com熱心網友回復：
我說的是filters: wall，這個是druid防注入的配置，會直接檢查sql。但是語法決議有bug，你用點特殊語法它就報錯，需要升級jar包，最重要的是這個功能mybatis已經實作，直接關掉就好。
uj5u.com熱心網友回復：
我試過，沒得用，還是一樣的報錯。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/14701.html
標籤：開發
上一篇：tableau字串轉換為日期格式
下一篇：oracle清理空間