manage.jsp

来自「课程设计中的在线书店源码」· JSP 代码 · 共 32 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="checkadmin.jsp"%>
<jsp:useBean id="db" class="dbBean.DBBean" scope="session"/>
<center>
<h2>系统维护</h2>
<table border bordercolor="#0099FF">
<tr><th colspan="3" bgcolor='#CCFFFF'>删除投票项</th>
<%
	ResultSet rs=db.executeQuery("select * from vote");
	int i=1;
	while(rs.next())
	{
		out.println("<tr>");
		out.println("<td>"+i+"</td>");
		out.println("<td>"+rs.getString("item")+"</td>");
		out.println("<td align='center'><a href='delete.jsp?delid="+rs.getString("id")+"'>删除</a></td>");
		i++;
	}
	rs.close();
	db.close();
%>
<tr><th colspan="3" bgcolor='#CCFFFF'>添加投票项</th>
<tr><td colspan="3">
<form method="post" action="add.jsp">
内容：<input type="text" name="additem" size="30">
<input type="submit" value="提交">
<input type="reset" value="重置">
</form>
</td>
<tr><td colspan="3" align="center" bgcolor='#CCFFFF'><a href="index.jsp">返回投票页面</a></td>
</table>
</center>