📄 editnew.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">编辑新闻</font></div></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="20" colspan="5"></td>
</tr>
<%
int pagesize=15;
int allcount;
int allpage;
int intpage;
int i;
String strpage=request.getParameter("page");
if(strpage==null)
{
intpage=1;
}
else{
intpage=Integer.parseInt("strpage");
if(intpage<1) intpage=1;
}
String sql="select id,title,addid,addtime from news order by id desc";
ResultSet rs=data.executeQuery(sql);
rs.last();
allcount=rs.getRow();
allpage=(allcount+pagesize-1)/pagesize;
if(intpage>allpage) intpage=allpage;
if(allpage>0)
{
rs.absolute((intpage-1)*pagesize+1);
int id=rs.getInt("id");
String title=rs.getString("title");
String addid=rs.getString("addid");
String addtime=rs.getString("addtime").substring(0,16);
%>
<tr>
<td width="240" height="20"> <a href="editnew.jsp?id=<%=id%>"><%=title%></a></td>
<td width="120"><div align="center"><%=addtime%></div></td>
<td width="60"><div align="center"><%=addid%></div></td>
<td width="40"><div align="center"><a href="editnew.jsp?id=<%=id%>"><font color="#FF0000">编辑</font></a></div></td>
<td width="40"><div align="center"><a href="editnew.jsp?del=<%=id%>"><font color="#FF0000">删除</font></a></div></td>
</tr>
<%
i=1;
id=0;
title="";
addid="";
addtime="";
while(i<pagesize && rs.next())
{
id=rs.getInt("id");
title=rs.getString("title");
addid=rs.getString("addid");
addtime=rs.getString("addtime").substring(0,16);
%>
<tr>
<td width="240" height="20"> <a href="editnew.jsp?id=<%=id%>"><%=title%></a></td>
<td width="120"><div align="center"><%=addtime%></div></td>
<td width="60"><div align="center"><%=addid%></div></td>
<td width="40"><div align="center"><a href="editnew.jsp?id=<%=id%>"><font color="#FF0000">编辑</font></a></div></td>
<td width="40"><div align="center"><a href="editnew.jsp?del=<%=id%>"><font color="#FF0000">删除</font></a></div></td>
</tr>
<%
i++;
}}%>
<tr>
<td height="20" colspan="5"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" bgcolor="3969A5"></td>
</tr>
</table>
<form action="" method="post">
<div align="center">当前<font color="#FF0000"><%=intpage%></font>/<font color="#FF0000"><%=allpage%></font>页，每页<font color="#FF0000"><%=pagesize%></font>条
<%if(intpage>1)
{
if(intpage==1)
{%>
<a href="editnew.jsp?page=<%=intpage-1%>">上一页 </a>
<%} else{%>
<a href="editnew.jsp?page=<%=1%>">最前页</a><a href="editnew.jsp?page=<%=intpage-1%>"> 上一页</a>
<%}}%>
<%
if(intpage<allpage)
{
if(intpage==allpage)
{%>
<a href="editnew.jsp?page=<%=intpage+1%>">下一页</a>
<%}else{%>
<a href="editnew.jsp?page=<%=intpage+1%>">下一页 </a><a href="editnew.jsp?page=<%=allpage%>">最后页</a>
<%}}%>
</div>
</form>
<br><br><br>
<%
String getid=request.getParameter("id");
if(getid!=null && getid!="")
{
sql="select * from news where id='"+getid+"'";
rs=data.executeQuery(sql);
rs.next();
String title=rs.getString("title");
String text=rs.getString("text");
String addid=rs.getString("addid");
String nominate=rs.getString("nominate");
String pic=rs.getString("pic");
String chkpic=rs.getString("chkpic");
rs.close();
%>
<form action="upnew.jsp" method="post" enctype="multipart/form-data">
<input type="hidden" name="oldpic" value="<%=pic%>">
<input type="hidden" name="id" value="<%=getid%>">
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="3969A5" height="25"><div align="center"><font color="#FFFFFF">添加新闻</font></div></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="20" colspan="3"></td>
</tr>
<tr>
<td width="150" height="20"><div align="right">新闻主题:</div></td>
<td width="10"></td>
<td><input name="title" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=title%>" size="48" maxlength="50"></td>
</tr>
<tr>
<td height="20" valign="top"><div align="right">新闻内容:</div></td>
<td></td>
<td><textarea name="text" cols="50" rows="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"><%=text%></textarea></td>
</tr>
<tr>
<td height="20"><div align="right">添加人:</div></td>
<td></td>
<td><input name="addid" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=addid%>" size="12"></td>
</tr>
<tr>
<td height="20"><div align="right">是否推荐:</div></td>
<td></td>
<td>
<%if(nominate.equals("0")){%>
<input type="radio" name="nominate" value="1">不推荐
<input type="radio" name="nominate" value="0" checked>推荐
<%}else{%>
<input type="radio" name="nominate" value="1" checked>不推荐
<input type="radio" name="nominate" value="0">推荐
<%}%>
</td>
</tr>
<tr>
<td height="20"><div align="right">是否含图片: </div></td>
<td></td>
<td>
<%if(chkpic.equals("0")){%>
<input type="radio" name="chkpic" value="0" checked>是
<input type="radio" name="chkpic" value="1">否
<%}else{%>
<input type="radio" name="chkpic" value="0">是
<input type="radio" name="chkpic" value="1" checked>否
<%}%>
</td>
</tr>
<tr>
<td height="120" colspan="3"><div align="center">
<%if(pic.equals("")){%>
<img src="../images/nopic.gif" width="100" height="80" border="0">
<%}else{%>
<img src="../news/<%=pic%>" width="100" height="80" border="0">
<%}%>
</div></td>
</tr>
<tr>
<td height="20"><div align="right">修改图片:</div></td>
<td></td>
<td><input type="file" name="pic" size="40" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
</tr>
<tr valign="bottom">
<td height="30" colspan="3"><div align="center">
<input type="submit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="修改">
<input type="reset" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="复位">
</div></td>
</tr>
<tr>
<td height="20" colspan="3"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" bgcolor="3969A5"></td>
</tr>
</table>
</form>
<%}%>
<%
String del=request.getParameter("del");
if(del!="" && del!=null)
{
sql="delete from news where id='"+del+"'";
rs=data.executeQuery(sql);
response.sendRedirect("editnew.jsp");
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -