开发过程遇到的问题

1.hibernate 原生sql查询问题：

public void getNurseStatInfo() {
        String sql = "select 'col018' id,count(*) count  from PHC_RECORD_CARD t where t.phc_model_def_id='932a9b81000080810af4' "
                + "union select 'col024' id,count(*) count from PHC_RECORD_CARD t where t.phc_model_def_id='7ca18efa000b0f7d44dc' "
                + "union select 'col032' id,count(*) count from PHC_RECORD_CARD t where t.phc_model_def_id='27f913b6000080e515e0' "
                + "union select 'col056' id,count(*) count from PHC_RECORD_CARD t where t.phc_model_def_id='243c447a00000f7d6958' "
                + "union select 'col062' id,count(*) count from PHC_RECORD_CARD t where t.phc_model_def_id='f786355d001c6a81ea34' "
                + "union select 'col027' id,count(*) count from PHC_RECORD_CARD t where t.phc_model_def_id='3f03ade200020f7d4b1c' "
                + "union select 'col059' id,count(*) count from PHC_RECORD_CARD t where t.phc_model_def_id='0305c2e600d57f1509a0' ";
        List<NurseStatInfo> statList = phcRecordCardDao.getEntityManager().createNativeQuery(sql, NurseStatInfo.class).getResultList();
        System.out.println("-----------------------------");
        for (NurseStatInfo info : statList) {
            System.out.println(info.getId());
            System.out.println(info.getCount());
        }
    }

import javax.persistence.Entity;
import javax.persistence.Id;

@Entity
public class NurseStatInfo {
    @Id
    private String id;
    private int count;
    
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public int getCount() {
        return count;
    }
    public void setCount(int count) {
        this.count = count;
    }
    
}

NurseStatInfo类中需要加@Entity、@Id两个注解，不然会报以下错误：

Caused by: org.hibernate.MappingException: Unknown entity

参考网站：http://stackoverflow.com/questions/30595445/how-to-map-a-native-query-to-a-pojo-when-i-do-not-have-any-entity-on-my-project