读书人

mybatis安插操作时获取主键

发布时间: 2013-08-26 12:17:40 作者: rapoo

mybatis插入操作时获取主键

 /* 1.添加商品信息 */        // 商品参数Map        Map<String, Object> inGoodsMap = new HashMap<String, Object>();        inGoodsMap.put("goodsId", 0);        inGoodsMap.put("goodsBarCode", form.getBoxBar());        inGoodsMap.put("goodsName", form.getGoodsName());        inGoodsMap.put("goodsType", 1);        inGoodsMap.put("goodsUnit", 1);        inGoodsMap.put("price", tradeprice);        inGoodsMap.put("tradePrice", retailprice);        // 手动同步,添加商品信息        dao.insert("GoodsService/handSyncInsertGoodsInfo", inGoodsMap);


<!-- 手动同步,添加商品信息 --><insert id="GoodsService/handSyncInsertGoodsInfo" parameterType="java.util.HashMap" ><selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="goodsId">          SELECT currval('goods_info_goodsid_seq')     </selectKey>  INSERT INTO goods_info(goodsbarcode, goodsname, goodstype, goodsunit, price,             tradeprice            )  VALUES ( #{goodsBarCode},      #{goodsName},       #{goodsType},        #{goodsUnit},       #{price},                #{tradePrice})</insert>

读书人网 >编程

热点推荐