📄 delnews.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">
</head>

<body>
<%
String newsid=request.getParameter("newsid");
String sqlnews="select * from cs_news where news_id="+newsid;
ResultSet rsnews=stm.executeQuery(sqlnews);
	rsnews.next();
String	newscontent=rsnews.getString("news_content");
	 
	newscontent=new String(newscontent.getBytes("GBK"),"ISO8859_1");
String	newstitle=rsnews.getString("news_title");

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

int	ispublic=rsnews.getInt("news_ispublic");
int	editby=rsnews.getInt("news_editby");
   int ishtml=rsnews.getInt("news_ishtml");
int	level=rsnews.getInt("news_level");
int	departid=rsnews.getInt("news_departid");
 int   userid=rsnews.getInt("news_userid");
  int  outeraudit=rsnews.getInt("news_outeraudit");
  int  inneraudit=rsnews.getInt("news_inneraudit");
   int 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_2(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+"')";

stm.executeUpdate(sqlnews2);
String sqlDel="DELETE FROM cs_news where news_id="+newsid;

	if(stm.executeUpdate(sqlDel)==1)
        {
          out.print("删除成功");

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

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