springboot + bootstrap + thymeleaf +mybatis 编写员工管理系统

最新推荐文章于 2023-09-28 21:25:11 发布
最新推荐文章于 2023-09-28 21:25:11 发布
阅读量2.1k 收藏 29
点赞数 3
分类专栏： springboot 文章标签： bootstrap
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/flycp/article/details/107470586
版权

前面一篇文章实现了用户登录验证：springboot + thymeleaf +interceptor实现用户登录验证
今天接着上一篇文章，接入mybatis，实现员工管理系统的增删改查功能。
本文前端静态资源：bootstrap静态资源页面
首先贴一下maven配置：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.1.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.cpown</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--webjar 引入jquery-->
        <dependency>
            <groupId>org.webjars</groupId>
            <artifactId>jquery</artifactId>
            <version>3.4.1</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>

        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.42</version>
        </dependency>


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.7</version>
            <scope>compile</scope>
            <optional>true</optional>
        </dependency>

    </dependencies>

    <build>
        <plugins>

            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.7</version>
                <configuration>
                    <configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>5.1.42</version>
                    </dependency>
                </dependencies>

            </plugin>

            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>

        </plugins>
    </build>

</project>

配置文件：

#数据库连接配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/yao?autoReconnect=true&amp;failOverReadOnly=false;useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456

#关闭thymeleaf缓存
spring.thymeleaf.cache=false
#sql日志打印级别 com.cpown.demo.mapper 对应的是自己的mapper.java文件存放路径
logging.level.com.cpown.demo.mapper=debug

#mybatisxml扫描
mybatis.mapper-locations=classpath:mapper/**/*.xml
#实体类
mybatis.type-aliases-package=com.cpown.demo.pojo

一、创建数据库表格以及映射文件

我们使用 mysql数据库，创建两张表格：

  1. 用户表 sys_user
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户名称',
  `password` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户密码',
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '邮箱',
  `sex` tinyint(4) DEFAULT NULL COMMENT '性别0 女 1男',
  `department_id` int(11) DEFAULT NULL COMMENT '部门id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
  1. 部门表 department
 CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `department_name` varchar(255) DEFAULT NULL COMMENT '部门名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='部门表';

这里使用 maven 插件generator 生成 实体类 pojo+mapper.xml+mapper.java文件，可以参考下：
maven插件自动生成pojo以及mapper映射文件

<1> pojo实体类
toString()方法需要自己重写。

package com.cpown.demo.pojo;

