解决方案 »
- Caused by: Action class [com.test.action.LoginAction] not found
- Struts1.3中集成fckeditor
- Tomcat中webapps下的项目如何导入到eclipse中呢?
- jsp连接数据库问题 只要一关闭 就提示错误500 在关闭哪一行有错误
- 点ie窗口的关闭按钮如何触发服务器端事件???我想做logout....
- 紧急求教!!如何实现页面的跳转???
- web的访问速度
- WebService能否实现推送功能?
- 请高手指教!!!如何在浏览器中输入http://localhost:8080时调用的是我自己的个人主页,而不是tomcat默认的主页?
- 请教高手!(系统分析设计)
- 分享:C语言开发的中英文混合分词服务器3.0正式发布,词库190多万词,每秒切分5万+,同时提供 c、java、C#、delphi、js调用范例
- jS谁帮我一下点击A变颜色带图片的代码
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping package="com.jsh.model" >
<class name="SaleBean" table="saleinfo" lazy="true" dynamic-update="true" dynamic-insert="true">
<id name="id" type="java.lang.Integer">
<generator class="native"></generator>
</id>
<property name="articleid" type="java.lang.String">
<column name="articleid" length="20" />
</property>
<property name="offerprice" type="java.lang.String">
<column name="offerprice" length="1" />
</property>
<property name="regtime" type="java.lang.String">
<column name="regtime" length="20" />
</property>
<many-to-one name="user" class="UserBean" column="regby"></many-to-one>
</class>
</hibernate-mapping>
具体情况:
sf = new Configuration().configure().buildSessionFactory();
Session session = sf.openSession();
// PageBean page = null;
Criteria criteria = session.createCriteria(SaleBean.class);
criteria.add(Restrictions.le("regtime", "2011-11-11"));
criteria.add(Restrictions.ge("regtime", "2011-11-01"));
// int rowCount = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
// criteria.setProjection(null);
List<SaleBean> list = criteria.list();
for(SaleBean s : list){
System.out.println(s.getId());
System.out.println(s.getUser().getName());
}
}
加上 这两句
// int rowCount = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
// criteria.setProjection(null);
查询总行数以后
criteria.list()装载的对象由SaleBean 变成object【】 SaleBean UserBean。欢迎大家测一下,继续讨论
前提 查询的对象有关联关系 如 多对一!
说明你list里面保存的不是SaleBean对象,而是Object[],直接用list,别用泛型的List<SaleBean>接收数据,或者用List<Object[]>。
总结:认为是hibernate BUG! 同意的支持下!
DetachedCriteria CompanyUserInfoC1 = DetachedCriteria
.forClass(CompanyUserInfo.class);
CompanyUserInfoC1.addOrder(Order.desc("uid"));
CompanyUserInfoC1.add(Expression.eq("type", "1"));
CompanyUserInfoC1.add(Expression.eq("premeditation1", "1"));
CompanyUserInfoC1.add(Expression.eq("premeditation2", "0"));
CompanyUserInfoC1.add(Expression.eq("premeditation3", "1"));
request.setAttribute("dianxingyuanqu", this.companyUserInfoService.findByPage(CompanyUserInfoC1, 0, 5));
//-----------------------------------------
// 精品综合园区
DetachedCriteria jinpin = DetachedCriteria.forClass(CompanyUserInfo.class);
DetachedCriteria jinpinzonghetype = DetachedCriteria.forClass(CompanyTypeInfo.class);
jinpinzonghetype.add(Expression.eq("companyTypeName", "综合园区"));
// jinpin.addOrder(Order.desc("premeditation3"));
jinpin.addOrder(Order.desc("uid"));
jinpin.add(Expression.eq("type", "1"));
jinpin.add(Expression.eq("companyTypeInfo",this.companyTypeInfoService.ListDeptInfor(jinpinzonghetype).get(0)));
jinpin.add(Expression.eq("premeditation1", "1"));
jinpin.add(Expression.eq("premeditation2", "0"));
jinpin.add(Expression.eq("premeditation3", "2"));
request.setAttribute("zhongheyuanqu", this.companyUserInfoService.findByPage(jinpin, 0,8));