使用mybatis框架,sql语句为:
SELECT () FROM BLQL_USER
1=1
and USERNAME LIKE '%${username}%'
and JOBNUMBER LIKE '%${jobnumber}%'
and ENABLE LIKE '%${enable}%'
and PHONE LIKE '%${phone}%'
ORDER BY CREATETIME
检查修改了好几次后台还是一直报:
The error occurred while setting parameters
SQL: SELECT ( ID,USERNAME,PASSWORD,REALNAME,JOBNUMBER,DESCRIPTION,CREATETIME,PHONE,EMAIL,ENABLE ) FROM BLQL_USER WHERE 1=1
Cause: java.sql.SQLSyntaxErrorException: ORA-00907: 缺失右括号
跪求各位技术大牛指引,小弟不胜感激。