@Test
public void testUpdata() 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);
	
	ShopOrder order = shopOrderDAO.queryShopOrderByKey(252L);
	order.setName("黄五");
	shopOrderDAO.updata(order);
	String selectSQL = "SELECT * FROM SHOP_ORDER SO WHERE SO.ORDER_ID = 252";
	ResultSet rs = this.executeSQL(selectSQL);
	rs.next();
	Assert.assertEquals(order.getName(), rs.getString("NAME"));
}