我必须进行登录表单验证，如果密码匹配，它将继续进行

Question

it is moving forward on any user name or password.let me know the correct solution for this.

这是我的道.java课

public List < Student > getLogin() {
return template.query("select * from auction", new RowMapper < Student > () {
@Override
public Student mapRow(ResultSet rs, int row) throws SQLException {
Student s = new Student();
s.setName(rs.getString(1))
s.setPassword(rs.getString(2));
return s;
}
});
}

这是我的控制器.java请更正我的代码....我需要做什么样的改变

@RequestMapping(value="/addLogin",method=RequestMethod.GET) 
public String addLogin(@ModelAttribute("SpringWeb")Student s, Model model) { 
List<Student> list=dao.getLogin(); 
List <Student> b=dao.getStudentRecord(); 
String name=s.getName(); 
String password=s.getPassword(); 
if(name.equals(list) && password.equals(list)) { 
model.addAttribute("welcome",name); 
model.addAttribute("record",b); 
return "change"; 
} else { 
model.addAttribute("login","Wrong Username or Password"); 
return "login"; 
}
}

Answer 1

您无需查询所有用户即可登录。 而是将查询更改为

"select * from auction where userName=? and password=?"

在服务中检查查询是否返回了任何行。 如果查询返回了一行，则登录成功，否则登录失败。

所以春天的实现变成了..

template.queryForList("select * from auction where userName=? and password=?", new Object[]{userName, password});