spring系列(七):SSH整合二

环境：jdk1.7    spring3.2.2    struts2.3.15   hibernate3.3.2  druid1.0.9.jar

上一篇我们讲解了ssh的整合。这一篇继续深入ssh的整合。

连接池我们将更换为性能更为强大的阿里巴巴的druid连接池

并对配置文件进行拆分以及对代码进行更进一步的分层

下面来看工程的建立及相关代码

导入包

工程结构

============web.xml配置=========================

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">    <error-page>  <error-code>404</error-code>  <location>/Err404.html</location>  </error-page>  <error-page>  <error-code>500</error-code>  <location>/Err500.html</location>  </error-page>    <!-- 解决延迟加载的问题start -->  <filter>  <filter-name>OpenSessionInView</filter-name>  <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>  </filter>  <filter-mapping>  <filter-name>OpenSessionInView</filter-name>  <url-pattern>*.php</url-pattern>  </filter-mapping>  <!-- 解决延迟加载的问题end -->    <!--struts2 config start  -->  <filter>  <filter-name>struts2</filter-name>  <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>  <init-param>  <param-name>config</param-name>  <param-value>struts-default.xml,struts-plugin.xml,configs/struts.xml</param-value>  </init-param>  </filter>  <filter-mapping>  <filter-name>struts2</filter-name>  <url-pattern>/*</url-pattern>  </filter-mapping>  <!--struts2 config end  -->      <!-- druid pool -->  <filter>     <filter-name>DruidWebStatFilter</filter-name>     <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>     <init-param>         <param-name>exclusions</param-name>         <param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>     </init-param>  </filter>  <filter-mapping>     <filter-name>DruidWebStatFilter</filter-name>     <url-pattern>/*</url-pattern>  </filter-mapping>  <servlet>        <servlet-name>DruidStatView</servlet-name>        <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>  </servlet>  <servlet-mapping>        <servlet-name>DruidStatView</servlet-name>        <url-pattern>/druid/*</url-pattern>  </servlet-mapping>  <!--http://localhost:8080/SSHFinal/druid/index.html  -->        <!--spring config start -->  <context-param>  <param-name>contextConfigLocation</param-name>  <param-value>classpath:configs/context.xml</param-value>  </context-param>  <listener>  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  </listener>  <!-- spring config end -->    <!-- 加载日志start -->  <context-param>  <param-name>log4jConfigLocation</param-name>  <param-value>classpath:configs/log4j.properties</param-value>  </context-param>  <listener>  <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>  </listener>  <!-- 加载日志end -->    <welcome-file-list>    <welcome-file>Login.jsp</welcome-file>  </welcome-file-list></web-app>

================druid连接池配置druid.properties==================

driverClassName=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/studentdbusername=rootpassword=sasa#配置监控统计拦截的filters，去掉后监控界面sql无法统计filters=stat#配置初始化大小 initialSize=6#配置初始化最大连接数 maxActive=20#配置初始化最小连接数 minIdle=3#配置获取连接等待超时的时间,1分钟 maxWait=60000#检测连接是否有效的SQL validationQuery=SELECT 'x'#空闲的连接是否进行有效性检查testWhileIdle=true#申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能 testOnBorrow=false#归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能 testOnReturn=false#启用PSCache，必须配置大于0，当大于0时，poolPreparedStatements自动触发修改为true maxPoolPreparedStatementPerConnectionSize=20#对于长时间不使用的连接强制关闭 removeAbandoned=true#超过60秒的空闲连接就可以被关闭了,单位是秒 removeAbandonedTimeout=60#配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 timeBetweenEvictionRunsMillis=10000#配置一个连接在池中最小生存的时间，单位是毫秒 minEvictableIdleTimeMillis=30000

===============hibernate核心配置文件hibernate.cfg.xml========================

<!DOCTYPE hibernate-configuration PUBLIC"-//Hibernate/Hibernate Configuration DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration><session-factory><property name="dialect">org.hibernate.dialect.MySQLDialect</property><property name="show_sql">true</property><property name="format_sql">true</property><property name="current_session_context_class">thread</property><property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property><property name="cache.provider_configuration_file_resource_path">     configs/ehcache.xml</property><property name="hibernate.cache.use_second_level_cache">true</property><property name="hibernate.cache.use_query_cache">true</property></session-factory></hibernate-configuration>

