org.apache.commons.dbutils.BasicRowProcessor Java Examples

/**
 * 查询一条数据,可搭配page,limit,order,group,having使用
 * 
 * @return T 返回javabean
 * @throws Exception if has error
 */
@SuppressWarnings("unchecked") 
public <T> T find() throws Exception{
	this.limit(1);
	try {
		if (buildSql_Select()) {
			BeanHandler<T> beanHandler= new BeanHandler<T>((Class<T>) this.beanClass,new BasicRowProcessor(new BeanProcessor(columnToPropertyOverrides)));
			T bean = new QueryRunner().query(conn, sql,beanHandler, param_where);
			D.autoCloseConn(conn);
			return bean;
		}
	} catch (Exception e) {
		D.closeConn(conn);
		throw e;
	}
	return null;
}
 

@Override
public <T> T queryEntity(Class<T> entityClass, String sql, Object... params) {
    T result;
    try {
        Map<String, String> columnMap = EntityHelper.getColumnMap(entityClass);
        if (MapUtils.isNotEmpty(columnMap)) {
            result = queryRunner.query(sql, new BeanHandler<T>(entityClass, new BasicRowProcessor(new BeanProcessor(columnMap))), params);
        } else {
            result = queryRunner.query(sql, new BeanHandler<T>(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("查询出错！", e);
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

@Override
public <T> List<T> queryEntityList(Class<T> entityClass, String sql, Object... params) {
    List<T> result;
    try {
        Map<String, String> columnMap = EntityHelper.getColumnMap(entityClass);
        if (MapUtils.isNotEmpty(columnMap)) {
            result = queryRunner.query(sql, new BeanListHandler<T>(entityClass, new BasicRowProcessor(new BeanProcessor(columnMap))), params);
        } else {
            result = queryRunner.query(sql, new BeanListHandler<T>(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("查询出错！", e);
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

/**
 * 
 * @Title:       querySql   
 * @Description: TODO(带可变参数查询,返回执行结果)   
 * @param:       @param clazz 转换的对象实例
 * @param:       @param sql 查询sql语句
 * @param:       @param para 查询参数
 * @param:       @return
 * @param:       @throws SQLException      
 * @return:      List      
 * @throws
 */
public <T> List querySql(T clazz, String sql, Object... para) throws SQLException {
	logger.debug("查询Sql: {}, 查询参数: {}", sql, ToStringBuilder.reflectionToString(para));
	QueryRunner runner = new QueryRunner();
	Connection conn = null;
	List<T> result = new ArrayList<T>();
	try {
		conn = getConnection();
		// 下划线分隔的表字段名转换为实体bean驼峰命名属性
		BeanProcessor bean = new GenerousBeanProcessor();
		RowProcessor processor = new BasicRowProcessor(bean);
		result = (List<T>) runner.query(conn, sql, new BeanListHandler((Class) clazz, processor), para);
	} catch (SQLException e) {
		logger.error("查询出错，异常信息: {}------", e.getMessage());
		throw e;
	} finally {
		if (conn != null && conn.getAutoCommit() == true) {
			freeConnection();
		}
	}
	return result;
}
 

private void validateProperDbUtilsVersion() {
    Package dbutilsPackage = BasicRowProcessor.class.getPackage();
    String dbutilsVersion = dbutilsPackage.getSpecificationVersion();

    if (dbutilsVersion == null) {
        return;  // in case the jar is shaded, this information may not be available; hence, we are forced to return
    }
    String[] versionParts = dbutilsVersion.split("\\.");
    if (versionParts.length < 2) {
        throw new IllegalArgumentException("Improper dbutils version; must have at least two parts x.y; " + dbutilsVersion);
    }

    int majorVersion = Integer.valueOf(versionParts[0]).intValue();
    int minorVersion = Integer.valueOf(versionParts[1]).intValue();

    if (!(majorVersion >= 1 && minorVersion >= 6)) {
        throw new IllegalArgumentException("commons-dbutils:commons-dbutils version must be >= 1.6 to avoid bugs w/ JDBC getColumnName() usage in <= 1.5");
    }
}
 

@Override
public <T> T queryEntity(Class<T> entityClass, String sql, Object... params) {
    T result;
    try {
        Map<String, String> columnMap = EntityHelper.getColumnMap(entityClass);
        if (MapUtil.isNotEmpty(columnMap)) {
            result = queryRunner.query(sql, new BeanHandler<T>(entityClass, new BasicRowProcessor(new BeanProcessor(columnMap))), params);
        } else {
            result = queryRunner.query(sql, new BeanHandler<T>(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("查询出错！", e);
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

@Override
public <T> List<T> queryEntityList(Class<T> entityClass, String sql, Object... params) {
    List<T> result;
    try {
        Map<String, String> columnMap = EntityHelper.getColumnMap(entityClass);
        if (MapUtil.isNotEmpty(columnMap)) {
            result = queryRunner.query(sql, new BeanListHandler<T>(entityClass, new BasicRowProcessor(new BeanProcessor(columnMap))), params);
        } else {
            result = queryRunner.query(sql, new BeanListHandler<T>(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("查询出错！", e);
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

@Override
public <T> T queryEntity(Class<T> entityClass, String sql, Object... params) {
    T result;
    try {
        Map<String, String> columnMap = EntityHelper.getColumnMap(entityClass);
        if (MapUtil.isNotEmpty(columnMap)) {
            result = queryRunner.query(sql, new BeanHandler<T>(entityClass, new BasicRowProcessor(new BeanProcessor(columnMap))), params);
        } else {
            result = queryRunner.query(sql, new BeanHandler<T>(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("查询出错！", e);
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

@Override
public <T> List<T> queryEntityList(Class<T> entityClass, String sql, Object... params) {
    List<T> result;
    try {
        Map<String, String> columnMap = EntityHelper.getColumnMap(entityClass);
        if (MapUtil.isNotEmpty(columnMap)) {
            result = queryRunner.query(sql, new BeanListHandler<T>(entityClass, new BasicRowProcessor(new BeanProcessor(columnMap))), params);
        } else {
            result = queryRunner.query(sql, new BeanListHandler<T>(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("查询出错！", e);
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

@SuppressWarnings("unchecked")
public <T> List<T> select() throws Exception{
	try {
		if (buildSql_Select()) {
			BeanListHandler<T> beanListHandler= new BeanListHandler<T>((Class<T>) this.beanClass,new BasicRowProcessor(new BeanProcessor(columnToPropertyOverrides)));
			List<T> beanList = new QueryRunner().query(conn, sql,beanListHandler,param_where);
			D.autoCloseConn(conn);
			return beanList;
		}
	} catch (Exception e) {
		D.closeConn(conn);
		throw e;
	}
	return null;
}
 

public static List<Map> resultSetToMaps(ResultSet rs) throws SQLException{

        List<Map> results =new ArrayList<>();
        BasicRowProcessor brp = new BasicRowProcessor();

        while(rs.next()){
            results.add(brp.toMap(rs));
        }

        return results;
    }
 

public static List<Object[]> resultSetToArrays(ResultSet rs) throws SQLException {
    List<Object[]> results =new ArrayList<>();
    BasicRowProcessor brp = new BasicRowProcessor();

    while (rs.next()){
        results.add(brp.toArray(rs));
    }

    return results;
}
 

public JdbcResultSetIterator(ResultSet resultSet) {
    this.resultSet = resultSet;
    this.convert = new BasicRowProcessor();
}
 

protected RepositoryDao() {
    super();
    beanHandler = new BeanHandler<>(getEntityClass(), new BasicRowProcessor(new RepositoryBeanProcessor()));
    beanListHandler = new BeanListHandler<>(getEntityClass(), new BasicRowProcessor(new RepositoryBeanProcessor()));
}
 

public EmployeeHandler(Connection con) {
    super(Employee.class, new BasicRowProcessor(new BeanProcessor(getColumnsToFieldsMap())));
    this.connection = con;
}