<select id="get*" resultType="hashmap" parameterType="map">
SELECT
obj_new.id,
obj_new.supply_unit,
obj_new.parnt_id,
obj_new.business_households,
obj_new.num,
obj_new.rownum,
obj_new.now,
obj_new.nownum
FROM
(
SELECT
obj.id,obj.supply_unit,obj.parnt_id,obj.business_households,obj.num,obj.rownum,obj.now,
@incrnum := IF(@nowtotal = obj.now, @incrnum, @nownum) AS nownum,
@nownum := @nownum + 1,
@nowtotal := obj.now
FROM
(
select id,supply_unit,parnt_id,business_households,num,rownum,COALESCE((num/b
数据库查询没问题,后台报错Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax
最新推荐文章于 2024-07-18 09:01:28 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)