@Override
	public Map<String, Object> findZzjg(String sTotalString) {
		JSONObject json = null;
		Zzjg zzjg = null;
		Map<String,Object> map = new HashMap<String, Object>();
		Connection con = DBUtil.getConnection();
		PreparedStatement ps = null;
		PreparedStatement ct = null;
		ResultSet count = null;
		int pages = 1;
		try {
			json = new JSONObject(sTotalString);
			String sql = "select tub.YJ,loc.write_name,tub.doctor,tub.build_date,tub.report_company,tub.name,tub.sex," +
					" tub.age,tub.tel,tub.address,loc.isningbo,tub.yj,tra.company_name," +
					" tra.user_name,tra.date_time,tra.track_method,tra.track_result,tra.note," +
					" loc.track_situation,loc.place_function,loc.place_date,loc.treatment_diagnosed," +
					" loc.no_place_reason,loc.write_company,loc.build_date as locbuilddate,loc.track_remark " +
					" from tub_report_card_loc loc " +
					" left join jhb_tracking_log tra on tra.card_num = loc.card_num_loc " +
					" left join tub_report_card tub on loc.card_num_loc = tub.card_num " +
					" WHERE loc.card_num_loc = ? " +
					"  order by tub.build_date desc,loc.card_num_loc desc ";
			ps = con.prepareStatement(sql.toString());
			if(json.has("ID")){
				ps.setString(1, json.getString("ID"));
			}else{
				map.put("isNull", "0");
				return map;
			}
			ResultSet rs = ps.executeQuery();
			if(rs.next()) {
				zzjg = new Zzjg();
				zzjg.setInPlace(rs.getString("TRACK_SITUATION"));
				zzjg.setDiagnosis(rs.getString("treatment_diagnosed"));
				zzjg.setInDate(dateToStr(rs.getDate("PLACE_DATE")));
				zzjg.setReason(rs.getString("NO_PLACE_REASON"));
				zzjg.setOldAddr(rs.getString("YJ"));
				zzjg.setPerson(rs.getString("write_name"));
				zzjg.setUnit(rs.getString("WRITE_COMPANY"));
				zzjg.setBuildDate(dateToStr(rs.getDate("locbuilddate")));
				map.put("zzjg", zzjg);
				map.put("pages", pages);
				map.put("isNull", "1");
				return map;
			}else{
				map.put("isNull", "0");
				return map;
			}
        } catch (JSONException e) {
            e.printStackTrace();
            System.out.println("追踪结果（zzjg）Json读取异常！");
        } catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库操作异常！");
		} finally {
			try {
				con.close();
				DBUtil.closeConnection();
				if(count!=null){
					count.close();
				}
				if(ct!=null){
					ct.close();
				}
				if(ps!=null){
					ps.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return map;
	}