ShopOrderDAO extends BaseIbatisDAO { public Long insert(final ShopOrder shopOrder) { return (Long) super.insert("SHOP_ORDER.insert", shopOrder); }  Long insert(final ShopOrder shopOrder); @SuppressWarnings("unchecked") List<ShopOrder> queryShopOrder(final Map<String, Object> parameters); @SuppressWarnings("unchecked") List<ShopOrderVO> queryShopOrderVO(final Map<String, Object> parameters); ShopOrder queryShopOrderByKey(final Long orderId); int updata(final ShopOrder shopOrder); Long orderCount(final Map<String, Object> parameters);  }
@Test public void testInsert() throws SQLException { ShopOrder shopOrder = new ShopOrder(); shopOrder.setActualPay(1000L); shopOrder.setAddress("上海市"); shopOrder.setCreateTime(new Date()); shopOrder.setMobile("13800138012"); shopOrder.setName("李四"); shopOrder.setOrderStatus(Constant.ORDER_STATUS.UNCONFIRM.name()); shopOrder.setOughtPay(2000L); shopOrder.setProductId(18L); shopOrder.setQuantity(10); shopOrder.setUserId(1l); shopOrder.setZip("201101"); shopOrder.setProductName("驴妈妈小公仔"); shopOrder.setProductType("PRODUCT"); shopOrderDAO.insert(shopOrder); String selectSQL = "SELECT * FROM SHOP_ORDER SO WHERE SO.ORDER_ID = " + shopOrder.getOrderId(); Statement stat = conn.createStatement(); ResultSet rs1 = stat.executeQuery(selectSQL); rs1.next(); Assert.assertEquals("13800138012", rs1.getString("MOBILE")); Assert.assertEquals("驴妈妈小公仔", rs1.getString("PRODUCT_NAME")); Assert.assertEquals("PRODUCT", rs1.getString("PRODUCT_TYPE")); }