GLK项目1（包含源代码）

qq_53254862

已于 2023-06-11 17:03:52 修改

阅读量158

点赞数

文章标签： java mybatis maven

于 2023-06-10 17:10:08 首次发布

本文链接：https://blog.csdn.net/qq_53254862/article/details/131143733

版权

项目目录

pom文件：

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.cdutetc</groupId>
    <artifactId>student</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.6.12</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.29</version>
        </dependency>
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.6</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.6.6</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-expression</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jcl</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
    </dependencies>
</project>

WebController：

package controller;


import entity.Member;
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 service.MemberService;

import java.util.ArrayList;
import java.util.List;

@Controller
public class WebController {
    @Autowired
    private MemberService memberService;

    @RequestMapping("/toAdd")
    public String toAdd() {
        return "add";
    }

    @RequestMapping("/toEdit")
    public ModelAndView toEdit(String uid) {
        ModelAndView modelAndView = new ModelAndView();
        Member member = memberService.searchByUid(uid);
        modelAndView.addObject("customer", member);
        modelAndView.setViewName("edit");
        return modelAndView;
    }

    @RequestMapping("/listAll")
    public ModelAndView list() {
        ModelAndView modelAndView = new ModelAndView();
        List<Member> list = memberService.list();
        modelAndView.addObject("beanList", list);
        modelAndView.setViewName("list");
        System.out.println(list.size());
        return modelAndView;
    }


    @RequestMapping("/add")
    public String add(Member member) {
        memberService.add(member);
        return "redirect:/listAll";
    }


    @RequestMapping("/edit")
    public String edit(Member member) {

        memberService.update(member);
        return "redirect:/listAll";
    }


    @RequestMapping("/delete")
    public String delete(String uid) {
        memberService.delete(uid);
        return "redirect:/listAll";
    }

    @RequestMapping("/search")
    public ModelAndView search(String number) {
        Member member = memberService.searchByNumber(number);
        ModelAndView modelAndView = new ModelAndView();
        ArrayList<Member> list = new ArrayList<>();
        list.add(member);
        modelAndView.addObject("beanList", list);
        modelAndView.setViewName("list");
        System.out.println(list.size());
        return modelAndView;
    }

}

MenberDao

package dao;


import entity.Member;

import java.util.List;

public interface MemberDao {

    List<Member> list();

    void add(Member member);

    void delete(String uid);

    void update(Member member);

    Member searchByUid(String uid);

    Member searchByNumber(String number);

}

Member：

package entity;

public class Member {

    private String uid;

    private String name;

    private String gender;

    private String role;

    private String classId;

    private String number;

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getUid() {
        return uid;
    }

    public void setUid(String uid) {
        this.uid = uid;
    }

    public String getName() {
        return name;
    }

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

    public String getRole() {
        return role;
    }

    public void setRole(String role) {
        this.role = role;
    }

    public String getClassId() {
        return classId;
    }

    public void setClassId(String classId) {
        this.classId = classId;
    }

    public String getNumber() {
        return number;
    }

    public void setNumber(String number) {
        this.number = number;
    }

}

ServiceImpl

package service.impl;


import dao.MemberDao;
import entity.Member;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import service.MemberService;

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

@Service
public class ServiceImpl implements MemberService {
    @Autowired
    private MemberDao memberDao;

    @Override
    public List<Member> list() {
        return memberDao.list();
    }

    @Override
    public void add(Member member) {
        member.setUid(UUID.randomUUID().toString());
        memberDao.add(member);
    }

    @Override
    public void delete(String uid) {
        memberDao.delete(uid);
    }

    @Override
    public void update(Member member) {
        memberDao.update(member);
    }

    @Override
    public Member searchByUid(String uid) {
        return memberDao.searchByUid(uid);
    }

    @Override
    public Member searchByNumber(String number) {
        return memberDao.searchByNumber(number);
    }

}

MemberService：

package service;


import entity.Member;

import java.util.List;

public interface MemberService {
    List<Member> list();

    void add(Member member);

    void delete(String uid);

    void update(Member member);

    Member searchByUid(String uid);

    Member searchByNumber(String number);

}

