由于在dao层的一个文件写出错了注解,导致了整个项目无法读取数据库。mybatis的这个设定真是糟糕透顶,所以说写ognl表达式来对数据库CRUD的时候一定要小心。控制台报出的错误如下:
Error building SqlSession.
The error may exist in com/itheima/travel/dao/FavoriteMapper.java
(best guess) ### Cause: org.apache.ibatis.builder.BuilderException:
Error parsing SQL Mapper Configuration. Cause:
org.apache.ibatis.builder.BuilderExcep Could not find value method on
SQL annotation
错误代码:
@Select(" <script>\n"
+ " select count(*) from tab_route\n"
+ " <where>\n"
+ " rflag=1 \n"
+ " <if test=\"rname!=null and !''.equals(rname)\">\n"
+ " and rname like concat('%',#{rname},'%')\n"
+ " </if>\n"
+ " <if test=\"price1!=null and price2!=null\">\n"
+ " and price >= #{price1} and price <= #{price2}\n"
+ " </if>\n"
+ " </where>\n"
+ " </script>")
int findFavoriteCount(@Param("rname") String rname,