mysql程序内嵌_mysql，工具里面运行没错，但是嵌入程序中，就报错。代码如下...

SELECTdabiao.taskInfoId,dabiao.title,dabiao.creatorName,dabiao.startTime,dabiao.endTime,dabiao.percentage,dabiao.operationFlag,dabiao.taskPersonIdFROM(SELECTti.idAStaskIn...

SELECT dabiao.taskInfoId,

dabiao.title,

dabiao.creatorName,

dabiao.startTime,

dabiao.endTime,

dabiao.percentage,

dabiao.operationFlag,

dabiao.taskPersonId

FROM (SELECT ti.id AS taskInfoId,

ti.title AS title,

ti.creator_name AS creatorName,

ti.start_time AS startTime,

ti.end_time AS endTime,

ti.percentage,

(CASE tp.operation_flag WHEN '1' THEN '是' ELSE '否' END)

AS operationFlag,

tp.id AS taskPersonId

FROM xqhz_task_person AS tp

LEFT JOIN

xqhz_task_info AS ti

ON tp.task_id = ti.id

WHERE tp.actor = 'liujl'

ORDER BY ti.id DESC) AS dabiao

WHERE 1 = 1

工具中正确执行。

但是在程序中就会报出：Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

展开