📄 addnews.jsp
字号:
<%@page contentType="text/html; charset=ISO8859_1" language="java" %>
<%
String news_location="";
String action=request.getParameter("action");
if(action==null)
{action="";}
if(action.equals("AddNews"))
{news_location="addnews";}
else
{news_location="listnews";}
%>
<%@ include file="session.jsp" %>
<%@page import="Eclass.News"%>
<%@ include file="config.jsp" %>
<%
java.sql.ResultSet rs=null;
java.sql.ResultSet rs1=null;
java.sql.ResultSet rs2=null;
String go=request.getParameter("go");
String title="",writer="",keyboard="",newstext="",befrom="",time="",newspath="",query="",select="",edit_classid="";
int bclassid=0,classid=0,newsid=0;
if(go==null)
{go="";}
//删除新闻
if(action.equals("DelNews"))
{News empire=new News();
newsid=Integer.parseInt(request.getParameter("newsid"));
empire.DelNews(news_basic_path,newsid);
%>
<script>
alert("删除新闻成功");self.location.href='ListNews.jsp';
</script>
<%
return;
}
//增加新闻
if(go.equals("ok")&&action.equals("AddNews"))
{
News empire=new News();
title=new String(request.getParameter("title").getBytes("ISO8859-1"),"gb2312");
writer=new String(request.getParameter("writer").getBytes("ISO8859-1"),"gb2312");;
bclassid=Integer.parseInt(request.getParameter("bclassid"));
classid=Integer.parseInt(request.getParameter("classid"));
keyboard=request.getParameter("keyboard");
newstext=new String(request.getParameter("newstext").getBytes("ISO8859-1"),"gb2312");
befrom=new String(request.getParameter("befrom").getBytes("ISO8859-1"),"gb2312");
empire.AddNews(news_basic_path,title,writer,bclassid,classid,keyboard,newstext,befrom);
%>
<script>
self.location.href='AddNews.jsp?action=AddNews';
</script>
<%
return;
}
//修改新闻
if(go.equals("ok")&&action.equals("EditNews"))
{
News empire=new News();
newsid=Integer.parseInt(request.getParameter("newsid"));
title=new String(request.getParameter("title").getBytes("ISO8859-1"),"gb2312");
writer=new String(request.getParameter("writer").getBytes("ISO8859-1"),"gb2312");
bclassid=Integer.parseInt(request.getParameter("bclassid"));
classid=Integer.parseInt(request.getParameter("classid"));
keyboard=request.getParameter("keyboard");
newstext=new String(request.getParameter("newstext").getBytes("ISO8859-1"),"gb2312");
befrom=new String(request.getParameter("befrom").getBytes("ISO8859-1"),"gb2312");
time=request.getParameter("time");
newspath=request.getParameter("newspath");
empire.EditNews(news_basic_path,newspath,newsid,title,writer,bclassid,classid,keyboard,newstext,befrom,time);
%>
<script>
alert("修改新闻成功");self.location.href='ListNews.jsp';
</script>
<%
return;
}
%>
<jsp:useBean id=empire1 scope="page" class="Eclass.jdbc_sql" />
<%
if(action.equals("EditNews"))
{
newsid=Integer.parseInt(request.getParameter("newsid"));
rs2=empire1.query("select title,writer,bclassid,classid,keyboard,newstext,befrom,time,newspath from enews_news where newsid="+newsid);
rs2.next();
title=rs2.getString("title");writer=rs2.getString("writer");bclassid=rs2.getInt("bclassid");
classid=rs2.getInt("classid");keyboard=rs2.getString("keyboard");newstext=rs2.getString("newstext");
befrom=rs2.getString("befrom");time=rs2.getString("time");newspath=rs2.getString("newspath");
rs2.close();
}
//类别
int i=0;
String big_options="";
rs=empire1.query("select bclassid,bclassname from enews_bclass");
%>
<html>
<head><title>新闻发布系统</title>
<meta http-equiv=Content-Type content=text/html; charset=gb2312>
<link rel="stylesheet" href="../images/ebb.css" type="text/css">
<meta http-equiv="MSThemeCompatible" content="Yes">
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT language=javascript>
function click()
{if(event.button==2)
{
alert('欢迎来到王猛的新闻发布系统')}}
document.onmousedown=click
</SCRIPT>
<script>
function on()
{
var f=document.add
f.HTML.value=f.newstext.value;
}
function mybclass()
{
bclass=new Array();
bclass[0]=new Array();
bclass[0][0]="0";
bclass[0][1]="请选择类别";
<%
while(rs.next())//显示大类
{i++;
if(rs.getInt("bclassid")==bclassid)
{select=" selected";}
else
{select="";}
%>
bclass[<%=i%>]=new Array();
bclass[<%=i%>][0]="<%=rs.getInt("bclassid")%>";
bclass[<%=i%>][1]="<%=rs.getString("bclassname")%>";
<%
big_options+="<option value="+rs.getInt("bclassid")+select+">"+rs.getString("bclassname")+"</option>";
}
i=0;
rs1=empire1.query("select classid,bclassid,classname from enews_class");//显示小类
%>
}
function myclass()
{
class1=new Array();
<%
while(rs1.next())
{if(classid==rs1.getInt("classid"))
{edit_classid="<option value="+classid+">"+rs1.getString("classname")+"</option>";}
%>
class1[<%=i%>]=new Array();
class1[<%=i%>][0]="<%=rs1.getInt("classid")%>";
class1[<%=i%>][1]="<%=rs1.getString("classname")%>";
class1[<%=i%>][2]="<%=rs1.getInt("bclassid")%>";
<%
i++;
}
%>
}
mybclass();
myclass();
function changeitem(myfrm)
{
var SelectedBigId,i,j;
for (i= myfrm.classid.options.length-1;i>=0 ;--i)
{
myfrm.classid.options[i] = null;
}
SelectedBigId = myfrm.bclassid.options[myfrm.bclassid.selectedIndex].value;
j = 0;
for (i=0 ;i< class1.length ;i++)
{
if (SelectedBigId == class1[i][2])
{
myfrm.classid.options[j] = new Option(class1[i][1],class1[i][0]);
++j;
}
}
}
function writer(tag){
var f=document.add.writer
f.value=tag+f.value
f.focus()
}
function clear(){
if(confirm("是否复位作者信息？")){
document.add.writer.value=""
document.add.writer.focus()
}
}
function bs(){
var f=document.add
f.newstext.value=f.HTML.value;
if(f.title.value.length==0){alert("标题没写");f.title.focus();return false}
if(f.classid.value.length==0){alert("请选择新闻类别");f.classid.focus();return false}
if(f.newstext.value.length==0){alert("正文没写");f.newstext.focus();return false}
}
function br(){
if(!confirm("是否复位？")){return false;}
document.add.title.select()
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" onload="on();">
<form name="add" method="post" onsubmit="return bs()" onreset="return br()" action=AddNews.jsp>
<input type=hidden name=go value=ok>
<input type=hidden name=action value=<%=action%>>
<input type=hidden name=newsid value=<%=newsid%>>
<input type=hidden name=time value=<%=time%>>
<input type=hidden name=newspath value=<%=newspath%>>
<table width="588" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="2">
<div align="center">新闻增加</div>
</td>
</tr>
<tr>
<td width="80">标题：</td>
<td width="506"><input type=text name=title value="<%=title%>">
图文： 是
<input type="checkbox" name="tw" value="1">
</td>
</tr>
<tr>
<td width="80">版权信息:<br>
</td>
<td width="506">
<input type=text name=writer value="<%=writer%>" size=10>来源:<input type=text name=befrom value="<%=befrom%>" size=10>[
<a href="javascript:writer('摘自:')">摘自:</a> | <a href="javascript:writer('编译:')">
编译:</a> | <a href="javascript:writer('源作者:')">源作者:</a> |
<a href="javascript:writer('转载自:')">转载自:</a> ] [
<a href="javascript:clear()">清空作者信息</a> ] [
<a href="javascript:tj('[推荐]')">推荐</a> ]
</td>
</tr>
<tr>
<td width="80">新闻类别:<br>
</td>
<td width="506">
<select name="bclassid" onchange="javascript:changeitem(document.add);">
<option value=0>请选择类别</option>
<%=big_options%>
</select>
<select name="classid"><%=edit_classid%>
</select>
</td>
</tr>
<tr>
<td height="15" width="80">新闻正文:<br>
</td>
<td height="15" rowspan="4">
<OBJECT id=HTML data=editor/editor.html width=500 height=293 type=text/x-scriptlet></object><textarea style="DISPLAY:none" name="newstext"><%=newstext%></textarea>
</td>
</tr>
<tr>
<td width="80"> </td>
</tr>
<tr>
<td width="80"> </td>
</tr>
<tr>
<td width="80"> </td>
</tr>
<tr>
<td>
<div align="left"> </div>
</td>
<td>
<input type="submit" name="ok" value="提交">
<input type="reset" name="Submit2" value="重置">
</td>
</tr>
</table>
</form>
</body>
</html>
<%
rs.close();
rs1.close();
empire1.closestmt();
empire1.closeconn();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -