Exemplo n.º 1
0
  @Override
  public List<String> queryForListString(String sql, Object... args) {
    try {
      EmptyUtils.isEmptyException(sql, "sql为空!");
      List<String> resultList = null;
      List<Map<String, Object>> list = null;
      long startTime = System.currentTimeMillis();
      if (!EmptyUtils.isEmpty(args)) {
        list = this.jdbcTemplate.queryForList(sql, args);
      } else {
        list = this.jdbcTemplate.queryForList(sql);
      }
      if (EmptyUtils.isNotEmpty(list)) {
        resultList = new ArrayList<String>();
        for (Map<String, Object> map : list) {

          Iterator<String> keys = map.keySet().iterator();
          if (keys.hasNext()) {
            String key = keys.next();
            resultList.add((String) map.get(key));
          }
        }
      }
      long endTime = System.currentTimeMillis();
      LOG.debug("processTime:{}", endTime - startTime);
      return resultList;
    } catch (Exception e) {
      LOG.error("queryForListString error:", e);
      throw new DaoException(e);
    }
  }
Exemplo n.º 2
0
  @Override
  public <T> T queryForObject(String sql, Class<T> requestType, Object... args) {
    try {
      EmptyUtils.isEmptyException(sql, "sql为空!");
      EmptyUtils.isEmptyException(requestType, "requestType类型对象为空!");
      long startTime = System.currentTimeMillis();
      T t = null;
      List<T> list = null;
      if (EmptyUtils.isNotEmpty(args)) {
        list =
            (List<T>) this.jdbcTemplate.query(sql, args, new BeanPropertyRowMapper<T>(requestType));
      } else {
        list = (List<T>) this.jdbcTemplate.query(sql, new BeanPropertyRowMapper<T>(requestType));
      }

      if (EmptyUtils.isNotEmpty(list)) {
        t = list.get(0);
      }

      long endTime = System.currentTimeMillis();
      LOG.debug("processTime:{}", endTime - startTime);
      return t;
    } catch (Exception e) {
      LOG.error("queryForObject error:", e);
      throw new DaoException(e);
    }
  }
Exemplo n.º 3
0
 @Override
 public <T> int update(String sql, T t) {
   try {
     EmptyUtils.isEmptyException(sql, "sql语句不能为空!");
     EmptyUtils.isEmptyException(t, "保存的对象是空值!");
     long startTime = System.currentTimeMillis();
     SqlParameterSource ps = new BeanPropertySqlParameterSource(t);
     int result = namedParameterJdbcTemplate.update(sql, ps);
     long endTime = System.currentTimeMillis();
     LOG.debug("processTime:{}", endTime - startTime);
     return result;
   } catch (Exception e) {
     LOG.error("updateObject error:", e);
     throw new DaoException(e);
   }
 }
Exemplo n.º 4
0
 @Override
 public int update(String sql, Object... params) {
   try {
     EmptyUtils.isEmptyException(sql, "sql语句不能为空!");
     return this.jdbcTemplate.update(sql, params);
   } catch (Exception e) {
     LOG.error("update error:", e);
     throw new DaoException(e);
   }
 }
Exemplo n.º 5
0
 @Override
 public int[] batchDelete(String[] sql) {
   EmptyUtils.isEmptyException(sql, "sql为空!");
   try {
     return this.jdbcTemplate.batchUpdate(sql);
   } catch (Exception e) {
     LOG.error("batchDelete error:", e);
     throw new DaoException(e);
   }
 }
Exemplo n.º 6
0
 @Override
 public int[] batchDelete(String sql, List<Object[]> batchArgs) {
   EmptyUtils.isEmptyException(sql, "sql为空!");
   try {
     return this.jdbcTemplate.batchUpdate(sql, batchArgs);
   } catch (Exception e) {
     LOG.error("batchDeleteObject error:", e);
     throw new DaoException(e);
   }
 }
Exemplo n.º 7
0
  @Override
  public int queryForInt(String sql, Object... params) {
    try {
      EmptyUtils.isEmptyException(sql, "sql");
      int result = 0;
      long startTime = System.currentTimeMillis();
      if (EmptyUtils.isEmpty(params)) {
        result = this.jdbcTemplate.queryForInt(sql);
      } else {
        result = this.jdbcTemplate.queryForInt(sql, params);
      }

      long endTime = System.currentTimeMillis();
      LOG.debug("processTime:{}", endTime - startTime);
      return result;
    } catch (Exception e) {
      LOG.error("queryForInt error:", e);
      throw new DaoException(e);
    }
  }
Exemplo n.º 8
0
 @Override
 public String queryForString(String sql, Object... args) {
   try {
     EmptyUtils.isEmptyException(sql, "sql为空!");
     String result = "";
     List<Map<String, Object>> list = null;
     long startTime = System.currentTimeMillis();
     list = this.jdbcTemplate.queryForList(sql, args);
     if (CollectionUtils.isNotEmpty(list)) {
       Map<String, Object> map = (Map<String, Object>) list.get(0);
       Iterator<String> keys = map.keySet().iterator();
       if (keys.hasNext()) {
         String key = keys.next();
         result = (String) map.get(key);
       }
     }
     long endTime = System.currentTimeMillis();
     LOG.debug("processTime:{}", endTime - startTime);
     return result;
   } catch (Exception e) {
     LOG.error("queryForString error:", e);
     throw new DaoException(e);
   }
 }