?? editupdate.jsp
字號:
<%@ page errorPage="error.jsp" %>
<%@ 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>企業(yè)內(nèi)部管理信息平臺-更新頁面</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");
//分別取得上傳的三個附件的路徑信息，并進行編碼轉(zhuǎn)換處理
author=new String(request.getParameter("author").getBytes("ISO8859_1"),"GBK");//取得記錄出處并進行編碼轉(zhuǎn)換
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");//取得記錄二級分類
//分別對標題、正文、一級分類和二級分類進行編碼轉(zhuǎn)換
ResultSet rs = sqlbean.executeQuery("select * from class where parentclass='"+parentclass+"' and class='"+class2+"'");
//調(diào)用sqlbean的executeQuery方法找到類別標識，并將結(jié)果賦予rs這個記錄集
rs.first(); //如果返回的記錄集不為空
String classid2=rs.getString("id");
rs.close();
int classid = Integer.parseInt(classid2);//將要添加的類ID轉(zhuǎn)換為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);//調(diào)用sqlbean的executeUpdate方法對數(shù)據(jù)庫的當(dāng)前記錄進行更新
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>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -