基于JavaWeb实现的研究室综合系统

冷不防 2022-03-10 08:49 118阅读 0赞

> 代码地址如下：  
> [http://www.demodashi.com/demo/14641.html][http_www.demodashi.com_demo_14641.html]

> 概述

基于JavaWeb实现的研究室综合系统,功能包括研究室成员注册、登陆，后台管理，相册功能，新闻模块，资源模块，论坛模块，咨询模块，简易答题系统模块。

> ## 一、准备工作 ##

开发环境：

*  JDK1.8
 *  Tomcat9.0
 *  Intellij IDEA2018.2

运行环境：

*  windows7以上
 *  Mac
 *  Chrome浏览器

实现功能：

*  研究室综合系统,功能包括研究室成员注册、登陆，后台管理，相册功能，新闻模块，资源模块，论坛模块，咨询模块，简易答题系统模块。

> ## 二、代码结构 ##

sql 目录下面的sql文件是项目数据库结构

![t9kZ2TYPRL1pCC4uTkQ.jpg][]

> ## 程序实现-Web系统 ##

#### 1.后台上传资源实现 ####

public class uploadResServlet extends HttpServlet { 
    
        private final String local = URL.getUrl();
        private final String tempFile = local + "resources\\tempFile"; //临时上传目录
        private final String uploadFile = local + "resources\\uploadFile"; //上传目录
        FileUploadProperties instance = FileUploadProperties.getInstance();
        private final String exts = instance.getPropertyValue("exts");
        private final String fileMaxSize = instance.getPropertyValue("file.max.size");
        private final String total = instance.getPropertyValue("total.file.max.size");
        private dbOperator db = null;
    
        /** * Handles the HTTP <code>POST</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */
        @Override
        protected void doPost(HttpServletRequest request, HttpServletResponse response)
                throws ServletException, IOException { 
            request.setCharacterEncoding("utf-8");
            response.setContentType("text/html;charset=utf-8");
            ServletFileUpload upload = getUpload();
            String user = request.getSession().getAttribute("user").toString();
            String userpower = request.getSession().getAttribute("userpower").toString();
            String content = "";
            String fileName = "";
            String filePath = "";
            String path  = "";
            if(userpower.equals("1")){ 
                path = "resources/useraddres.jsp";
            }else if(userpower.equals("2")){ 
                path = "admin/resources/uploadres.jsp";
            }
            
            try { 
                List<FileItem> items = upload.parseRequest(request);
                for (FileItem item : items) { 
                    if (item.isFormField()) { 
                        String formName = item.getFieldName();
                        String formContent = item.getString("utf-8");
                        if (formName.equals("introduce")) { 
                            content = formContent;
                        }
                    } else { 
                        fileName = item.getName();
                        String extName = fileName.substring(fileName.indexOf(".") + 1);
                        try { 
                            validate(extName);
                            db = new dbOperator();
                            if (!db.isSameName("r_title", "resources", fileName)) { 
                                InputStream inStream = item.getInputStream();
                                filePath = uploadFile + "\\" + fileName;
                                String sql = "insert into resources values(" + null + ",'" + fileName + "','" + content + "','" + filePath.replace('\\', '/') + "','" + user + "')";
                                if (db.SqlQuery(sql) != 0) { 
                                    byte[] buffer = new byte[1024];
                                    int len = 0;
                                    OutputStream outStream = new FileOutputStream(filePath);
                                    while ((len = inStream.read(buffer)) != -1) { 
                                        outStream.write(buffer, 0, len);
                                    }
                                    inStream.close();
                                    outStream.close();
                                    request.setAttribute("message", "上传成功!");
                                } else { 
                                    request.setAttribute("message", "上传失败!");
                                }
                            } else { 
                                request.setAttribute("message", "上传失败,该文件名已存在!请检查是否已经上传!");
                            }
    
                        } catch (InvalidExtNameException ex) { 
                            request.setAttribute("message", ex.getMessage());
                            ex.printStackTrace(System.err);
                        }
                    }
    
                }
                request.getRequestDispatcher(path).forward(request, response);
            } catch (FileUploadException e) { 
            }
    
        }
    
        private ServletFileUpload getUpload() { 
            // 为基于硬盘文件的项目集创建一个工厂
            DiskFileItemFactory factory = new DiskFileItemFactory();
            // 设置工厂的约束条件
            factory.setSizeThreshold(1024 * 5);
    
            File tempDir = new File(tempFile);
            File uploadDir = new File(uploadFile);
            if (!tempDir.exists()) { 
                tempDir.mkdirs();
            }
            if (!uploadDir.exists()) { 
                uploadDir.mkdirs();
            }
            factory.setRepository(tempDir);
    
            // Create a new file upload handler(创建一个新文件上传处理程序)
            ServletFileUpload upload = new ServletFileUpload(factory);
            //设置请求的总大小限制
            upload.setSizeMax(Integer.parseInt(fileMaxSize));
            return upload;
        }
    
        private void validate(String extName) { 
            List<String> extList = Arrays.asList(exts.split(","));
            if (!extList.contains(extName)) { 
                throw new InvalidExtNameException("文件类型错误!请上传文档类型的资源(doc,docx,pptx,ppt,txt)!");
            }
        }
    
    }

#### 基于EasyUI实现的后台用户管理页面 ####

<%-- 
        Document   : manageuser
        Created on : 2017-6-19, 9:48:30
        Author     : 挺
        注释:这是对普通用户进行增删改查的界面
    --%>
    
    <%@page contentType="text/html" pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
            <link href="../../images/b128.png" rel="icon" type="images/x-ico"/>
            <link href="../../EasyUI/themes/icon.css" rel="stylesheet" />
            <link href="../../EasyUI/themes/default/easyui.css" rel="stylesheet" />
            <script src="../../EasyUI/jquery.min.js"></script>
            <script src="../../EasyUI/jquery.easyui.min.js"></script>
            <script src="../../EasyUI/locale/easyui-lang-zh_CN.js"></script>
            <title>用户信息管理</title>
        </head>
        <body>
            <table id="dg">
            </table>
        </body>
    </html>
    
    <script>
        var flag;
        var dep = [{"value": "信息学院", "text": "信息学院"}];
        var major = [{"value": "网络工程", "text": "网络工程"}, {"value": "计算机科学与工程", "text": "计算机科学与工程"}];
        var sex = [{"value": "男", "text": "男"}, {"value": "女", "text": "女"}];
        var Class = [{"value": "网络121", "text": "网络121"}, {"value": "网络122", "text": "网络122"}, {"value": "计算机121", "text": "计算机121"}, {"value": "计算机122", "text": "计算机122"}, {"value": "计算机123", "text": "计算机123"}];
    
        $('#dg').datagrid({
            url: '../../UserServlet',
            loadMsg: "数据加载中...",
            pagination: true,
            fit: true,
            singleSelect: true,
            fitColumns: true,
            onSelect: function() {
                $('#btn_edit').linkbutton('enable');
                $('#btn_no').linkbutton('enable');
                $('#btn_save').linkbutton('enable');
                $('#btn_reload').linkbutton('enable');
                $('#btn_cut').linkbutton('enable');
            },
            onUnselect: function() {
                $('#btn_edit').linkbutton('disable');
                $('#btn_no').linkbutton('disable');
                $('#btn_save').linkbutton('disable');
                $('#btn_reload').linkbutton('disable');
                $('#btn_cut').linkbutton('disable');
            },
            columns: [[
                    {field: 'uname', title: '用户名', width: 10, editor: 'text'},
                    {field: 'urealname', title: '姓名', width: 10, editor: 'text'},
                    {field: 'uage', title: '年龄', width: 5, editor: 'numberbox'},
                    {field: 'usex', title: '性别', width: 5,
                        editor: {
                            type: 'combobox', options: {data: sex, valueField: 'value', textField: 'text', panelHeight: 'auto', editable: false}
                        }
                    },
                    {field: 'uaddress', title: '地址', width: 15, editor: 'text'},
                    {field: 'uinstitute', title: '学院', width: 10,
                        editor: {
                            type: 'combobox', options: {data: dep, valueField: 'value', textField: 'text', panelHeight: 'auto', editable: false}
                        }
                    },
                    {field: 'umajor', title: '专业', width: 10,
                        editor: {
                            type: 'combobox', options: {data: major, valueField: 'value', textField: 'text', panelHeight: 'auto', editable: false}
                        }
                    },
                    {field: 'uclass', title: '班级', width: 10,
                        editor: {
                            type: 'combobox', options: {data: Class, valueField: 'value', textField: 'text', panelHeight: 'auto', editable: false}
                        }
                    },
                    {field: 'ustudentid', title: '学号', width: 10},
                    {field: 'uemail', title: '邮箱', width: 15, editor: 'text'}
                ]],
            toolbar: [
                {
                    iconCls: 'icon-add',
                    id: 'btn_add',
                    text: '添加',
                    handler: function() {
                        flag = 1;
                        $('#dg').datagrid('insertRow', {index: 0, row: {}});
                        $('#dg').datagrid('selectRow', 0);
                        $('#dg').datagrid('beginEdit', 0);
                    }
                }, '-', {
                    iconCls: 'icon-edit',
                    id: 'btn_edit',
                    text: '编辑',
                    disabled: true,
                    handler: function() {
                        flag = 2;
                        var row = $('#dg').datagrid("getSelected");
                        var index = $('#dg').datagrid('getRowIndex', row);
                        $('#dg').datagrid('beginEdit', index);
                    }
                }, '-', {
                    iconCls: 'icon-save',
                    id: 'btn_save',
                    text: '保存',
                    disabled: true,
                    handler: function() {
                        var row = $('#dg').datagrid("getSelected");
                        $('#edit').linkbutton('disable');
                        $('#no').linkbutton('disable');
                        $('#save').linkbutton('disable');
                        $('#reload').linkbutton('disable');
                        var index = $('#dg').datagrid('getRowIndex', row);
                        $('#dg').datagrid('endEdit', index);
                        if (row.uname + "" == "" || row.urealname + "" == "") {
                            alert("信息不能为空!");
                            $('#btn_edit').linkbutton('enable');
                            $('#btn_no').linkbutton('enable');
                            $('#btn_save').linkbutton('enable');
                            $('#dg').datagrid('beginEdit', index);
                            return;
                        }
                        if (flag == 1) {
                            $.messager.prompt('提示信息', '请输入学号：', function(r) {
                                if (r) {
                                    row.ustudentid = r;
                                    $.ajax({
                                        type: "post",
                                        url: "../../UserAdminServlet", //对管理员进行添加和编辑进行逻辑处理的servlet
                                        data: {
                                            flag: flag,
                                            ustudentid: row.ustudentid,
                                            uname: row.uname,
                                            urealname: row.urealname,
                                            uage: row.uage,
                                            usex: row.usex,
                                            uaddress: row.uaddress,
                                            uinstitute: row.uinstitute,
                                            umajor: row.umajor,
                                            uclass: row.uclass,
                                            uemail: row.uemail
                                        },
                                        success: function(datas) {
                                            var datas = eval("(" + datas + ")");
                                            if (datas.data == "0") {
                                                $.messager.alert('我的消息', '添加成功!', 'info');
                                                $('#dg').datagrid('reload', null);
                                                $('#btn_edit').linkbutton('disable');
                                                $('#btn_no').linkbutton('disable');
                                                $('#btn_save').linkbutton('disable');
                                                $('#btn_reload').linkbutton('disable');
                                                $('#btn_cut').linkbutton('disable');
                                                $('#dg').datagrid('reload', null);
                                            }
                                            else if (datas.data == "2") {
                                                $.messager.alert('我的消息', '添加失败!', 'info');
                                                $('#dg').datagrid('reload', null);
                                            } else {
                                                $.messager.alert('我的消息', '添加的用户名已存在!', 'info');
                                                //$('#dg').datagrid('reload', null);
                                                $('#dg').datagrid('beginEdit', 0);
                                            }
                                        }
                                    });
                                }
                            });
                        } else if (flag == 2) {
                            $.ajax({
                                type: "post",
                                url: "../../UserAdminServlet", //对管理员进行添加和编辑进行逻辑处理的servlet
                                data: {
                                    flag: flag,
                                    ustudentid: row.ustudentid,
                                    uname: row.uname,
                                    urealname: row.urealname,
                                    uage: row.uage,
                                    usex: row.usex,
                                    uaddress: row.uaddress,
                                    uinstitute: row.uinstitute,
                                    umajor: row.umajor,
                                    uclass: row.uclass,
                                    uemail: row.uemail
                                },
                                success: function(datas) {
                                    var datas = eval("(" + datas + ")");
                                    if (datas.data == "1") {
                                        $.messager.alert('我的消息', '编辑成功!', 'info');
                                        $('#dg').datagrid('reload', null);
                                        $('#btn_edit').linkbutton('disable');
                                        $('#btn_no').linkbutton('disable');
                                        $('#btn_save').linkbutton('disable');
                                        $('#btn_reload').linkbutton('disable');
                                        $('#btn_cut').linkbutton('disable');
                                        $('#dg').datagrid('reload', null);
                                    }
                                    else {
                                        $.messager.alert('我的消息', '编辑失败!', 'info');
                                        $('#dg').datagrid('reload', null);
                                    }
                                }
                            });
                        }
    
                    }
                }, '-', {
                    iconCls: 'icon-cut',
                    id: 'btn_cut',
                    text: '删除',
                    disabled: true,
                    handler: function() {
                        var row = $('#dg').datagrid("getSelected");
                        $.messager.confirm('删除', '确认删除吗？', function(r) {
                            if (r) {
                                flag = 3;
                                // 退出操作;
                                $.ajax({
                                    type: "post",
                                    url: "../../UserAdminServlet",
                                    data: {
                                        flag: flag,
                                        ustudentid: row.ustudentid
                                    },
                                    success: function(data) {
                                        var data = eval("(" + data + ")");
                                        if (data.data == "5") {
                                            $.messager.alert('我的消息', '删除成功!', 'info');
                                            $('#dg').datagrid('reload', null);
                                            $('#btn_edit').linkbutton('disable');
                                            $('#btn_no').linkbutton('disable');
                                            $('#btn_save').linkbutton('disable');
                                            $('#btn_reload').linkbutton('disable');
                                            $('#btn_cut').linkbutton('disable');
                                        }
                                        else {
                                            $.messager.alert('我的消息', '删除失败!', 'info');
                                        }
                                    }
                                })
                            }
                        });
                    }
                }, '-', {
                    iconCls: 'icon-no',
                    id: 'btn_no',
                    text: '取消编辑',
                    disabled: true,
                    handler: function() {
                        var row = $('#dg').datagrid("getSelected");
                        var index = $('#dg').datagrid('getRowIndex', row);
                        $('#dg').datagrid('cancelEdit', index);
                    }
                }, '-', {
                    iconCls: 'icon-reload',
                    id: 'btn_reload',
                    text: '重置密码',
                    disabled: true,
                    handler: function() {
                        var row = $('#dg').datagrid("getSelected");
                        $.messager.confirm('重置', '确认重置吗？', function(r) {
                            if (r) {
                                flag = 4;
                                // 退出操作;
                                $.ajax({
                                    type: "post",
                                    url: "../../UserAdminServlet",
                                    data: {
                                        flag: flag,
                                        ustudentid: row.ustudentid
                                    },
                                    success: function(datas) {
                                        var datas = eval("(" + datas + ")");
                                        if (datas.data == "7") {
                                            $.messager.alert('我的消息', '重置成功!', 'info');
                                            $('#dg').datagrid('reload', null);
                                            $('#btn_edit').linkbutton('disable');
                                            $('#btn_no').linkbutton('disable');
                                            $('#btn_save').linkbutton('disable');
                                            $('#btn_reload').linkbutton('disable');
                                            $('#btn_cut').linkbutton('disable');
                                        }
                                        else {
                                            $.messager.alert('我的消息', '重置失败!', 'info');
                                        }
                                    }
                                });
                            }
                        });
                    }
                }]
    
        });
    
        //分页
        var pagenum = 10;
        load();
        function load() {
            var p = $('#dg').datagrid('getPager');
            $(p).pagination({
                pageSize: pagenum, //每页显示的记录条数，默认为10  
                pageList: [10, 20, 30], //可以设置每页记录条数的列表 
                beforePageText: '第', //页数文本框前显示的汉字  
                afterPageText: '页    共 {pages} 页',
                displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录',
                onBeforeRefresh: function(pageNumberNow, pageSizeNow) {
                    pagenum = pageSizeNow;
                    $('#dg').datagrid('load', null);
                    load();
                }
    
            });
        }
    </script>

> ## 四、运行效果 ##

1、 将sql文件导入自己本地的数据库；  
2、 Intellij IDEA 导入下载的项目，在Add Configuration中配置好Tomcat，点击Run 即可；  
3、 管理员用户:admin 密码：123456

#### 首页 ####

![K9Gj3ZREnYe0F81d8LD.jpg][]

#### 登陆页面 ####

![HXDsqSGSWeJAvAOoHbf.png][]

#### 后台管理页面 ####

![adtt8zVHxojV5kg7okj.png][]

#### 后台用户管理页面 ####

*  包括增删改查、重置密码  
    ![lKtKN3IS4JTIBrDTPCa.png][]

#### 后台上传资源页面 ####

![44Z0zWRUxzaUjrFYFwJ.png][]

\#\#\#\#后台新闻发布页面  
![5HaiCQglBv5JJIDcV2y.png][]

#### 前端用户资源页面 ####

![OTE6Qz8lN6iburWmqER.png][]

#### 前端论坛页面 ####

![Ld7ApRTd1mWPbSgtjWf.png][]

#### 前端答题系统页面 ####

![cOlQAXfCoyc9KdDOcWa.png][]

#### 前端分数查询页面 ####

![W0AAk7PCD6ZePdBLNM7.png][]  
基于JavaWeb实现的研究室综合系统

> 代码地址如下：  
> [http://www.demodashi.com/demo/14641.html][http_www.demodashi.com_demo_14641.html]

> 注：本文著作权归作者，由demo大师发表，拒绝转载，转载需要作者授权

[http_www.demodashi.com_demo_14641.html]: http://www.demodashi.com/demo/14641.html
[t9kZ2TYPRL1pCC4uTkQ.jpg]: /images/20220310/4fb6ab9dbbc747ec98fdfdac3cb8f291.png
[K9Gj3ZREnYe0F81d8LD.jpg]: /images/20220310/44847f5f843844cfb193018ca74e9415.png
[HXDsqSGSWeJAvAOoHbf.png]: /images/20220310/d9a9f02cde534cbb9229c7cfae57fceb.png
[adtt8zVHxojV5kg7okj.png]: /images/20220310/f1918fccf5c042ce9c0846b93f72bf99.png
[lKtKN3IS4JTIBrDTPCa.png]: /images/20220310/84c6412f67b345939f6e46297853ab81.png
[44Z0zWRUxzaUjrFYFwJ.png]: /images/20220310/cb953c7da7ed4519ab786f342c319129.png
[5HaiCQglBv5JJIDcV2y.png]: /images/20220310/6806feeb62de4ba6b93d979d7e04f871.png
[OTE6Qz8lN6iburWmqER.png]: /images/20220310/f285b9e0f0eb437196883fb446ead016.png
[Ld7ApRTd1mWPbSgtjWf.png]: /images/20220310/591bf594d41a4b7b97537f0386bdc4e7.png
[cOlQAXfCoyc9KdDOcWa.png]: /images/20220310/a22fbf19053c4880b008a5a95e77b43d.png
[W0AAk7PCD6ZePdBLNM7.png]: /images/20220310/065e27e4e8e748f19ef7bdb4a8372df2.png