?? voteadmin.jsp
字號:
<%@page
language="java"
contentType="text/html;charset=GBK"
%>
<%@include file="session.jsp"%>
<%@include file="/config.jsp"%>
<%@include file="/jdbc_database.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<META HTTP-EQUIV="Expires" CONTENT="0">
<meta http-equiv="Cache-Control" content="no-store">
<meta name="GENERATOR" content="BUPTICET">
<meta name="ProgId" content="BUPTICET.NetOffice">
<LINK rel="stylesheet" type="text/css" href="../css/style.css">
<SCRIPT LANGUAGE="JavaScript" src="/scripts/script.js" TYPE="text/javascript"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
function changeorder(order,desc,pagenum)
{
location="voteadmin.jsp?order="+order+"&desc="+desc+"&pagenum="+pagenum;
}
</SCRIPT>
<script language="JavaScript">
function dele()
{
if(confirm('確認要刪除此投票項目嗎？'))
{
return true;
}
else
{
return false;
}
}
</script>
</head>
<body class="mainBody">
<%
String tempstr="";
String sqlstr="";
String title="全部投票項目";
String statestr="";
String orderstr="",descstr="",wherestr="";
int ordernum=0,descnum=0;
int pagesize=20,pagenum=1,count=0,pagecount=1,startrow=0;
try
{
//刪除
if(request.getParameter("deleteid")!=null)
{
sqlstr="delete from vote where id='"+request.getParameter("deleteid")+"'";
statement.executeUpdate(sqlstr);
}
ordernum=(request.getParameter("order")==null)?0:Integer.valueOf(request.getParameter("order")).intValue();
descnum=(request.getParameter("desc")==null)?1:Integer.valueOf(request.getParameter("desc")).intValue();
descstr=(descnum>0)?" desc":"";
switch (ordernum)
{
case 0:
orderstr=" order by id"+descstr;
break;
case 1:
orderstr=" order by brif"+descstr;
break;
case 2:
orderstr=" order by num"+descstr;
break;
case 3:
orderstr=" order by type"+descstr;
break;
default:
orderstr=" order by id"+descstr;
}
if(request.getParameter("statestr")!=null)
{
int state=Integer.valueOf(request.getParameter("statestr")).intValue();
switch (state)
{
case 0:
tempstr="你還沒有選擇要查看的相應的調查！";
break;
case 1:
tempstr="對不起！沒有找到您請求的頁面！";
break;
case 2:
tempstr="恭喜！您修改投票項目成功！";
break;
case 3:
tempstr="對不起！您訪問的頁面出錯，請重試！";
break;
case 4:
tempstr="您請求的頁面不能直接訪問！";
break;
case 5:
tempstr="恭喜！您添加投票項目成功！！";
break;
case 6:
tempstr="對不起，沒有查到這條紀錄，請先選擇您要訪問的紀錄！";
break;
case 10:
tempstr="內(外)網只能顯示一個投票！";
break;
}
statestr="<table width=100% border=0><tr height=30><td> <font color=\""+Page_warncolor+"\">"+tempstr+"</font></td></tr></table>";
out.println(statestr);
}
descnum=(descnum+1)%2;
descstr=(descnum>0)?"降序":"升序";
//定義分頁參數
if(request.getParameter("pagenum")==null)
pagenum=1;
else
pagenum=Integer.valueOf(request.getParameter("pagenum")).intValue();
sqlstr="select count(*) from vote where voteid=0";
result=statement.executeQuery(sqlstr);
if(result.next())
count=result.getInt(1);
pagecount=(count+pagesize-1)/pagesize;
pagecount=(pagecount<1)?1:pagecount;
pagenum=(pagenum>pagecount)?pagecount:pagenum;
startrow=(pagenum-1)*pagesize;
%>
<!--***************************主體表格分界*****************************-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="35">
<tr>
<td width="25"><img src="../images/space.gif" width="25"></td>
<td width="55"><img src="../images/title_head.gif" width="55" height="35"></td>
<td width="100%" background="../images/title_bg.gif" valign="bottom"> <font size="3" face="黑體" color="#6600CC"> 投 票 設 置 </font>
<font size="2" color="#FF6600" face="Arial, Helvetica, sans-serif">——<%=title%></font></td>
</tr>
</table>
<div align=right>
<a href="voteadmin.jsp">全部投票項目</a>
<a href="voteaddnew.jsp">新增投票項目</a>
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="tableHead" align=center>
<td width='10%' nowrap><a onclick="javascript:changeorder(0,<%=descnum%>,1)" title="點擊可按投票項目ID的<%=descstr%>排列" style="cursor:hand"><font color="#6600CC">序號</font></a></td>
<td width="0%">|</td>
<td width='20%' nowrap><a onclick="javascript:changeorder(1,<%=descnum%>,1)" title="點擊可按投票項目標題的<%=descstr%>排列" style="cursor:hand"><font color="#6600CC">投票項目</font></a></td>
<td width="0%">|</td>
<td width='10%' nowrap><a onclick="javascript:changeorder(2,<%=descnum%>,1)" title="點擊可按投票數的<%=descstr%>排列" style="cursor:hand"><font color="#6600CC">投票數</font></a></td>
<td width="0%">|</td>
<td width='20%' nowrap><a onclick="javascript:changeorder(3,<%=descnum%>,1)" title="點擊可按投票項目類型的<%=descstr%>排列" style="cursor:hand"><font color="#6600CC">類型</font></a></td>
<td width="0%">|</td>
<td width='20%' nowrap><font color="#6600CC">修改</font></td>
<td width="0%">|</td>
<td width='20%' nowrap><font color="#6600CC">刪除</font></td>
<td width="0%">|</td>
</tr>
<%
int m=0,i=startrow+1;
String trbgcolor=Page_trbgcolor;
if(count!=0)
{
Statement statement2=con.createStatement();
ResultSet result2=null;
String typearray[]={"暫停使用","內網顯示","外網顯示"};
sqlstr="select id,brif,type from vote where voteid=0 "+orderstr+" limit "+startrow+","+pagesize;
result=statement.executeQuery(sqlstr);
while(result.next())
{
sqlstr="select sum(num) from vote where id="+result.getInt("id");
result2=statement2.executeQuery(sqlstr);
trbgcolor=(trbgcolor==Page_trbgcolor)?"#FFFFFF":Page_trbgcolor;
tempstr="<tr height=20 align=center onmouseover='selectRow(this)' onmouseout='unSelectRow(this)' bgcolor='"+trbgcolor+"'>";
tempstr+="<td><font color='"+Page_warncolor+"'>"+i+"</font></td>";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td align=left><a href=vote.jsp?id="+result.getInt("id")+" title='查看投票結果'>"+result.getString("brif")+"</a></td>";
tempstr+="<td width='0%'></td>"+"\r\n";
if(result2.next())
tempstr+="<td>"+result2.getInt(1)+"</td>";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td>"+typearray[result.getInt("type")]+"</td>";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td><a href=\"voteedit.jsp?editid="+result.getInt("id")+"\">修改</a></td>";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td><a href=\"voteadmin.jsp?deleteid="+result.getInt("id")+"\" onclick=\"return dele()\">刪除</a></td>";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="</tr>";
out.print(tempstr);
i++;
m++;
}
if(result2!=null)
{
result2.close();
result2=null;
}
if(statement2!=null)
{
statement2.close();
statement2=null;
}
}
for(int j=m;j<pagesize;j++)
{
trbgcolor=(trbgcolor==Page_trbgcolor)?"#FFFFFF":Page_trbgcolor;
tempstr="<tr height=21 align=center bgcolor='"+trbgcolor+"'>";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="<td width='0%'></td>"+"\r\n";
tempstr+="</tr>"+"\r\n";
out.print(tempstr);
}%>
</table>
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="16">
<tr>
<td height="16" background="../images/line.gif"> </td>
</tr>
</table>
<table width="540" border="0" cellspacing="0" cellpadding="0" height="18" align="center">
<tr valign="middle">
<td style="color:#6600CC;font-size:12px">
<span align="center">現有 <font color="#FF6600"><%=count%></font> 個投票項目</span>
<span align="center"> 共 <font color="#FF6600"><%=pagecount%></font> 頁 </span>
<span align="center">第 <font color="#FF6600"><%=pagenum%></font> 頁</span>
<%
descnum=(descnum+1)%2;
if(pagenum>1)
{
tempstr="<a href=voteadmin.jsp?order="+ordernum+"&desc="+descnum+"&pagechange=1&pagenum=1><font color='#6600CC'>首頁 </span></a>";
tempstr+="<a href=voteadmin.jsp?order="+ordernum+"&desc="+descnum+"&pagechange=1&pagenum="+(pagenum-1)+"><span align='center'><font color='#6600CC'><img border='0' src='../images/arrowleft2.gif' onMouseOver=\"this.src='../images/arrowleft.gif'\" onMouseOut=\"this.src='../images/arrowleft2.gif'\" width='10' height='10'> 上一頁</font></span></a> ";
}
else
{
tempstr="<font color='"+Page_thbgcolor+"'>首頁</font> <span align='center'><img border='0' src='../images/arrowleft.gif' width='10' height='10'> 上一頁</span></font> ";
}
out.print(tempstr);
if(pagenum<pagecount)
{
tempstr="<a href=voteadmin.jsp?order="+ordernum+"&desc="+descnum+"&pagechange=1&pagenum="+(pagenum+1)+"><span align='center'><font color='#6600CC'>下一頁 <img border='0' src='../images/arrowright2.gif' onMouseOver=\"this.src='../images/arrowright.gif'\" onMouseOut=\"this.src='../images/arrowright2.gif'\" width='10' height='10'></font></span></a> ";
tempstr+="<a href=voteadmin.jsp?order="+ordernum+"&desc="+descnum+"&pagechange=1&pagenum="+pagecount+"><span align='center'><font color='#6600CC'>末頁</font></span></a>";
}
else
{
tempstr="<font color='"+Page_thbgcolor+"'><span align='center'>下一頁 <img border='0' src='../images/arrowright.gif' width='10' height='10'></span> 末頁</font>";
}
out.print(tempstr);
%>
</td>
</tr>
</table>
<!--***************************主體表格分界*****************************-->
</body>
</html>
<%
}
catch(Exception e)
{
response.sendRedirect("/index.jsp?statestr=3");
return;
}
finally
{
try{
if(result!=null)
{
result.close();
result=null;
}
if(statement!=null)
{
statement.close();
statement=null;
}
if(con!=null)
{
con.close();
con=null;
}
}catch(Exception e){}
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -