B - S模式系统开发实训指导书120524 - 图文

goodsID = rs.getInt(1); goodsName = rs.getString(2); introduce = rs.getString(3); nowprice = rs.getFloat(4); picture = rs.getString(5); %>

conn.close(); %>

（4）特价书页面的设计： 该页面效果如图 26 所示：

图 3-11 特价书sale.jsp的效果图

特价书sale.jsp关键代码如下：

<%@ page contentType=\ import=\<%@ page import=\<% connDB conn = new connDB(); String username = (String) session.getAttribute(\ ResultSet rs = conn .executeQuery(\sale=1 order by GoodsName\ int goodsID = -1; String goodsName = \ String introduce = \ float price = (float) 0.0; float nowprice = (float) 0.0; String picture = \%>

conn.close(); %>

（5）图书的详细信息页面设计 该页面效果如图 26 所示：

图 3-12图书的详细信息good_detail.jsp的效果图

图书的详细信息页面设计good_detail.jsp 关键代码如下：

<%@ page contentType=\<%@ page import=\<% connDB conn = new connDB(); String username = (String) session.getAttribute(\ int ID = -1; ID = Integer.parseInt(request.getParameter(\ if (ID > 0) { ResultSet rs = conn .executeQuery(\ID,GoodsName,Introduce,nowprice,picture from tb_goods where ID=\+ ID); int goodsID = -1; String goodsName = \ String introduce = \ float nowprice = (float) 0.0; String picture = \ if (rs.next()) { goodsID = rs.getInt(1); goodsName = rs.getString(2); introduce = rs.getString(3); nowprice = rs.getFloat(4); picture = rs.getString(5); }