📄 editupdate.jsp
字号:
<%@ page errorPage="error.jsp" pageEncoding="GBK"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
response.sendRedirect("login.jsp");
} %>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<html>
<head>
<title>企业内部管理信息平台-更新页面</title>
</head>
<body>
<%
String id,d,title2,tempclass2,news2,del,sql,tempclass1,author,file1,file2,file3;
del = (String)request.getParameter("delete");
id = (String)request.getParameter("id");
int idd = Integer.parseInt(id);
if(del!=null)
{
out.print("you select delete!");
sql="delete from news where id="+idd+"";
sqlbean.executeDelete(sql);
//out.print("<p align='center'><font face='Arial'><strong><br><big>Data deleted! </big><br>");
response.sendRedirect("editchoose.jsp");}
else
{file1=new String(request.getParameter("file1").getBytes("ISO8859_1"),"GBK");
file2=new String(request.getParameter("file2").getBytes("ISO8859_1"),"GBK");
file3=new String(request.getParameter("file3").getBytes("ISO8859_1"),"GBK");
//分别取得上传的三个附件的路径信息，并进行编码转换处理
author=new String(request.getParameter("author").getBytes("ISO8859_1"),"GBK");//取得记录出处并进行编码转换
String news=new String(request.getParameter("news").getBytes("ISO8859_1"),"GBK");//取得记录正文
String title=new String(request.getParameter("title").getBytes("ISO8859_1"),"GBK"); //取得记录标题
String parentclass=new String(request.getParameter("selMain").getBytes("ISO8859_1"),"GBK");//取得记录一级分类
String class2=new String(request.getParameter("selSlave").getBytes("ISO8859_1"),"GBK");//取得记录二级分类
//分别对标题、正文、一级分类和二级分类进行编码转换
ResultSet rs = sqlbean.executeQuery("select * from class where parentclass='"+parentclass+"' and class='"+class2+"'");
//调用sqlbean的executeQuery方法找到类别标识，并将结果赋予rs这个记录集
rs.first(); //如果返回的记录集不为空
String classid2=rs.getString("id");
rs.close();
int classid = Integer.parseInt(classid2);//将要添加的类ID转换为int类型
sql="UPDATE news SET news = '" +news+ "',classid="+classid+",parentclass ='" +parentclass+ "', class ='" +class2+ "', author ='" +author+ "', title ='" +title+ "', file1 = '" +file1+ "',file2 = '" +file2+ "',file3 = '" +file3+ "' where id="+idd;
//进行更新操作的SQL语句
sqlbean.executeUpdate(sql);//调用sqlbean的executeUpdate方法对数据库的当前记录进行更新
out.print("<p align='center'><font face='Arial'><strong><br><big>Data edited! </big><br>");
}
%>
<big><br>
</big></strong><font color="#000080"><small><a href="editchoose.jsp">Edit More</a></small></font></font></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -