📄 news_man.jsp
字号:
//log process
String sql_in = "insert into "+logrecord_table+" (logrecord_id,user_name,operation_time,logrecord_operation) values('','"+session.getValue("user_name")+"',now(),'delete news type: "+type_id+",board: "+board_id+", news_id: "+news_id+" ')";
NewsBean.executeUpdate(sql_in);
}
}
%>
<%@ include file = "func/header.jsp" %>
<body>
<script language="javascript">
function setid()
{
str='<div align="left">';
if(!window.form1.upcount.value)
window.form1.upcount.value=1;
//j=1
//str1 = window.form1.newsdetail_content+j+.value;
for(i=1;i<=window.form1.upcount.value;i++)
str+='新闻内容'+i+'<br> <textarea name="newsdetail_content'+i+'" cols="49" rows="9" class="textare"></textarea><br>相关图片'+i+' <input type="file" name="newsdetail_img'+i+'" size="41" class="input"><br><hr size=0 width=100%>';
window.upid.innerHTML=str+'</div>';
}
</script>
<div align=center>
新闻管理
<br>
<table width="90%" border="1" cellspacing="0" cellpadding="0" bordercolor="#00CC66" borderColorDark="#FFFFFF" borderColorLight="#00CC66">
<tr>
<td width="10%">
<div align="center">新闻编号</div>
</td>
<td width="35%">
<div align="center">新闻标题</div>
</td>
<td width="15%">
<div align="center">新闻作者</div>
</td>
<td width="17%">
<div align="center">新闻来源</div>
</td>
<td width="23%">
<div align="center">操 作</div>
</td>
</tr>
<%
//out.println(fileBean.getFieldValue("page"));
if(request.getParameter("page")==""||request.getParameter("page")==null)
intCurrentPage = 1;
else
{
intCurrentPage = Integer.parseInt(request.getParameter("page"));
if(intCurrentPage<1) intCurrentPage = 1;
} //得到当前页数
sql = "select * from "+news_table+" where type_id="+type_id+" and board_id="+board_id+" order by news_id desc";
rs = NewsBean.executeQuery(sql);
rs.last();
intRowCount = rs.getRow();
intPageCount = (intRowCount+intPageSize-1)/intPageSize;
if(intCurrentPage>intPageCount) intCurrentPage=intPageCount; //对当前页数的控制
if(intPageCount>0)
{
rs.absolute((intCurrentPage-1)*intPageSize+1);
//for(color=0,i=0;i<intPageSize&&!rs.isAfterLast();color++,i++)
i=0;
do {
%>
<tr>
<td width="10%">
<div align="center"><%=rs.getString("news_id")%></div>
</td>
<td width="35%">
<div align="center"><a href="..\newsdetail.jsp?news_id=<%=rs.getString("news_id")%>" target=_blank><%=rs.getString("news_title")%></a></div>
</td>
<td width="15%">
<div align="center"><%=rs.getString("news_author")%></div>
</td>
<td width="17%">
<div align="center"><%=rs.getString("news_source")%> </div>
</td>
<td width="23%">
<div align="center">
<a href="news_man.jsp?action=pass&news_id=<%=rs.getString("news_id")%>&news_audit=<% if(Integer.parseInt(rs.getString("news_audit"))==1) out.print("0"); else out.print("1"); %>&page=<%=intCurrentPage%>"><% if(Integer.parseInt(rs.getString("news_audit"))==1) {%> 取消审核 <%} else {%> 通过审核 <%} %></a>
<a href="news_man.jsp?action=edit&news_id=<%=rs.getString("news_id")%>&page=<%=intCurrentPage%>">编辑</a> <% if (user_power>=9999) { %>
<a href="news_man.jsp?action=delete&news_id=<%=rs.getString("news_id")%>&page=<%=intCurrentPage%>">删除</a><% } %></div>
</td>
</tr>
<%
i++;
}
while(rs.next()&&i<intPageSize);
}
%>
</table>
<br>
<%
if(intCurrentPage == 1) {
%> 首页 前页 <% }
else
out.println("<a href='news_man.jsp?page=1'>首页</a> <a href='news_man.jsp?page="+(intCurrentPage-1)+"'>前页</a> ");
if(intCurrentPage==intPageCount) {
%>后页 末页<% }
else
out.println("<a href='news_man.jsp?page="+(intCurrentPage+1)+"'>后页</a> <a href='news_man.jsp?page="+intPageCount+"'>末页</a> ");
%>
<hr size=0 width=100%>
<%
if(isedit==true)
{
sql = "select * from "+news_table+" where news_id="+news_id;
rs = NewsBean.executeQuery(sql);
rs.next();
}
%>
<form action="news_man.jsp" method="post" name="form1" enctype="MULTIPART/FORM-DATA" onsubmit="return formCheck()">
<input type="Hidden" name="action" value="<%if(isedit==true) out.print("modify"); else out.print("add"); %>">
<%if(isedit==true)
{
%>
<input type="Hidden" name="news_id" value="<%=news_id%>">
<%
}
%>
<table width="90%" border="1" cellspacing="0" cellpadding="2" bordercolor="#00CC66" borderColorDark="#FFFFFF" borderColorLight="#00CC66">
<tr>
<td><div align="right">新闻标题</div></td>
<td><div align="left">
<input name="news_title" type="text" class=input size="16" maxlength=100 value="<% if(isedit==true) out.print(rs.getString("news_title")); %>">
</div></td>
<td><div align="right">新闻作者</div></td>
<td><div align="left">
<input name="news_author" type="text" class=input size="16" maxlength=100 value="<% if(isedit==true) out.print(rs.getString("news_author")); %>">
</div></td>
</tr>
<tr>
<td><div align="right">关键字</div></td>
<td><div align="left">
<input name="keyword_value" type="text" class=input size="16" maxlength=100 value="<% if(isedit==true){ sql="select * from "+keyword_table+" where news_id="+news_id+" order by keyword_id"; rs1=NewsBean.executeQuery(sql); while(rs1.next()) temp=temp+rs1.getString("keyword_value")+","; out.println(temp); } %>">
</div></td>
<td><div align="right">如右格式：</div></td>
<td>学习，jsp，配置，</td>
</tr>
<tr>
<td><div align="right">新闻来源</div></td>
<td><input name="news_source" type="text" class=input size="16" maxlength=100 value="<% if(isedit==true) out.print(rs.getString("news_source")); %>"></td>
<td><div align="right"><input type="button" name="Button" onClick="setid();" value="设定" class="button"></div></td>
<td><input type="text" value="1" name="upcount" class=input size="16" maxlength=2></td>
</tr>
<tr>
<td colspan="4" id="upid">
<% if(isedit==true) {
sql="select * from "+newsdetail_table+" where news_id="+news_id+" order by newsdetail_id";
rs1=NewsBean.executeQuery(sql);
for(i=1;rs1.next();i++) {
%>
<div align="left">新闻内容<%=i%><br> <textarea name="newsdetail_content<%=i%>" cols="49" rows="9" class="textare"><%=StrTool.UnHtmlEncode(rs1.getString("newsdetail_content"))%></textarea><br>
相关图片<%=i%> <input type="file" name="newsdetail_img<%=i%>" size="41" class="input"><br><hr size=0 width=100%><br>
<%
}
}
else
{
%>
<div align="left">
新闻内容1<br> <textarea name="newsdetail_content1" cols="49" rows="9" class="textare"></textarea><br>
相关图片1 <input type="file" name="newsdetail_img1" size="41" class="input"><br><hr size=0 width=100%>
</div>
<%
}
%>
</td>
</tr>
<tr>
<td colspan="1">
<div align="right">状态</div>
</td>
<td colspan="3">
<div align="left">
<input type="radio" name="news_audit" value=1 checked>已审核
<input type="radio" name="news_audit" value=0>未审核
</div>
</td>
</tr>
</table>
<br>
<input type=submit value="确 定" class=button> <input type=reset value="重 置" class=button>
</form>
</div>
<SCRIPT language=JavaScript>
function formCheck()
{
if(document.form1.news_title.value=="")
{
alert("请输入新闻标题!");
document.form1.news_title.focus();
return false;
}
if(document.form1.news_author.value=="")
{
alert("请输入新闻作者!");
document.form1.news_author.focus();
return false;
}
if(document.form1.news_source.value=="")
{
alert("请输入新闻来源!");
document.form1.news_source.focus();
return false;
}
if(document.form1.newsdetail_content1.value=="")
{
alert("请输入新闻内容");
document.form1.newsdetail_content1.focus();
return false;
}
}
</SCRIPT>
<% rs.close();
NewsBean.close();
%>
<%@ include file = "func/footer.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -