?? upddata.jsp
字號:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ include file="Conn.jsp" %>
<HTML>
<HEAD>
<TITLE>修改數據</TITLE>
</HEAD>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>修改數據</FONT>
</CENTER>
<BR>
<HR>
<BR>
<%
String Submit = request.getParameter("submit1"); //取得指令按鈕傳出的數據
//判斷是否可取得表單中指令按鈕的傳出值
if(Submit == 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循環配合next方法將數據表中的記錄列出
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>
</CENTER>
<BR>
<P><FONT SIZE = 4 COLOR = red>請輸入欲修改售價的書號與新價格
</FONT></P>
<FORM action="UpdData.jsp" method=POST id=form2 name=form2>
書號:<INPUT type="text" name=tmpBookID><BR>
價格:<INPUT type="text" name=tmpNewPrice>
<INPUT type="submit" value="修改" name=submit1>
</FORM>
<%
}
else
{
String BID = request.getParameter("tmpBookID");
String Price = request.getParameter("tmpNewPrice");
//建立查詢書籍數據的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>
<%
}
else
{
String strUpd = "UPDATE Book SET PRICE = " +
Price + " WHERE BookID = '" +
BID + "'";
stmt.executeUpdate(strUpd); //執行數據更新語句
rs = stmt.executeQuery(strSQL); //執行SQL語句取得修改后的書籍數據
rs.next(); //移至第一筆記錄
%>
<CENTER>
<H3><P><FONT SIZE = 5 COLOR = red>
<%= BID %>
</FONT>
修改后的詳細數據如下:</P></H3>
<TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue><TD><B>書籍編號</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("BookID") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>書籍名稱</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("Title") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>出版日期</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("PDate") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>作 者</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("Author") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>價 格</B></TD>
<TD bgcolor = pink><B><FONT SIZE = 4 COLOR = red><B>
<%= rs.getInt("Price") %>
</B></FONT></TD></TR>
<TR bgcolor=SkyBlue><TD><B>總頁數</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getInt("Pages") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>備 注</B></TD>
<TD COLSPAN = 2 bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("BookMemo")%></B>
</TD></TR></TABLE>
<%
}
%>
<P><A HREF = UpdData.jsp>還要進行修改</A></P></CENTER>
<%
}
%>
</BODY>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -