大学生就业管理系统源码

FlatLife

已于 2025-06-24 15:59:51 修改

阅读量1.4k

点赞数 3

CC 4.0 BY-SA版权

文章标签： mybatis java spring boot

于 2022-12-06 15:48:14 首次发布

本文链接：https://blog.youkuaiyun.com/FlatLife/article/details/128203852

在这里插入图片描述

大学生就业管理系统源码

基于springboot框架，结合mybatis，maven配置工具

项目较为简单，适合初学者入门和学习

主要功能：

就业信息管理，用户管理，增删改查，就业人数统计：按专业、班级、岗位、企业统计

数据库为mysql，部分实现代码如下：

就业信息实体类

package com.bjpowernode.employment.mapper.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

public class EmploymentInfo {
    private String informationId;
    private String companyName;
    private String companyAddress;
    private String employmentStation;
    private String treatment;
    private String abilityRequirement;
    private String studentName;
    private String studentMajor;
    private String studentGender;
    private String studentClass;
    private String studentMobile;
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date employmentTime;
    private String companyContactName;
    private String companyContactMobile;

    public String getInformationId() {
        return informationId;
    }

    public void setInformationId(String informationId) {
        this.informationId = informationId;
    }

    public String getCompanyName() {
        return companyName;
    }

    public void setCompanyName(String companyName) {
        this.companyName = companyName;
    }

    public String getCompanyAddress() {
        return companyAddress;
    }

    public void setCompanyAddress(String companyAddress) {
        this.companyAddress = companyAddress;
    }

    public String getEmploymentStation() {
        return employmentStation;
    }

    public void setEmploymentStation(String employmentStation) {
        this.employmentStation = employmentStation;
    }

    public String getTreatment() {
        return treatment;
    }

    public void setTreatment(String treatment) {
        this.treatment = treatment;
    }

    public String getAbilityRequirement() {
        return abilityRequirement;
    }

    public void setAbilityRequirement(String abilityRequirement) {
        this.abilityRequirement = abilityRequirement;
    }

    public String getStudentName() {
        return studentName;
    }

    public void setStudentName(String studentName) {
        this.studentName = studentName;
    }

    public String getStudentGender() {
        return studentGender;
    }

    public void setStudentGender(String studentGender) {
        this.studentGender = studentGender;
    }

    public String getStudentMajor() {
        return studentMajor;
    }

    public void setStudentMajor(String studentMajor) {
        this.studentMajor = studentMajor;
    }

    public String getStudentClass() {
        return studentClass;
    }

    public void setStudentClass(String studentClass) {
        this.studentClass = studentClass;
    }

    public String getStudentMobile() {
        return studentMobile;
    }

    public void setStudentMobile(String studentMobile) {
        this.studentMobile = studentMobile;
    }

    public Date getEmploymentTime() {
        return employmentTime;
    }

    public void setEmploymentTime(Date employmentTime) {
        this.employmentTime = employmentTime;
    }

    public String getCompanyContactName() {
        return companyContactName;
    }

    public void setCompanyContactName(String companyContactName) {
        this.companyContactName = companyContactName;
    }

    public String getCompanyContactMobile() {
        return companyContactMobile;
    }

    public void setCompanyContactMobile(String companyContactMobile) {
        this.companyContactMobile = companyContactMobile;
    }
}

就业信息 controller层

package com.bjpowernode.employment.controller;

import com.bjpowernode.employment.common.CommonResult;
import com.bjpowernode.employment.mapper.entity.EmploymentInfo;
import com.bjpowernode.employment.service.EmploymentInfoService;
import com.bjpowernode.employment.util.GuidUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;
import java.util.UUID;

@Controller
public class EmploymentInfoController {
    @Autowired
    EmploymentInfoService employmentInfoService;

    @RequestMapping({"/employment/index", "/employment/employmentinfo"})
    public String index(){
        return "system/employmentinfo/employmentinfo";
    }

    @ResponseBody
    @RequestMapping("/employment/getallinfo")
    public CommonResult<List<EmploymentInfo>> getAllInfo(EmploymentInfo employmentInfo, @RequestParam("limit") int pageSize, @RequestParam("page") int pageNum){
        List<EmploymentInfo> infoList = employmentInfoService.getAllEmploymentInfo(employmentInfo, pageNum, pageSize);
        CommonResult<List<EmploymentInfo>> rtInfoResult = CommonResult.generateSuccessResult(infoList.size(), infoList);

        return rtInfoResult;
    }

