ShopLogDAO extends BaseIbatisDAO { public Long insert(final ShopLog shopLog) { super.insert("SHOP_LOG.insert", shopLog); return shopLog.getLogId(); }  Long insert(final ShopLog shopLog); @SuppressWarnings("unchecked") List<ShopLog> query(final Map<String, Object> parametes); void savePutPoint(final ShopCustomerPresentPoint scpp);  }
@Test public void testInsert() throws SQLException{ ShopLog log = new ShopLog(); log.setContent("content"); log.setLogType("SHOP_PRODUCT"); log.setObjectId(Long.valueOf(11L)); log.setObjectType("PRODUCT_CREATE"); log.setOperatorId("34ds5673543453456fs"); Long id = shopLogDAO.insert(log); String sql = "select * from SHOP_LOG where LOG_ID = " + id ; Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery(sql); rs.next(); Assert.assertEquals("content", rs.getString("content")); Assert.assertEquals("SHOP_PRODUCT", rs.getString("LOG_TYPE")); Assert.assertEquals("11", String.valueOf(rs.getLong("OBJECT_ID"))); Assert.assertEquals("PRODUCT_CREATE", rs.getString("OBJECT_TYPE")); }