hibernate几种HQL的写法

1、"select new com.vnv.bank.mutualAccount.actionform.MutualSubAccountForm"
        + "(ab.accountName, ab.accountId , ab.provSeq , ab.citySeq , ab.bankName ,"
        +"sa.accountId , sa.accountName , sa.subAccountType , ab.bankInfo.id ,sa.id) " +
        " from SubAccount sa , AccountBank ab " +
        "where sa.accountBank = ab.id  and sa.id = " 

2、" select new  AccountQueryBean(s, a, t) from "
    + " SubAccount s ,Account a ,Transaction t "
    + "where (t.credit=s.id and s.account.id=a.id";

  其中a,s,f 分别是相应的POJO类，AccountQueryBean 结构如下

public class AcctBalHisBean {
 AcctBalHis a =null;
 SubAccount s =null; 
 SubAccount sa = null;
    Transaction t = null;
 
 public AcctBalHisBean (){}
 public AcctBalHisBean (AcctBalHis a,SubAccount s,SubAccount sa,Transaction t){
  this.a=a;
  this.s=s;
  this.sa = sa;
  this.t = t;
 
 }
 String accountId;
 String subAccountId;
 String balance;
 String lockAmount;
 String fee;
 String accountName;//对方帐户名称
 String otherSubAccountId;//对方子帐户id
    String thisAccountName;
    String amount;
 String transId;
 String upDate;
 String beginDate;
 String endDate;
 String startPage;
 String tid;
 String ttransId;
 
 public String getTtransId() {
  return t.getTransId();
 }
 public void setTtransId(String ttransId) {
  this.ttransId = ttransId;
 }
 public String getTid() {
  return t.getId()+"";
 }
 public void setTid(String tid) {
  this.tid = tid;
 }
 public Transaction getT() {
  return t;
 }
 public void setT(Transaction t) {
  this.t = t;
 }
 public AcctBalHis getA() {
  return a;
 }
 public void setA(AcctBalHis a) {
  this.a = a;
 }
 public String getAccountId() {
  return s.getAccountId();
 }
 public void setAccountId(String accountId) {
  this.accountId = accountId;
 }
 public String getAccountName() {
  return sa.getAccount().getName();
 }
 public void setAccountName(String accountName) {
  this.accountName = accountName;
 }
 public String getBalance() {
  return a.getBalance()+"";
 }
 public void setBalance(String balance) {
  this.balance = balance;
 }
 public String getFee() {
  return a.getFee()+"";
 }
 public void setFee(String fee) {
  this.fee = fee;
 }
 public String getLockAmount() {
  return a.getLockAmount()+"";
 }
 public void setLockAmount(String lockAmount) {
  this.lockAmount = lockAmount;
 }
 public SubAccount getS() {
  return s;
 }
 public void setS(SubAccount s) {
  this.s = s;
 }
 public SubAccount getSa() {
  return sa;
 }
 public void setSa(SubAccount sa) {
  this.sa = sa;
 }
 public String getSubAccountId() {
  return a.getId()+"";
 }
 public void setSubAccountId(String subAccountId) {
  this.subAccountId = subAccountId;
 }
 public String getTransId() {
  return a.getTransid()+"";
 }
 public void setTransId(String transId) {
  this.transId = transId;
 }
 public String getUpDate() {
  return a.getUpdateTime()+"";
 }
 public void setUpDate(String upDate) {
  this.upDate = upDate;
 }
 public String getAmount() {
  return a.getAmount()+"";
 }
 public void setAmount(String amount) {
  this.amount = amount;
 }
 public String getThisAccountName() {
  return s.getAccountName();
 }
 public void setThisAccountName(String thisAccountName) {
  this.thisAccountName = thisAccountName;
 }
 public String getOtherSubAccountId() {
  return sa.getAccount().getId()+"";
 }
 public void setOtherSubAccountId(String otherSubAccountId) {
  this.otherSubAccountId = otherSubAccountId;
 }
 
 }