求大神帮忙,id有,但是不知道为什么查不到

Question

String sql="select count(info),DATE_FORMAT(indate,'%m') from user_log ulog where ulog.userid='"+userid+"' and DATE_FORMAT(indate,'%Y')=DATE_FORMAT(NOW(),'%Y') GROUP BY DATE_FORMAT(indate,'%m')";这条sql语句在mysql中能查出来,

@ResponseBody
@RequestMapping(value="findUser_log",method=RequestMethod.POST)
public void findUser_log(HttpServletResponse response) throws IOException{

    List<User_logBean> list= reportForSvc.findUser_log(119);
    System.out.println(list.toString());
    System.out.println(list.size()+"大小...");
    List<Map<String, Object>> temp=new ArrayList<Map<String,Object>>();
    Map<String, Object> data=new HashMap<String, Object>();

    for (int i = 0; i < list.size(); i++) {
        Map<String, Object> map=new HashMap<String, Object>();

        map.put("info", ((User_logBean) list.get(i)).getInfo());
        map.put("indate", ((User_logBean) list.get(i)).getIndate());

        System.out.println(map.get("info")+"--------"+map.get("indate"));
        temp.add(map);
    }
    data.put("data", temp);

    JSONObject jsonObject=JSONObject.fromObject(data);
    System.out.println(jsonObject.toString());

    但是这控制器里面查不到数据,并且报错java.sql.SQLException: Column 'id' not found.     我的bean里面有id,数据库也有.

Answer 1

你用的是hibernate？不是iBATIS？