目录
快速创建
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>