基于ssm+layui教材管理系统源码和论文

最新推荐文章于 2024-07-24 18:20:33 发布

程序猿毕业分享网

最新推荐文章于 2024-07-24 18:20:33 发布

阅读量320

点赞数

分类专栏： java毕业设计文章标签： layui ssm jsp

本文链接：https://blog.csdn.net/weixin_46437112/article/details/128068323

版权

java毕业设计专栏收录该内容

69 篇文章 40 订阅

订阅专栏

计算机技术和网络信息技术的发展和普及，据调查，到目前为止，我国还有许多高校，甚至一些重点院校的教材管理工作仍为手工管理方式，这种管理方式不但与现实高校教材管理业务的需求不相适应，而且也与高校信息化建设的发展趋势不相适应。因此，高校教材管理人员目前迫切需要一套方便、高效的计算机化的管理信息系统来代替他们繁重、低效的传统手工管理方式，并最终实现教材管理的全面自动化。

项目具体功能请看视频：

基于ssm+layui教材管理系统

pom.xml代码：

<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/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.dev.books</groupId>
    <artifactId>Books</artifactId>
    <packaging>war</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>ssm Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <properties>
        <!-- 设置项目编码编码 -->
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    </properties>

    <dependencies>
        <!-- java ee -->
        <dependency>
            <groupId>javax</groupId>
            <artifactId>javaee-api</artifactId>
            <version>7.0</version>
        </dependency>

        <!-- 单元测试 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

        <!-- 实现slf4j接口并整合 -->
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.2</version>
        </dependency>

        <!-- JSON -->
        <dependency>
            <groupId>org.codehaus.jackson</groupId>
            <artifactId>jackson-mapper-asl</artifactId>
            <version>1.9.13</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-core</artifactId>
            <version>2.8.7</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.8.7</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.54</version>
        </dependency>

        <!-- 数据库 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.12</version>
        </dependency>

        <!-- 数据库连接池 -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>

        <!-- MyBatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>

        <!-- mybatis/spring整合包 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>3.4.2</version>
        </dependency>

        <!-- Spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>4.1.3.RELEASE</version>
        </dependency>

        <!-- JSP相关 -->
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
            <scope>provided</scope>
        </dependency>
        <!--logback-->
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.1.2</version>
        </dependency>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-core</artifactId>
            <version>1.1.2</version>
        </dependency>
        <dependency>
            <groupId>org.logback-extensions</groupId>
            <artifactId>logback-ext-spring</artifactId>
            <version>0.1.1</version>
        </dependency>

        <!--导入和导出excel相关-->
        <!--poi-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.16</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.14</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <exclusions>
                <exclusion>
                    <groupId>xerces</groupId>
                    <artifactId>xercesImpl</artifactId>
                </exclusion>
            </exclusions>
            <version>3.14</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-scratchpad</artifactId>
            <version>3.14</version>
            <optional>true</optional>
        </dependency>

        <!--easypoi-->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.2.0</version>
        </dependency>

        <!--log4j依赖-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.25</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.25</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-simple</artifactId>
            <version>1.7.25</version>
            <scope>test</scope>
        </dependency>

        <!--文件上传-->
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.5</version>
        </dependency>
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.2</version>
        </dependency>

        <!--swagger -->
        <dependency>
            <groupId>com.mangofactory</groupId>
            <artifactId>swagger-springmvc</artifactId>
            <version>1.0.2</version>
        </dependency>
        <dependency>
            <groupId>com.mangofactory</groupId>
            <artifactId>swagger-models</artifactId>
            <version>1.0.2</version>
        </dependency>
        <dependency>
            <groupId>com.wordnik</groupId>
            <artifactId>swagger-annotations</artifactId>
            <version>1.5.3-M1</version>
        </dependency>

        <!-- WebSocket配置开始-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-websocket</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-messaging</artifactId>
            <version>4.3.5.RELEASE</version>
        </dependency>
        <!-- WebSocket配置结束-->
    </dependencies>

    <build>
        <finalName>Books</finalName>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <!-- 设置JDK版本 -->
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

package com.dev.books.controller;

import com.alibaba.fastjson.JSON;
import com.dev.books.pojo.Book;
import com.dev.books.pojo.StoreIn;
import com.dev.books.pojo.StoreOut;
import com.dev.books.pojo.User;
import com.dev.books.service.BookService;
import com.dev.books.service.StoreInService;
import com.dev.books.service.StoreOutService;
import com.dev.books.service.UserService;
import com.dev.books.util.Layui;
import com.dev.books.util.RandNum;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.util.*;

@Controller
public class StoreOutController {
    @Autowired
    StoreOutService storeOutService;

    @Autowired
    StoreInService storeInService;

    @Autowired
    BookService bookService;

    @Autowired
    UserService userService;

    @ResponseBody
    @RequestMapping(value = "/inserTeachertReceiveBook")
    public String addReceiveBook(@RequestBody Map dataMap, HttpServletRequest request) {
        System.out.println(dataMap);
        String book_id = dataMap.get("book_id").toString();
        String book_out = dataMap.get("book_out").toString();
        String storeInId = dataMap.get("id").toString();
        String id = RandNum.getGUID();
        /*
        要先登录，才有getId
         */
        HttpSession session = request.getSession(true);//新建session对象
        User user = (User) session.getAttribute("user");  //将对应数据存入session中
        StoreOut storeOut = new StoreOut(id,book_id,user.getId(),Integer.parseInt(book_out));
        System.out.println("storeOut:"+storeOut);
        /*
        使用fastjson把类转换成json,有两个好处，
        1.需要map类型传参数
        2.fastjson能够格式化时间类型
         */
        String storeInJson = JSON.toJSONString(storeOut);
        Map map = JSON.parseObject(storeInJson, Map.class);
        System.out.println(map);
        List<StoreOut> storeOuts = storeOutService.findStooByUidAndBid(user.getId(),book_id);
        if(storeOuts.size()>0){
            return "cannot receve";
        }else {
            int n = storeOutService.addReceiveBook(map);
            if (n > 0) {
                StoreIn storeIn = storeInService.findStoreInById(storeInId);
                int init_book_count = storeIn.getBook_count();//原来库存
                int current_book_count = init_book_count-Integer.parseInt(book_out);//现在库存=原来库存-已经领走库存
                storeInService.updateBookCount(current_book_count,storeInId);
                return "success";
            }
            return "failure";
        }
    }

    @ResponseBody
    @RequestMapping(value = "/getStoreOutByUserId",produces="application/json;charset=UTF-8")
    public String getStoreOutByUserId(@RequestParam("limit") String limit, @RequestParam("page") String page, HttpServletRequest request) {
        List<StoreOut> list = new ArrayList<>();
        String uid="";
        HttpSession session = request.getSession(true);//新建session对象
        User user = (User) session.getAttribute("user");  //将对应数据存入session中
        User u = null;
        if(user.getIdentification().equals("学生")){
            u = userService.findTeacherByUserId(user.getId());
            uid = u.getT_id();
        }else if(user.getIdentification().equals("教师")){
            uid = user.getId();
        }
        List<StoreOut> storeOuts = storeOutService.findStoreOutByUserId(uid);
        for(int i=0;i<storeOuts.size();i++){
            StoreOut s = storeOuts.get(i);
            int total_add = s.getBook_out();
            int total_sub = s.getBook_back();
            int total = total_add - total_sub;
            s.setTotal(total);
            list.add(s);
        }
        Layui l = Layui.data(list.size(), list);
        return JSON.toJSONString(l);
    }

    @ResponseBody
    @RequestMapping(value = "/getStuStoreOutByUserId",produces="application/json;charset=UTF-8")
    public String getStuStoreOutByUserId(@RequestParam("limit") String limit, @RequestParam("page") String page, HttpServletRequest request) {
        List<StoreOut> list = new ArrayList<>();
        HttpSession session = request.getSession(true);//新建session对象
        User user = (User) session.getAttribute("user");  //将对应数据存入session中
        List<StoreOut> storeOuts = storeOutService.findStoreOutByUserId(user.getId());
        for(int i=0;i<storeOuts.size();i++){
            StoreOut s = storeOuts.get(i);
            int total_add = s.getBook_out();
            int total_sub = s.getBook_back();
            int total = total_add - total_sub;
            s.setTotal(total);
            list.add(s);
        }
        Layui l = Layui.data(list.size(), list);
        System.out.println(list);
        return JSON.toJSONString(l);
    }

    @ResponseBody
    @RequestMapping(value = "/inserStutReceiveBook")
    public String inserStutReceiveBook(@RequestBody Map dataMap, HttpServletRequest request) {
        System.out.println(dataMap);
        //String book_id = dataMap.get("book_id").toString();
        String book_out = dataMap.get("book_out").toString();
        String book_id = dataMap.get("id").toString();
        String id = RandNum.getGUID();
        /*
        要先登录，才有getId
         */
        HttpSession session = request.getSession(true);//新建session对象
        User user = (User) session.getAttribute("user");  //将对应数据存入session中
        StoreOut storeOut = new StoreOut(id,book_id,user.getId(),Integer.parseInt(book_out));
        System.out.println("storeOut:"+storeOut);
        User u = userService.findTeacherByUserId(user.getId());
        /*
        使用fastjson把类转换成json,有两个好处，
        1.需要map类型传参数
        2.fastjson能够格式化时间类型
         */
        String storeInJson = JSON.toJSONString(storeOut);
        Map map = JSON.parseObject(storeInJson, Map.class);
        System.out.println(map);
        System.out.println("book_id:"+book_id);
        List<StoreOut> sto = storeOutService.findStooByUidAndBid(user.getId(),book_id);
        if(sto.size()>0){
            return "cannot receve";
        }else{
            int n = storeOutService.addReceiveBook(map);
            if (n > 0) {
                String tid = u.getT_id();
                List<StoreOut> storeOuts = storeOutService.findStoreOutByUserId(tid);//查询教师id号
                //StoreIn storeIn = storeInService.findStoreInById(storeInId);
                int init_book_count = storeOuts.get(0).getBook_out();//原来教师库存
                int current_book_count = init_book_count-Integer.parseInt(book_out);//现在库存=原来库存-已经领走库存
                storeOutService.updateTeacherBookOut(current_book_count,book_id,tid);
                //storeInService.updateBookCount(current_book_count,storeInId);
                return "success";
            }
            return "failure";
        }

    }

    @ResponseBody
    @RequestMapping(value = "/delete_updateTeachertStore")
    public String delete_updateTeachertStore(@RequestBody Map dataMap, HttpServletRequest request) {
        System.out.println(dataMap);
        System.out.println("----教师退书-------");
        String book_id = dataMap.get("book_id").toString();
        String book_num = dataMap.get("book_num").toString();
        String isAll = dataMap.get("isAll").toString();
        HttpSession session = request.getSession(true);//新建session对象
        User user = (User) session.getAttribute("user");  //将对应数据存入session中
        if(isAll.equals("yes")){//退还该书的全部
            List<StoreOut> stoos = storeOutService.findStooByUidAndBid(user.getId(),book_id);
            int current_teach_book = stoos.get(0).getBook_out();
            int n = storeOutService.deleteStoreOutByUidandBid(book_id,user.getId());
            if(n>0){
                List<StoreIn> storeIns = storeInService.findStoreInByBookId(book_id);
                int current_book_count = storeIns.get(0).getBook_count() + current_teach_book;
                storeInService.updateBookCountByBookId(current_book_count,book_id);
                return "success";
            }else {
                return "failure";
            }
        }else{
            //退还书的一部分
            List<StoreOut> storeOuts = storeOutService.findStooByUidAndBid(user.getId(),book_id);
            if(storeOuts.size()>0&&storeOuts.get(0).getBook_back()!=0){
                return "cannot back";
            }else{
                int n = storeOutService.updateTeacherBookBack(Integer.parseInt(book_num),book_id,user.getId());
                if(n>0){
                    List<StoreIn> storeIns = storeInService.findStoreInByBookId(book_id);
                    int current_book_count = storeIns.get(0).getBook_count() + Integer.parseInt(book_num);
                    storeInService.updateBookCountByBookId(current_book_count,book_id);
                    return "success";
                }else {
                    return "failure";
                }
            }
        }
    }

    /**
     * 教师和学生退书还不一样，教师退书是直接退到书库，学生是退书退到教师手中。
     * @param dataMap
     * @param request
     * @return
     */
    @ResponseBody
    @RequestMapping(value = "/delete_updateStutStore")
    public String delete_updateStutStore(@RequestBody Map dataMap, HttpServletRequest request) {
        System.out.println(dataMap);
        System.out.println("----学生退书-------");
        String book_id = dataMap.get("book_id").toString();
        String book_num = dataMap.get("book_num").toString();
        String isAll = dataMap.get("isAll").toString();
        HttpSession session = request.getSession(true);//新建session对象
        User user = (User) session.getAttribute("user");  //将对应数据存入session中
        User u = userService.findTeacherByUserId(user.getId());
        String uid = u.getT_id();
        List<StoreOut> teachStoos = storeOutService.findStooByUidAndBid(uid,book_id);
        int current_tea_book = teachStoos.get(0).getBook_out();
        List<StoreOut> stoos = storeOutService.findStooByUidAndBid(user.getId(),book_id);
        int current_stu_book = stoos.get(0).getBook_out();
        //int current_book_count = current_tea_book + current_stu_book;
        if(isAll.equals("yes")){//退还该书的全部
            int stu_book = stoos.get(0).getBook_out()-stoos.get(0).getBook_back();
            int n = storeOutService.deleteStoreOutByUidandBid(book_id,user.getId());
            if(n>0){
                //获取对应教师的领书记录
                int current_book_count = current_tea_book + stu_book;
                storeOutService.updateTeacherBookOut(current_book_count,book_id,uid);
                return "success";
            }else {
                return "failure";
            }
        }else{
            //退还书的一部分,获取该学生的领书记录
            List<StoreOut> storeOuts = storeOutService.findStooByUidAndBid(user.getId(),book_id);
            if(storeOuts.size()>0&&storeOuts.get(0).getBook_back()!=0){
                return "cannot back";
            }else{
                int stu_book_back = Integer.parseInt(book_num);
                int current_book_count = current_tea_book + stu_book_back;
                int n = storeOutService.updateTeacherBookBack(Integer.parseInt(book_num),book_id,user.getId());
                if(n>0){
                    storeOutService.updateTeacherBookOut(current_book_count,book_id,uid);
                    return "success";
                }else {
                    return "failure";
                }
            }
        }
    }


    @ResponseBody
    @RequestMapping(value = "/getStoreOutById")
    public String getStoreInById(@RequestParam("id")String id){
        StoreOut storeOuts = storeOutService.findStoreOutById(id);
        String book_id = storeOuts.getBook_id();
        return book_id;
    }
}