public KpiSyncMapping save(KpiSyncMapping kpiMapping) throws Exception {
try {
Connection conn = MongoConnect.getConnection();
PreparedStatement pstmt =
conn.prepareStatement(
"insert into KpiSyncMapping(name,cateId,dataSourceId,fieldMap,owner) values(?,?,?,?,?)");
pstmt.setString(1, kpiMapping.getName() == null ? "" : kpiMapping.getName());
pstmt.setString(2, kpiMapping.getCateId() == null ? "" : kpiMapping.getCateId());
pstmt.setString(3, kpiMapping.getDataSourceId() == null ? "" : kpiMapping.getDataSourceId());
pstmt.setString(
4,
kpiMapping.getFieldMap() == null
? "{}"
: JSONObject.fromObject(kpiMapping.getFieldMap()).toString());
pstmt.setString(5, kpiMapping.getOwner());
pstmt.executeUpdate();
} catch (Exception e) {
throw e;
}
return getByName(kpiMapping.getName());
}
public KpiSyncMapping update(KpiSyncMapping kpiMapping) throws Exception {
try {
Connection conn = MongoConnect.getConnection();
PreparedStatement pstmt =
conn.prepareStatement(
"update KpiSyncMapping set name=?,cateId=?,dataSourceId=?,fieldMap=? where _id=?");
pstmt.setString(1, kpiMapping.getName() == null ? "" : kpiMapping.getName());
pstmt.setString(2, kpiMapping.getCateId() == null ? "" : kpiMapping.getCateId());
pstmt.setString(3, kpiMapping.getDataSourceId() == null ? "" : kpiMapping.getDataSourceId());
pstmt.setString(
4,
kpiMapping.getFieldMap() == null
? "{}"
: JSONObject.fromObject(kpiMapping.getFieldMap()).toString());
pstmt.setString(5, kpiMapping.getId());
pstmt.executeUpdate();
} catch (Exception e) {
throw e;
}
return kpiMapping;
}