写了一个最基础的java web数据库课设，遵循三层架构。
后端：Java
前端：jsp + layui + echarts
数据库：mysql
web容器：tomcat
操作系统：win10
IDE：idea
这里写了图书的查询、借阅和归还，用户信息管理，违约处理等界面，其他功能可自由拓展

d="_8">声明：

本项目只是一个toy，未作安全防护部分和多人同时连接服务（多线程），请勿直接作实际用途

界面展示
dnimg.cn/20201217150858506.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25haXVl,size_16,color_FFFFFF,t_70" alt="在这里插入图片描述" />
dnimg.cn/20201217151512864.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25haXVl,size_16,color_FFFFFF,t_70" alt="在这里插入图片描述" />

dnimg.cn/2020121715142993.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25haXVl,size_16,color_FFFFFF,t_70" alt="在这里插入图片描述" />
dnimg.cn/20201217151538713.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25haXVl,size_16,color_FFFFFF,t_70" alt="在这里插入图片描述" />

dnimg.cn/20201217150935995.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25haXVl,size_16,color_FFFFFF,t_70" alt="在这里插入图片描述" />
数据库备份以及还原

de class="prism language-java">d">package com.book.control;

d">import java.io.*;

d">public d">class Backup {
    d">public d">static d">void dbBackUp(String root,String pwd,String dbName,String backPath,String backName) d">throws Exception {
        String pathSql = backPath+backName;
        File fileSql = d">new File(pathSql);
        //创建备份sql文件
        d">if (!fileSql.exists()){
            fileSql.createNewFile();
        }
        //mysqldump -hlocalhost -uroot -p123456 db > /home/back.sql
        StringBuffer sb = d">new StringBuffer();
        sb.append("mysqldump");
        sb.append(" -h127.0.0.1");
        sb.append(" -u"+root);
        sb.append(" -p"+pwd);
        sb.append(" "+dbName+" >");
        sb.append(pathSql);
        System.out.println("cmd命令为："+sb.toString());
        Runtime runtime = Runtime.getRuntime();
        System.out.println("开始备份："+dbName);
        Process process = runtime.exec("cmd /c"+sb.toString());
        System.out.println("备份成功!");
    }

    /**
     * 恢复数据库
     * @param root
     * @param pwd
     * @param dbName
     * @param filePath
     * mysql -hlocalhost -uroot -p123456 db < /home/back.sql
     */
    d">public d">static d">void dbRestore(String root,String pwd,String dbName,String filePath){
        StringBuilder sb = d">new StringBuilder();
        sb.append("mysql");
        sb.append(" -h127.0.0.1");
        sb.append(" -u"+root);
        sb.append(" -p"+pwd);
        sb.append(" "+dbName+" <");
        sb.append(filePath);
        System.out.println("cmd命令为："+sb.toString());
        Runtime runtime = Runtime.getRuntime();
        System.out.println("开始还原数据");
        d">try {
            Process process = runtime.exec("cmd /c"+sb.toString());
            InputStream is = process.getInputStream();
            BufferedReader bf = d">new BufferedReader(d">new InputStreamReader(is,"utf8"));
            String line = null;
            d">while ((line=bf.readLine())!=null){
                System.out.println(line);
            }
            is.close();
            bf.close();
        } d">catch (IOException e) {
            e.printStackTrace();
        }
        System.out.println("还原成功！");
    }
    d">public d">static d">void Backupall() d">throws Exception {
        dbBackUp("root","***","book_list","d://backup//","book.sql");
        dbBackUp("root","***","borrow_list","d://backup//","borrow.sql");
        dbBackUp("root","***","user_list","d://backup//","user.sql");
    }
    d">public d">static d">void main(String[] args) d">throws Exception {
        Backupall();
    }
}
de>

d="_94">源码地址：

123/BooksAdministration/">github
欢迎star