【JSP开源代码栏目提醒】:网学会员为需要JSP开源代码的朋友们搜集整理了admin_vote.jsp相关资料,希望对各位网友有所帮助!
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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=gb2312">
<title>管理投票系统</title>
</head>
<link rel="stylesheet" type="text/css" href="css/css.css">
<script>
function check()
{
if(additem.itemname.value==""){alert("请输入添加项目!");additem.itemname.focus();return false;}
}
</script>
<body>
<jsp:useBean id="vote" scope="session" class="test.Conndb"/>
<form action="Additem.jsp" name="additem" method="post" onsubmit="return check()">
<table cellpadding="0" cellspacing="1" width="500" align="center">
<tr bgcolor="#99ccff">
<td width="127" align="center">添加投票项目</td>
<td width="205"><input type="text" name="itemname" style="background-color:#99ccff;border-color:black;border:1px solid;"></td>
<td width="162"><input type="submit" name="add" value="添加" style="background-color:#99ccff;border-color:black;border:1px solid;"></td>
</tr>
</table>
</form>
<table width="100%" cellpadding="0" cellspacing="1" align="center">
<tr bgcolor="#99ccff">
<td align="center">序 号</td>
<td align="center">选 项</td>
<td align="center">投 票 率</td>
<td align="center" colspan="3">行 为</td>
</tr>
<%
ResultSet totrs = vote.query("select sum(v_num) as totnum from vote_tab");
totrs.next();
int tot_num = totrs.getInt("totnum");
totrs.close();
ResultSet rs = vote.query("select * from vote_tab");
int i=1;
while(rs.next())
{
int v_num = rs.getInt(3);
%>
<tr>
<td height="22" align="center">
[<%=i%>]</td>
<td height="27" align="center" nowrap>
<%=rs.getString(2).trim()%>
</td>
<td nowrap>
投票率:<img src="images/1.bmp" width="<%=Math.floor(v_num*200/tot_num)%>" height="10"> <%=Math.floor(v_num*100/tot_num)%>% [得:<%=v_num%>票 共:<%=tot_num%>票]</td>
<td align="center">[<a href="Update.jsp?id=<%=rs.getInt(1)%>">修 改</a>]</td>
<td align="center">[<a href="Delete.jsp?id=<%=rs.getInt(1)%>">删 除</a>]</td>
</tr>
<%
i++;
}
rs.close();
%>
<tr bgcolor="#99ccff">
<td colspan="5" height="18" align="center">[<a href="index.jsp">返回首页</a>]</td>
</tr>
</table>
</body>
</html>
上一篇:
admin_var.jsp
下一篇:
高中生2016外国励志名言精选