zzbert 2019-11-20 10:29 采纳率: 100%
浏览 1728

一个查询语句在navicat中可以执行,但是在mybatis中报错了

报错提示的语句和我写的mybatis中的语句不一样,不知道怎么个回事儿0.0。

mybatis中sql语句:

        SELECT
            t.m_id as 'id',
            t.name,
            t.numbers,
            t.s_id as 'spId',
            t.learned,
            t.learning,
            t.plan_finish_date as 'planFinishDate',
            t.plan,
            t.next_plan as 'nextPlan'
        FROM(
            SELECT
                m.id as 'm_id',
                m.name,
                m.createdate,
                s.numbers,
                s.id as 's_id',
                s.learned,
                s.learning,
                s.plan_finish_date ,
                s.plan,
                s.next_plan
            FROM
                member AS m
            LEFT JOIN study_plan AS s ON m.id = s.m_id
            ORDER BY
                s.numbers DESC
            LIMIT 10000
        ) t
        GROUP BY t.name
        ORDER BY t.createdate

我多粘贴了一些报错信息

Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
        ) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT

        t.m_id as 'id',
        t.name as 'name',
        t.numbers as 'numbers',
        t.sp_id as 'spId',
        t.learned as 'learned',
        t.learning as 'learning',
        t.plan_finish_date as 'planFinishDate',
        t.plan as 'plan',
        t.createdate as 'createdate',
        t.next_plan as 'nextPlan'

        FROM (
        SELECT
        m.id as 'm_id',
        m.`name`,
        m.createdate,
        s.numbers,
        s.id as 'sp_id',
        s.learned,
        s.learning,
        s.plan_finish_date ,
        s.plan,
        s.next_plan
        FROM
        member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
        ) tmp_count

xml截个图
图片说明

  • 写回答

7条回答 默认 最新

  • zhshchilss 2019-11-20 10:43
    关注

    你这两个sql也不一样啊

    评论

报告相同问题?

悬赏问题

  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误