@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"));
}