该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
数据库有2张表:tb_financial_account是tb_client的子表
tb_client和tb_financial_account使用hibernante影射到dao后,表tb_client产生TbClientDAO.java 和TbClient.java
表tb_financial_account产生TbFinancialAccountDAO.java和TbFinancialAccount.java
TbClient.java有如下字段:
private Integer clientNo;(主键)
private String clientName;
private String idCardNo;
private String sex;
private String phone;
private String address;
private String email;
private String hobby;
private Date createdDate;
private Set tbFinancialAccounts = new HashSet(0);
TbFinancialAccount.java有如下字段:
private Integer accountNo;
private TbClient tbClient;(外键.此外键在数据库中名为:client_No.影射到dao后生成为主表的对象)
private Float financingAmount;
private Date createdDate;
private String status;
private String password;
private Set tbFundAccounts = new HashSet(0);
请问如果我想要根据子表的client_No查询出主表里的姓名的话请问应该这样写查询语句.并请稍微的说明一下查询语句的原理.
谢谢.