springmvc+spring+springjdbc商品列表展示修改

package cn.bdqn.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; import org.springframework.stereotype.Repository; import cn.bdqn.dao.GoodsDao; import cn.bdqn.domain.Goods; import cn.bdqn.util.MyUtil; @Repository public class GoodsDaoImpl implements GoodsDao { @Autowired private JdbcTemplate jdbcTemplate; @Override public List<Goods> selectGoods(Goods goods) { StringBuilder sb = new StringBuilder(); sb.append("SELECT `id`,`goodsName`,`billStatus`,`goodsDistrict`,`goodsPrice`,`goodsCount`,`creationTime` from goods g where 1=1 "); if (null != goods.getGoodsDistrict() && !"".equals(goods.getGoodsDistrict())) { sb.append(" and g.goodsDistrict= " + goods.getGoodsDistrict()); } List<Map<String, Object>> lists = jdbcTemplate.queryForList(sb.toString()); return MyUtil.toObject(lists); } @Override public Goods getOneGoods(final Integer id) { String sqlStr = " SELECT `id`,`goodsName`,`billStatus`,`goodsDistrict`,`goodsPrice`,`goodsCount`,`creationTime` " + " FROM goods WHERE id =? "; final Goods goods = new Goods(); jdbcTemplate.query(sqlStr, new Object[] { id }, new RowCallbackHandler() { public void processRow(ResultSet rs) throws SQLException { goods.setId(id); goods.setGoodsName(rs.getString("goodsName")); goods.setBillStatus(rs.getString("billStatus")); goods.setGoodsDistrict(rs.getString("goodsDistrict")); goods.setGoodsPrice(rs.getString("goodsPrice")); goods.setGoodsCount(rs.getString("goodsCount")); goods.setCreationTime(rs.getString("creationTime")); } }); return goods; } @Override public int updateGoods(Goods goods) { String sqlStr = " update Goods g set g.goodsName = ?,g.goodsPrice = ?,g.billStatus = ?,g.goodsCount=? where g.id = ?"; int result = jdbcTemplate.update(sqlStr, new Object[] { goods.getGoodsName(), goods.getGoodsPrice(), goods.getBillStatus(), goods.getGoodsCount(), goods.getId() }); return result; } }