@Override
 public boolean add(ImageInfo imageInfo) {
   if (StringUtils.isEmpty(imageInfo.getUrl()) || StringUtils.isEmpty(imageInfo.getRefId())) {
     log.error("添加图片信息失败!" + imageInfo.toString(), null);
     return false;
   }
   List<ImageInfo> list = queryByComapny(imageInfo.getRefId());
   if (list != null && list.size() >= MAX_IMAGE) {
     log.error("添加图片信息失败!图片总数已经大于等于" + MAX_IMAGE, null);
     return false;
   }
   CompanyInfo companyInfo = companyInfoService.getObjectById(imageInfo.getRefId());
   StringBuffer str = new StringBuffer();
   str.append("INSERT INTO baiduad.image_info                ");
   str.append("(title,url,order_num,link,create_date,remark,ref_id,company_name) ");
   str.append("VALUES                                        ");
   str.append("(?,?,?,?,?,?,?,?)                                 ");
   imageInfo.setCreateDate(new Date());
   return super.add(
       str.toString(),
       imageInfo.getTitle(),
       imageInfo.getUrl(),
       Integer.valueOf(imageInfo.getOrderNum()),
       imageInfo.getLink(),
       imageInfo.getCreateDate(),
       imageInfo.getRemark(),
       imageInfo.getRefId(),
       companyInfo.getCompanyName());
 }
 @Override
 public ImageInfo getObjectById(int pkId) {
   if (pkId <= 0) {
     log.error("获取单个图片信息失败!pkId=" + pkId, null);
     return null;
   }
   return super.getObject(
       "SELECT company_name,pk_id,title,ref_id,url,order_num,link,create_date,remark FROM baiduad.image_info where pk_Id = ? ",
       Integer.valueOf(pkId));
 }
 @Override
 public boolean del(int pkId, HttpServletRequest servletRequest) {
   if (pkId <= 0) {
     log.error("删除图片信息失败!" + pkId, null);
     return false;
   }
   ImageInfo image = getObjectById(pkId);
   if (image != null
       && super.del("DELETE FROM baiduad.image_info WHERE pk_id =  ? ", Integer.valueOf(pkId))) {
     FileUtil.deleteFile(image.getUrl(), "imgs", servletRequest);
     return true;
   }
   return false;
 }
 @Override
 public boolean update(ImageInfo imageInfo) {
   if (StringUtils.isEmpty(imageInfo.getUrl())
       || StringUtils.isEmpty(imageInfo.getLink())
       || imageInfo.getPkId() <= 0) {
     log.error("更新图片信息失败!" + imageInfo.toString(), null);
     return false;
   }
   StringBuffer str = new StringBuffer();
   str.append("UPDATE baiduad.image_info                  ");
   str.append("SET                                        ");
   str.append("title=?,url=?,order_num=?,link=?,remark=?  ");
   str.append("WHERE                                      ");
   str.append("pk_id=?                                    ");
   return super.update(
       str.toString(),
       imageInfo.getTitle(),
       imageInfo.getUrl(),
       Integer.valueOf(imageInfo.getOrderNum()),
       imageInfo.getLink(),
       imageInfo.getRemark(),
       Integer.valueOf(imageInfo.getPkId()));
 }