首页 > ormlite更新数据库的时候,那里写错了?

ormlite更新数据库的时候,那里写错了?

public ModelAndView add(HttpServletRequest request,

        HttpServletResponse response, zzpt_car item) {
    ConnectionSource connectionSource = DBUtil.getConnectionSource();
    HttpSession session = request.getSession();
    sys_user user = (sys_user) session.getAttribute(ConfigUtil.USER);
    String cus_id=request.getParameter("district.districtName");
    String id_id=request.getParameter("district.id");
    
    try {
        Dao<zzpt_car, String> dao = DaoManager.createDao(connectionSource,
                zzpt_car.class);
        String car_id = new DoNumber().get_DJ_Number("CAR");
        item.setCar_own_user(user.getId());// 获取登录用户id
        item.setCreatetime(SystemUtil.getDate("yyyy-MM-dd HH:mm:ss"));
        item.setCar_id(car_id);
        item.setStatus("0");
        item.setCar_owner(cus_id);
        dao.create(item);
        
        //更新person的状态为2
        
        Dao<zzpt_person, String> dao1 = DaoManager.createDao(connectionSource,
                zzpt_person.class);
        
        UpdateBuilder<zzpt_person, String> update = dao1.updateBuilder();
        
        update.updateColumnValue("status",2).where().eq("id", id_id);
        
        connectionSource.close();
    } catch (SQLException e) {
        e.printStackTrace();
        return jsonError(request, "保存失败", "");
    }
    return jsonSuccess(request, "保存成功!", getBasePath(request)+ "admin/car/index.html");
}

    

dao.create(item)能成功运行,pdate.updateColumnValue("status",2).where().eq("id", id_id);就不行。


dao写错了


UpdateBuilder只是用来生成更新的条件和值得, 最终还需要你调用dao对象的update方法执行UpdateBuilder的prepare方法生成的PreparedUpdate对象

【热门文章】
【热门文章】