会议预约管理信息系统(三)

huiyishenhe.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 10:36
  To change this template use File | Settings | File Templates.
--%>
<%@ page import="Bean.users" %>
<%@ page import="java.util.List" %>
<%@ page import="Bean.users" %>
<%@ page import="Bean.meeting" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!-- 需导入sql包,user实体包 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <meta charset="utf-8">
    <title>会议审核页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">会议信息</h2>


<jsp:useBean id="util" class="Dao.dao"/>

<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    List<meeting> list = util.readMeeting();
%>
<%if(list.isEmpty()) {%>
<br>
<br>
<br>
<p style="text-align: center;font-size: xx-large;font-weight: 500;">当前数据库无相关信息</p>
<%}else {%>
<table  id="table">
    <tr>
        <th>会议主题</th>

    </tr>
    <%for (meeting m : list) { %>
    <tr>
        <td><a href="huiyishenhe`.jsp?name=<%=m.getMeetingName() %>"><%=m.getMeetingName()%></a>


    </tr>
    <%}} %>
</table>

</body>
</html>

huiyishenhe`.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 10:37
  To change this template use File | Settings | File Templates.
--%>
<%@ page import="Bean.users" %>
<%@ page import="java.util.List" %>
<%@ page import="Dao.dao" %>
<%@ page import="Bean.meeting" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!-- 需导入sql包,user实体包 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title>Title</title>
</head>
<body>


<jsp:useBean id="util" class="Dao.dao"/>

<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    String name =(request.getParameter("theme"));
    meeting m = dao.getmeeting1(name);
%>
<form action="huiyishenhe.jsp" method="get" id="form" onsubmit="return check()" >
    <input type="hidden" name="id" value="<%=name%>">
    <table >
        <tr>
            <th>会议主题</th>
            <th>会议内容</th>
            <th>会议开始时间</th>
            <th>会议结束时间</th>
            <th>参会人员</th>
            <th>参会人数</th>
            <th>审核状态</th>
        </tr>

        <tr>
            <td><%=m.getMeetingName()%></td>
            <td><%=m.getMeetingContent()%></td>
            <td><%=m.getMeetingBegin()%></td>
            <td><%=m.getMeetingEnd()%></td>
            <td><%=m.getParticipants()%></td>
            <td><%=m.getAuditStatus()%></td>
            <td><a href="huiyishnehe```.jsp?name=<%=m.getMeetingName()%>">不同意</a>
            <td><a href="huiyishenhe``.jsp?name=<%=m.getMeetingName()%>">同意</a>

        </tr>

    </table>
</form>
</body>
</html>

huiyiyuyue.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 11:28
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>会议预约</title>
</head>
<body>
<form action="huiyiyuyue`.jsp" method="get">
    <table align="center" border="1" width="500">
        <tr>
            <td>会议室主题: </td>
            <td>

                <label>
                    <input type="text" name="theme" />
                </label>
            </td>
        </tr>
        <tr>
            <td>会议内容: </td>
            <td>
                <label>
                    <input type="text" name="neirong" />
                </label>
            </td>
        </tr>
        <tr>
            <td>会议室开始时间: </td>
            <td>
                <label>
                    <input type="text" name="begin" />
                </label>
            </td>
        </tr>
        <tr>
            <td>会议结束时间: </td>
            <td>
                <label>
                    <input type="text" name="end" />
                </label>
            </td>
        </tr>
        <tr>
            <td>参会人数: </td>
            <td>
                <label>
                    <input type="text" name="canhuiren" />
                </label>
            </td>
        </tr>
        <tr>
            <td>参会人员: </td>
            <td>
                <label>
                    <input type="text" name="people" />
                </label>
            </td>
        </tr>
        <tr>
            <td>预约会议室: </td>
            <td>
                <label>
                    <input type="text" name="room" />
                </label>
            </td>
        </tr>

        <tr align="center">
            <td colspan="2">
                <input type="submit" value="提交" />
                <input type="reset" value="重置" />
            </td>
        </tr>
    </table>
</form>
</body>

</html>

