?? update.jsp
字號:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ include file="Conn.jsp" %>
<%@ page language="java" %>
<HTML>
<HEAD>
<TITLE>整筆記錄的修改</TITLE>
</HEAD>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>整筆記錄的修改</FONT>
</CENTER>
<BR>
<HR>
<BR>
<%
String BID = request.getParameter("tmpBookID"); //取得tmpBookID欄傳出的數據
String HID = request.getParameter("hidRecID"); //取得hidRecID欄傳出的數據
//判斷是否可取得表單中tmpBookID欄的傳出值
if(BID == null)
{
rs = stmt.executeQuery("SELECT * FROM Book"); //開啟ResultSet對象
%>
<CENTER>
<TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue>
<TD><B>書籍編號</B></TD><TD><B>書 名</B></TD>
<TD><B>售 價</B></TD></TR>
<%
while(rs.next())
{
%>
<TR>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("BookID") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("Title") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getInt("Price") %></B></TD>
</TR>
<%
}
%>
</TABLE>
<BR>
<P><FONT SIZE = 4 COLOR = red>請輸入欲進行數據修改之書號
</FONT></P>
<FORM action="" method=POST id=form2 name=form2>
<INPUT type="text" name=tmpBookID>
<INPUT type="submit" value="修改" name=submit1>
</FORM>
</CENTER>
<%
}
else if(HID == null) //若無法取得hidRecID欄的傳出值, 則產生數據修改表單
{
//建立查詢書籍數據的SQL字串
String strSQL = "SELECT * FROM Book WHERE " +
"BookID = '" + BID + "'";
rs = stmt.executeQuery(strSQL); //開啟ResultSet變量
if(!rs.next())
{
%>
<CENTER>
<P>找不到書號為
<FONT SIZE = 4 COLOR = red>
<%= BID %>
</FONT>的書籍<P>
<P><A HREF = Update.jsp>還要進行修改</A></P></CENTER>
<%
}
else
{
%>
<FORM action="Update.jsp" method=POST>
<TABLE>
<TR COLSPAN = 2 align=center>
<FONT SIZE = 4 COLOR = red>請在表單中進行數據的修改</FONT>
</TR>
<TR><TD>書籍編號</TD>
<TD>
<INPUT type="text" name=tmpBookID
value="<%= rs.getString("BookID")%>">
</TD></TR>
<TR><TD>書籍名稱</TD><TD>
<INPUT type="text" size=30 name=tmpTitle
value="<%=rs.getString("Title")%>">
</TD></TR>
<TR><TD>出版日期</TD><TD>
<INPUT type="text" name=tmpPDate
value="<%=rs.getString("PDate")%>">
</TD></TR>
<TR><TD>作 者</TD><TD>
<INPUT type="text" name=tmpAuthor
value="<%=rs.getString("Author")%>">
</TD></TR>
<TR><TD>價 格</TD><TD>
<INPUT type="text" name=tmpPrice
value="<%= rs.getInt("Price")%>">
</TD></TR>
<TR><TD>總頁數</TD><TD>
<INPUT type="text" name=tmpPages
value="<%=rs.getString("Pages")%>">
</TD></TR>
<TR><TD>備 注</TD></TR>
</TABLE>
<TEXTAREA rows=5 cols=40 name=txtaMemo><%= rs.getString("BookMemo")%>
</TEXTAREA>
<!--利用隱藏欄位傳遞欲修改記錄的編號-->
<INPUT type="hidden" name=hidRecID
value=<%= rs.getString("ID") %>><P></P>
<INPUT type="submit" value="進行修改" name=submit3>
<A HREF = Update.jsp>放棄修改</A></P></CENTER>
</FORM>
<%
}
}
else
{
String strDel = "DELETE * FROM Book WHERE ID = " + HID; //刪除舊數據的SQL敘述
stmt.executeUpdate(strDel); //利用SQL敘述將舊數據自數據庫中刪除
//建立新增數據至數據庫的SQL敘述
String strSQL = "INSERT INTO Book(BookID, Title, PDate, " +
"Author, Price, Pages, BookMemo) Values ('" +
ISOtoGb2312.convert(request.getParameter("tmpBookID"))+ "','" +
ISOtoGb2312.convert(request.getParameter("tmpTitle")) +"','" +
ISOtoGb2312.convert(request.getParameter("tmpPDate")) + "','" +
ISOtoGb2312.convert(request.getParameter("tmpAuthor")) + "'," +
ISOtoGb2312.convert(request.getParameter("tmpPrice")) + "," +
ISOtoGb2312.convert(request.getParameter("tmpPages")) + ",'" +
ISOtoGb2312.convert(request.getParameter("txtaMemo")) + "')";
stmt.executeUpdate(strSQL); //利用SQL敘述將數據新增至數據庫
strSQL = "SELECT * FROM Book WHERE BookID = '" + BID + "'"; //建立查詢書籍數據的SQL字串
rs = stmt.executeQuery(strSQL); //開啟ResultSet變量
rs.next(); //移至第一筆記錄
%>
<CENTER>
<H3><P><FONT SIZE = 5 COLOR = red>
<%= BID %>
</FONT>
修改后的詳細數據如下:</P></H3>
<TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>書籍編號
</B></TD><TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("BookID") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>書籍名稱
</B></TD><TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("Title") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>出版日期
</B></TD><TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("PDate") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>作 者
</B></TD><TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("Author") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>價 格
</B></TD><TD bgcolor=LightGoldenrodYellow>
<FONT SIZE = 4 COLOR = red><B>
<%= rs.getString("Price") %></B></FONT></B>
</TD></TR>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>總頁數
</B></TD><TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("Pages") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD bgcolor=SkyBlue><B>備 注
</B></TD><TD COLSPAN = 2 bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("BookMemo")%></B></TD></TR>
</TABLE>
<P><A HREF = Update.jsp>還要進行修改</A></P></CENTER>
<%
}
%>
</BODY>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -