SQL出错

2016-12-26 15:43:02,870 DEBUG [org.springframework.test.context.support.DirtiesContextTestExecutionListener] - After test method: context [DefaultTestContext@307c824e testClass = ProjectTest, testInstance = com.zito.awfp.park.project.ProjectTest@3e4ee7c0, testMethod = t1@ProjectTest, testException = org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'projectId !=null and projectId'' '. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: projectId !=null and projectId''  [org.apache.ibatis.ognl.ParseException: Encountered "\'\'" at line 1, column 31.

 

原因:

出现这个问题一般为xml文件中的sql语句写错了,少了某个标点

解决方法:

1.仔细查看配置文件,检查sql语句