===============spring核心配置文件context.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" xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beans                    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd                    http://www.springframework.org/schema/aop                    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd                    http://www.springframework.org/schema/tx                    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"><!-- 导入其它sping配置文件 --><import resource="classpath:configs/spring/context-*.xml"/><!-- durid连接池配置start --><bean id="duridConfig" class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer"><property name="locations">    <list><value>classpath:configs/druid.properties</value></list></property>    </bean>    <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"><property name="driverClassName" value="${driverClassName}" /><property name="url" value="${url}" /><property name="username" value="${username}" /><property name="password" value="${password}" /><property name="filters" value="${filters}" /><property name="initialSize" value="${initialSize}" /><property name="maxActive" value="${maxActive}" /><property name="minIdle" value="${minIdle}" /><property name="maxWait" value="${maxWait}" /><property name="validationQuery" value="${validationQuery}" /><property name="testWhileIdle" value="${testWhileIdle}" /><property name="testOnBorrow" value="${testOnBorrow}" /><property name="testOnReturn" value="${testOnReturn}" /><property name="maxPoolPreparedStatementPerConnectionSize" value="${maxPoolPreparedStatementPerConnectionSize}" /><property name="removeAbandoned" value="${removeAbandoned}" /><property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}" /><property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" /><property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" /></bean>    <!-- durid连接池配置end -->    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><property name="dataSource" ref="druidDataSource"></property><property name="configLocation"><value>classpath:configs/hibernate.cfg.xml</value></property><property name="mappingLocations"><list><value>classpath:configs/mappers/*.hbm.xml</value></list></property></bean><!-- 事务配置start --><bean id="txManger" class="org.springframework.orm.hibernate3.HibernateTransactionManager"><property name="sessionFactory" ref="sessionFactory"></property></bean><tx:advice id="txAdvise" transaction-manager="txManger"><tx:attributes><tx:method name="find*" read-only="true"/><tx:method name="search*" read-only="true"/><tx:method name="load*" read-only="true"/><tx:method name="query*" read-only="true"/><tx:method name="get*" read-only="true"/><tx:method name="add*" propagation="REQUIRED"/><tx:method name="save*" propagation="REQUIRED"/><tx:method name="modify*" propagation="REQUIRED"/><tx:method name="update*" propagation="REQUIRED"/><tx:method name="del*" propagation="REQUIRED"/><tx:method name="do*" propagation="REQUIRED"/></tx:attributes></tx:advice><aop:config><aop:pointcut id="mycut" expression="execution(* com.obtk.biz.*.*(..))"/><aop:advisor advice-ref="txAdvise" pointcut-ref="mycut"/></aop:config><!-- 事务配置end --></beans>

==============dao层配置context-dao.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" xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beans                    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd                    http://www.springframework.org/schema/aop                    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd                    http://www.springframework.org/schema/tx                    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"><!-- 根据名称自动装配 --><bean id="userDao" class="com.obtk.dao.user.UserDaoImpl" autowire="byName"></bean><!-- 根据类型自动装配 --><bean id="stuDao" class="com.obtk.dao.stu.StudentDaoImpl" autowire="byType"></bean><!-- 不进行自动装配 --><bean id="acctDao" class="com.obtk.dao.acct.AcctDaoImpl"><property name="sessionFactory" ref="sessionFactory"></property></bean></beans>

====================struts核心配置文件struts.xml=====================

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN""struts-2.3.dtd"><struts>    <constant name="struts.action.extension" value="php"></constant>    <constant name="struts.multipart.saveDir" value="C:\tmp"></constant>    <!-- 最大只能传1m上来 -->    <constant name="struts.multipart.maxSize" value="1048576"></constant>    <!-- 导入其它struts配置 --><include file="configs/struts/struts-*.xml"></include></struts>

==============用户模块的struts配置struts-user.xml======================

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN""struts-2.3.dtd"><struts>    <package name="user" extends="struts-default"><action name="Login" class="com.obtk.actions.user.LoginAction"><result name="success">index.jsp</result><result name="input">Login.jsp</result></action><action name="CheckUser" class="com.obtk.actions.user.CheckUserAction"><result name="success" type="stream"><param name="contentType">text/html</param><param name="inputName">bis</param></result></action><action name="Register" class="com.obtk.actions.user.RegisterAction"><result name="success">Login.jsp</result><result name="input">Register.jsp</result></action><action name="ShowWeather" class="com.obtk.actions.user.WeatherAction"><result name="success">ShowWeather.jsp</result></action></package></struts>

=================关键的分页代码StudentDaoImpl.java=====================

