无法使用Spring安全性使用数据库登录

Question

我尝试了用户登录数据库的这个示例，但我无法登录。即使我提供了正确的用户名和密码，但我总是会收到错误信息。这是我的代码： 的login.jsp

<form name="login" action="<c:url value='j_spring_security_check'/>" method="POST"> 
    <input type='text' name='username' />    
    <input type='password' name='password'>      
    <input name="submit" type="submit">&nbsp;<input name="reset" type="reset"> 
</form> 

和我的查询是一样喜欢这个链接http://www.mkyong.com/spring-security/spring-security-form-login-using-database/我弹簧security.xml文件是

<http auto-config="true" use-expressions="true"> 
    <intercept-url pattern="/signin" access="permitAll"></intercept-url> 
    <intercept-url pattern="/logout" access="permitAll"></intercept-url> 
    <intercept-url pattern="/denied" access="permitAll"></intercept-url> 
    <intercept-url pattern="/**" access="isAuthenticated()"></intercept-url> 
    <form-login login-page="/signin" authentication-failure-url="/denied"/> 
    <logout logout-success-url="/logout"></logout> 
</http> 
<authentication-manager> 
    <authentication-provider> 
     <jdbc-user-service data-source-ref="dataSource" users-by-username-query="select username,password,'true' as enabled from users where username=? limit 1" authorities-by-username-query="select username, role from user_roles where username =?"/> 
    </authentication-provider>   
</authentication-manager> 

，这是我的spring-database.xml

<beans xmlns="http://www.springframework.org/schema/beans" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"> 

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
     <property name="driverClassName" value="com.mysql.jdbc.Driver" /> 
     <property name="url" value="jdbc:mysql://localhost:3306/test" /> 
     <property name="username" value="root" /> 
     <property name="password" value="userroot" /> 
    </bean>  
</beans> 

和我的securityconfig.java和app config.java是相同的。只是用户名值是root和password = userroot。任何帮助？

Answer 1

在您的login.jsp窗体中，您必须使用j_username和j_password作为输入的名称。