Java-SSM-新冠疫苗接种登记系统

<?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.item.dao.TbVaccineMapper">
    <select id="GetInfo" resultType="TbVaccine">
        select * from tb_vaccine;
    </select>
    <!-- name的模糊查询以及id_no的精准查询 -->
    <select id="SelectByNameAndIdNo" resultType="TbVaccine">
        select * from tb_vaccine
        <if test="name!=null or id_no!=null">
            where 1=1
        </if>
        <if test="name!=null">
            and name like "%${name}%"
        </if>
        <if test="id_no!=null">
            and id_no="${id_no}"
        </if>
    </select>
    <insert id="AddInfo">
        INSERT into tb_vaccine VALUES(0,"${name}","${sex}","${id_no}","${address}",#{company},NOW());
    </insert>
    <delete id="DeleteById">
        delete from tb_vaccine where id=#{id}
    </delete>
</mapper>

package com.item.model;

public class TbVaccine {
    private int id;
    private String name;
    private String sex;
    private String id_no;
    private String address;
    private int company;
    private String inoculation_time;

    @Override
    public String toString() {
        return "TbVaccine{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", id_no='" + id_no + '\'' +
                ", address='" + address + '\'' +
                ", company=" + company +
                ", inoculation_time='" + inoculation_time + '\'' +
                '}';
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getId_no() {
        return id_no;
    }

    public void setId_no(String id_no) {
        this.id_no = id_no;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public int getCompany() {
        return company;
    }

    public void setCompany(int company) {
        this.company = company;
    }

    public String getInoculation_time() {
        return inoculation_time;
    }

    public void setInoculation_time(String inoculation_time) {
        this.inoculation_time = inoculation_time;
    }
}

package com.item.dao;

import com.item.model.TbVaccine;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TbVaccineMapper {
    List<TbVaccine> GetInfo();

    List<TbVaccine> SelectByNameAndIdNo(@Param("name") String name,@Param("id_no") String id_no);

    int AddInfo(
            @Param("name") String name,
            @Param("sex") String sex,
            @Param("id_no") String id_no,
            @Param("address") String address,
            @Param("company") int company
    );

    int DeleteById(@Param("id") int id);
}

package com.item.service;

import com.item.model.TbVaccine;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TbVaccineService {
    /**
     * 查询所有
     *
     * @return
     */
    List<TbVaccine> GetInfo();

    /**
     * 模糊查询
     *
     * @return
     */
    List<TbVaccine> SelectByNameAndIdNo(String name, String id_no);

    /**
     * 添加
     * @param name
     * @param sex
     * @param id_no
     * @param address
     * @param company
     * @return
     */
    int AddInfo(
            String name,
            String sex,
            String id_no,
            String address,
            int company
    );

    /**
     * 删除
     * @param id
     * @return
     */
    int DeleteById(int id);
}

package com.item.serviceimpl;

import com.item.dao.TbVaccineMapper;
import com.item.model.TbVaccine;
import com.item.service.TbVaccineService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class TbVaccineServiceImpl implements TbVaccineService {

    @Autowired
    private TbVaccineMapper tbVaccineMapper;
    @Override
    public List<TbVaccine> GetInfo() {
        return tbVaccineMapper.GetInfo();
    }

    @Override
    public List<TbVaccine> SelectByNameAndIdNo(String name, String id_no) {
        return tbVaccineMapper.SelectByNameAndIdNo(name,id_no);
    }

    @Override
    public int AddInfo(String name, String sex, String id_no, String address, int company) {
        return tbVaccineMapper.AddInfo(name,sex,id_no,address,company);
    }

    @Override
    public int DeleteById(int id) {
        return tbVaccineMapper.DeleteById(id);
    }
}

package com.item.controller;

import com.item.model.TbVaccine;
import com.item.service.TbVaccineService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

@Controller
public class TbVaccineController {
    @Autowired
    private TbVaccineService db;

    @GetMapping("/GetInfo")
    public String GetInfo(HttpServletRequest request, Model model){
        List<TbVaccine> list = db.GetInfo();
        model.addAttribute("lists",list);
        return "GetInfo";
    }

    @GetMapping("/SelectByNameAndIdNo")
    public String SelectByNameAndIdNo(HttpServletRequest request, Model model){
        String name = request.getParameter("name");
        String id_no = request.getParameter("id_no");
        List<TbVaccine> list = db.SelectByNameAndIdNo(name==""?null:name,id_no==""?null:id_no);
        model.addAttribute("lists",list);
        return "GetInfo";
    }
    @GetMapping("/AddInfoPage")
    public String AddInfoPage(){
        return "AddInfoPage";
    }
    @PostMapping("/AddInfo")
    public String AddInfo(HttpServletRequest request, Model model){
        String name = request.getParameter("name");
        String sex = request.getParameter("sex");
        String id_no = request.getParameter("id_no");
        String address = request.getParameter("address");
        String company = request.getParameter("company");
        db.AddInfo(name,sex,id_no,address,Integer.parseInt(company));
        return "redirect:/GetInfo";
    }
    @GetMapping("/DeleteById")
    public String DeleteById(HttpServletRequest request, Model model){
        String id = request.getParameter("id");
        db.DeleteById(Integer.parseInt(id));
        return "redirect:/GetInfo";
    }
}

<%@ page import="java.util.List" %>
<%@ page import="com.item.model.TbVaccine" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2022/6/1 0001
  Time: 10:34
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>视图页面</title>
</head>
<body>
<h1>新冠疫苗接种登记系统</h1>
<form action="/SelectByNameAndIdNo">
    姓名：<input type="text" name="name"/>
    身份证：<input type="text" name="id_no"/>
    <input type="submit" value="查询"/>
    <a href="/AddInfoPage">登记</a>
</form>
<% List<TbVaccine> list = (List<TbVaccine>) request.getAttribute("lists");%>
<table style="width: 100%" cellpadding="1" cellspacing="1" border="1">
    <tr>
        <th>序号</th>
        <th>姓名</th>
        <th>性别</th>
        <th>身份证号码</th>
        <th>地址</th>
        <th>疫苗企业</th>
        <th>接种时间</th>
        <th>操作</th>
    </tr>
    <%
        for (TbVaccine t : list) {
    %>
        <tr>
            <td><%=t.getId()%></td>
            <td><%=t.getName()%></td>
            <td><%=t.getSex()%></td>
            <td><%=t.getId_no()%></td>
            <td><%=t.getAddress()%></td>
            <td><%=t.getCompany()%></td>
            <td><%=t.getInoculation_time()%></td>
            <td>
                <a href="/DeleteById?id=<%=t.getId()%>" onclick="return confirm('是否删除此行')">删除</a>
            </td>
        </tr>
    <%
    }
%>
</table>
</body>
</html>

<%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2022/6/1 0001
  Time: 10:36
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>添加页面</title>
</head>
<body>
    <form action="/AddInfo" method="post">
        <p>
            姓名<input type="text" name="name"/>
        </p>
        <p>
            性别<input type="text" name="sex"/>
        </p>
        <p>
            身份证<input type="text" name="id_no"/>
        </p>
        <p>
            地址<input type="text" name="address"/>
        </p>
        <p>
            型号<input type="text" name="company"/>
        </p>
        <p>
            <input type="submit" value="添加"/>
            <input type="reset" value="重置"/>
        </p>
    </form>
</body>
</html>