Spring JDBC中处理Bean属性与数据库列名不一致的映射策略

import lombok.Data; // 假设使用了Lombok简化getter/setter

@Data
public class Funding {
    private Long loanId;       // 对应数据库列名：LOAN_ID
    private String sellerLoanId; // 对应数据库列名：L_SELLER_LOAN_ID
    // 可以添加其他属性
}

import org.springframework.jdbc.core.RowMapper;
import java.sql.ResultSet;
import java.sql.SQLException;

public class FundingRowMapper implements RowMapper<Funding> {

    @Override
    public Funding mapRow(ResultSet rs, int rowNum) throws SQLException {
        Funding funding = new Funding();
        // 直接通过列名从ResultSet中获取数据，并设置到Bean属性
        // LOAN_ID 列名与 loanId 属性名可以通过 BeanPropertyRowMapper 自动映射，
        // 但为了完整性，这里也手动指定
        funding.setLoanId(rs.getLong("LOAN_ID"));

        // 重点：处理不匹配的列名 L_SELLER_LOAN_ID 映射到 sellerLoanId 属性
        funding.setSellerLoanId(rs.getString("L_SELLER_LOAN_ID"));

        // 如果有其他字段，也在此处进行映射
        // funding.setSomeOtherProperty(rs.getString("SOME_DB_COLUMN"));

        return funding;
    }
}

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class FundingDao {

    private final JdbcTemplate jdbcTemplate;

    @Autowired
    public FundingDao(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public List<Funding> findAllFundingValues() {
        String sql = "SELECT LOAN_ID, L_SELLER_LOAN_ID FROM FUNDING_TABLE"; // 确保SQL查询包含所有需要的列
        // 使用自定义的 FundingRowMapper 实例进行查询
        return jdbcTemplate.query(sql, new FundingRowMapper());
    }

    // 示例：根据ID查询单个Funding对象
    public Funding findFundingById(Long id) {
        String sql = "SELECT LOAN_ID, L_SELLER_LOAN_ID FROM FUNDING_TABLE WHERE LOAN_ID = ?";
        return jdbcTemplate.queryForObject(sql, new FundingRowMapper(), id);
    }
}