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>

用户管理功能

<%@ 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>操&nbsp;&nbsp;作&nbsp;</td>
                <td>操&nbsp;&nbsp;作&nbsp;</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>&nbsp;&nbsp;&nbsp;</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>
View Code

 

posted @ 2020-10-20 20:28  qazvve  阅读(42)  评论(0)  编辑  收藏  举报