?? addnews.jsp
字號:
<%@page contentType="text/html; charset=gb2312" 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("gb2312"),"ISO8859-1");
writer=new String(request.getParameter("writer").getBytes("gb2312"),"ISO8859-1");;
bclassid=Integer.parseInt(request.getParameter("bclassid"));
classid=Integer.parseInt(request.getParameter("classid"));
keyboard=request.getParameter("keyboard");
newstext=new String(request.getParameter("newstext").getBytes("gb2312"),"ISO8859-1");
befrom=new String(request.getParameter("befrom").getBytes("gb2312"),"ISO8859-1");
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("gb2312"),"ISO8859-1");
writer=new String(request.getParameter("writer").getBytes("gb2312"),"ISO8859-1");
bclassid=Integer.parseInt(request.getParameter("bclassid"));
classid=Integer.parseInt(request.getParameter("classid"));
keyboard=request.getParameter("keyboard");
newstext=new String(request.getParameter("newstext").getBytes("gb2312"),"ISO8859-1");
befrom=new String(request.getParameter("befrom").getBytes("gb2312"),"ISO8859-1");
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>新聞發(fā)布系統(tǒng)</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>無標(biāo)題文檔</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT language=javascript>
function click()
{if(event.button==2)
{
alert('歡迎來到王猛的新聞發(fā)布系統(tǒng)')}}
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("是否復(fù)位作者信息?")){
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("標(biāo)題沒寫");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("是否復(fù)位?")){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">標(biāo)題:</td>
<td width="506"><input type=text name=title value="<%=title%>">
圖文: 是
<input type="checkbox" name="tw" value="1">
</td>
</tr>
<tr>
<td width="80">版權(quán)信息:<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('轉(zhuǎn)載自:')">轉(zhuǎn)載自:</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">新聞?wù)?<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();
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -