//增加和修改学生家庭信息
JSONObject jsonObject = JSONObject.fromObject(json_info);
TableBean familyTB_modify = new TableBean("TN_FAMILY_MODIFY");
TableBean familyTB_new = new TableBean("TN_FAMILY_NEW");
dataBean.addTableBean(familyTB_modify);
dataBean.addTableBean(familyTB_new);
if (jsonObject != null && jsonObject.size() > 0 && !"{}".equals(jsonObject)) {
@SuppressWarnings("unchecked")
Set<String> studentIdSet = jsonObject.keySet();
for(String studentId : studentIdSet){
JSONArray jsonArray_family = jsonObject.getJSONArray(studentId);
for (int i = 0; i < jsonArray_family.size(); i++) {
JSONObject jsonObj_sub = (JSONObject) jsonArray_family.get(i);
String familyId = (String) jsonObj_sub.get("familyId");
String familyName = (String) jsonObj_sub.get("familyName");
String familyRelationName = (String) jsonObj_sub.get("familyRelationName");
RowBean rowBean = new RowBean();
rowBean.addCellBean(new CellBean("CR_STUDENT_ID", studentId));
rowBean.addCellBean(new CellBean(TriangleDefinition.COLUMN_NAME_CN_NAME, familyName));
rowBean.addCellBean(new CellBean("CR_FAMILY_RELATION_ID", familyRelationName));
if (StringUtils.isNotBlank(familyId)) {
rowBean.addCellBean(new CellBean(TriangleDefinition.COLUMN_NAME_CN_ID, familyId));
familyTB_modify.addRowBean(rowBean);
}else{
familyTB_new.setDbTableDataOperationId(TriangleDefinition.DATABASE_TABLE_DATA_OPERATION_INSERT);
familyTB_new.addRowBean(rowBean);
}
}
}
}