10.20号进度总结
添加了管理员功能及页面
<body leftFrame="true">
<div id="scrollContent">
<div class="arrowlistmenu">
<div class="menuheader expandable">系统菜单</div>
<ul class="categoryitems">
<li><a href="../adminindex.jsp" target="frmright"><span
class="text_slice">权限管理</span></a></li>
<li><a href="../resetpass.jsp" target="frmright"><span
class="text_slice">修改密码</span></a></li>
<li><a href="../xqmanage.jsp" target="frmright"><span
class="text_slice">需求管理</span></a></li>
<li><a href="../mytest.jsp" target="frmright"><span
class="text_slice">查询</span></a></li>
<li><a href="../xsshenheindex.jsp" target="frmright"><span
class="text_slice">形式审核</span></a></li>
<li><a href="../xsshenheindex2.jsp" target="frmright"><span
class="text_slice">形式审核未通过的</span></a></li>
<li><a href="../jsshenheindex.jsp" target="frmright"><span
class="text_slice">技术审核</span></a></li>
<li><a href="../jsshenheindex2.jsp" target="frmright"><span
class="text_slice">审核失败的</span></a></li>
<li><a href="../Introduce.html" target="frmright"><span
class="text_slice">系统介绍</span></a></li>
</ul>
</body>
用户管理功能
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>用户管理</title> </head> <body> <div bgcolor="#E7E7E7"> 用户管理<br/> </div> <form name="form0" action="Userupdate_per.jsp" method="post"> <table> <tr bgcolor="#E7E7E7"> <td>用户名称 <input type="text" name="Iname"> <input type="submit" value="查询"> </td> </tr> </table> </form> <form name="form1" id="form1" action=""> <table border="1" width="900" name="table1" id="table1"> <tr> <td>用户名称</td> <!-- <td>原因</td> --> <td>操 作 </td> <td>操 作 </td> </tr> <jsp:useBean id="db" class="DBBean.Bean" scope="page" /> <% String Iname = ""; // String xsreason=""; // String sql2="";//用来查询未通过的原因,用于显示原因 System.out.println(" "); System.out.println("adminindex.jsp 界面信息:"); String sql = "select Iname from baseinfo "; //String sql2="select Iresult where" ResultSet rs = db.executeQuery(sql); while (rs.next()) { //System.out.println(rs.getString(1)); //可以输出Inamenum的所有值 比如Iname为图书馆 那么输出图书馆1 图书馆2 图书馆3 Iname = rs.getString(1); out.println("<tr><td>" + Iname + "</td>"+ // "</td><td>" + xsreason+ "</td><td><a href='del.jsp?Iname=" + Iname + "'>删除</a> </td><td><a href='Userupdate.jsp?Iname=" + Iname + "'>修改</a></td></tr>"); } // sql2="select xsreason from xssh where Inamenum="+"'"+Inamenum+"'"; // ResultSet rs2=db.executeQuery(sql2); // while(rs2.next()){ // xsreason=rs2.getString(1); // System.out.println("xqmanage界面的xsreason:"+xsreason); // } rs.close(); db.close(); %> </table> </form> </body> </html>