nested exception is org.springframework.jdbc.BadSqlGram 问题

type Exception report

message Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: 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 'course_name = '数据结构'' at line 5
### The error may exist in com/wj/mapper/CourseMapper.xml
### The error may involve com.wj.mapper.CourseMapper.selectCourseList-Inline
### The error occurred while setting parameters
### SQL: select * from course          WHERE teacher_id = ?                               course_name = ?
### Cause: 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 'course_name = '数据结构'' at line 5
; bad SQL grammar []; nested exception is 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 'course_name = '数据结构'' at line 5

在写ssm查询数据库时出现这个问题，mapper.xml为：

<!--查询课程列表-->
    <select id="selectCourseList" resultMap="Course" parameterType="Course" >
        select * from course
        <where>
        <if test="teacherId !=null">
            teacher_id = #{teacherId},
        </if>
        <if test="courseName != null">
            course_name = #{courseName}
        </if>
        </where>
    </select>

百度到说是用到了mysql的关键字，但是排查没有，所以一定是sql写的有问题：更改为：

 <!--查询课程列表-->
    <select id="selectCourseList" resultMap="Course" parameterType="Course" >
        select * from course
        <where>
        <if test="teacherId !=null">
            teacher_id = #{teacherId}
        </if>
        <if test="courseName != null">
            and course_name = #{courseName}
        </if>
        </where>
    </select>

在第二个if判断之前加上and关键字，做条件拼接！

2018.8.7 教务系统查询时遇到的问题。