使用Hibernate执行sqlk语句的问题

0 0

使用Hibernate执行sqlk语句的问题0

在网上搜到Hibernate执行sql语句的方法，我在BaseDao写了如下的方法
public List<T> selectBySql(final Class<T> entityClass, final String sql,
final Object... values) {
return (List<T>) ht.execute(new HibernateCallback() {

public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = createSqlQuery(s, sql, values);
query.setResultTransformer(Transformers
.aliasToBean(entityClass));
List<T> result = query.list();
for(T t : result) {
DimTraficonMap dim = (DimTraficonMap)t;
}
return result;
}
});
}
其中的createSqlQuery为
public Query createSqlQuery(Session session, String sql, Object... objects) {
Query query = session.createSQLQuery(sql);
if (objects != null) {
for (int i = 0; i < objects.length; i++) {
query.setParameter(i, objects[i]);
}
}
return query;
}

class TestDao extends BaseDao {

public TestDao() {
super("./src/hibernateScott.cfg.xml");
}

public void get() {
String hql = "select * from dim_traficon_map dim where dim.ID=? and dim.ZONE_ID=?";
ArrayList<Object> paramObj = new ArrayList<Object>();
paramObj.add(BigDecimal.valueOf(124));
paramObj.add(BigDecimal.valueOf(1971));

List<DimTraficonMap> result = (List<DimTraficonMap>)super.selectBySql(DimTraficonMap.class, hql, paramObj.toArray());
System.out.println("Size:"+result.size());
}
}

当我执行
TestDao dao = new TestDao();
dao.get();
出现如下错误

Exception in thread "main" org.springframework.orm.hibernate3.HibernateSystemException: Could not find setter for ID on class com.traffic.rest.data.bean.DimTraficonMap; nested exception is org.hibernate.PropertyNotFoundException: Could not find setter for ID on class com.traffic.rest.data.bean.DimTraficonMap
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:676)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.traffic.rest.dao.BaseDao.selectBySql(BaseDao.java:92)
at test.TestDao.get(Test.java:100)
at test.Test.main(Test.java:83)

以下是相关的Bean：DimTraficonMap

package com.traffic.rest.data.bean;
// Generated 2012-6-1 9:58:20 by Hibernate Tools 3.2.0.b9


import java.math.BigDecimal;

/**
 *        @hibernate.class
 *         table="DIM_TRAFICON_MAP"
 *     
 */
public class DimTraficonMap  implements java.io.Serializable {


     /**
      *            @hibernate.id
 *             generator-class="assigned"
 *         
     */
     private DimTraficonMapPK comp_id;
     /**
      *            @hibernate.property
 *             column="IP"
 *             length="128"
 *         
     */
     private String ip;
     /**
      *            @hibernate.property
 *             column="CA"
 *             length="50"
 *         
     */
     private String ca;
     /**
      *            @hibernate.property
 *             column="LID"
 *             length="22"
 *             not-null="true"
 *         
     */
     private Integer lid;

    public DimTraficonMap() {
    }

	
    public DimTraficonMap(DimTraficonMapPK comp_id, Integer lid) {
        this.comp_id = comp_id;
        this.lid = lid;
    }
    public DimTraficonMap(DimTraficonMapPK comp_id, String ip, String ca, Integer lid) {
       this.comp_id = comp_id;
       this.ip = ip;
       this.ca = ca;
       this.lid = lid;
    }
   
    /**       
     *      *            @hibernate.id
     *             generator-class="assigned"
     *         
     */
    public DimTraficonMapPK getComp_id() {
        return this.comp_id;
    }
    
    public void setComp_id(DimTraficonMapPK comp_id) {
        this.comp_id = comp_id;
    }
    /**       
     *      *            @hibernate.property
     *             column="IP"
     *             length="128"
     *         
     */
    public String getIp() {
        return this.ip;
    }
    
    public void setIp(String ip) {
        this.ip = ip;
    }
    /**       
     *      *            @hibernate.property
     *             column="CA"
     *             length="50"
     *         
     */
    public String getCa() {
        return this.ca;
    }
    
    public void setCa(String ca) {
        this.ca = ca;
    }
    /**       
     *      *            @hibernate.property
     *             column="LID"
     *             length="22"
     *             not-null="true"
     *         
     */
    public Integer getLid() {
        return this.lid;
    }
    
    public void setLid(Integer lid) {
        this.lid = lid;
    }




}

package com.traffic.rest.data.bean;
// Generated 2012-6-1 9:58:20 by Hibernate Tools 3.2.0.b9


import java.math.BigDecimal;

/**
 * DimTraficonMapPK generated by hbm2java
 */
public class DimTraficonMapPK  implements java.io.Serializable {


     /**
      *                @hibernate.property
 *                 column="ID"
 *             
     */
     private BigDecimal id;
     /**
      *                @hibernate.property
 *                 column="ZONE_ID"
 *             
     */
     private BigDecimal zoneId;

    public DimTraficonMapPK() {
    }

    public DimTraficonMapPK(BigDecimal id, BigDecimal zoneId) {
       this.id = id;
       this.zoneId = zoneId;
    }
   
    /**       
     *      *                @hibernate.property
     *                 column="ID"
     *             
     */
    public BigDecimal getId() {
        return this.id;
    }
    
    public void setId(BigDecimal id) {
        this.id = id;
    }
    /**       
     *      *                @hibernate.property
     *                 column="ZONE_ID"
     *             
     */
    public BigDecimal getZoneId() {
        return this.zoneId;
    }
    
    public void setZoneId(BigDecimal zoneId) {
        this.zoneId = zoneId;
    }




}