这是调用存储过程的方法 在dao层
public ArrayList<Coupon> allCoupon(int pageindex,int pagesize){
Session session = HibernateSessionFactory.getSession();
System.out.println("hello");
Query cste=session.getNamedQuery("get_page");//这地方报错了;org.hibernate.MappingException: Named query not known: get_page
System.out.println(cste);
cste.setString(1,"coupon");
cste.setString(2, "");
cste.setInteger(3, pageindex);
cste.setInteger(4, pagesize);
cste.setString(5, "");
cste.setString(6, "");
ArrayList<Coupon> couponlist = (ArrayList<Coupon>) cste.list();
System.out.println(couponlist.size()+"hello");
if(couponlist.size()>0){
return couponlist;
}
return couponlist;
}
这是映射文件的配置
<sql-query name="get_page" callable="true">
<return alias="Coupon" entity-name="com.entity.Coupon" class="com.entity.Coupon">
<return-property name="couponNo" column="couponNo"></return-property>
<return-property name="couponTitle" column="couponTitle"></return-property>
<return-property name="rebate" column="rebate"></return-property>
</return>
{?=call get_page(?,?,?,?,?,?)}
</sql-query>
在线等,
public ArrayList<Coupon> allCoupon(int pageindex,int pagesize){
Session session = HibernateSessionFactory.getSession();
System.out.println("hello");
Query cste=session.getNamedQuery("get_page");//这地方报错了;org.hibernate.MappingException: Named query not known: get_page
System.out.println(cste);
cste.setString(1,"coupon");
cste.setString(2, "");
cste.setInteger(3, pageindex);
cste.setInteger(4, pagesize);
cste.setString(5, "");
cste.setString(6, "");
ArrayList<Coupon> couponlist = (ArrayList<Coupon>) cste.list();
System.out.println(couponlist.size()+"hello");
if(couponlist.size()>0){
return couponlist;
}
return couponlist;
}
这是映射文件的配置
<sql-query name="get_page" callable="true">
<return alias="Coupon" entity-name="com.entity.Coupon" class="com.entity.Coupon">
<return-property name="couponNo" column="couponNo"></return-property>
<return-property name="couponTitle" column="couponTitle"></return-property>
<return-property name="rebate" column="rebate"></return-property>
</return>
{?=call get_page(?,?,?,?,?,?)}
</sql-query>
在线等,
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货