MemberDao.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="dao.MemberDao">
    <resultMap id="MemberMapper" type="entity.Member">
        <result property="uid" column="uid"/>
        <result property="name" column="name"/>
        <result property="gender" column="gender"/>
        <result property="role" column="role"/>
        <result property="classId" column="class_id"/>
        <result property="number" column="number"/>
    </resultMap>
    <select id="list" resultMap="MemberMapper">
        select *
        from `manage-system`.member_info;
    </select>
    <select id="searchByNumber" resultMap="MemberMapper">
        select *
        from `manage-system`.member_info
        where number = #{number}
    </select>
    <select id="searchByUid" resultMap="MemberMapper">
        select *
        from `manage-system`.member_info
        where uid = #{uid}
    </select>
    <insert id="add">
        insert into `manage-system`.member_info (uid, gender, name, role, class_id, number)
        values (#{uid}, #{gender}, #{name}, #{role}, #{classId}, #{number})
    </insert>
    <update id="update"> update `manage-system`.member_info
                         set name=#{name},
                             role=#{role},
                             class_id=#{classId},
                             number=#{number},
                             gender=#{gender}
                         where uid = #{uid}
    </update>
    <delete id="delete"> delete
                         from `manage-system`.member_info
                         where uid = #{uid};
    </delete>
</mapper>

applicationContext-dao.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd">
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!-- spring创造工厂，spring获得dao下接口的代理对象 -->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="dao"/>
    </bean>
</beans>

jdbc.properties:

jdbc.username=root
jdbc.password=819424
jdbc.url=jdbc:mysql://localhost:3306/manage-system?useUnicode=true&characterEncoding=UTF-8
jdbc.driverClassName=com.mysql.jdbc.Driver

log4j.properties:

log4j.rootLogger=debug, stdout, logfile

log4j.category.org.springframework=info
#log4j.category.org.apache=INFO

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

log4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=d:\\log\\myweb.log
log4j.appender.logfile.MaxFileSize=1KB
log4j.appender.logfile.MaxBackupIndex=5
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n

springMVC.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation=" http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <mvc:annotation-driven/>
    <mvc:default-servlet-handler/>
    <context:component-scan base-package="controller,service"/>
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

MANIFEST.MF:

Manifest-Version: 1.0
Class-Path:

add.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri ="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
    <title>添加一条成员信息</title>
</head>
<body>
    <h3 align="center">添加成员</h3>
    <form action="add.jsp" method="post">
        <table border="0" align="center" width="40%" style="margin-left: 100px">
        <tr>
            <td width="100px">名字</td>
            <td width="40%">
                <input type="text" name="name">
            </td>
        </tr>
        <tr>
            <td>性别</td>
            <td>
                <input type="radio" name="gender" value="男" id="male">
                <label for="male">男</label>
                <input type="radio" name="gender" value="女" id="female">
                <label for="female">女</label>
            </td>
        </tr>
        <tr>
            <td>身份</td>
            <td>
                <input type="text" name="role" id="role"/>
            </td>
        </tr>
        <tr>
            <td>班级</td>
            <td>
                <input type="text" name="classId" id="email"/>
            </td>
        </tr>
        <tr>
            <td>学号</td>
            <td>
                <input type="text" name="number" id="number"/>
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="submit" name="submit" value="提交"/>
                <input type="reset" name="reset" value="重置">
                <input type="button" value="后退" onclick="history.go(-1)"/>
            </td>
        </tr>
        </table>
    </form>
</body>
</html>

edit.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri ="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
    <title>修改一条成员信息</title>
</head>
<body>
<h3 align="center">修改成员</h3>
<form action="/edit" method="post">
    <table border="0" align="center" width="40%" style="margin-left: 100px">
        <tr>
            <td width="100px">名字</td>
            <td width="40%">
                <label>
                    <input type="text" name="name" value="${customer.name}">
                </label>
            </td>
        </tr>
        <tr>
            <td>性别</td>
            <td>
                <input type="radio" name="gender" value="男" id="male">
                <label for="male">男</label>
                <input type="radio" name="gender" value="女" id="female">
                <label for="female">女</label>
            </td>
        </tr>
        <tr>
            <td>身份</td>
            <td>
                <label for="role"></label><input type="text" name="role" id="role" value="${customer.role}" />
            </td>
        </tr>
        <tr>
            <td>班级</td>
            <td>
                <label>
                    <input type="text" name="classId" value="${customer.classId}"/>
                </label>
            </td>
        </tr>
        <tr>
            <td>学号</td>
            <td>
                <label for="number"></label><input type="text" name="number" id="number" value="${customer.number}"/>
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="submit" name="submit" value="提交"/>
                <input type="reset" name="reset" value="重置">
                <input type="button" value="后退"  onclick="history.go(-1)"/>
            </td>
        </tr>
        <label>
            <input type="text" name="uid" hidden="hidden" value="${customer.uid}">
        </label>
    </table>

</form>
</body>
</html>

list.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>人员列表</title>

</head>
<body>
<h3 align="center">成员列表</h3>
<h4 align="center"><a href="add.jsp">添加成员</a></h4>
<form action="/search">
    <h5 align="center">根据学号查询<label>
        <input type="text" name="number">
    </label><input type="submit" value="查询"></h5>
</form>
<table border="1" width="70%" align="center">
    <tr>
        <th>姓名</th>
        <th>性别</th>
        <th>班级</th>
        <th>学号</th>
        <th>角色</th>
        <th>操作</th>
    </tr>
    <c:forEach items="${beanList}" var="cstm">
        <tr>
            <td>${cstm.name}</td>
            <td>${cstm.gender}</td>
            <td>${cstm.classId}</td>
            <td>${cstm.number}</td>
            <td>${cstm.role}</td>
            <td>
                <a href="toEdit?uid=${cstm.uid}">编辑</a>
                <a href="delete?uid=${cstm.uid}">删除</a>
            </td>
        </tr>
    </c:forEach>
</table>
<br/>

<%--<center>--%>
<%--第${pb.pc}页/共${pb.tp}页--%>
<%--<a href="${pb.url}&pc=1">首页</a>--%>
<%--<c:if test="${pb.pc}>1">--%>
<%--<a href="${pb.url}&pc=${pb.pc-1}">上一页</a>--%>
<%--</c:if>--%>

<%--<c:choose>--%>
<%--&lt;%&ndash;设置显示的起始和终止页&ndash;%&gt;--%>
<%--<c:when test="${pb.tp<=10}">--%>
<%--<c:set var="begin" value="1"/>--%>
<%--<c:set var = "end" value = "${pb.tp}"/>--%>
<%--</c:when>--%>
<%--<c:otherwise>--%>
<%--<c:set var = "begin" value="${pb.pc-5}"/>--%>
<%--<c:set var = "end" value="${pb.pc+4}"/>--%>
<%--&lt;%&ndash;头溢出&ndash;%&gt;--%>
<%--<c:if test="${begin<1}">--%>
<%--<c:set var = "begin" value = "1"/>--%>
<%--<c:set var = "end" value = "10" />--%>
<%--</c:if>--%>
<%--&lt;%&ndash;尾溢出&ndash;%&gt;--%>
<%--<c:if test = "${end > pb.tp}">--%>
<%--<c:set var = "begin" value = "${pb.tp-9}"/>--%>
<%--<c:set var = "end" value = "${pb.tp}"/>--%>
<%--</c:if>--%>
<%--</c:otherwise>--%>
<%--</c:choose>--%>

<%--&lt;%&ndash;循环遍历页码表&ndash;%&gt;--%>
<%--<c:forEach var = "i" begin = "${begin}" end = "${end}">--%>
<%--<c:choose>--%>
<%--<c:when test= "${i eq pb.pc}">--%>
<%--[${i}]--%>
<%--</c:when>--%>
<%--<c:otherwise>--%>
<%--<a href="${pb.url}&pc=${i}">${i}</a>--%>
<%--</c:otherwise>--%>
<%--</c:choose>--%>
<%--</c:forEach>--%>

<%--<c:if test="${pb.pc<pb.tp}">--%>
<%--<a href="${pb.url}&pc=${pb.pc+1}">下一页</a>--%>
<%--</c:if>--%>
<%--<a href="${pb.url}&pc=${pb.tp}">尾页</a>--%>
<%--</center>--%>
</body>
</html>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
    <servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springMVC.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
    <!-- 配置转码过滤器 -->
    <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <!-- 整合mybatis -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext-dao.xml</param-value>
    </context-param>
</web-app>

index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <base target="main"/>
    <title>学生信息管理系统</title>
</head>
<body style="text-align: center">
<h1>学生信息管理系统</h1>
<a href="././pages/list.jsp">查询所有成员</a>
<a href="././pages/add.jsp">添加成员</a>
<form action="/search">
    <h5>根据学号查询<input type="text" name="number"><input type="submit" value="查询"></h5>
</form>

</body>
</html>