public class InvoiceModel
{
private Integer invoiceid;
private Date invoicedate;
private String invoicetype;
private BigDecimal invoicesum; ////这个在数据库表里面没有这个字段 所以hbm.xml也没有这个字段的配置
}
我现在想执行一个sql语句
public List<InvoiceModel> findAll(int startNum , int pageSize)
{
Session session = HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();
SQLQuery sqlquery = session.createSQLQuery("select a.*,invoicesum from DPC_invoice a left join ( select invoice_id ,sum( invoice_product_num*invoice_product_price) invoicesum from DPC_invoice_product group by invoice_id )b on a.invoice_id =b.invoice_id");
if( startNum > -1 )
{
sqlquery.setFirstResult(startNum).setMaxResults(pageSize);
}
List<InvoiceModel> list = sqlquery.addEntity(InvoiceModel.class).list();
return list;
}
这个sql语句里面,那个别名invoicesum 怎么样才能填充到InvoiceModel里面的private BigDecimal invoicesum;属性中去啊
{
private Integer invoiceid;
private Date invoicedate;
private String invoicetype;
private BigDecimal invoicesum; ////这个在数据库表里面没有这个字段 所以hbm.xml也没有这个字段的配置
}
我现在想执行一个sql语句
public List<InvoiceModel> findAll(int startNum , int pageSize)
{
Session session = HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();
SQLQuery sqlquery = session.createSQLQuery("select a.*,invoicesum from DPC_invoice a left join ( select invoice_id ,sum( invoice_product_num*invoice_product_price) invoicesum from DPC_invoice_product group by invoice_id )b on a.invoice_id =b.invoice_id");
if( startNum > -1 )
{
sqlquery.setFirstResult(startNum).setMaxResults(pageSize);
}
List<InvoiceModel> list = sqlquery.addEntity(InvoiceModel.class).list();
return list;
}
这个sql语句里面,那个别名invoicesum 怎么样才能填充到InvoiceModel里面的private BigDecimal invoicesum;属性中去啊
解决方案 »
- eXtremeComponents性能如何???
- web project中的struts2.0中获得ApplicationContext可以吗??
- 关于jfreechart在aix+was显示问题,急!急!
- 404
- oas 部署为什么那么慢啊 1天1夜都不行啊 停在这里就不动了
- hibernate hql 查询问题
- 用struts怎样实现将在jsp页面中增加html代码
- CMP和Blob的问题,能用CMP实现对具有Blob字段的数据库的调用么?
- 我想问一下jsp和servlet有什么区别,servlet究竟是干什么的啊???
- 急急急,java swing JPanel 布局问题,解决立马结贴,100分送上
- 帮忙找错
- 结贴率100%,在线等:pushlet如何订阅多个主题
首先在类中写一个有属性invoicesum的构造方法,然后sql语句可以像这样写 select new InvoiceModel
(invoicesum )... from .......