202020205517

目录

快速创建

archetypeCatalog

internal 

mysql


CREATE DATABASE /!32312 IF NOT EXISTS/manage-system /!40100 DEFAULT CHARACTER SET utf8 */;

USE manage-system;

创建表member_info

CREATE TABLE member_info (
  `uid` varchar(40) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `role` varchar(20) DEFAULT NULL,
  `class_id` varchar(20) DEFAULT NULL,
  `number` varchar(20) DEFAULT NULL,
  `gender` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

插入数据

insert  into `member_info`(`uid`,`name`,`role`,`class_id`,`number`,`gender`) values 

('002108e2-9a10-4510-9683-8d8fd1d374ef','张','学员','三班','201901001','男'),

('003108e2-9a10-4510-9683-8d8fd1d374ef','王','学生','五班','201901002','女'),

('2a29fbb7-a5c3-4c32-ada9-728376d3bcd6','wang','学生','三班','201901006','男'),

('71bcdeec-493b-4f14-a302-f5a4ecc419e7','小红','体育委员','一班','2019010010','女'),

('87393f0a-e3a7-4b1f-99f2-c241cfaf4164','lily','学生','一班','201901009','女'),

('b574cbe7-eabc-4343-b510-795ce34fcef2','zhou','成员','一班','201901003','男'),

('d9ba8cc5-266f-4c93-9067-a123c2724098','吴','组长','三班','2019010011','男');


创建表user

CREATE TABLE `user` (
  `uid` varchar(50) NOT NULL,
  `username` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

pom.xml

<?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>

 java.controller.WebController.java

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;
    }

}

java.dao.MemberDao.interface

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);

}

java.entity.Member.java

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;
    }

}

java.service.impl.ServiceImpl.java

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);
    }

}

 java.service.MemberSercice.interface

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);

}

resources.dao.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>

recources.applicationContext-dao.xml(spring)

<?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>

resources.jdbc.properties

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

resources.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

resources.springMVC.xml(spring)

<?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>

webapp.META-INF.MANIFEST.MF

Manifest-Version: 1.0
Class-Path: 

webapp.pages.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>

webapp.pages.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>

webapp.pages.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>
    <style>
        * {
            margin: 0;
            padding: 0;
        }

        .box {
            text-align: center;
        }

        input {
            width: 70px;
        }

        .box .top {
            font-size: 30px;
            margin-bottom: 50px;
        }

        .btn {
            width: 50px;
            border-radius: 10px;
            background-color: blue;
            color: white;
        }

        .bottom1 {
            font-size: 30px;
            margin-bottom: 50px;
        }

        li {
            width: 70px;
            width: 70px;
            display: inline-block;
            list-style: none;
            border: 1px solid black;
        }

        ul {
            display: flex;
            justify-content: center;
        }

        .firstLi li {
            background-color: aqua;
        }

        a{
            color: red;
        }
    </style>

</head>
</head>

<body>
<div class="box">
    <div class="top">
        图书
    </div>
    <form class="centen">
        <span>图书类别:</span><input class="name" type="text" name="" id="">
        <span>图书名:</span><input class="year" type="text">


        <span>描述:</span><input class="money" type="text">

        <button class="btn">录入</button>
    </form>
    <div class="bottom1">

    </div>
    <div class="bottom2">
        <ul class="firstLi">
            <li>序号</li>
            <li>图书类别</li>
            <li>图书名</li>
            <li>描述</li>
            <li>操作</li>
            <a href=""></a>
        </ul>
        <div class="bottom3">

        </div>
    </div>
</div>
<script>
    const bottom2 = document.querySelector(`.bottom2`)
    const year = document.querySelector(`.year`)
    const name = document.querySelector(`.name`)
    const money = document.querySelector(`.money`)
    const btn = document.querySelector(`.btn`)
    const btn1=document.querySelector(`.centen`)
    let num = 1
    // const students = []
    let b3 = document.querySelector(`.bottom3`)
    let students = JSON.parse(localStorage.getItem(`data`)) || []   //将本地的数据给students

    function fa(e) {
        if(name.value!=0&&year.value!=0&&money.value!=0&&e.target.tagName==`BUTTON`){
            console.log(e); //判断是否要添加的是空值  判断按下的是否是button
            let student = {
                name: name.value,
                year: year.value,
                money: money.value,
            }       //将输入的值保存到一个对象里面
            students.push(student) //将这个对象添加到对象数组中
            localStorage.setItem(`data`, JSON.stringify(students))//添加到本地数据中
            daying()  //打印当前的数据
            this.reset() //重置表单 清除表单里刚刚填写的内容
        }
    }

    function daying(){ //打印出数据
        let newArr = students.map(function (ele, num) { //将students数组中每个对象取出并且遍历 将新数组返回
            return `
            <ul>
            <li>${num+1}</li>
            <li>${ele.name}</li>
            <li>${ele.year}</li>

            <li>${ele.money}</li>

            <li><a data-id="${num}">删除</a></li>
            </ul>
        `
        })
        // console.log(`-------------------------------------`);
        // // console.log(arr)
        // console.log(newArr)


        b3.innerHTML = newArr.join(``)      //将数组中的对象全部取出 并且连接成一个字符串
    }
    // }


    daying()        //刷新网页的时候打印本地的数据
    btn1.addEventListener(`click`, fa)  //给按钮添加点击事件
    console.log(students);


    //删除
    b3.addEventListener(`click`,function(e){
        if(e.target.tagName==`A`){
            //判断点击的是否是删除键位 a标签
            console.log(e.target.dataset.id)
            //获取点击的a标签的自定义属性   这个自定义属性代表他在数组中是第几个
            students.splice(e.target.dataset.id,1)
            //在对象中删除这个对象
            daying()
            //打印删除了对象后这个数组
            localStorage.setItem('data', JSON.stringify(students))
            //将新的数组转换为字符串传给本地数据
        }
    })


</script>
</body>
</html>

webapp.WEB-INF.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>

webapp.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>
<form action="/search">
    <h5>根据编号查询<input type="text" name="number"><input type="submit" value="查询"></h5>
</form>

</body>
</html>

评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值