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>