【JSP开源代码栏目提醒】:本文主要为网学会员提供garbage.jsp,希望对需要garbage.jsp网友有所帮助,学习一下!
<%@ page contentType="text/html; charset=gb2312"%>
<%@ include file="verify.jsp" %>
<%@ include file="../share/connection.jsp" %>
<%@ include file="../share/function.jsp" %>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.io.*"%>
<%
String name = (String)session.getAttribute("adminname");
if(!name.equals("admin"))
{
out.println("您没有此权限");
return;
}
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../jscss/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.table { border: #C4D3EC; border-style: solid; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px}
.cell { border: #285A9D; border-style: solid; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 1px}
-->
</style>
</head>
<body>
<%
int flag=0;
String informid;
String informtitle;
String informcontent;
int ispopup;
int isfly;
int isroll;
int ishtml;
int departid;
int userid;
int expire;
int isdel;
int outeraudit;
int inneraudit;
String sqlList;
String sqlinform;
String sqlSaveEdit;
//ResultSet rsinform;
ResultSet rsList;
String action=request.getParameter("action");
String actionArray[]={"list","edit","delet"};
for(int i=0;i<actionArray.length;i++)
{
if (action.equalsIgnoreCase(actionArray[i]))
{
flag=i;
break;
}
}
switch(flag)
{
case 0:
%>
<TABLE width="682" height=20
border=0 align="center" cellPadding=0 cellSpacing=0 background="../images/adminbg.gif" bgColor=#587dbc>
<TBODY>
<TR>
<TD><font color="#ffffff">
<div align="center"><strong><font color="#000000">通知回收中心</font></strong></div>
</font></TD>
</TR>
</TBODY>
</TABLE>
<table width="682" border="0" align="center" cellpadding="0" cellspacing="5" style="border:1px solid #003366">
<tr>
<td>
<br>
<table width="100%" border="0" align="center">
<tr>
</tr>
<tr>
<td bordercolor="#999999">
<div align="right">
<p><a href="delinform_1.jsp"><strong><font color="#66CCFF" face="宋体"><em>全部删除</em></font></strong></a>
<%
sqlList="select * from cs_inform_2 left join cs_depart on inform_departid=depart_id"
+" order by inform_adddate desc ";
//sqlList="select * from cs_inform order by inform_id desc";
rsList=stm.executeQuery(sqlList);
while(rsList.next())
{%>
</p>
</div>
<table width="100%" align="center" class="table">
<tr>
<td>
<%
out.print(rsList.getString("inform_title"));%>
</td>
<td width="190"> <font color="#7299D3"><<%=rsList.getString("inform_adddate")%>><<%=rsList.getString("depart_name")%>></font>
</td>
<td width="115"> |<a href="garbage.jsp?action=edit&informid=<%=rsList.getInt("inform_id")%>">还原</a>||<a href="garbage.jsp?action=delet&informid=<%=rsList.getInt("inform_id")%>">永久删除</a>
</td>
</tr>
</table>
<%
}
%>
</td></tr>
</table>
</td>
</tr>
</table>
<%
out.print("<br>");
break;
case 1:
informid=request.getParameter("informid");
sqlinform="select * from cs_inform_2 where inform_id="+informid;
ResultSet rsinform=stm.executeQuery(sqlinform);
rsinform.next();
informcontent=rsinform.getString("inform_content");
informcontent=new String(informcontent.getBytes("GBK"),"ISO8859_1");
informtitle=rsinform.getString("inform_title");
informtitle=new String(informtitle.getBytes("GBK"),"ISO8859_1");
informtitle=myTools.addSlashes(informtitle);
informcontent=myTools.addSlashes(informcontent);
ispopup=rsinform.getInt("inform_ispopup");
isfly=rsinform.getInt("inform_isfly");
isroll=rsinform.getInt("inform_isroll");
ishtml=rsinform.getInt("inform_ishtml");
expire=rsinform.getInt("inform_expire");
departid=rsinform.getInt("inform_departid");
userid=rsinform.getInt("inform_userid");
outeraudit=rsinform.getInt("inform_outeraudit");
inneraudit=rsinform.getInt("inform_inneraudit");
isdel=rsinform.getInt("inform_isdel");
Calendar cal=Calendar.getInstance();
String addDate=cal.get(cal.YEAR)+"-"
+(cal.get(cal.MONTH)+1)+"-"
+cal.get(cal.DAY_OF_MONTH);
java.util.GregorianCalendar gcal=new java.util.GregorianCalendar();
gcal.add(gcal.DAY_OF_MONTH,expire);
String expireDate=gcal.get(gcal.YEAR)+"-"
+(gcal.get(gcal.MONTH)+1)+"-"
+gcal.get(gcal.DAY_OF_MONTH);
String sqlinform2="INSERT INTO cs_inform(inform_title,inform_content,"
+"inform_ispopup,inform_expire,inform_expiredate,inform_adddate,inform_isfly,inform_isroll,inform_ishtml,inform_departid,inform_userid,inform_id,inform_outeraudit,inform_inneraudit,inform_isdel) "
+"VALUES("
+"'"+informtitle+"'," //inform title
+"'"+informcontent+"'," //inform content
+ispopup+","//if it's a popup inform
+expire+"," //num of days to expire
+"'"+expireDate+"'," //expire date
+"'"+addDate+"','"+isfly+"','"+isroll+"','"+ishtml+"','"+departid+"','"+userid+"','"+informid+"','"+outeraudit+"','"+inneraudit+"','"+isdel+"')";
String sqlDel="DELETE FROM cs_inform_2 where inform_id="+informid;
stm.executeUpdate(sqlDel);
if(stm.executeUpdate(sqlinform2)==1)
{
out.print("还原通知成功");
}
break;
case 2:
informid=request.getParameter("informid");
String sqlDel2="DELETE FROM cs_inform_2 where inform_id="+informid;
if(stm.executeUpdate(sqlDel2)==1)
{
out.print("删除成功");
}
}
%>
</body>
</html>
上一篇:
gameList.jsp
下一篇:
多年来只想说一句,我不怪你