manage.jsp

来自「它统一管理各个应用系统用户的身份验证」· JSP 代码 · 共 36 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="dbBean.DBBean" scope="session"/>
<center>
<h2><font face="微软雅黑">系统维护</font></h2>
<h3 align="right"><font face="微软雅黑" size="3">欢迎，<%=request.getAttribute("SSOUser")%> ！<br><a href="manage.jsp?action=logout">注销</a></font></h3>
<div align="right">
<br> 
</div><table border bordercolor="#0099FF">
<tr><th colspan="3" bgcolor='#CCFFFF'><font face="微软雅黑">删除投票项</font></th>
<%
	ResultSet rs=db.executeQuery("select * from vote");
	int i=1;
	String temp;
	while(rs.next())
	{
		temp = rs.getString("item");
		out.println("<tr>");
		out.println("<td>"+i+"</td>");
		out.println("<td>"+temp+"</td>");
		out.println("<td align='center'><a href='delete.jsp?delitem="+temp+"'>删除</a></td>");
		i++;	
	}
	rs.close();
	db.close();
%>
<tr><th colspan="3" bgcolor='#CCFFFF'><font face="微软雅黑">添加投票项</font></th>
<tr><td colspan="3">
<form method="post" action="add.jsp"><font face="微软雅黑">
内容</font><font face="微软雅黑">：</font><input type="text" name="additem" size="30">
<font face="微软雅黑"><input type="submit" value="提交"></font>
<font face="微软雅黑"><input type="reset" value="重置"></font>
</form>
</td>
<tr><td colspan="3" align="center" bgcolor='#CCFFFF'><font face="微软雅黑"><a href="/Vote/index.jsp">返回投票页面</a></font></td>
</table>
</center>