📄 news_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 newsid;
String newstitle;
String newscontent;
int editby;

int ispublic;
int ishtml;
int departid;
int userid;
int level;
int isdel;
int outeraudit;
int inneraudit;
String sqlList;
String sqlnews;
String sqlSaveEdit;
//ResultSet rsnews;
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="delnews_1.jsp"><strong><font color="#66CCFF" face="宋体"><em>全部删除</em></font></strong></a> 
              <%
		 sqlList="select * from cs_news_2 left join cs_depart on news_departid=depart_id"
		+" order by news_adddate desc ";

//sqlList="select * from cs_news order by news_id desc";
rsList=stm.executeQuery(sqlList);
while(rsList.next())
{%>
            </p>
          </div>
        
          <table width="100%" align="center" class="table">
            <tr> 
              <td>
                <%
  out.print(rsList.getString("news_title"));%>
              </td>
              <td width="190"> <font color="#7299D3">&lt;<%=rsList.getString("news_adddate")%>&gt;&lt;<%=rsList.getString("depart_name")%>&gt;</font> 
              </td>
              <td width="115"> |<a href="news_garbage.jsp?action=edit&newsid=<%=rsList.getInt("news_id")%>">还原</a>||<a href="news_garbage.jsp?action=delet&newsid=<%=rsList.getInt("news_id")%>">永久删除</a> 
              </td>
            </tr>
          </table>
          <%
	  }
	  %>
	  </td></tr>
      </table>
	  </td>
	  </tr>
	  </table>
	  
	  <%
	  out.print("<br>");

	break;
case 1:
newsid=request.getParameter("newsid");
sqlnews="select * from cs_news_2 where news_id="+newsid;
ResultSet rsnews=stm.executeQuery(sqlnews);
	rsnews.next();
	newscontent=rsnews.getString("news_content");
	 
	newscontent=new String(newscontent.getBytes("GBK"),"ISO8859_1");
	newstitle=rsnews.getString("news_title");

newstitle=new String(newstitle.getBytes("GBK"),"ISO8859_1");
newstitle=myTools.addSlashes(newstitle);
newscontent=myTools.addSlashes(newscontent);

	ispublic=rsnews.getInt("news_ispublic");
	editby=rsnews.getInt("news_editby");
    ishtml=rsnews.getInt("news_ishtml");
	level=rsnews.getInt("news_level");
	departid=rsnews.getInt("news_departid");
    userid=rsnews.getInt("news_userid");
    outeraudit=rsnews.getInt("news_outeraudit");
    inneraudit=rsnews.getInt("news_inneraudit");
    isdel=rsnews.getInt("news_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 editDate=gcal.get(gcal.YEAR)+"-"
          //+(gcal.get(gcal.MONTH)+1)+"-"
          //+gcal.get(gcal.DAY_OF_MONTH);

String sqlnews2="INSERT INTO cs_news(news_title,news_content,"
	+"news_ispublic,news_editby,news_adddate,news_ishtml,news_level,news_departid,news_userid,news_id,news_outeraudit,news_inneraudit,news_isdel) "
	+"VALUES("
	+"'"+newstitle+"'," //news title
	+"'"+newscontent+"'," //news content
	+ispublic+","//if it's a popup news
	+editby+"," //num of days to expire

	+"'"+addDate+"','"+ishtml+"','"+level+"','"+departid+"','"+userid+"','"+newsid+"','"+outeraudit+"','"+inneraudit+"','"+isdel+"')";
String sqlDel="DELETE FROM cs_news_2 where news_id="+newsid;
stm.executeUpdate(sqlDel);


	if(stm.executeUpdate(sqlnews2)==1)
        {
          out.print("还原新闻成功");
        }
break;
case 2:

newsid=request.getParameter("newsid");
String sqlDel2="DELETE FROM cs_news_2 where news_id="+newsid;
if(stm.executeUpdate(sqlDel2)==1)
{
 out.print("删除成功");
   
}
}
%>

</body>
</html>
⌨️ 快捷键说明

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