public static String getComboBoxJsonBySqlFormat(List<Object> list, String column) {
String[] columns = column.split(",");
List<Map> workMesions = new ArrayList<Map>();
if (dbtype.equalsIgnoreCase("db2")) {
for (Object i : list) {
Object[] wm = (Object[]) i;
// if(columns.length == wm.length){
HashMap map = new HashMap();
for (int j = 0; j < columns.length; j++) {
map.put(columns[j], wm[j]);
}
workMesions.add(map);
}
} else {
for (Object i : list) {
Object[] wm = (Object[]) i;
// if(columns.length == wm.length){
HashMap map = new HashMap();
for (int j = 0; j < columns.length; j++) {
map.put(columns[j], wm[j]);
}
workMesions.add(map);
}
}
// if(isneedall!=""&&isneedall!=null){
// for(int j=0;j<columns.length;j++){
// HashMap map = new HashMap();
// map.put(columns[j],"");
// workMesions.add(map);
// }
// }
StringBuilder tempJsonString = new StringBuilder("");
JSONValue JSONArray;
try {
JSONArray = JSONMapper.toJSON(workMesions);
JsonString = JSONArray.render(true);
} catch (MapperException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
tempJsonString.append(JsonString);
JsonString = tempJsonString.toString();
return JsonString;
}
public static String getGridJsonFormat(int sumnum, List<Object> list) {
String ddd = "";
if (sumnum == 0) {
JsonString = "{totalProperty:0,root:);";
return "{totalProperty:" + sumnum + ",root:[]}";
} else {
// StringBuffer tempJsonString =null;
StringBuilder tempJsonString = new StringBuilder("{totalProperty:" + sumnum + ",root:");
JSONValue JSONArray;
try {
JSONArray = JSONMapper.toJSON(list);
JsonString = JSONArray.render(true);
} catch (MapperException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
tempJsonString.append(JsonString);
tempJsonString.append("}");
JsonString = tempJsonString.toString();
}
return JsonString;
}
public static String getGridJsonBySqlFormat(int sumnum, List<Object> list, String column) {
if (sumnum == 0) {
// System.out.println("总条数为0 ，没有数据可以格式化...");
return "{totalProperty:" + sumnum + ",root:[]}";
} else {
// StringBuffer tempJsonString =null;
String[] columns = column.split(",");
List<Map> workMesions = new ArrayList<Map>();
if (dbtype.equalsIgnoreCase("db2")) {
for (Object i : list) {
Object[] wm = (Object[]) i;
// if(columns.length == wm.length){
HashMap map = new HashMap();
for (int j = 0; j < columns.length; j++) {
if (wm[j + 1] == null) {
wm[j + 1] = "";
}
if (wm[j + 1].getClass().isEnum()) {
wm[j] = wm[j + 1].toString().trim();
}
// System.out.println(wm[j]);
map.put(columns[j], wm[j + 1]);
}
workMesions.add(map);
// }
// else{
// System.out.println(columns.length);
// System.out.println(wm.length);
// for(int j=0;j<wm.length;j++){
// System.out.println(wm[j]);
// }
// System.out.println("字段数量不符合，请核对column参数");
// }
}
} else {
for (Object i : list) {
Object[] wm = (Object[]) i;
// if(columns.length == wm.length){
HashMap map = new HashMap();
for (int j = 0; j < columns.length; j++) {
if (wm[j] == null) {
wm[j] = "";
}
if (wm[j].getClass().isEnum()) {
wm[j] = wm[j].toString().trim();
}
// System.out.println(wm[j]);
map.put(columns[j], wm[j]);
}
workMesions.add(map);
// }
// else{
// System.out.println(columns.length);
// System.out.println(wm.length);
// for(int j=0;j<wm.length;j++){
// System.out.println(wm[j]);
// }
// System.out.println("字段数量不符合，请核对column参数");
// }
}
}
StringBuilder tempJsonString = new StringBuilder(" { ");
tempJsonString.append("totalProperty:" + sumnum + ",root:");
JSONValue JSONArray;
try {
JSONArray = JSONMapper.toJSON(workMesions);
JsonString = JSONArray.render(true);
} catch (MapperException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
tempJsonString.append(JsonString);
tempJsonString.append("}");
JsonString = tempJsonString.toString();
}
return JsonString;
}