huiyiyuyue`.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<jsp:useBean id="util" class="Dao.dao"/>
<%
    String theme =request.getParameter("theme");
    String neirong= request.getParameter("neirong");
    String begin= request.getParameter("begin");
    String end= request.getParameter("end");
    String canhuiren= request.getParameter("canhuiren");
    String people= request.getParameter("people");
    String room=request.getParameter("room");
    if(util.chachonghuiyishi(room)){
        out.print("<script language ='javaScript'> alert('录入会议室重复');window.history.back(-1); </script>");
    }
    else
    {util.input3(theme,neirong,begin,end,canhuiren,people,room);
        out.print("<script language='javaScript'> alert('录入成功');</script>");
        response.setHeader("refresh", "0;url=zhiyuan.jsp");}

%>
</body>
</html>

liulanhuigl.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>管理员浏览会议室</title>
</head>
<body>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!-- 需导入sql包,user实体包 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <meta charset="utf-8">
    <title>浏览会议室页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">会议室信息</h2>


<jsp:useBean id="util" class="Dao.dao"/>

<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    List<room> list = util.readRoom();
%>
<%if(list.isEmpty()) {%>
<br>
<br>
<br>
<p style="text-align: center;font-size: xx-large;font-weight: 500;">当前数据库无相关信息</p>
<%}else {%>
<table  id="table">
    <tr>
        <th>会议室编号</th>
        <th>会议室名称</th>
        <th>会议室地址</th>
        <th>可用状态</th>
        <th>目前状态</th>
        <th>容纳人数</th>
    </tr>
    <%for (room r : list) { %>
    <tr>
        <td><%=r.getMeetroomId()%></td>
        <td><%=r.getMeetroomName()%></td>
        <td><%=r.getAddress()%></td>
        <td><%=r.getReadyState()%></td>
        <td><%=r.getStatus()%></td>
        <td><%=r.getCapacity()%></td>

    </tr>
    <%}} %>
</table>

</body>
</html>

liulanhuizy.jsp

<%@ page import="Bean.room" %>
<%@ page import="java.util.List" %>
<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 10:23
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>职员浏览会议室</title>
</head>
<body>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!-- 需导入sql包,user实体包 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <meta charset="utf-8">
    <title>浏览会议室页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">会议室信息</h2>


<jsp:useBean id="util" class="Dao.dao"/>

<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    List<room> list = util.readRoomk();
%>
<%if(list.isEmpty()) {%>
<br>
<br>
<br>
<p style="text-align: center;font-size: xx-large;font-weight: 500;">当前数据库无相关信息</p>
<%}else {%>
<table  id="table">
    <tr>
        <th>会议室编号</th>
        <th>会议室名称</th>
        <th>会议室地址</th>
        <th>可用状态</th>
        <th>目前状态</th>
        <th>容纳人数</th>

    </tr>
    <%for (room r : list) { %>
    <tr>
        <td><%=r.getMeetroomId()%></td>
        <td><%=r.getMeetroomName()%></td>
        <td><%=r.getAddress()%></td>
        <td><%=r.getReadyState()%></td>
        <td><%=r.getStatus()%></td>
        <td><%=r.getCapacity()%></td>

    </tr>
    <%}} %>
</table>

</body>
</html>

shanchuhuiyishi.jsp

<%@ page import="Bean.room" %>
<%@ page import="java.util.List" %><%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 9:51
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!-- 需导入sql包,user实体包 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <meta charset="utf-8">
    <title>删除会议室页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">会议室信息</h2>


<jsp:useBean id="util" class="Dao.dao"/>

<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    List<room> list = util.readRoom();
%>
<%if(list.isEmpty()) {%>
<br>
<br>
<br>
<p style="text-align: center;font-size: xx-large;font-weight: 500;">当前数据库无相关信息</p>
<%}else {%>
<table  id="table">
    <tr>
        <th>会议室编号</th>
        <th>会议室名称</th>
        <th>会议室地址</th>
        <th>可用状态</th>
        <th>目前状态</th>
        <th>容纳人数</th>
        <th>操作</th>
    </tr>
    <%for (room r : list) { %>
    <tr>
        <td><%=r.getMeetroomId()%></td>
        <td><%=r.getMeetroomName()%></td>
        <td><%=r.getAddress()%></td>
        <td><%=r.getReadyState()%></td>
        <td><%=r.getStatus()%></td>
        <td><%=r.getCapacity()%></td>
        <td><a href="shanchuhuiyishi`.jsp?id=<%=r.getId() %>">删除</a>

    </tr>
    <%}} %>
</table>

</body>
</html>

