📄 garbage.jsp

📁 该源码为JSP的开发案例集锦
💻 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">&lt;<%=rsList.getString("inform_adddate")%>&gt;&lt;<%=rsList.getString("depart_name")%>&gt;</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>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -