1、添加Class:SysUser
package com.gx.po;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;
import java.io.Serializable;
import java.util.Date;
public class SysUser implements Serializable {
private Integer id;private Date gmtCreate;
private Date gmtModified;
private Byte isDeleted;
private String userName;
private String userPassword;
private String salt;
private Integer departmentId;
private Integer positionId;
private Integer roleId;
private String realName;
private Byte gender;
@JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date birthday;
private String portrait;
private String email;
private String mobile;
private String qq;
private String wechat;
private Byte userStatus;
private Integer loginCount;
private String remark;
private static final long serialVersionUID = 1L;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Date getGmtCreate() {
return gmtCreate;
}
public void setGmtCreate(Date gmtCreate) {
this.gmtCreate = gmtCreate;
}
public Date getGmtModified() {
return gmtModified;
}public void setGmtModified(Date gmtModified) {
this.gmtModified = gmtModified;
}
public Byte getIsDeleted() {
return isDeleted;
}
public void setIsDeleted(Byte isDeleted) {
this.isDeleted = isDeleted;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPassword() {
return userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
}
public String getSalt() {
return salt;
}
public void setSalt(String salt) {
this.salt = salt;
}
public Integer getDepartmentId() {
return departmentId;
}
public void setDepartmentId(Integer departmentId) {
this.departmentId = departmentId;
}
public Integer getPositionId() {
return positionId;
}
public void setPositionId(Integer positionId) {
this.positionId = positionId;
}
public Integer getRoleId() {
return roleId;
}
public void setRoleId(Integer roleId) {
this.roleId = roleId;}
public String getRealName() {
return realName;
}
public void setRealName(String realName) {
this.realName = realName;
}
public Byte getGender() {
return gender;
}
public void setGender(Byte gender) {
this.gender = gender;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getPortrait() {
return portrait;
}
public void setPortrait(String portrait) {
this.portrait = portrait;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getQq() {
return qq;
}
public void setQq(String qq) {
this.qq = qq;
}public String getWechat() {
return wechat;
}
public void setWechat(String wechat) {
this.wechat = wechat;
}
public Byte getUserStatus() {
return userStatus;
}
public void setUserStatus(Byte userStatus) {
this.userStatus = userStatus;
}
public Integer getLoginCount() {
return loginCount;
}
public void setLoginCount(Integer loginCount) {
this.loginCount = loginCount;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
@Override
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append(getClass().getSimpleName());
sb.append(" [");
sb.append("Hash = ").append(hashCode());
sb.append(", id=").append(id);
sb.append(", gmtCreate=").append(gmtCreate);
sb.append(", gmtModified=").append(gmtModified);
sb.append(", isDeleted=").append(isDeleted);
sb.append(", userName=").append(userName);
sb.append(", userPassword=").append(userPassword);
sb.append(", salt=").append(salt);
sb.append(", departmentId=").append(departmentId);
sb.append(", positionId=").append(positionId);
sb.append(", roleId=").append(roleId);
sb.append(", realName=").append(realName);
sb.append(", gender=").append(gender);
sb.append(", birthday=").append(birthday);
sb.append(", portrait=").append(portrait);
sb.append(", email=").append(email);
sb.append(", mobile=").append(mobile);
sb.append(", qq=").append(qq);
sb.append(", wechat=").append(wechat);
sb.append(", userStatus=").append(userStatus);
sb.append(", loginCount=").append(loginCount);
2、添加接口SysUserDao
package com.gx.dao;
import com.gx.po.SysUser;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository("sysUserDao")
public interface SysUserDao {
//查询所有
List
}
3、添加SysUserDao接口对应的Mapper
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
property="gmtModified"/> property="departmentId"/> id , gmt_create, gmt_modified, is_deleted, user_name, user_password, salt, department_id, position_id, role_id, real_name, gender, birthday, portrait, email, mobile, qq, wechat, user_status, login_count, remark select from sys_user 4、编写servies层代码 package com.gx.service; import com.gx.po.SysUser; import java.util.List; public interface IUserService { //查询所有用户 List } 5、Servies接口类 package com.gx.service.impl; import com.gx.dao.SysUserDao; import com.gx.po.SysUser; import com.gx.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; @Service("userService") @Transactional//事务注解 public class UserServiceImpl implements IUserService { //注入Dao @Autowired private SysUserDao sysUserDao; @Override public List return sysUserDao.selectAll(); } } package com.gx.controller; import com.gx.po.SysUser; import com.gx.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import java.util.List; @Controller @RequestMapping("/user") public class UserController { //service层 @Autowired private IUserService userService; @RequestMapping("/list") public ModelAndView list(){ ModelAndView mv=new ModelAndView("/userList"); //查询数据 List mv.addObject("userList",userList); return mv; } } <%-- Created by IntelliJ IDEA. User: sxj Date: 2021/8/9 Time: 20:58 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
th,td{
border: 1px solid black;
}
| Id | 创建时间 | 用户名 | 部门id | 职位id | 角色id | 姓名 | 性别 | 生日 | 手机号 |
|---|---|---|---|---|---|---|---|---|---|
| ${user.id} | ${user.gmtCreate} | ${user.userName} | ${user.departmentId} | ${user.positionId} | ${user.roleId} | ${user.realName} | ${user.gender} | ${user.birthday} | ${user.mobile} |
- 网页结果
