editnews.jsp
来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 199 行
JSP
199 行
<%@ page contentType="text/html; charset=gb2312"%>
<%@ include file="verify.jsp" %>
<%@ include file="../share/connection.jsp" %>
<%@ include file="../share/function.jsp" %>
<%
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;
int newsdepartid;
String newscontent;
String sqlList;
String sqlDepart;
String sqlNews;
String sqlSaveEdit;
int ishtml;
ResultSet rsNews;
ResultSet rsList;
ResultSet rsDepart;
String action=request.getParameter("action");
String actionArray[]={"list","edit","save"};
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>
<%
sqlList="select news_id,news_title,news_adddate,depart_name,news_ip "
+" from cs_news left join cs_depart on news_departid=depart_id"
+" order by news_id desc ";
//sqlList="select * from cs_news order by news_adddate desc";
rsList=stm.executeQuery(sqlList);
while(rsList.next())
{
String titlename=rsList.getString("news_title");
String news_ip=rsList.getString("news_ip");
String news_adddate=rsList.getString("news_adddate");
%>
<table width="100%" align="center" class="table">
<tr>
<td width="179" align="left"><% out.print(titlename);
%> </td>
<td width="134"><font color="#7299D3"><<%out.print(news_adddate);%>></font></td><td width="116"><font color="#7299D3"><<%=rsList.getString("depart_name")%>></font></td>
<td width="115"><font color="#7299D3"><IP:<% out.print(news_ip);%>></font>
</td>
<td width="110"><div align="right"><a href="editnews.jsp?action=edit&newsid=<%=rsList.getInt("news_id")%>">编辑</a>
||<a href="shixiao_news.jsp?newsid=<%=rsList.getInt("news_id")%>">失效</a>||<a href="delnews.jsp?newsid=<%=rsList.getInt("news_id")%>">删除</a></div></td>
</tr>
</table>
<%
out.print("<br>");
}
break;
case 1:
newsid=request.getParameter("newsid");
sqlNews="select * from cs_News where news_id="+newsid;
rsNews=stm.executeQuery(sqlNews);
rsNews.next();
newscontent=rsNews.getString("news_content");
newstitle=rsNews.getString("news_title");
//out.print(newstitle);
ishtml=rsNews.getInt("news_ishtml");
%>
</td>
</tr>
</table>
<FORM name=frmNewsInfo action='editnews.jsp?action=save' method=post >
<TABLE width="67%" 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="67%" align=center cellpadding=3 cellspacing=1 style="border:1px solid #003366">
<TBODY>
<TD width=9% ><b>标题：</b><BR> </TD>
<TD width="91%" colspan="2">
<input type="text" name="title" size="60" value='<%= newstitle %>'>
</TD>
</TR>
<TR>
<TD > </TD>
<TD>这个新闻是<%=(ishtml==0)?"纯文本":"html"%>格式</TD>
</TR>
<TR>
<TD ><B>内容</B><BR> </TD>
<TD> <textarea name="content" cols="60" rows="15">
<%
if(ishtml==1)
{out.println("<html>"+newscontent+"<html>");}
else
{out.println(newscontent);}
%>
</textarea></TD>
</TR>
<TR align="center">
<TD colspan="2" >
<input type="hidden" name="newsid" value="<%=newsid%>">
<input type="hidden" name="ishtml" value="<%=ishtml%>">
<input type=submit value="确 认" name=Submit>
<input type=reset value="清 除" name=reset>
<input type="button" name="Cancel" value="返 回" onClick="history.back()"> </TD>
</TR>
</table>
</form>
<%
break;
case 2:
newsid=request.getParameter("newsid");
newstitle=request.getParameter("title");
newscontent=request.getParameter("content");
newstitle=myTools.addSlashes(newstitle);
newscontent=myTools.addSlashes(newscontent);
ishtml = Integer.parseInt(request.getParameter("ishtml"));
if(ishtml != 0)
{
newscontent = myTools.addSlashes(newscontent);
}
java.util.Calendar cal=java.util.Calendar.getInstance();
String editDate=cal.get(cal.YEAR)+"-"
+(cal.get(cal.MONTH)+1)+"-"
+cal.get(cal.DAY_OF_MONTH);
sqlNews="UPDATE cs_news SET "
+"news_title="+"'"+newstitle+"',"
+"news_content="+"'"+newscontent+"',"
+"news_editdate="+"'"+editDate+"',"
+"news_editby=0 "
+"where news_id="+newsid;
if(stm.executeUpdate(sqlNews)==1)
{
out.print("修改新闻成功");
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?