把这段sql查出来的列名转换为javabean:SELECT p.id, p.identifier,p.company,p.business_source,p.salesmen,p.charge,p.contract_sign_date,p.total_money,IFNULL(pa.invoice_money,0.00) invoice_money,IF(pa.invoice_money IS NULL,p.total_money,p.total_money-pa.invoice_money) invoice_money_notready,IFNULL(pa.invoice_money_rate,0.00) invoice_money_rate FROM `ly_project` p LEFT JOIN `ly_project_amount` pa ON pa.project_id = p.id
时间: 2024-03-16 15:43:03 浏览: 47
以下是将该SQL查询结果转换为JavaBean的属性:
```java
public class LyProject {
private Integer id;
private String identifier;
private String company;
private String businessSource;
private String salesmen;
private String charge;
private Date contractSignDate;
private BigDecimal totalMoney;
private BigDecimal invoiceMoney;
private BigDecimal invoiceMoneyNotready;
private BigDecimal invoiceMoneyRate;
// 对应的 getter 和 setter 方法
}
```
注意:JavaBean 的属性名一般使用驼峰命名法。
阅读全文