public class Department {
    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column department.id
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    private Integer id;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column department.department_name
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    private String departmentName;

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column department.id
     *
     * @return the value of department.id
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    public Integer getId() {
        return id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column department.id
     *
     * @param id the value for department.id
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column department.department_name
     *
     * @return the value of department.department_name
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    public String getDepartmentName() {
        return departmentName;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column department.department_name
     *
     * @param departmentName the value for department.department_name
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    public void setDepartmentName(String departmentName) {
        this.departmentName = departmentName;
    }

    @Override
    public String toString() {
        return "Department{" +
                "id=" + id +
                ", departmentName='" + departmentName + '\'' +
                '}';
    }
}

package com.cpown.demo.pojo;

import java.util.Date;

public class SysUser {
    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sys_user.id
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    private Integer id;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sys_user.name
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    private String name;

    private String password;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sys_user.email
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    private String email;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sys_user.sex
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    private Byte sex;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sys_user.birth
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    private Date birth;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sys_user.department_id
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    private Integer departmentId;

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column sys_user.id
     *
     * @return the value of sys_user.id
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public Integer getId() {
        return id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column sys_user.id
     *
     * @param id the value for sys_user.id
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column sys_user.name
     *
     * @return the value of sys_user.name
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public String getName() {
        return name;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column sys_user.name
     *
     * @param name the value for sys_user.name
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public void setName(String name) {
        this.name = name;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column sys_user.email
     *
     * @return the value of sys_user.email
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public String getEmail() {
        return email;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column sys_user.email
     *
     * @param email the value for sys_user.email
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public void setEmail(String email) {
        this.email = email;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column sys_user.sex
     *
     * @return the value of sys_user.sex
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public Byte getSex() {
        return sex;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column sys_user.sex
     *
     * @param sex the value for sys_user.sex
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public void setSex(Byte sex) {
        this.sex = sex;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method returns the value of the database column sys_user.department_id
     *
     * @return the value of sys_user.department_id
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public Integer getDepartmentId() {
        return departmentId;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method sets the value of the database column sys_user.department_id
     *
     * @param departmentId the value for sys_user.department_id
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    public void setDepartmentId(Integer departmentId) {
        this.departmentId = departmentId;
    }


    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "SysUser{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", email='" + email + '\'' +
                ", sex=" + sex +
                ", departmentId=" + departmentId +
                '}';
    }
}

<2> mapper映射文件

package com.cpown.demo.mapper;

import com.cpown.demo.pojo.Department;
import com.cpown.demo.pojo.SysUser;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface DepartmentMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table department
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table department
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    int insert(Department record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table department
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    Department selectByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table department
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    List<Department> selectAll();

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table department
     *
     * @mbg.generated Tue Jul 14 20:30:14 CST 2020
     */
    int updateByPrimaryKey(Department record);

    List<Department> selectDepartmentByName(@Param("name")String name);

}

package com.cpown.demo.mapper;

import com.cpown.demo.dto.SysUserDto;
import com.cpown.demo.pojo.SysUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SysUserMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table sys_user
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table sys_user
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    int insert(SysUser record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table sys_user
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    SysUser selectByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table sys_user
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    List<SysUserDto> selectAll();

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table sys_user
     *
     * @mbg.generated Tue Jul 14 20:27:59 CST 2020
     */
    int updateByPrimaryKey(SysUser record);

    List<SysUser> selectSysUserByName(@Param("name")String name);
}

为了前端直接展示部门名称，定义Dto查询关联部门表，直接展示部门名称：

package com.cpown.demo.dto;

import com.cpown.demo.pojo.SysUser;

/**
 * 用户查询Dto
 */
public class SysUserDto extends SysUser {
   
    private String departmentName;

    public String getDepartmentName() {
   
        return departmentName;
    }

    public void setDepartmentName(String departmentName) {
   
        this.departmentName = departmentName;
    }
}

<3> xml文件

<?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">
<mapper namespace="com.cpown.demo.mapper.DepartmentMapper">
  <resultMap id
最低0.47元/天 解锁文章
springboot入门级项目（一）学生管理系统（springboot+mybatis+bootstrap+thymeleaf）
m0_67393593的博客
06-12 1127
1、登录页面 ，支持中英文切换 2、学生管理页面，支持增删改查（这里就不演示了，操作时间太长，录制的gif太大，传不上来，直接看主页面） 跟着B站的狂神老师学习了一段时间的springboot，打算写个小项目练练手当做复习（我还是新手）。前端直接用的bootstrap已有的模板。 大家可以看看狂神的员工管理系统：https://www.bilibili.com/video/BV1PE411i7CVp=20学生管理系统资源获取：百度网盘 链接：https://pan.baidu.com/s/10_Ikc0I7
spring boot+thymeleaf+bootstrap实现后台管理系统界面
08-28
主要为大家详细介绍了spring boot+thymeleaf+bootstrap简单实现后台管理系统界面，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
spring boot+thymeleaf+bootstrap 简单实现后台管理系统界面
04-21
spring boot+thymeleaf+bootstrap 简单实现后台管理系统界面；
spring boot+thymeleaf+bootstrap 简单实现后台管理系统界面（看评论酌情下载）
12-07
spring boot+thymeleaf+bootstrap 简单实现后台管理系统界面（看评论酌情下载）
java-简单员工管理系统（使用bootStrap）
weixin_49319251的博客
09-02 1979
本文提供详细页面代码与java后端代码，并提供编写过程中值得注意的地方。 简单员工管理系统 注意：写页面代码时，需注意以下几点： 1、修改、添加操作，需先清空模态框中form表单缓存（不然会造成修改数据后，点击添加操作，刚修改的数据会展示在添加操作页面中）。 方法： $("#form")[0].reset(); 2、修改、添加操作，需先清空隐藏域（即隐藏域中的id。若不清空，执行修改操作后，拿到的id保存在隐藏域中，这时执行添加操作（添加操作本无id），会将执行修改操作时的id，传给添加操作。造成添加操作变
基于 Springboot、Shiro、Mybatis、Thymeleaf 做的后台管理系统（也有传统MVC版本，都在ZIP里）
08-10
基于 Springboot、Shiro、Mybatis、Thymeleaf 做的后台管理系统，简单粗暴
SpringBoot+MyBatis+Apache Shiro+Bootstrap+Thymeleaf可用于开发企业级应用系统
05-26
本系统（基于SpringBoot+MyBatis+Apache Shiro+Bootstrap+Thymeleaf） 可用于开发所有企业级WEB应用系统（如:各种后台管理系统、CRM、ERP、CMS、OA、博客、论坛等...）。响应式布局，支持大部分浏览器（如：IE9+...
基于springboot+bootstrap模版+thymeleaf的一个简单自习室预约管理系统源码+数据库sql文件.zip
最新发布
05-21
这是一个基于Spring Boot、Bootstrap模板和Thymeleaf的自习室预约管理系统的源代码项目，包含数据库SQL文件。这个系统的设计和实现充分利用了现代Web开发技术，旨在提供一个简洁高效的在线预约平台。 首先，Spring ...
springboot-penguin:基于SpringBoot + Mybatis + Thymeleaf + SemanticUI + Bootstrap的在线考试系统的在线考试系统
03-11
在线考试系统（低仿牛客网） 系统概要 在线考试系统针对为学生提供一个在线考试的平台，在这里，学生甚至可以网上在线考试，而且可以浏览题库中心下的各个课程的题库，也可以在讨论区下发表自己的想法，当然也在帖子...
springboot+shiro+mybatis+Thymeleaf实现用户权限框架
11-29
本项目名为“springboot+shiro+mybatis+Thymeleaf实现用户权限框架”，它整合了四个关键的技术组件，旨在提供一个易于上手、功能丰富的解决方案。下面将详细阐述这些技术及其在框架中的作用。 1. **Spring Boot**: ...
spring boot+bootstrap+thymeleaf
04-10
自己整理的spring boot+bootstrap+thymeleaf的模板，传统erp或者管理后台的样式，简单好用。
springboot+mybatis+bootstrap开发员工OA后台管理系统
12-30
springboot+mybatis+bootstrap开发员工OA后台管理系统 项目描述 jboa项目有请假以及报销单的申请和审核session共享加登陆拦截人事对人员的管理 员工添加报销单提交到（本部门）部门经理，部门经理通过如果总金额大于5000提交到总经理，总经理打回或拒绝会打回到部门经理，总经理通过到财务，财务付款到员工，付款成功不能编辑和提交 员工添加报销单提交到（本部门）部门经理，部门经理通过如果总金额小于5000提交到财务，财务付款到员工，付款成功不能编辑和提交 请假单员工添加，提交到（本部门）部门经理，部门经理通过后到员工 springboot+mybatis+bootstrap开发员工oa后台管理系统 运行环境 jdk8+tomcat8+mysql5.6以上+IntelliJ IDEA+maven 项目技术(必填) springboot+bootstrap+ajax+mybatis+freemarker+redis 数据库文件 链接: https://pan.baidu.com/s/1yWu3dKfd3OMW2CrGxl5qJQ 密码: 7q11 jar包文件 maven搭建 链接: https://pan.baidu.com/s/1dbyswv52Zw1czS0Aj0SOJQ 密码: xwen
springboot+bootstrap+shiro权限管理
03-28
本系统是有springboot结合shiro开发的一款权限管理系统，前端用的是bootstrap，界面美观，含数据库文件。
拿来即用springboot+bootstrap整合若依的后台管理系统
08-10
入口在ruoyi-platweb ccspAplication.java 也可以打包到tomcat中
springboot+bootstrap实现的图书管理系统
06-09
springboot+bootstrap实现的图书管理系统
教学管理系统-springboot+bootstrap
12-06
教学管理系统，内含登、用户管理、角色管理、权限管理、实时对话、写日记（富文本编辑），日记审核流程。日记打分统计（饼图和条形图）。
基于SpringBoot+Bootstrap的旅游管理系统的设计与实现
2301_77541824的博客
09-28 1115
随着旅游业的迅速发展，传统的旅游信息查询方式，已经无法满足用户需求，因此，结合计算机技术的优势和普及，针对常州旅游，特开发了本基于Bootstrap的常州地方旅游管理系统。本论文首先对常州地方旅游管理系统进行需求分析，从系统开发环境、系统目标、设计流程、功能设计等几个方面进行系统的总体设计，开发出本基于Bootstrap的常州地方旅游管理系统，主要实现了用户功能模块和管理员功能模块两大部分，用户可查看景点信息、景点资讯等，注册登录后可进行景点订票操作，同时管理员可进入系统后台对系统进行全面管理操作。
SpringBoot实例①SpringBoot+bootstrap+thymeleaf实现简单页面
南北极之间
05-31 9212
首先，新建一个springboot项目。具体步骤参考之前的SpringBoot入门文章，有详细图文介绍。pom&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-in...
springboot+mybatis+bootstrap+thymeleaf前后端框架搭建
qq_43248715的博客
12-22 1146
大家对thymeleaf框架比较不熟悉，其实thymeleaf是spring官方推荐的前台框架，今天就教大家如何使用thymeleaf整合到springboot中。 创建maven项目，pom.xml文件添加springboot需要的依赖包 <dependencies> <!--springboot启动依赖包--> <dependency> <groupId>org.springframework.boot</group
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值