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

<% } %>

查询模块search.jsp代码如下：

<%@ page contentType=\

ID,supertype order by supertype\

int id = -1; String typename = \%>

查询返回结果search_deal.jsp效果图如下：

图 3-9 查询search_deal.jsp效果图

查询结果search_deal.jsp主要代码如下：

<%@ page contentType=\<%@ page import=\<%@ page import=\<% connDB conn = new connDB(); chStr chStr = new chStr(); String username = (String) session.getAttribute(\ String type = request.getParameter(\ String key = chStr.chStr(request.getParameter(\ String sql = \ String typename = \ if (type != null) { if (!type.equals(\ sql = \ if (!key.equals(\

sql = sql + \

} ResultSet rs_type = conn.executeQuery(\

where ID=\

if (rs_type.next()) { typename = rs_type.getString(1); } } else { typename = \全部分类\ if (!key.equals(\ sql = \ } } sql = \ ResultSet rs_search = conn.executeQuery(sql); int goodsID = -1; String goodsName = \ String introduce = \ float nowprice = (float) 0.0;

%>

<%@include file=\

background=\

cellspacing=\

] <% while (rs_search.next()) { goodsID = rs_search.getInt(\ goodsName = rs_search.getString(\ introduce = rs_search.getString(\ nowprice = rs_search.getFloat(\

if (introduce.length() > 20) { introduce = introduce.substring(0, 20) + \ } %>

cellspacing=\

<% if (username != null && username != \ %>

<% } %> <% conn.close(); } else { out .println(\您的操作有误！');

window.location.href='index.jsp';\

} %>

main.jsp效果见主页的居中部分，显示特价书和新书上架信息，主要代码如下： <%@ page contentType=\ import=\<%@ page import=\<% connDB conn = new connDB(); String username = (String) session.getAttribute(\ ResultSet rs_sale = conn .executeQuery(\