struts hibernate spring 实现分页、排序、复杂条件查询①

brimstone

浏览: 29566 次
性别:
来自: 南京

最近访客更多访客>>

2017wang

woodding2008

雨丝竺忆

z330281840

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

J2EE

Struts Hibernate Spring Bean SSH

2个月前，因为项目需要开始接触到SSH ，以前只用过JSP 开发过项目，所以对于SSH 一切都是新鲜玩意，虽然学习的过程是痛苦的，但是解决问题的快乐只有自己能体会到。
在这里是我第一次写Blog，一是为了能够和这里的朋友共同进步，二是为了记录自己收获的点点滴滴，三是为了能够给和我一样的初学者分享所得——严重跑题。。 :D

言归正传，下面是我的实现方法

一、开发环境
JDK1.5 Hibernate 3.1 Struts 1.2 Spring2.0 MyEclplise 5.5GA

二、Struts 和 Spring配置
Struts配置文件

xml 代码

xml version="1.0" encoding="UTF-8"?>
>
<struts-config>
<data-sources />
<form-beans>
<form-bean name="drugForm" type="com.trade.struts.form.DrugForm" />
<form-bean name="drugQueryForm" type="com.trade.struts.queryform.DrugQueryForm" />
<form-bean name="baseForm" type="com.trade.struts.queryform.BaseForm" />
form-beans>
<global-exceptions />
<global-forwards />
<action-mappings>
<action
attribute="drugQueryForm"
input="/Drug/drug_list.jsp"
name="drugQueryForm"
parameter="method"
path="/drugQuery"
scope="request"
>
<forward name="success" path="/index.jsp" />
<forward name="list" path="/Drug/drug_list.jsp" />
action>
action-mappings>
<controller>
<set-property property="processorClass"
value="org.springframework.web.struts.DelegatingRequestProcessor" />
controller>
<message-resources parameter="com.trade.struts.ApplicationResources" />
<plug-in
className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation"
value="/WEB-INF/applicationContext.xml" />
plug-in>
struts-config>

Spring配置代码

xml 代码

xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
<bean id="dataSourceTrade"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver">
property>
<property name="url"
value="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=Trade">
property>
<property name="username" value="share">property>
<property name="password" value="sa">property>
bean>
<bean id="sessionFactoryTrade"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSourceTrade" />
property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
prop>
<prop key="hibernate.show_sql">trueprop>
<prop key="current_session_context_class">threadprop>
<prop key="connection.pool_size">10prop>
<prop key="hibernate.hbm2ddl.auto">updateprop>
props>
property>
<property name="mappingResources">
<list>list>
property>
bean>
<bean id="dataSourceRush"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver">
property>
<property name="url"
value="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=Rush">
property>
<property name="username" value="share">property>
<property name="password" value="sa">property>
bean>
<bean id="sessionFactoryRush"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSourceTrade" />
property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
prop>
props>
property>
<property name="mappingResources">
<list>
<value>com/trade/vo/rush/Drug.hbm.xmlvalue>
list>
property>
bean>
<bean id="DrugDAOHibernate" class="com.trade.dao.hibernate.DrugDAOHibernate">
<property name="sessionFactory">
<ref bean="sessionFactoryRush" />
property>
bean>
<bean id="DrugService" class="com.trade.service.DrugService">
<property name="ddh">
<ref bean="DrugDAOHibernate" />
property>
bean>
<bean name="/drugQuery" abstract="false" lazy-init="default"
autowire="default" dependency-check="default" class="com.trade.struts.action.DrugAction">
<property name="ds">
<ref bean="DrugService" />
property>
bean>beans>

三、DAOImpl、Service 业务逻辑部分

因为主要是介绍分页，这里只放分页相关代码

DrugDAOHibernate类，这里使用的方法参考（抄袭。。）了Robbin等关于使用离线Criteria实现查询的代码

java 代码

package com.trade.dao.hibernate;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.trade.dao.IDrugDAO;
import com.trade.vo.DrugDAO;
import com.trade.vo.rush.Drug;
public class DrugDAOHibernate extends HibernateDaoSupport implements IDrugDAO {
private static final Log log = LogFactory.getLog(DrugDAO.class);
//获得符合查询条件的记录数目
public Long getDrugCount(final DetachedCriteria detachedCriteria) {
return (Long)getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
Criteria criteria = detachedCriteria.getExecutableCriteria(session);
Long count= Long.parseLong((criteria.setProjection(Projections.rowCount()).uniqueResult()).toString());
criteria.setProjection(null);
return count;
}
}, true);
}
//根据条件进行查询、分页
public List listByConditions(final DetachedCriteria detachedCriteria,final int pageNo,final int pageSize) {
return (List) getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
Criteria criteria = detachedCriteria.getExecutableCriteria(session);
criteria.setMaxResults(pageSize);
criteria.setFirstResult((pageNo-1)*pageSize);
return criteria.list();
}
}, true);
}
}

Service层很简单

java 代码

package com.trade.service;
import java.util.List;
import org.hibernate.criterion.DetachedCriteria;
import com.trade.dao.hibernate.DrugDAOHibernate;
public class DrugService {
//由Spring注入DrugDAOHibernate实例
private DrugDAOHibernate ddh ;
public DrugDAOHibernate getDdh() {
return ddh;
}
public void setDdh(DrugDAOHibernate ddh) {
this.ddh = ddh;
}
//获得满足条件的记录数
public List listByConditions(final DetachedCriteria detachedCriteria,final int pageNo,final int pageSize){
return ddh.listByConditions(detachedCriteria,pageNo,pageSize);
}
//根据条件进行查询、分页
public Long getDrugCount(final DetachedCriteria detachedCriteria){
return ddh.getDrugCount(detachedCriteria);
}
}

字数有限制。。请见下文。。

分享到：

struts hibernate spring 实现分页、排序、 ...

2007-11-27 02:06
浏览 4269
评论(4)
论坛回复 / 浏览 (3 / 12985)
分类:企业架构
查看更多

4 楼 amcucn 2008-10-19

不错，和我目前所用到的方法基本上是如出一辙！

3 楼 javaxy 2008-10-19

下文呢？

2 楼 erlyhds 2008-10-18

<div class='quote_title'>brimstone 写道</div>
<div class='quote_div'>
2个月前，因为项目需要开始接触到SSH ，以前只用过JSP 开发过项目，所以对于SSH 一切都是新鲜玩意，虽然学习的过程是痛苦的，但是解决问题的快乐只有自己能体会到。 在这里是我第一次写Blog，一是为了能够和这里的朋友共同进步，二是为了记录自己收获的点点滴滴，三是为了能够给和我一样的初学者分享所得——严重跑题。。

言归正传，下面是我的实现方法

 一、开发环境 JDK1.5 Hibernate 3.1 Struts 1.2 Spring2.0 MyEclplise 5.5GA
二、Struts 和 Spring配置 Struts配置文件
<div class='code_title'>xml 代码</div>
<div class='dp-highlighter'><ol class='dp-xml'>
<li class='alt'>xml version="1.0" encoding="UTF-8"?> </li>
<li>> </li>
<li class='alt'> </li>
<li><struts-config> </li>
<li class='alt'> <data-sources /> </li>
<li> <form-beans> </li>
<li class='alt'> <form-bean name="drugForm" type="com.trade.struts.form.DrugForm" /> </li>
<li> <form-bean name="drugQueryForm" type="com.trade.struts.queryform.DrugQueryForm" /> </li>
<li class='alt'> <form-bean name="baseForm" type="com.trade.struts.queryform.BaseForm" /> </li>
<li> form-beans> </li>
<li class='alt'> </li>
<li> <global-exceptions /> </li>
<li class='alt'> <global-forwards /> </li>
<li> <action-mappings> </li>
<li class='alt'> <action </li>
<li> attribute="drugQueryForm" </li>
<li class='alt'> input="/Drug/drug_list.jsp" </li>
<li> name="drugQueryForm" </li>
<li class='alt'> parameter="method" </li>
<li> path="/drugQuery" </li>
<li class='alt'> scope="request" </li>
<li> > </li>
<li class='alt'> <forward name="success" path="/index.jsp" /> </li>
<li> <forward name="list" path="/Drug/drug_list.jsp" /> </li>
<li class='alt'> action> </li>
<li> </li>
<li class='alt'> action-mappings> </li>
<li> </li>
<li class='alt'>  </li>
<li> <controller> </li>
<li class='alt'> <set-property property="processorClass" </li>
<li> value="org.springframework.web.struts.DelegatingRequestProcessor" /> </li>
<li class='alt'> controller> </li>
<li> </li>
<li class='alt'>  </li>
<li> <message-resources parameter="com.trade.struts.ApplicationResources" /> </li>
<li class='alt'> </li>
<li>  </li>
<li class='alt'> <plug-in </li>
<li> className="org.springframework.web.struts.ContextLoaderPlugIn"> </li>
<li class='alt'> <set-property property="contextConfigLocation" </li>
<li> value="/WEB-INF/applicationContext.xml" /> </li>
<li class='alt'> plug-in> </li>
<li>struts-config> </li>
<li class='alt'> </li>
</ol></div>
 Spring配置代码
<div class='code_title'>xml 代码</div>
<div class='dp-highlighter'><ol class='dp-xml'>
<li class='alt'>xml version="1.0" encoding="UTF-8"?> </li>
<li><beans xmlns="http://www.springframework.org/schema/beans" </li>
<li class='alt'> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" </li>
<li> xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"> </li>
<li class='alt'> </li>
<li>  </li>
<li class='alt'>  </li>
<li> </li>
<li class='alt'> <bean id="dataSourceTrade" </li>
<li> class="org.apache.commons.dbcp.BasicDataSource"> </li>
<li class='alt'> <property name="driverClassName" </li>
<li> value="com.microsoft.jdbc.sqlserver.SQLServerDriver"> </li>
<li class='alt'> property> </li>
<li> <property name="url" </li>
<li class='alt'> value="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=Trade"> </li>
<li> property> </li>
<li class='alt'> <property name="username" value="share">property> </li>
<li> <property name="password" value="sa">property> </li>
<li class='alt'> bean> </li>
<li> </li>
<li class='alt'> <bean id="sessionFactoryTrade" </li>
<li> class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> </li>
<li class='alt'> <property name="dataSource"> </li>
<li> <ref bean="dataSourceTrade" /> </li>
<li class='alt'> property> </li>
<li> <property name="hibernateProperties"> </li>
<li class='alt'> <props> </li>
<li> <prop key="hibernate.dialect"> </li>
<li class='alt'> org.hibernate.dialect.SQLServerDialect </li>
<li> prop> </li>
<li class='alt'> <prop key="hibernate.show_sql">trueprop> </li>
<li> <prop key="current_session_context_class">threadprop> </li>
<li class='alt'> <prop key="connection.pool_size">10prop> </li>
<li> <prop key="hibernate.hbm2ddl.auto">updateprop> </li>
<li class='alt'> props> </li>
<li> property> </li>
<li class='alt'> <property name="mappingResources"> </li>
<li> <list>list> </li>
<li class='alt'> property> </li>
<li> bean> </li>
<li class='alt'> </li>
<li>  </li>
<li class='alt'> </li>
<li> <bean id="dataSourceRush" </li>
<li class='alt'> class="org.apache.commons.dbcp.BasicDataSource"> </li>
<li> <property name="driverClassName" </li>
<li class='alt'> value="com.microsoft.jdbc.sqlserver.SQLServerDriver"> </li>
<li> property> </li>
<li class='alt'> <property name="url" </li>
<li> value="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=Rush"> </li>
<li class='alt'> property> </li>
<li> <property name="username" value="share">property> </li>
<li class='alt'> <property name="password" value="sa">property> </li>
<li> bean> </li>
<li class='alt'> </li>
<li> <bean id="sessionFactoryRush" </li>
<li class='alt'> class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> </li>
<li> <property name="dataSource"> </li>
<li class='alt'> <ref bean="dataSourceTrade" /> </li>
<li> property> </li>
<li class='alt'> <property name="hibernateProperties"> </li>
<li> <props> </li>
<li class='alt'> <prop key="hibernate.dialect"> </li>
<li> org.hibernate.dialect.SQLServerDialect </li>
<li class='alt'> prop> </li>
<li> props> </li>
<li class='alt'> property> </li>
<li> <property name="mappingResources"> </li>
<li class='alt'> <list> </li>
<li> <value>com/trade/vo/rush/Drug.hbm.xmlvalue> </li>
<li class='alt'> list> </li>
<li> property> </li>
<li class='alt'> bean> </li>
<li class='alt'>  </li>
<li> <bean id="DrugDAOHibernate" class="com.trade.dao.hibernate.DrugDAOHibernate"> </li>
<li> <property name="sessionFactory"> </li>
<li class='alt'> <ref bean="sessionFactoryRush" /> </li>
<li> property> </li>
<li class='alt'> bean> </li>
<li> <bean id="DrugService" class="com.trade.service.DrugService"> </li>
<li class='alt'> <property name="ddh"> </li>
<li> <ref bean="DrugDAOHibernate" /> </li>
<li class='alt'> property> </li>
<li> bean> </li>
<li class='alt'> </li>
<li> <bean name="/drugQuery" abstract="false" lazy-init="default" </li>
<li class='alt'> autowire="default" dependency-check="default" class="com.trade.struts.action.DrugAction"> </li>
<li> <property name="ds"> </li>
<li class='alt'> <ref bean="DrugService" /> </li>
<li> property> </li>
<li class='alt'> bean>beans> </li>
</ol></div>
三、DAOImpl、Service 业务逻辑部分
因为主要是介绍分页，这里只放分页相关代码
DrugDAOHibernate类，这里使用的方法参考（抄袭。。）了Robbin等关于使用离线Criteria实现查询的代码
<div class='code_title'>java 代码</div>
<div class='dp-highlighter'><ol class='dp-j'>
<li class='alt'>package com.trade.dao.hibernate; </li>
<li> </li>
<li class='alt'>import java.util.List; </li>
<li> </li>
<li class='alt'>import org.apache.commons.logging.Log; </li>
<li>import org.apache.commons.logging.LogFactory; </li>
<li class='alt'>import org.hibernate.Criteria; </li>
<li>import org.hibernate.HibernateException; </li>
<li class='alt'>import org.hibernate.Session; </li>
<li>import org.hibernate.criterion.DetachedCriteria; </li>
<li class='alt'>import org.hibernate.criterion.Projections; </li>
<li>import org.springframework.orm.hibernate3.HibernateCallback; </li>
<li class='alt'>import org.springframework.orm.hibernate3.support.HibernateDaoSupport; </li>
<li> </li>
<li class='alt'>import com.trade.dao.IDrugDAO; </li>
<li>import com.trade.vo.DrugDAO; </li>
<li class='alt'>import com.trade.vo.rush.Drug; </li>
<li> </li>
<li class='alt'>public class DrugDAOHibernate extends HibernateDaoSupport implements IDrugDAO { </li>
<li> </li>
<li class='alt'> private static final Log log = LogFactory.getLog(DrugDAO.class); </li>
<li> </li>
<li class='alt'> //获得符合查询条件的记录数目 </li>
<li> public Long getDrugCount(final DetachedCriteria detachedCriteria) { </li>
<li class='alt'> return (Long)getHibernateTemplate().execute(new HibernateCallback() { </li>
<li> public Object doInHibernate(Session session) throws HibernateException { </li>
<li class='alt'> Criteria criteria = detachedCriteria.getExecutableCriteria(session); </li>
<li> Long count= Long.parseLong((criteria.setProjection(Projections.rowCount()).uniqueResult()).toString()); </li>
<li class='alt'> criteria.setProjection(null); </li>
<li> return count; </li>
<li class='alt'> } </li>
<li> }, true); </li>
<li class='alt'> } </li>
<li> </li>
<li class='alt'> //根据条件进行查询、分页 </li>
<li> public List listByConditions(final DetachedCriteria detachedCriteria,final int pageNo,final int pageSize) { </li>
<li class='alt'> </li>
<li> return (List) getHibernateTemplate().execute(new HibernateCallback() { </li>
<li class='alt'> public Object doInHibernate(Session session) throws HibernateException { </li>
<li> Criteria criteria = detachedCriteria.getExecutableCriteria(session); </li>
<li class='alt'> criteria.setMaxResults(pageSize); </li>
<li> criteria.setFirstResult((pageNo-1)*pageSize); </li>
<li class='alt'> return criteria.list(); </li>
<li> } </li>
<li class='alt'> }, true); </li>
<li> } </li>
<li class='alt'> </li>
<li> } </li>
</ol></div>
Service层很简单
<div class='code_title'>java 代码</div>
<div class='dp-highlighter'><ol class='dp-j'>
<li class='alt'>package com.trade.service; </li>
<li> </li>
<li class='alt'>import java.util.List; </li>
<li> </li>
<li class='alt'>import org.hibernate.criterion.DetachedCriteria; </li>
<li> </li>
<li class='alt'>import com.trade.dao.hibernate.DrugDAOHibernate; </li>
<li> </li>
<li class='alt'> </li>
<li> </li>
<li class='alt'>public class DrugService { </li>
<li>//由Spring注入DrugDAOHibernate实例 </li>
<li class='alt'>private DrugDAOHibernate ddh ; </li>
<li> </li>
<li class='alt'>public DrugDAOHibernate getDdh() { </li>
<li> return ddh; </li>
<li class='alt'>} </li>
<li> </li>
<li class='alt'>public void setDdh(DrugDAOHibernate ddh) { </li>
<li> this.ddh = ddh; </li>
<li class='alt'>} </li>
<li> </li>
<li class='alt'>//获得满足条件的记录数 </li>
<li>public List listByConditions(final DetachedCriteria detachedCriteria,final int pageNo,final int pageSize){ </li>
<li class='alt'> return ddh.listByConditions(detachedCriteria,pageNo,pageSize); </li>
<li> </li>
<li class='alt'>} </li>
<li>//根据条件进行查询、分页 </li>
<li class='alt'>public Long getDrugCount(final DetachedCriteria detachedCriteria){ </li>
<li> return ddh.getDrugCount(detachedCriteria); </li>
<li class='alt'>} </li>
<li>} </li>
</ol></div>
字数有限制。。请见下文。。</div>

1 楼 bobomtv17 2007-12-13

很不错的例子,我也在学习SSH,谢谢了!

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论