java - Spring Framework - JDBC 登录

Question

我一直在尝试使用 spring 创建一个简单的 JDBC 登录页面，但我不知道如何解决这个问题。我输入了真实数据库中显示的正确用户名和密码，但它没有让我登录？

它应该让我登录，然后将我转发到仅限员工的管理页面。但一切都变成了登录错误

登录控制器：

@Controller
public class LoginController {

@Autowired
private UserServiceImpl userService;

@GetMapping("/login")
public String showLoginForm(Model model) {

    User user = new User();
    model.addAttribute("user", user);

    return "login";
}

@PostMapping("/processLogin")
public String processLogin(@ModelAttribute("user") User user, Model model) {

    if (userService.findUser(user.getUsername(), user.getPassword()) == null) {
        return "/access-denied";
    } else {
        return "/management/dashboard";
    }
}

@GetMapping("/access-denied")
public String accessDenied(Model model) {
    return "access-denied";
}

登录表单（JSP 页面）：

<form:form method="post" modelAttribute="user"
                action="${pageContext.request.contextPath}/processLogin">

                <div class="form-group">
                    <div class="form-label-group">
                        <label for="inputUser">Username: </label> <input name="username"
                            type="text" path="username" id="inputUser" class="form-control"
                            placeholder="Username" required="required" autofocus="autofocus">
                    </div>
                </div>

                <div class="form-group">
                    <div class="form-label-group">
                        <label for="inputPassword">Password: </label> 
                        <input name="username" type="password" path="password"
                            id="inputPassword" class="form-control" placeholder="Password"
                            required="required">
                    </div>
                </div>

                <div class="form-group">
                    <div class="checkbox">
                        <label> <input type="checkbox" value="remember-me">
                            Remember Password
                        </label>
                    </div>
                </div>

                <input type="submit" value="Login"/>

            </form:form>

USER DAO（查询用户）：

@Autowired
private SessionFactory sessionFactory;

@Override
@Transactional
public User findUser(String username, String password) {

    Session session = sessionFactory.getCurrentSession();

    session.beginTransaction();

    Query<User> theQuery = session.createQuery("from User 
    where username=:username", User.class);
    User user = theQuery.getSingleResult();

    session.close();

    if (user.getPassword().equals(password)) {
        return user;
    }

    return null;
}

用户实体：

@Entity
@Table(name = "users")
public class User {

@Column(name = "username")
private String username;

@Column(name = "password")
private String password;

public User(String username, String password) {
    this.username = username;
    this.password = password;
}

public User() {

}

// and all the getters/setters

数据库表：

CREATE TABLE `users` (
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`enabled` tinyint(1) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



INSERT INTO `users` 
VALUES 
('john','{noop}test123',1),
('mary','{noop}test123',1),
('susan','{noop}test123',1);

标签： javaspringspring-mvc