连接mysql无问题
两句查询语句如下： <authentication-provider>
<jdbc-user-service data-source-ref="dataSource"
users-by-username-query="select student.username,student.password, status.status as enabled from student left join status on status.id=student.id where student.username='?'"
authorities-by-username-query="select student.username,role_table.descn as authority from student left join student_role_student on student_role_student.student=student.ID left join student_role_role_table on student_role_role_table.student_role=student_role_student.student_role left join role_table on role_table.id=student_role_role_table.role_table where student.username='?'"/>
</authentication-provider>这两句单独在mysql中运行，将‘？’换成用户名后，无问题但是在这个web应用中运行登陆却出现这个提示，无法进行登录：Your login attempt was not successful, try again.Reason: PreparedStatementCallback; bad SQL grammar [SELECT username,password,enabled FROM users WHERE username = ?]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'score.users' doesn't exist; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT username,password,enabled FROM users WHERE username = ?]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'score.users' doesn't exist 求大神帮忙解答！！！！！跪谢！！！
两句查询语句如下： <authentication-provider>
<jdbc-user-service data-source-ref="dataSource"
users-by-username-query="select student.username,student.password, status.status as enabled from student left join status on status.id=student.id where student.username='?'"
authorities-by-username-query="select student.username,role_table.descn as authority from student left join student_role_student on student_role_student.student=student.ID left join student_role_role_table on student_role_role_table.student_role=student_role_student.student_role left join role_table on role_table.id=student_role_role_table.role_table where student.username='?'"/>
</authentication-provider>这两句单独在mysql中运行，将‘？’换成用户名后，无问题但是在这个web应用中运行登陆却出现这个提示，无法进行登录：Your login attempt was not successful, try again.Reason: PreparedStatementCallback; bad SQL grammar [SELECT username,password,enabled FROM users WHERE username = ?]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'score.users' doesn't exist; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT username,password,enabled FROM users WHERE username = ?]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'score.users' doesn't exist 求大神帮忙解答！！！！！跪谢！！！
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货