1、在对象中有个字段为Timestamp类型,需要将数据库的开始日期字段和开始时间字段拼接成一个字段开始字段
private static Timestamp getDateTime(String date,String time) throws ParseException {
DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS", Locale.ENGLISH); sdf.setLenient(false);//sdf.setLenient(false);的目的是禁止SimpleDateFormat的自动计算功能,如果日期不合格自动报错。Date testTime = sdf.parse(date+" "+time);//拼接时,注意日期末尾与时间开头的空格,需要空出来保持格式才正确通过
Timestamp timeVal=new Timestamp(testTime.getTime()); System.out.println(timeVal); return timeVal; }2、JSON集合数组对象
logger.info("开始同步信息");
List<MeetingInfo> meetinginfo=RecordUtil.searchAll(MeetingInfo.class); List<JSONObject> json = new ArrayList<JSONObject>(); for(int i=0;i<meetinginfo.size();i++) { JSONObject jsonval=new JSONObject(); jsonval.put("name", meetinginfo.get(i).getLastname()); try { jsonval.put("start",getDateTime(meetinginfo.get(i).getBegindate(),meetinginfo.get(i).getBegintime())); jsonval.put("over",getDateTime(meetinginfo.get(i).getEnddate(),meetinginfo.get(i).getEndtime())); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); logger.info("时间拼接出错"+e.getMessage()); } jsonval.put("mr_id",meetinginfo.get(i).getMetromid()); jsonval.put("create_name",meetinginfo.get(i).getLastname()); jsonval.put("remark",meetinginfo.get(i).getMetdescn()); jsonval.put("phone",meetinginfo.get(i).getMetroname()); json.add(jsonval); } String result=HttpRequestUtil.postJson(PropUtil.getStringCK("ecustom","URL.Conference"),json,true); System.out.println(result);