@Override
public void updateLv2(MergeItemGroup merge) {
String sql =
"update bi_dim.D_MERGE_ITEM_GROUP dmig set dmig.name = '"
+ merge.getMergeName()
+ "', dmig.state_date = to_date('"
+ merge.getMergeDate()
+ "','yyyy-mm-dd'),dmig.dimension_table_name = '"
+ merge.getTableName()
+ "' where dmig.merge_group_id = "
+ merge.getMergeId();
dataBaseDaoHelper.executeNativeSQL(sql);
}
@Override
public void lv2Add(MergeItemGroup merge) {
String sql =
"insert into bi_dim.D_MERGE_ITEM_GROUP values (bi_dim.s_merge_item_group.nextval,'"
+ merge.getLatituId()
+ "','"
+ merge.getMergeName()
+ "',to_date('"
+ merge.getMergeDate()
+ "','yyyy-MM-dd'),'"
+ merge.getTableName()
+ "')";
dataBaseDaoHelper.executeNativeSQL(sql);
// return dataBaseDaoHelper.persist("bi_dim.S_MERGE_ITEM_GROUP", merge,
// "mergeId");
}