package com.obtk.dao.stu;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import org.hibernate.HibernateException;import org.hibernate.Query;import org.hibernate.Session;import org.springframework.orm.hibernate3.HibernateCallback;import org.springframework.orm.hibernate3.HibernateTemplate;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.obtk.entitys.PageEntity;import com.obtk.entitys.StudentEntity;public class StudentDaoImpl extends HibernateDaoSupport implements IStudentDao{public StudentEntity loadOne(Integer stuId) {HibernateTemplate template = this.getHibernateTemplate();template.setCacheQueries(true);StudentEntity stu = template.load(StudentEntity.class,stuId);return stu;}//hibernate分页@SuppressWarnings("unchecked")public List<StudentEntity> queryByPage(final PageEntity thePage) {List<StudentEntity> stuList=null;HibernateTemplate template = this.getHibernateTemplate();template.setCacheQueries(true);String hql="from StudentEntity s inner join fetch s.dept d where 1=1";final StringBuffer hqlBuffer=new StringBuffer(hql);if(thePage.getStuName()!=null){hqlBuffer.append(" and s.stuName like '%'"+thePage.getStuName()+"'%'");}if(thePage.getGender()!=null){hqlBuffer.append(" and s.gender='"+thePage.getGender()+"'");}if(thePage.getDeptName()!=null){hqlBuffer.append(" and d.deptName='"+thePage.getDeptName()+"'");}hqlBuffer.append(" order by s.age desc");stuList=this.getHibernateTemplate().executeFind(     new HibernateCallback<Object>() {     public Object doInHibernate(Session session)    throws HibernateException, SQLException {    Query qy=session.createQuery(hqlBuffer.toString());    //设置每页显示多少条    qy.setMaxResults(thePage.getPageSize());    //设置从那一条开始    qy.setFirstResult((thePage.getPageNo()-1)*thePage.getPageSize());     return qy.list();    }});return stuList;}//hibernate分页public Integer countCnt(PageEntity thePage) {Integer result=null;HibernateTemplate template = this.getHibernateTemplate();template.setCacheQueries(true);String hql="select count(*) from StudentEntity s inner join s.dept d where 1=1";final StringBuffer hqlBuffer=new StringBuffer(hql);if(thePage.getStuName()!=null){hqlBuffer.append(" and s.stuName like '%'"+thePage.getStuName()+"'%'");}if(thePage.getGender()!=null){hqlBuffer.append(" and s.gender='"+thePage.getGender()+"'");}if(thePage.getDeptName()!=null){hqlBuffer.append(" and d.deptName='"+thePage.getDeptName()+"'");}List theList=template.find(hqlBuffer.toString());if(theList.size()!=0){result=Integer.parseInt(theList.get(0)+"");}System.out.println("总条数:"+result);return result;}}

=============PageEntity.java===================

package com.obtk.entitys;import java.io.Serializable;public class PageEntity implements Serializable{private static final long serialVersionUID = -3179165911044543465L;private Integer pageNo=1;      //当前页码private Integer pageSize=3;    //每页显示多少条 private Integer totalPages;    //总页码private String stuName;     //搜索关键字private String gender;  //根据性别搜private String deptName;   //根据部门名称public PageEntity() {}public Integer getPageNo() {return pageNo;}public void setPageNo(Integer pageNo) {this.pageNo = pageNo;}public Integer getPageSize() {return pageSize;}public void setPageSize(Integer pageSize) {this.pageSize = pageSize;}public Integer getTotalPages() {return totalPages;}public void setTotalPages(Integer totalPages) {this.totalPages = totalPages;}public void setStuName(String stuName) {this.stuName = stuName;}public String getStuName() {return stuName;}public void setDeptName(String deptName) {this.deptName = deptName;}public String getDeptName() {return deptName;}public String getGender() {return gender;}public void setGender(String gender) {this.gender = gender;}}

=======action代码StudentPageAction.java=====================

package com.obtk.actions.stu;import java.util.List;import java.util.Map;import com.obtk.biz.StudentBiz;import com.obtk.entitys.PageEntity;import com.obtk.entitys.StudentEntity;import com.opensymphony.xwork2.ActionContext;import com.opensymphony.xwork2.ActionSupport;public class StudentPageAction extends ActionSupport{private String stuName;private String gender;private String deptName;private String pageNo;private String pageSize;private StudentBiz stuBiz;public void setStuBiz(StudentBiz stuBiz) {this.stuBiz = stuBiz;}public String execute() throws Exception {PageEntity thePage=new PageEntity();     if(pageNo!=null){    int mYPageNo=Integer.parseInt(pageNo);    thePage.setPageNo(mYPageNo);    }    if(pageSize!=null){    int myPageSize=Integer.parseInt(pageSize);    thePage.setPageSize(myPageSize);    }    if(stuName!=null){    stuName=new String(stuName.getBytes("iso-8859-1"),"utf-8");    thePage.setStuName(stuName);    }    if(gender!=null){    gender=new String(gender.getBytes("iso-8859-1"),"utf-8");    thePage.setGender(gender);    }    if(deptName!=null){    deptName=new String(deptName.getBytes("iso-8859-1"),"utf-8");    thePage.setDeptName(deptName);    }//第一次进来就是第一页数据List<StudentEntity> stuList=stuBiz.queryByPage(thePage);//总条数int rows=stuBiz.countCnt(thePage);int totalPages=0;if(rows%thePage.getPageSize()==0){totalPages=rows/thePage.getPageSize();}else{totalPages=rows/thePage.getPageSize()+1;}//因为要在页面上展示thePage.setTotalPages(totalPages);ActionContext ac=ActionContext.getContext();Map request=(Map)ac.get("request");if(stuList!=null){//分页实体对象request.put("thePage",thePage);//尽量用request对象保存数据request.put("stuList",stuList);return this.SUCCESS;}else{return this.ERROR;}}public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}public String getGender() {return gender;}public void setGender(String gender) {this.gender = gender;}public String getDeptName() {return deptName;}public void setDeptName(String deptName) {this.deptName = deptName;}public String getPageNo() {return pageNo;}public void setPageNo(String pageNo) {this.pageNo = pageNo;}public String getPageSize() {return pageSize;}public void setPageSize(String pageSize) {this.pageSize = pageSize;}}

==================页面代码===================

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@ taglib  prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@page import="java.text.SimpleDateFormat"%><%@page import="com.obtk.entitys.*"%> <c:set var="path" value="${pageContext.request.contextPath}"></c:set><c:set var="scheme" value="${pageContext.request.scheme}"></c:set><c:set var="serverName" value="${pageContext.request.serverName}"></c:set><c:set var="serverPort" value="${pageContext.request.serverPort}"></c:set><c:set var="basePath" value="${scheme}://${serverName}:${serverPort}${path}/"></c:set><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <!-- 设定参考路径 -->    <base href="${basePath }">    <title>第一个页面</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0">  <script type="text/javascript">function changePage(){var sizeStrTag=document.getElementsByName("theSize")[0];var sizeStr=sizeStrTag.value;window.location="QueryStuPage.php?pageNo=1&pageSize="+sizeStr;}</script>    </head><body><h2>欢迎您:${sessionScope.userName}  <a href="Quit.php">退出</a></h2><h2>显示学生的数据 </h2><form action="QueryStuPage.php" method="get"><p><input type="text" name="stuName" value="${thePage.stuName}"/> <input type="submit" value="搜索"/></p></form><c:if test="${not empty stuList}"><table border="1px"><tr><td>编号</td><td>名称</td><td>性别</td><td>年龄</td><td>地址</td><td>操作</td></tr>   <c:forEach items="${stuList}" var="stu">     <tr><td>${stu.stuId}</td><td>${stu.stuName}</td>        <td>${stu.gender}</td>        <td>${stu.age}</td><td>${stu.address}</td>        <td><a href="DeleteStu.php?stuId=${stu.stuId}">删除</a>             <a href="QueryOne.php?stuId=${stu.stuId}">修改</a></td></tr>   </c:forEach></table><!-- 如果当前不是第一页，就有上一页 --><c:set var="pre" value="1"></c:set><c:if test="${thePage.pageNo ne 1}"><c:set var="pre" value="${thePage.pageNo*1 -1}"></c:set></c:if><!-- 如果当前不是最后一页,就有下一页 --><c:set var="next" value="${thePage.totalPages}"></c:set><c:if test="${thePage.pageNo ne thePage.totalPages}"><c:set var="next" value="${thePage.pageNo*1+1}"></c:set></c:if><p>当前页码:${thePage.pageNo}/${thePage.totalPages}       <a href="QueryStuPage.php?pageNo=1&pageSize=${thePage.pageSize}&keyStr=${thePage.stuName}">首页</a>     <a href="QueryStuPage.php?pageNo=${thePage.totalPages}&pageSize=${thePage.pageSize}&keyStr=${thePage.stuName}">尾页</a>     <a href="QueryStuPage.php?pageNo=${pre}&pageSize=${thePage.pageSize}&keyStr=${thePage.stuName}">上一页</a>     <a href="QueryStuPage.php?pageNo=${next}&pageSize=${thePage.pageSize}&keyStr=${thePage.stuName}">下一页</a>     每页显示多少条<select name="theSize" onchange="changePage();">    <option value="3"    <c:if test="${thePage.pageSize eq 3}">selected="selected"</c:if>        >3</option>    <option value="5"     <c:if test="${thePage.pageSize eq 5}">        selected="selected"        </c:if>       >5</option>    <option value="8"        <c:if test="${thePage.pageSize eq 8}">        selected="selected"        </c:if>       >8</option>    </select></p></c:if></body></html>