public static void main(String[] args) {
JSONArray js = new JSONArray();
Calendar cal = Calendar.getInstance();
cal.add(Calendar.HOUR, -24);
cal.getTimeInMillis();
js.add(2016);
js.add(11);
js.add(4);
js.add(15);
js.add(101);
js.add(303030);
js.add("我是");
JSONObject obj = new JSONObject();
obj.put("result", js);
JSONArray json = obj.getJSONArray("result");
for (int index = 0; index < json.size(); index++) {
Object[] params = new Object[5];
for (int i = 0; i < 5; i++) {
params[i] = json.getIntValue(i);
}
saveMethodData("kimMethodOutput", params, cal, json);
}
}
public static void saveMethodData(String sqlType, Object[] params, Calendar c, JSONArray result) {
boolean sign = false;
Method method = new Method();
String findSql = "select * from t_method where year=? and month=? and day=? and server =? and channel =?";
method = method.findFirst(findSql, params);
if (method == null) {
method = new Method();
method.setTs(c.getTime());
method.setYear(result.getIntValue(0));
method.setMonth(result.getIntValue(1));
method.setDay(result.getIntValue(2));
method.setServer(result.getIntValue(3));
method.setChannel(result.getIntValue(4));
sign = true;
}
switch (sqlType) {
case "kimMethodOutput":
method.setkimOutputMethodSum(result.getIntValue(5));
method.setMethod(result.getString(6));
break;
case "kimMethodConsume":
method.setkimOutputMethodSum(result.getIntValue(5));
method.setMethod(result.getString(6));
break;
case "kimdbMethodOutput":
method.setkimOutputMethodSum(result.getIntValue(5));
method.setMethod(result.getString(6));
break;
case "kimdbMethodConsume":
method.setkimOutputMethodSum(result.getIntValue(5));
method.setMethod(result.getString(6));
break;
}
if (sign) {
method.save();
} else {
method.update();
}
}
日志
Exception in thread "main" java.lang.NullPointerException
at com.jfinal.plugin.activerecord.Model.find(Model.java:567)
at com.jfinal.plugin.activerecord.Model.findFirst(Model.java:594)
at com.mile.service.service.MethodService.saveMethodData(MethodService.java:191)
at com.mile.service.service.MethodService.main(MethodService.java:182)