📄 addmanagernewsstep2.jsp
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@ include file="../incoming/Common.jsp"%>
<%@ include file="../incoming/ConnectDB.jsp"%>
<%@ include file="../incoming/Check.jsp"%>
<%@ include file="../incoming/CodeFilter.jsp"%>
<%
String msg="";
String categoryid = "";
try
{
categoryid= new String(request.getParameter("categoryid").getBytes("ISO8859_1"),"GBK");
String newstitle = new String(request.getParameter("newstitle").getBytes("ISO8859_1"),"GBK");
String newsbody = new String(request.getParameter("newsbody").getBytes("ISO8859_1"),"GBK");
java.util.Date cur_time = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String adddate = formatter.format(cur_time);
String managerid=(String)session.getValue("UserName");
sql1 = "INSERT INTO News(Title,Body,AddDate,ManagerID,CategoryID) VALUES(?,?,?,?,?)";
PreparedStatement prepstmt = null;
prepstmt=con.prepareStatement(sql1);
prepstmt.setBytes(1,newstitle.getBytes("GB2312"));
prepstmt.setBytes(2,(toHtml(newsbody)).getBytes("GB2312"));
prepstmt.setBytes(3,adddate.getBytes("GB2312"));
prepstmt.setBytes(4,managerid.getBytes("GB2312"));
prepstmt.setInt(5,Integer.parseInt(categoryid));
prepstmt.executeUpdate();
sql1 = "UPDATE manager SET TotalNews=TotalNews+1 WHERE ManagerID=?";
prepstmt=con.prepareStatement(sql1);
prepstmt.setBytes(1,managerid.getBytes("GB2312"));
prepstmt.executeUpdate();
}
catch(Exception e)
{
msg = e.getMessage();
}
%>
<html>
<head>
<title><%=title%>管理</title>
<link href="../incoming/style.css" rel="stylesheet" type="text/css">
<script Language="JavaScript">
function ToManagerNewsMain()
{
top.location="Main.jsp?categoryid="+<%=categoryid%>;
}
</script>
</head>
<body>
<table border="1" width=700 align=center cellpadding=0 cellspacing=0>
<tr align="center" bgcolor="#CCCCCC" height=25>
<td height="42"><a class="title">发布新闻</a></TD>
</tr>
<tr>
<td height="56" align="center" ><div align="right"></div><span class="text">
<%
if(msg.equals(""))
out.println("发布新闻成功！");
else
out.println("发布新闻失败！错误原因："+msg);
%>
</span></td>
</tr>
<tr>
<td height="36" align=center ><FONT color=#000000>
<input name=Submit type=button value="返回新闻管理" onClick="ToManagerNewsMain()">
</font></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -