基于javaweb+jsp的自习室座位预订管理系统

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Layui Ajax

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可修改

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

            defaultToolbar: ['filter', 'exports', 'print', { //自定义头部工具栏右侧图标。如无需自定义，去除该参数即可
                title: '提示',
                layEvent: 'LAYTABLE_TIPS',
                icon: 'layui-icon-tips'
            }],
            title: '公告列表',
            cols: [
                [
                        {
                            field: 'noticeName',
                            title: '标题',
                            templet: vo => (vo = vo.noticeName) ? '' + vo + '' : '',
                            event: 'info',
                        },
                        {
                            field: 'noticeText',
                            title: '内容',
                        },
                        {
                            field: 'noticeType',

                `yuyue_sex` = #{yuyueSex},
                `yuyue_phone` = #{yuyuePhone},
                `yuyue_zxs` = #{yuyueZxs},
                `yuyue_zuo` = #{yuyueZuo},
                `yuyue_date` = #{yuyueDate},
                `yuyue_text` = #{yuyueText}
        
        WHERe `id` = #{id}
    

    
    
        SELECT  FROM `t_yuyue`
        
            
                ${searchColumn} LIKE CONCAt('%',#{keyword},'%')  AND

            
                ${loginUser.username}
                退出登录

搜索：

        //搜索
        let $ = layui.$, active = {
            reload: function () {
                let url = 'zuoweiList?keyword=' + $('#search_keyword').val() + '&searchColumn=' + $('#searchColumn').val();
                //执行重载
                table.reload('myTable', {
                    url: url,
                    page: {
                        curr: 1 //重新从第 1 页开始
                    }
                });
            }
        };
        $('.searchTable .layui-btn').on('click', function () {
            let type = $(this).data('type');
            active[type] ? active[type].call(this) : '';

                    }
                ]
            ],
        });
        //监听工具条
        table.on('tool(myTable)', function (obj) { //注：tool 是工具条事件名，myTable 是 table 原始容器的属性 lay-filter="对应的值"
            let data = obj.data; //获得当前行数据
            let layEvent = obj.event; //获得 lay-event 对应的值（也可以是表头的 event 参数对应的值）
            if (layEvent === 'del') { //删除
                // layer.confirm('删除' + data.realName + "?", function (index) {
                $.ajax({
                    type: "GET",
                    dataType: "text",
                    url: "userDelete?id=" + data.id,
                    success: function () {
                        console.log("已删除！");
                    }
                });
                obj.del(); //删除对应行（tr）的DOM结构，并更新缓存
                //parent.location.reload();//刷新父级页面
                // layer.close(index);
                //parent.location.reload();//刷新父级页面
                layer.msg(data.realName + ' 删除成功！');
                // });
            } else if (layEvent === 'edit') { //编辑

     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping("zuoweiList")
    public void list(HttpServletResponse response, HttpServletRequest request) throws IOException {
        this.redirectList(request, response);
    }

    /**
     * 跳转到列表页面
     *
     * @param request

    }

    public void setYuyuePhone(String yuyuePhone) {
        this.yuyuePhone = yuyuePhone;
    }
    public String getYuyueZxs() {
        return yuyueZxs;
    }

    public void setYuyueZxs(String yuyueZxs) {
        this.yuyueZxs = yuyueZxs;
    }
    public String getYuyueZuo() {
        return yuyueZuo;
    }

    public void setYuyueZuo(String yuyueZuo) {
        this.yuyueZuo = yuyueZuo;
    }
    public String getYuyueDate() {
        return yuyueDate;
    }

    
        `id`,`notice_name`,`notice_text`,`notice_type`,`create_date`
    

    
    
        INSERT INTO `t_notice`
        
                    `id`,
                    `notice_name`,
                    `notice_text`,
                    `notice_type`,
                    `create_date`
        
        
                    #{id},
                    #{noticeName},
                    #{noticeText},
                    #{noticeType},
                    #{createDate}

        this.zuoweiName = zuoweiName;
    }
    public String getZuoweiZxs() {
        return zuoweiZxs;
    }

    public void setZuoweiZxs(String zuoweiZxs) {
        this.zuoweiZxs = zuoweiZxs;
    }
    public String getZuoweiAddress() {
        return zuoweiAddress;
    }

    public void setZuoweiAddress(String zuoweiAddress) {
        this.zuoweiAddress = zuoweiAddress;
    }
    public String getZuoweiTime() {
        return zuoweiTime;
    }

    public void setZuoweiTime(String zuoweiTime) {
        this.zuoweiTime = zuoweiTime;
    }
    public String getZuoweiRen() {
        return zuoweiRen;
    }

                    `zuowei_time`,
                    `zuowei_ren`,
                    `zuowei_phone`,
                    `zuowei_status`,
                    `zuowei_text`
        
        
                    #{id},
                    #{zuoweiName},
                    #{zuoweiZxs},
                    #{zuoweiAddress},
                    #{zuoweiTime},
                    #{zuoweiRen},
                    #{zuoweiPhone},
                    #{zuoweiStatus},
                    #{zuoweiText}