//使用hibernate进行多表查询, 返回一个list

    public List<?> getHfxx(BigDecimal id) {

        String hql = "select a.xchfsj,a.khjb,a.khly,b.jhhffs from CmKhxxb a,CmKhgzxxb b where a.khbh=b.khbh and a.id="+id;

        List<?> list = hiberTem.find(hql);

        return list;

    }

    //点击回访客户, 返回客户信息表, 与上面的方法差不多, 只是返回给不同的标签

    @ResponseBody

    @RequestMapping(value="/getCmKhxx.do", method=RequestMethod.POST)

    public String getCmKhxx(@RequestParam(value="khid")String khid) {

        String json = "{\"success\":";

        BigDecimal bId = new BigDecimal(khid);

        List<?> list = cmKhxxbDao.getHfxx(bId);

        Iterator<?> iter = list.iterator();

        HashMap<String, String> map = null;

        while(iter.hasNext()) {

            Object[] o = (Object[])iter.next();

            if(o!=null) {

                map = new HashMap<String, String>();

                String hfsj = "";

                try {

                    hfsj = DateFormat.getStringDate((Date)o[0]);

                } catch (ParseException e) {

                    e.printStackTrace();

                }

                map.put("xchfsj", hfsj);

                map.put("khjb", (String)o[1]);

                map.put("khly", (String)o[2]);

                map.put("jhhffs", (String)o[3]);

            }

        }

        if(map==null) {

            json += "false}";

        } else {

            json += "true,\"action\":";

            json += JSON.toJSONString(map);

            json += "}";

        }

        return json;

    }