Question

JSP页面调用Servlet实现数据库表格数据显示

这是Servlet代码
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {

String varRt_card_no=req.getParameter("varRt_card_no");
String varRt_point_bank=req.getParameter("varRt_point_bank");
String rangeg=req.getParameter("Range");

String sql="select CM_ITEM_CODE,CM_ITEM_DESC,CM_REDEMPTION_POINT from cp_crdtbl,CP_PNTBNK,cp_bnkcat,cp_catitm WHERE " +
"CP_PNTBNK.PB_BANK_ID=cp_bnkcat.BC_POINT_BANK_ID" +
"and cp_bnkcat.BC_CATITM_ID=cp_catitm.CM_CATALOGUE_CODE" +
"and cp_crdtbl.cb_cardholder_no= '"+varRt_card_no+"'";
try {
StatisticsDBObject sb=new StatisticsDBObject();
sb.getMultiStatistics(sql);
} catch (Exception e) {
e.printStackTrace();
}

Answer 1

首先你要把数据库里面的数据封装到一个集合对象里面去 比如是 List
然后在跳转之前设置request属性
request.setAttribute("属性名",你封装数据的那个集合对象);

Answer 2

这些代码如果你要在前台显示东西的话，肯定要把你要显示的东西放到request或者session或者application中啊

追问

我用request的话改咋整