    @ResponseBody
    @RequestMapping("/employment/getinfo")
    public CommonResult<List<EmploymentInfo>> getinfo(EmploymentInfo info, @RequestParam("limit") int pageSize, @RequestParam("page") int pageNum){
        List<EmploymentInfo> infoList = employmentInfoService.getEmploymentInfo(info, pageNum, pageSize);
        CommonResult<List<EmploymentInfo>> rtInfoResult = CommonResult.generateSuccessResult(infoList.size(), infoList);

        return rtInfoResult;
    }

    @ResponseBody
    @RequestMapping("/employment/addinfo")
    public CommonResult<Integer> addInfo(EmploymentInfo info){
        info.setInformationId(GuidUtil.getGuid());
        employmentInfoService.addEmploymentInfo(info);
        return CommonResult.generateSuccessResult(1, 1);
    }

    @ResponseBody
    @RequestMapping("/employment/updateinfo")
    public CommonResult<Integer> updateInfo(EmploymentInfo info){
        employmentInfoService.updateEmploymentInfo(info);
        return CommonResult.generateSuccessResult(1, 1);
    }

    @ResponseBody
    @RequestMapping("/employment/delinfo/{infoId}")
    public CommonResult<Integer> delInfo(@PathVariable("infoId") String infoId){
        employmentInfoService.deleteEmploymentInfo(infoId);
        return CommonResult.generateSuccessResult(1, 1);
    }
}

用户 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">
<mapper namespace="com.bjpowernode.employment.mapper.UserMapper">
    <resultMap id="userResultMap" type="com.bjpowernode.employment.mapper.entity.User">
        <result column="user_id" jdbcType="VARCHAR" property="userId" />
        <result column="user_name" jdbcType="VARCHAR" property="userName" />
        <result column="user_pwd" jdbcType="VARCHAR" property="userPwd" />
        <result column="user_account" jdbcType="VARCHAR" property="userAccount" />
        <result column="user_type" jdbcType="VARCHAR" property="userType" />
    </resultMap>

    <select id="getAllUsers" resultMap="userResultMap" parameterType="com.bjpowernode.employment.mapper.entity.User">
        select user_id, user_name, user_pwd, user_account, user_type from user
        where 1=1
        <if test="userId != null and userId != ''">
            and user_id = #{userId}
        </if>
        <if test="userName != null and userName != ''">
            and user_name like '%${userName}'
        </if>
        <if test="userAccount != null and userAccount != ''">
            and user_account like '%${userAccount}'
        </if>
        <if test="userType != null and userType != ''">
            and user_type = #{user_type}
        </if>
    </select>

    <select id="getUserById" resultMap="userResultMap">
        select user_id, user_name, user_pwd, user_account, user_type from user
        where user_id = #{userId}
    </select>

    <select id="getUserByAccount" resultMap="userResultMap">
        select user_id, user_name, user_pwd, user_account, user_type from user
        where user_account = #{userAccount}
    </select>

    <insert id="addUser" parameterType="com.bjpowernode.employment.mapper.entity.User">
        insert into user 
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="userId != null">
                user_id,
            </if>
            <if test="userName != null">
                user_name,
            </if>
            <if test="userPwd != null">
                user_pwd,
            </if>
            <if test="userAccount != null">
                user_account,
            </if>
            <if test="userType != null">
                user_type,
            </if>
        </trim>
        <trim prefix="values(" suffix=")" suffixOverrides=",">
            <if test="userId != null">
                #{userId},
            </if>
            <if test="userName != null">
                #{userName},
            </if>
            <if test="userPwd != null">
                #{userPwd},
            </if>
            <if test="userAccount != null">
                #{userAccount},
            </if>
            <if test="userType != null">
                #{userType},
            </if>
        </trim>
    </insert>

    <update id="updateUser" parameterType="com.bjpowernode.employment.mapper.entity.User">
        update user
        <set>
            <if test="userName != null">
                user_name = #{userName},
            </if>
            <if test="userPwd != null">
                user_pwd = #{userPwd},
            </if>
            <if test="userAccount != null">
                user_account = #{userAccount},
            </if>
            <if test="userType != null">
                user_type = #{userType},
            </if>
        </set>
        where user_id = #{userId}
    </update>

    <delete id="deleteUser">
        delete from user where user_id = #{userId}
    </delete>
</mapper>

用户管理前端 html

<!DOCTYPE html>
<html >
<head th:include="include/commoncss::commoncss(~{})">
</head>
<body class="layui-layout-body">
<div class="layui-layout layui-layout-admin">
    <div th:replace="include/header::header"></div>
    <!--查询条件-->
    <fieldset class="layui-elem-field layui-field-title" style="margin-top: 15px;">
        <legend>搜索条件</legend>
    </fieldset>
    <form action="" method="post" id="searchUser" lay-filter="searchUser" class="layui-form">
        <div class="layui-form-item">
            <div class="layui-inline">
                <label class="layui-form-label">用户帐号</label>
                <div class="layui-input-inline">
                    <input type="text" name="userAccount" id="userAccount" class="layui-input input-radius"
                           placeholder="请输入用户帐号">
                </div>
            </div>
            <div class="layui-inline">
                <label class="layui-form-label">用户姓名</label>
                <div class="layui-input-inline">
                    <input type="text" name="userName" id="userName" class="layui-input input-radius"
                           placeholder="请输入用户姓名">
                </div>
            </div>

            <div class="layui-inline" style="padding-left: 3%">
                <button type="button" class="layui-btn layui-btn-sm layui-btn-radius" lay-submit="" lay-filter="doSearch"><i
                        class="layui-icon layui-icon-search layui-icon-normal"></i>查询
                </button>
                <button type="reset" class="layui-btn layui-btn-sm layui-btn-radius layui-btn-warm"><i
                        class="layui-icon layui-icon-refresh"></i><span>重置</span>
                </button>
            </div>
        </div>
    </form>
    <!-- 用户列表 -->
    <div>
        <table class="layui-hide" id="userList" lay-filter="userList"></table>
    </div>
    <!-- 表格操作 -->
    <script type="text/html" id="usersToolBar">
        <button type="button" lay-event="userAdd" class="layui-btn layui-btn-sm layui-btn-normal layui-btn-radius">
            <i class="layui-icon layui-icon-add-1"></i>添加用户
        </button>
    </script>
    <!-- 用户操作 -->
    <script type="text/html" id="userListOpt">
        <a class="layui-btn layui-btn-xs" lay-event="userEdit">编辑</a>
        <a class="layui-btn layui-btn-xs layui-btn-danger" lay-event="userDel">删除</a>
    </script>
    <!-- 添加或修改弹出层 -->
    <div style="display: none;padding: 10px;padding-right: 5%" id="addOrUpdateUser">
        <form action="" method="post" class="layui-form" id="addOrUpdateForm" lay-filter="addOrUpdateForm">
            <div class="layui-form-item">
                <div class="layui-inline">
                    <label class="layui-form-label">帐号</label>
                    <div class="layui-input-block">
                        <input type="hidden" name="userId">
                        <input type="text" name="userAccount" lay-verify="required" autocomplete="off"
                               class="layui-input input-radius" placeholder="请输入帐号">
                    </div>
                </div>
                <div class="layui-inline">
                    <label class="layui-form-label">姓名</label>
                    <div class="layui-input-block">
                        <input type="text" name="userName" lay-verify="required" autocomplete="off"
                               class="layui-input input-radius" placeholder="请输入姓名">
                    </div>
                </div>
            </div>

            <div class="layui-form-item">
                <div class="layui-inline">
                    <label class="layui-form-label">密码</label>
                    <div class="layui-input-block">
                        <input type="password" name="userPwd" lay-verify="required" autocomplete="off"
                               class="layui-input input-radius" placeholder="请输入密码">
                    </div>
                </div>
                <div class="layui-inline">
                    <label class="layui-form-label">确认密码</label>
                    <div class="layui-input-block">
                        <input type="password" name="confirm_userPwd" lay-verify="required|confirmPass" autocomplete="off"
                               class="layui-input input-radius" placeholder="请再次输入密码">
                    </div>
                </div>
            </div>
            <div class="layui-form-item">
                <div class="layui-inline">
                    <label class="layui-form-label">身份类型</label>
                    <div class="layui-input-block">
                        <input type="radio" name="userType" value="1" title="普通用户" checked>
                        <input type="radio" name="userType" value="0" title="管理员" >
                    </div>
                </div>
            </div>
            <div class="layui-form-item">
                <div class="layui-input-block" style="text-align: center;padding-right: 7%">
                    <button type="button" class="layui-btn layui-btn-radius" lay-submit="" lay-filter="userSubmitBtn" id="userSubmitBtn"><i
                            class="layui-icon layui-icon-search layui-icon-normal"></i>提交
                    </button>
                    <button type="userReset" class="layui-btn layui-btn-radius layui-btn-warm"><i
                            class="layui-icon layui-icon-refresh"></i><span>重置</span>
                    </button>
                </div>
            </div>
        </form>
    </div>

    <div th:include="include/commonjs::commonjs(~{::script})">
        <script type="text/javascript" src="/resources/js/common/header.js"></script>
        <script type="text/javascript" src="/resources/js/system/usermanage/usermanage.js"></script>
    </div>
</div>
</body>
</html>