?? paraqry.jsp
字號(hào):
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ include file="Conn.jsp" %>
<HTML>
<HEAD>
<TITLE>參數(shù)式查詢</TITLE>
</HEAD>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>參數(shù)式查詢</FONT>
</CENTER>
<HR>
<%
String BID = request.getParameter("tmpBookID"); //取得從tmpBookID控制項(xiàng)傳出的數(shù)據(jù)
if( BID == null) //判斷是否取得從tmpBookID控制項(xiàng)中傳遞過來的數(shù)據(jù)
{
rs = stmt.executeQuery("SELECT BookID, Title FROM BOOK"); //建立ResultSet(結(jié)果集)變量，并執(zhí)行SQL語句
%>
<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightYellow>
<TR bgcolor=DeepSkyBlue>
<TD><B>書籍編號(hào)</B></TD><TD><B>書 名</B></TD>
</TR>
<%
while(rs.next()) //利用while循環(huán)配合next方法將數(shù)據(jù)表中的記錄列出
{
%>
<TR>
<TD><B><%= rs.getString("BookID") %></B></TD>
<TD><B><%= rs.getString("Title") %></B></TD>
</TR>
<%
}
%>
</TABLE><P></P>
<P><FONT SIZE = 4 COLOR = red>請(qǐng)輸入欲查看詳細(xì)數(shù)據(jù)之書號(hào)
</FONT></P>
<FORM action="ParaQry.jsp" method=POST name=form2>
<INPUT type="text" name=tmpBookID>
<INPUT type="submit" value="進(jìn)行查詢" name=submit1>
</FORM>
<%
}
else
{
String strSQL = "SELECT * FROM Book WHERE BookID = '" + BID + "'"; //建立查詢書籍?dāng)?shù)據(jù)的SQL字串
rs = stmt.executeQuery(strSQL); //建立ResultSet(結(jié)果集)變量, 并執(zhí)行SQL語句
if (!rs.next())
{
%>
<CENTER>
<P>找不到書號(hào)為
<FONT SIZE = 4 COLOR = red>
<%= BID %>
</FONT>的書籍<P>
<%
}
else
{
%>
<CENTER>
<H3><P><FONT SIZE = 5 COLOR = red>
<%= BID %>
</FONT>
的詳細(xì)數(shù)據(jù)如下:</P></H3>
<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue>
<TR><B><TD bgcolor=LightYellow><B>書籍編號(hào)</B></TD>
<TD><B><%= rs.getString("BookID")%></B></TD></TR>
<TR><TD bgcolor=LightYellow><B>書籍名稱</B></TD>
<TD><B><%= rs.getString("Title")%></B></TD></TR>
<TR><TD bgcolor=LightYellow ><B>出版日期</B></TD>
<TD><B><%= rs.getDate("PDate")%></B></TD></TR>
<TR><TD bgcolor=LightYellow><B>作 者</B></TD>
<TD><B><%= rs.getString("Author")%></B></TD></TR>
<TR><TD bgcolor=LightYellow ><B>價(jià) 格</B></TD>
<TD><B><%= rs.getString("Price")%></B></TD></TR>
<TR><TD bgcolor=LightYellow><B>總頁數(shù)</B></TD>
<TD><B><%= rs.getString("Pages")%></B></TD></TR>
<TR><TD bgcolor=LightYellow><B>備 注</B></TD>
<TD COLSPAN = 2><B><%= rs.getString("BookMemo")%>
</TD></TR>
</TABLE>
<%
}
%>
<P><A HREF = ParaQry.jsp>重新查詢</A></P></CENTER>
<%
}
%>
</BODY>
</HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -