java web 图书管理系统_基于SPRINGBOOT微信小程序的图书管理系统的设计与实现

好程序设计擅长JAVA(SSM,SSH,SPRINGBOOT)、PYTHON(DJANGO/FLASK)、THINKPHP、C#、安卓、微信小程序、MYSQL、SQLSERVER等，欢迎咨询

       

今天将为大家分析一个基于微信小程序的图书管理系统(图书管理系统，是一个由人、计算机等组成的能进行管理信息的收集、传递、加工、保存、维护和使用的系统，利用信息控制企业的行为，帮助企业实现其规划目标。)，基于微信小程序的图书管理系统项目使用框架为SSM(MYECLIPSE)，选用开发工具为PHPSTORM。基于微信小程序的图书管理系统为一个 后台项目。

为了完成基于微信小程序的图书管理系统，我们首先需要对该系统进行需求分析。一个基于微信小程序的图书管理系统应包含用户角色有管理员、学生。为了能让用户顺利登陆系统完成相关操作，需要为每种登陆角色设置账户和密码字段。

总结得出基于微信小程序的图书管理系统项目所有数据为：管理员(id)、学生(xuesheng)、图书(tushu)、公告(gonggao)

基于微信小程序的图书管理系统之管理员表

字段名 | 类型 | 属性 | 描述  

id | int(11) | PRIMARY KEY | 管理员id

username | varchar(255) |  | 账号

password | varchar(255) |  | 密码

基于微信小程序的图书管理系统之学生表

字段名 | 类型 | 属性 | 描述  

id | int(11) | PRIMARY KEY | 学生id

mingzi | varchar(255) |  | 名字

username | varchar(255) |  | 账号

password | varchar(255) |  | 密码

xinyong | varchar(255) |  | 信用

zhuangtai | varchar(255) |  | 状态

基于微信小程序的图书管理系统之图书表

字段名 | 类型 | 属性 | 描述  

id | int(11) | PRIMARY KEY | 图书id

mingcheng | varchar(255) |  | 名称

shuliang | varchar(255) |  | 数量

shuoming | varchar(255) |  | 说明

shangjiashijian | varchar(255) |  | 上架时间

基于微信小程序的图书管理系统之公告表

字段名 | 类型 | 属性 | 描述  

id | int(11) | PRIMARY KEY | 公告id

biaoti | varchar(255) |  | 标题

neirong | varchar(255) |  | 内容

sql建表语句如下：

[cc]SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- ----------------------------

-- Table structure for ggtsglxt

-- ----------------------------

DROP TABLE IF EXISTS `t_id`;

CREATE TABLE `t_id` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',`username` varchar(255) DEFAULT NULL COMMENT '账号',`password` varchar(255) DEFAULT NULL COMMENT '密码',PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='管理员';

-- ----------------------------

DROP TABLE IF EXISTS `t_xuesheng`;

CREATE TABLE `t_xuesheng` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生id',`mingzi` varchar(255) DEFAULT NULL COMMENT '名字',`username` varchar(255) DEFAULT NULL COMMENT '账号',`password` varchar(255) DEFAULT NULL COMMENT '密码',`xinyong` varchar(255) DEFAULT NULL COMMENT '信用',`zhuangtai` varchar(255) DEFAULT NULL COMMENT '状态',PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='学生';

-- ----------------------------

DROP TABLE IF EXISTS `t_tushu`;

CREATE TABLE `t_tushu` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图书id',`mingcheng` varchar(255) DEFAULT NULL COMMENT '名称',`shuliang` varchar(255) DEFAULT NULL COMMENT '数量',`shuoming` varchar(500) DEFAULT NULL COMMENT '说明',`shangjiashijian` varchar(255) DEFAULT NULL COMMENT '上架时间',PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='图书';

-- ----------------------------

DROP TABLE IF EXISTS `t_gonggao`;

CREATE TABLE `t_gonggao` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告id',`biaoti` varchar(255) DEFAULT NULL COMMENT '标题',`neirong` varchar(500) DEFAULT NULL COMMENT '内容',PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='公告';

[/cc]

公告控制层:

[cc]package org.mypro.front;

import java.io.File;

import java.io.IOException;

import java.math.BigDecimal;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Calendar;

import java.util.Collections;

import java.util.Date;

import java.util.List;

import javax.jms.Session;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import org.apache.commons.lang3.StringUtils;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.mypro.service.GonggaoServiceImp;

import org.mypro.entity.Gonggao;

import org.mypro.entity.GonggaoExample;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.multipart.MultipartFile;

@Controller

@RequestMapping(value = "/")

public class GonggaoController {

private static final Log logger = LogFactory.getLog(GonggaoController.class);

@Autowired

private GonggaoServiceImp gonggaoservice;

@RequestMapping(value = "addgonggao")

    public String addgonggao(HttpServletRequest request, HttpServletResponse response,HttpSession session,String backurl) {

    logger.debug("GonggaoController.addgonggao ......");

       gonggaoservice.addgonggao(request,session);    

       if(backurl !=  && backurl.indexOf("addgonggao.action") == -1){

return "forward:/" + backurl;}

    return "addgonggao";

    }

@RequestMapping(value = "addgonggaoact")

public String addgonggaoact(HttpServletRequest request,HttpSession session, HttpServletResponse response,Gonggao gonggao,String backurl) throws IOException {

logger.debug("GonggaoController.addgonggaoact ......");

       gonggaoservice.addgonggaoact(request,session,gonggao);

       if(backurl !=  && backurl.indexOf("addgonggaoact.action") == -1){

return "forward:/" + backurl;}

return "forward:/gonggaomanage.action";

}

@RequestMapping(value = "gonggaomanage")

public String gonggaomanage(HttpServletRequest request,HttpSession session, HttpServletResponse response,String backurl) {

logger.debug("GonggaoController.gonggaomanage ......");

       gonggaoservice.gonggaomanage(request,session);

       if(backurl !=  && backurl.indexOf("gonggaomanage.action") == -1){

return "forward:/" + backurl;}

return "gonggaomanage";

}

@RequestMapping(value = "gonggaoview")

public String gonggaoview(HttpServletRequest request,HttpSession session, HttpServletResponse response,String backurl) {

logger.debug("GonggaoController.gonggaoview ......");

       gonggaoservice.gonggaoview(request,session);

       if(backurl !=  && backurl.indexOf("gonggaoview.action") == -1){

return "forward:/" + backurl;}

return "gonggaoview";

}

@RequestMapping(value = "updategonggao")

public String updategonggao(HttpServletRequest request, HttpServletResponse response,HttpSession session,int id,String backurl){

logger.debug("GonggaoController.updategonggao ......");

       gonggaoservice.updategonggao(request,session,id);

       if(backurl !=  && backurl.indexOf("updategonggao.action") == -1){

return "forward:/" + backurl;}

return "updategonggao";

}

@RequestMapping(value = "updategonggaoact")

public String updategonggaoact(HttpServletRequest request, HttpServletResponse response,Gonggao gonggao,HttpSession session,String backurl) throws IOException {

logger.debug("GonggaoController.updategonggaoact ......");

       gonggaoservice.updategonggaoact(request,gonggao,session);

       if(backurl !=  && backurl.indexOf("updategonggaoact.action") == -1){

return "forward:/" + backurl;}

return "forward:/gonggaomanage.action";

}

@RequestMapping(value = "deletegonggao")

public String deletegonggao(HttpServletRequest request, HttpServletResponse response,HttpSession session,int id,String backurl){

logger.debug("GonggaoController.deletegonggao ......");

       gonggaoservice.deletegonggao(request,session,id);

       if(backurl !=  && backurl.indexOf("deletegonggao.action") == -1){

return "forward:/" + backurl;}

return "forward:/gonggaomanage.action";

}

@RequestMapping(value = "searchgonggao")

public String searchgonggao(HttpServletRequest request, HttpServletResponse response,HttpSession session,String search,String backurl) {

logger.debug("GonggaoController.searchgonggao ......");

       gonggaoservice.searchgonggao(request,session,search);

       if(backurl !=  && backurl.indexOf("searchgonggao.action") == -1){

return "forward:/" + backurl;}

return "searchgonggao";

}

@RequestMapping(value = "gonggaodetails")

public String gonggaodetails(HttpServletRequest request,HttpSession session, HttpServletResponse response,int id,String backurl) {

logger.debug("GonggaoController.gonggaodetails ......");

       gonggaoservice.gonggaodetails(request,session,id);

       if(backurl !=  && backurl.indexOf("gonggaodetails.action") == -1){

return "forward:/" + backurl;}

return "gonggaodetails";

}

}[/cc]

如需源码，请联系站长

好程序设计，为你提供想要的效果

为你量身定制的程序设计

关于程序设计，我们将尽心尽力为你完成

十年程序经验，尽在好程序设计