SSM整合实现User表新增_ssm新增用户代码-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_50179990/article/details/120855431

本文详细介绍了如何使用Spring、SpringMVC和MyBatis（SSM）框架整合实现User表的增删改查操作。包括SysUser实体类的定义、SysUserDao接口及Mapper配置、UserService接口和服务实现、Controller层的编写以及展示结果的JSP页面设计。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;

/**

* sys_user

* @author

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;

/**

* 所属部门id

private Integer departmentId;

/**

* 职位id

private Integer positionId;

/**

* 角色id

private Integer roleId;

/**

* 姓名

private String realName;

/**

* 性别(0未知 1男 2女)

private Byte gender;

/**

* 出身日期

@JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")

@DateTimeFormat(pattern = "yyyy-MM-dd")

private Date birthday;

/**

* 头像

private String portrait;/**

* Email

private String email;

/**

* 手机号

private String mobile;

/**

* QQ

private String qq;

/**

* 微信

private String wechat;

/**

* 用户状态(0禁用 1启用)

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<SysUser> selectAll();

}

3、添加SysUserDao接口对应的Mapper

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<result column="gmt_modified" jdbcType="TIMESTAMP"

property="gmtModified"/>

<result column="department_id" jdbcType="INTEGER"

property="departmentId"/>

</resultMap>

, 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

</sql>

select

from sys_user

</select>

</mapper>

4、编写servies层代码

package com.gx.service;

import com.gx.po.SysUser;

import java.util.List;

public interface IUserService {

//查询所有用户

List<SysUser> selectAll();

}

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<SysUser> selectAll() {

return sysUserDao.selectAll();

}

编写Controller

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<SysUser> userList=userService.selectAll();

mv.addObject("userList",userList);

return mv;

}

编写jsp页面

<%--

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" %>

<html>

<head>

<style>

th,td{

border: 1px solid black;

}

</style>

</head>

<body>

<table>

<thead>

</thead>

<tbody>

<c:forEach items="${userList}" var="user">

<tr>

<td>${user.gmtCreate}</td>

<td>${user.userName}</td>

<td>${user.departmentId}</td>

<td>${user.positionId}</td>

<td>${user.roleId}</td>

<td>${user.realName}</td>

<td>${user.gender}</td>

<td>${user.birthday}</td>

<td>${user.mobile}</td>

</tr>

</c:forEach>

</tbody>

</table>

</body>

</html>

网页结果