select      a.id,      a.prj_code,      a.prj_status   from      t_project_approval a   WHERE a.id = #{id}   select      c.item_name   FROM      t_sys_dictitem c   WHERE      c.dict_code = 'prj_status'      and c.item_code = #{prjStatus}   select      b.prj_name   from      t_letter_trial b   WHERE b.prj_code = #{prjCode}

package com.hhwy.fm.projectapproval.domain;import java.util.UUID;import javax.persistence.*;import com.hhwy.framework.annotation.PropertyDesc;import com.hhwy.framework.persistent.entity.Domain;/** * 
描 述：项目立项(项目表) * 
创 建 人：Jinzhaoqiang * 
创建时间： * 
修改备注：无 * 
版本：1.0.0 */@Entity(name="ProjectApproval")@Inheritance(strategy = InheritanceType.SINGLE_TABLE)@Table(name="t_project_approval")public class ProjectApproval extends Domain{   private static final long serialVersionUID = 7119079399916219284L;   @Id   @Column(         name = "id",         length = 32   )   private String id = UUID.randomUUID().toString().replace("-", "");       @Column(name="prj_code", columnDefinition="varchar(15) comment '项目编号'")    private String prjCode;       @Column(name="prj_status", columnDefinition="varchar(2) comment '状态：1待储备、2储备中、3已储备、4形式内审中、5待函审、6项目函审中、7待立项、8终止中、9已终止、10立项中、11已立项'")   private String prjStatus;        @PropertyDesc("项目状态名称")    @Transient    private String prjStatusName;        @PropertyDesc("工程名称")    @Transient    private String prjName;   @Override   public String getId() {      return id;   }   @Override   public void setId(String id) {      this.id = id;   }   public String getPrjCode() {      return prjCode;   }   public void setPrjCode(String prjCode) {      this.prjCode = prjCode;   }   public String getPrjStatus() {      return prjStatus;   }   public void setPrjStatus(String prjStatus) {      this.prjStatus = prjStatus;   }   public String getPrjStatusName() {      return prjStatusName;   }   public void setPrjStatusName(String prjStatusName) {      this.prjStatusName = prjStatusName;   }   public String getPrjName() {      return prjName;   }   public void setPrjName(String prjName) {      this.prjName = prjName;   }}

ProjectApproval projectApproval = (ProjectApproval)dao.getOneBySQL("projectapproval.sql.testPositionSelect",id);