07.22总结

增加检索功能

在 cn.agriculture.web.controller/GoodsController中增加检索方法

 @RequestMapping(value = "selectGoods", method = RequestMethod.POST)

    public String  selectGoods(Model model,HttpSession session,GoodsForm goodsForm,Device device){

      log.info("检索相关商品");

    List<GoodsForm> list=goodsService.searchGoodsListrelative(goodsForm);

    model.addAttribute("list",list);

    UVO uvo = (UVO)session.getAttribute("UVO");

    if (uvo == null) {

    uvo = new UVO();

    session.setAttribute("UVO", uvo);

    }

    CartForm cartForm = new CartForm();

    cartForm.setGuestId(uvo.getGuestId());

    model.addAttribute("cartList", cartService.searchCartList(cartForm));

    if(device.isNormal()) {

    return "shop/index";

    } else {

    return "mobile/index";

    }

在cn.agriculture.web.service/GoodsService中添加检索方法

package cn.agriculture.web.service;

import java.util.List;

import jp.terasoluna.fw.dao.QueryDAO;

import jp.terasoluna.fw.dao.UpdateDAO;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import cn.agriculture.web.form.GoodsForm;

@Service

public class GoodsService {

@Autowired

QueryDAO queryDao;

@Autowired

UpdateDAO updateDao;

public List<GoodsForm> searchGoodsList(GoodsForm frm) {

List<GoodsForm> result = queryDao.executeForObjectList("Goods.selectGoodsList", frm);

return result;

}

public List<GoodsForm> searchGoodsListrelative(GoodsForm frm) {

List<GoodsForm> result = queryDao.executeForObjectList("Goods.selectGoodsListrelative", frm);

return result;

}

public GoodsForm searchGoods(GoodsForm frm) {

GoodsForm result = queryDao.executeForObject("Goods.selectGoods", frm, GoodsForm.class);

return result;

}

}

在userBar.html中添加检索按钮和input框

<form action="selectGoods" th:object="${goodsForm}" method="post">

<input type="text" name="commodityName"/>

<input type="submit" value="检索"/>

</form>

在GoodsSqlMap.xlm中添加

<select id="selectGoodsListrelative"

parameterClass="cn.agriculture.web.form.GoodsForm"

resultClass="cn.agriculture.web.form.GoodsForm">

SELECT commodity.commodity_id as commodityId,

commodity.type as type,

supplier.supplier_name as supplierName,

brand.brand_name as brandName,

commodity.commodity_name as commodityName,

commodity.weight as weight,

commodity.is_gift as isGift,

commodity.specifications as specifications,

commodity.unit as unit,

commodity.benchmark_price as benchmarkPrice,

commodity.guide_price as guidePrice,

commodity.retail_price as retailPrice,

commodity.competition_level as competitionLevel,

commodity.note as note,

commodity.update_time as updateTime,

commodity.update_user as updateUser,

commodity.picture_id as pictureId,

stock.stock as stock

FROM commodity, supplier, brand, stock

WHERE commodity.commodity_id = stock.commodity_id

AND commodity.supplier_id = supplier.supplier_id

AND commodity.brand_id = brand.brand_id

AND commodity.commodity_name LIKE '%$commodityName$%' <!-- 模糊查询 -->

</select>

转载于:https://my.oschina.net/u/2414262/blog/482359