开发工具:
MySql
idea
Maven
Tomcat
JDK使用版本为1.8
用户表
实体类
public class UserInfo {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public UserInfo() {
}
public UserInfo(int id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
@Override
public String toString() {
return "UserInfo{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
登录界面
当用户名和密码全部正确时,将跳转到主页,并在左侧显示当前登录的用户名;
密码错误或者用户名不存在时,会在页面进行提示,实现代码:
@RequestMapping("/doLogin.do")
public String doLogin(String username, String password, HttpServletRequest request){
UserInfo userInfo = userInfoService.doLogin(username);
// 2. 判断
if (userInfo != null ){
if (userInfo.getPassword().equals(password)) {
System.out.println("密码正确,登陆成功!");
request.getSession().setAttribute("user",userInfo);
return "main";
} else {
System.out.println("密码错误,登陆失败");
request.setAttribute("msg","密码错误,请重新输入");
return "../login";
}
} else {
System.out.println("用户不存在,请重新输入");
request.setAttribute("msg","用户名不存在");
return "../login";
}
}
查询功能:
Controller层
@RequestMapping("/findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue = “1”)Integer page,
@RequestParam(defaultValue = “5”) Integer size){
//调用service中的方法,得到查询结果
List userInfoList=userInfoService.findAll(page,size);
//把得到的数据存放到pageInfo中
PageInfo pageInfo = new PageInfo(userInfoList);
ModelAndView mv=new ModelAndView();
mv.addObject(“pageInfo”,pageInfo);
mv.setViewName(“user-list”);
return mv;
}
Service层:
@Override
public List findAll(Integer page,Integer size) {
PageHelper.startPage(page,size);
return userInfoDao.findAll();
}
Mapper.xml
select * from tb_user
在数据库中插入数据,页面效果
转载:https://blog.csdn.net/x050049/article/details/104595229