private static void setParameter(SQLQuery sqlQuery, Object... params) { if (Validator.isNotEmpty(params)) { for (int i = 0; i < params.length; i++) { sqlQuery.setParameter(i, params[i]); } } }
/** * 判断数据库表是否存在(只适用于DB2) * * @param schema * @param tableName * @return true:存在;false:不存在 * @author LiuKun * @throws SQLException * @created 2012-8-9 下午7:29:24 */ @Transactional public Boolean existTableForDB2(String schema, String tableName) { if (Validator.isEmpty(schema)) { throw new RuntimeException("schema为空!"); } if (Validator.isEmpty(tableName)) { throw new RuntimeException("tableName为空!"); } String sql = " SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATOR = ? AND NAME = ? "; List<Map<String, Object>> mapList = executeQuery(sql, null, schema.toUpperCase(), tableName.toUpperCase()); if (Validator.isNotEmpty(mapList)) { return Boolean.TRUE; } else { return Boolean.FALSE; } }
/** * 检测某个属性值是否存在 * * @param clazz * @param propertyName * @param value * @return * @author LiuKun * @created 2012-7-28 上午11:36:02 */ @Transactional public <E extends Entity> Boolean checkExist(Class<E> clazz, String propertyName, Object value) { List<E> list = findByProperty(clazz, propertyName, value); if (Validator.isEmpty(list)) { return Boolean.FALSE; } else { return Boolean.TRUE; } }
/** * 判断数据库表是否存在 * * @param tableName * @return true:存在;false:不存在 * @author LiuKun * @throws SQLException * @created 2012-8-9 下午7:29:24 */ @Transactional public Boolean existTable(String tableName) { if (Validator.isEmpty(tableName)) { throw new RuntimeException("数据库表名为空!"); } Boolean flag = Boolean.FALSE; try { flag = getBaseDao().existTable(tableName); } catch (SQLException e) { throw new RuntimeException(e); } return flag; }
/** * 保存实体集合 * * @param entitys * @author LiuKun * @created 2012-8-2 上午9:56:27 */ @Transactional public <E extends Entity> void save(Collection<E> entitys) { if (Validator.isNotEmpty(entitys)) { baseDao.save(entitys); } }