实体类
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private String username;
private String password;
}
接口
@Mapper
@Repository
public interface UserMapper {
User getUsers(String username,String password);
}
SQL语句
<mapper namespace="com.li.Mapper.UserMapper">
<select id="getUsers" resultMap="UserMap">
select * from user where username=#{username} AND password=#{password}
</select>
<resultMap id="UserMap" type="User">
<result property="username" column="username"></result>
<result property="password" column="password"/>
</resultMap>
</mapper>
数据库表
controller层
@RequestMapping("/index")
public String user(@RequestParam("username") String username,
@RequestParam("password") String password,
Model model,
HttpSession session) {
User login = userMapper.getUsers(username,password);
if (login!=null) {
session.setAttribute("loginUser", username);
return "redirect:/dash";
} else {
model.addAttribute("msg", "用户名或密码错误");
return "index";
}
}