shanchuhuiyishi`.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 10:07
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>删除会议室</title>
</head>
<body>
<jsp:useBean id="util" class="Dao.dao"/>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    int id=Integer.parseInt(request.getParameter("id"));
    if(util.deletedata2(id))
    {
        out.print("<script language='javaScript'> alert('删除成功');window.history.back(-1);</script>");
    }
    else
    {
        out.print("<script language ='javaScript'> alert('删除失败');window.history.back(-1); </script>");
    };
%>

</body>
</html>

xiugaihuiyishi.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 9:48
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改会议室信息界面</title>
</head>
<body>
<form action="xiugaihuiyishi`.jsp" method="get">
    <table align="center" border="1" width="500">
        <tr>
            <td>会议室编号: </td>
            <td>
                <label>
                    <select name="jibie">
                        <option value="A">A</option>
                        <option value="B">B</option>
                        <option value="C" selected>C</option>
                    </select>
                </label>
                <label>
                    <input type="text" name="number" />
                </label>
            </td>
        </tr>
        <tr>
            <td>会议室名称: </td>
            <td>
                <label>
                    <input type="text" name="name" />
                </label>
            </td>
        </tr>
        <tr>
            <td>会议室地址: </td>
            <td>
                <label>
                    <input type="text" name="address" />
                </label>
            </td>
        </tr>
        <tr>
            <td>可用状态: </td>
            <td>
                <label>
                    <input type="radio" name="keyong" value="可用">可用<br>
                    <input type="radio" name="keyong" value="不可用" checked>不可用<br>
                </label>
            </td>
        </tr>
        <tr>
            <td>目前状态: </td>
            <td>
                <label>
                    <input type="radio" name="muqian" value="占用">占用<br>
                    <input type="radio" name="muqian" value="不占用" checked>不占用<br>
                </label>
            </td>
        </tr>
        <tr>
            <td>容纳人数: </td>
            <td>
                <label>
                    <input type="text" name="num" />
                </label>
            </td>
        </tr>


        <tr align="center">
            <td colspan="2">
                <input type="submit" value="提交" />
                <input type="reset" value="重置" />
            </td>
        </tr>
    </table>
</form>
</body>

</html>

xiugaihuiyishi`.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/12/9
  Time: 9:49
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<jsp:useBean id="util" class="Dao.dao"/>
<%
    String jibie =request.getParameter("jibie");
    String roomid= request.getParameter("jibie")+request.getParameter("number");
    String name= request.getParameter("name");
    String address= request.getParameter("address");
    String keyong= request.getParameter("keyong");
    String muqian= request.getParameter("muqian");
    String num= request.getParameter("num");
    if(util.chachonghuiyishi(roomid)){
        out.print("<script language ='javaScript'> alert('录入会议室重复');window.history.back(-1); </script>");
    }
    else if(util.judgehysnum(jibie,num)){
        out.print("<script language ='javaScript'> alert('容纳人数不符合要求');window.history.back(-1); </script>");
    }
    else
    {util.xiugai2(roomid,name,address,keyong,muqian,num);
        out.print("<script language='javaScript'> alert('修改成功');</script>");
        response.setHeader("refresh", "0;url=guanliyuan.jsp");}

%>
</body>
</html>

xiugaihuiyishi``.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!-- 需导入sql包,user实体包 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <meta charset="utf-8">
    <title>修改会议室页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">会议室信息</h2>


<jsp:useBean id="util" class="Dao.dao"/>

<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");
    List<room> list = util.readRoom();
%>
<%if(list.isEmpty()) {%>
<br>
<br>
<br>
<p style="text-align: center;font-size: xx-large;font-weight: 500;">当前数据库无相关信息</p>
<%}else {%>
<table  id="table">
    <tr>
        <th>会议室编号</th>
        <th>会议室名称</th>
        <th>会议室地址</th>
        <th>可用状态</th>
        <th>目前状态</th>
        <th>容纳人数</th>
        <th>操作</th>
    </tr>
    <%for (room r : list) { %>
    <tr>
        <td><%=r.getMeetroomId()%></td>
        <td><%=r.getMeetroomName()%></td>
        <td><%=r.getAddress()%></td>
        <td><%=r.getReadyState()%></td>
        <td><%=r.getStatus()%></td>
        <td><%=r.getCapacity()%></td>
        <td><a href="xiugaihuiyishi.jsp?id=<%=r.getId() %>">修改</a>

    </tr>
    <%}} %>
</table>

</body>
</html>

 

上一篇:CodeGo.net> WinRT XAML-如何在列表视图中样式选定的项目?


下一篇:C#-MaterialDesign多个对话框