📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="error.jsp" %><%@ include file="initialization.jsp" %><%ResultSet bulletinRS=mysql.getResultSet("select title,promulgateDate,bulletinID from bulletin order by bulletinID desc limit 0,10;");ResultSet bookRS=mysql.getResultSet("select bookName,bookID from book order by bookID desc limit 0,10;");if (request.getParameter("name") != null && request.getParameter("password") != null) { String name = request.getParameter("name"); String password = request.getParameter("password"); ResultSet studentRS=mysql.getResultSet("select * from student where studentID="+name+" and password="+password+";"); if (studentRS!=null&&studentRS.first()) { session.setAttribute("login", "OK"); session.setAttribute("name",name); response.sendRedirect("service.jsp"); } else { out.print("<script language='JavaScript'>alert('输入错误，请重新输入!');</script>"); } }%><html><head><title>图书馆管理系统</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><link type="text/css" href="css/link.css" rel="stylesheet"><link type="text/css" href="css/text.css" rel="stylesheet"><link type="text/css" href="css/form.css" rel="stylesheet"></head><body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="images/bg.gif" ><!-- ImageReady Slices (index.psd) --><table align="center" height="100%"><tr valign="middle"><td><table id="__01" width="779" height="436" border="0" cellpadding="0" cellspacing="0" align="center"> <tr> <td width="82" height="116" background="images/index-01.gif"> <DIV align="center" style="margin-bottom:28px"> <script language="javascript" src="javascript/calendar.js"></script> </DIV></td> <td colspan="5" width="696" height="116" background="images/index-02.gif"> <table width="200" border="0" cellspacing="0" cellpadding="0" align="right" style="margin-bottom:90px"> <tr> <td align="center"> <A title=将本站加入到你的收藏夹 href="javascript:window.external.addFavorite('babala_234@163.com','图书馆管理系统');" >收藏本站</A> |<A name=StranLink>繁体中文</A> |<A href="admin_logon.jsp?module=admin" title="点击进入系统管理中心">系统管理</A> </td> </tr> </table> </td> <td> <img src="images/spacer.gif" width="1" height="116" alt=""></td> </tr> <tr> <td width="239" height="260" colspan="2" rowspan="5" align="center" background="images/index-03.gif"> <table width="200" height="66" border="0" cellpadding="0" cellspacing="0" class="black"> <tr> <td height="21">开馆时间：</td> </tr> <tr> <td height="17"> 工作日：8：00-22：00</td> </tr> <tr> <td height="20"> 休假日：8：00-17：00</td> </tr> </table></td> <td colspan="2"> <img src="images/index-04.gif" width="354" height="22" alt=""></td> <td colspan="2" width="185" height="22" background="images/index-05.gif"> <form name="search" method="post" action="search.jsp" style="border:none;margin:0,0,0,0"> <input name="search" type="text" id="search" size="18" class="inputall"> <input type="submit" name="Submit" value="搜索" class="inputall"> </form> </td> <td> <img src="images/spacer.gif" width="1" height="22" alt=""></td> </tr> <form name="logon" method="post" action=""> <tr> <td rowspan="3"> <img src="images/index-06.gif" width="124" height="29" alt=""></td> <td> <img src="images/index-07.gif" width="230" height="1" alt=""></td> <td> <img src="images/index-08.gif" width="69" height="1" alt=""></td> <td rowspan="3" width="116" height="29" background="images/index-09.gif"> <input type="submit" name="Submit2" value="登录" class="inputall"></td> <td> <img src="images/spacer.gif" width="1" height="1" alt=""></td> </tr> <tr> <td colspan="2" width="299" height="27" background="images/index-10.gif"> <table width="100%" height="100%"border="0" cellspacing="0" cellpadding="0" class="black"> <tr> <td width="18%" align="right">用户名:</td> <td width="31%"> <input name="name" type="text" id="name" size="15" maxlength="20" class="inputbottom"> </td> <td width="17%" align="right">密 码:</td> <td width="34%"> <input name="password" type="password" id="password" size="15" maxlength="20" class="inputbottom"></td> </tr> </table> </td> <td> <img src="images/spacer.gif" width="1" height="27" alt=""></td> </tr> </form> <tr> <td colspan="2"> <img src="images/index-11.gif" width="299" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="1" height="1" alt=""></td> </tr> <tr> <td colspan="4" rowspan="2" width="539" height="210" background="images/index-12.gif"> <table width="536" height="144" border="0" cellpadding="0" cellspacing="0" style="margin-top:36px"> <tr> <td width="337" height="144" align="center" valign="top"> <table width="95%" border="0" cellpadding="0" cellspacing="0"> <% while(bulletinRS.next()){ %> <tr> <td width="5%"><img src="images/tri.gif" /></td> <td width="64%" align="left"><a href="bulletin.jsp?ID=<%=bulletinRS.getString("bulletinID")%>" class="orange-black"> <%=bulletinRS.getString("title")%></a></td> <td width="31%" class="yellow">（<%=bulletinRS.getString("promulgateDate")%>）</td> </tr> <% }%> </table></td> <td width="30"> </td> <td width="169" valign="top"> <table border="0" cellspacing="0" cellpadding="0"> <% while(bookRS.next()){%> <tr> <td width="159"><a href="book.jsp?ID=<%=bookRS.getString("bookID")%>" class="orange-black"> <%=bookRS.getString("bookName")%></a></td> </tr> <% }%> </table></td> </tr> </table></td> <td> <img src="images/spacer.gif" width="1" height="209" alt=""></td> </tr> <tr> <td colspan="2"> <img src="images/index-13.gif" width="239" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="1" height="1" alt=""></td> </tr> <tr> <td colspan="6" width="778" height="58" background="images/index-14.gif"> <TABLE cellSpacing="0" cellPadding="0" width="100%" height="100%" border="0" align="center"> <TBODY> <TR> <TD align="center" class="black">计算机科学与技术2班版权所有 © 洪智标 制作维护 <br> 学号：3104006491 E-mail： <a href="mailto:babala_234@163.com" class="white-yellow">babala_234@163.com</a></TD> </TR> <TR> <TD height="6"></TD> </TR> </TBODY> </TABLE> </td> <td> <img src="images/spacer.gif" width="1" height="58" alt=""></td> </tr> <tr> <td> <img src="images/spacer.gif" width="82" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="157" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="124" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="230" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="69" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="116" height="1" alt=""></td> <td></td> </tr></table></td></tr></table><script language="javascript" src="javascript/stranjf.js"></script><!-- End ImageReady Slices --></body></html><%@ include file="finality.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -