ShopOrderDAO extends BaseIbatisDAO { public ShopOrder queryShopOrderByKey(final Long orderId) { return (ShopOrder) super. queryForObject("SHOP_ORDER.queryShopOrderByKey", orderId); }  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 testQueryShopOrderByKey() throws SQLException { ShopOrder order = shopOrderDAO.queryShopOrderByKey(252L); String mobile = order.getMobile(); String selectSQL = "SELECT * FROM SHOP_ORDER SO WHERE SO.ORDER_ID = 252" ; ResultSet rs = this.executeSQL(selectSQL); rs.next(); Assert.assertEquals(mobile, rs.getString("MOBILE")); }