SSH三大框架的整合+利用Ajax实现无刷新分页

最新推荐文章于 2019-06-11 09:01:45 发布

不贰之家

最新推荐文章于 2019-06-11 09:01:45 发布

阅读量4.4k

点赞数

分类专栏： Java 文章标签： ajax hibernate 数据库 struts spring

本文链接：https://blog.csdn.net/qq_34078119/article/details/56048997

版权

Java 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

本文档详细介绍了如何将Struts2.3.24、Spring4.0和Hibernate4.2整合，并结合MySQL数据库进行SSH项目的搭建。通过引入json.js，实现了Ajax无刷新分页功能。配置过程包括：web.xml的设置、实体类和数据库的连接（如Person.java和Person.hbm.xml）、Dao、Biz和Action的实现，以及多个配置文件的编写（如struts.xml、hibernate.cfg.xml、db.properties等）。最后，成功页面success.jsp展示了分页效果。

摘要由CSDN通过智能技术生成

以下是我利用Struts2.3.24、Spring4.0、Hibernate4.2 结合Mysql数据库进行的ssh整合，实现分页需要json.js
首先ssh的整合需要导入所有的jar包

在web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>testssh</display-name>
  <!-- 加载Struts配置文件 -->
  <filter>
      <filter-name>struts2</filter-name>
      <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>/*</url-pattern>
  </filter-mapping>
  <!--加载spring  -->
  <!-- needed for ContextLoaderListener -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext-*.xml</param-value>
    </context-param>

    <!-- Bootstraps the root web application context before servlet initialization -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
</web-app>

接下来需要加入实体类与数据库相连接
Person.java

package com.zking.entity;

public class Person {
    private int pid;
    private String pname;
    private int page;
    public int getPid() {
        return pid;
    }
    public void setPid(int pid) {
        this.pid = pid;
    }
    public String getPname() {
        return pname;
    }
    public void setPname(String pname) {
        this.pname = pname;
    }
    public int getPage() {
        return page;
    }
    public void setPage(int page) {
        this.page = page;
    }
    public Person(String pname, int page) {
        super();
        this.pname = pname;
        this.page = page;
    }
    public Person() {
        super();
        // TODO Auto-generated constructor stub
    }



}

加入是实体类的映射文件
Person.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-2-18 20:09:46 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="com.zking.entity.Person" table="PERSON">
        <id name="pid" type="int">
            <column name="PID" />
            <generator class="native" />
        </id>
        <property name="pname" type="java.lang.String">
            <column name="PNAME" />
        </property>
        <property name="page" type="int">
            <column name="PAGE" />
        </property>
    </class>
</hibernate-mapping>

写一个PersoDao.java

package com.zking.dao;

import java.util.List;

import com.zking.entity.Person;

public interface PersonDao {
    public void addPerson(Person person);
    public List<Person> getPersons(int pageNo,int pageSize);
}

用PersonDaoImp.java实现PersonDao

package com.zking.dao;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;

import com.zking.entity.Person;

public class PersonDaoImp implements PersonDao {
    private SessionFactory sessionFactory;
    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    public Session getSession(){
        return sessionFactory.getCurrentSession();
    }

    @Override
    public void addPerson(Person person) {
            getSession().save(person);
    }

    @Override
    public List<Person> getPersons(int pageNo,int pageSize) {
        List<Person> persons=getSession().createQuery("from Person")
                .setFirstResult((pageNo-1)*pageSize)//从第几条开始拿
                .setMaxResults(pageSize)//每次拿几条
                .list();
        return persons;
    }
}

PersonBiz.java

package com.zking.biz;

import java.util.List;

import com.zking.entity.Person;

public interface PersonBiz {
    public void addPerson(Person person);
    public List<Person> getPersons(int pageNo,int pageSize);
}

PersonBizImp.java

package com.zking.biz;

import java.util.List;

import com.zking.dao.PersonDao;
import com.zking.entity.Person;

public class PersonBizImp implements PersonBiz{

    private PersonDao personDao;
    public PersonDao getPersonDao() {
        return personDao;
    }

    public void setPersonDao(PersonDao personDao) {
        this.personDao = personDao;
    }

    @Override
    public void addPerson(Person person) {
        personDao.addPerson(person);
    }

    @Override
    public List<Person> getPersons(int pageNo,int pageSize) {
        return personDao.getPersons(pageNo,pageSize);
    }

}

PersonAction.java

package com.zking.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionSupport;
import com.zking.biz.PersonBiz;
import com.zking.entity.Person;

import net.sf.json.JSONArray;

public class PersonAction extends ActionSupport{
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    private Person person;
    private PersonBiz personBiz;

    private int pageNo=1;
    private int pageSize=5;

    public int getPageNo() {
        return pageNo;
    }


    public void setPageNo(int pageNo) {
        this.pageNo = pageNo;
    }


    public int getPageSize() {
        return pageSize;
    }


    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }


    public PersonBiz getPersonBiz() {
        return personBiz;
    }


    public void setPersonBiz(PersonBiz personBiz) {
        this.personBiz = personBiz;
    }


    public void setPerson(Person person) {
        this.person = person;
    }


    public Person getPerson() {
        return person;
    }

    public String add() throws Exception {
        // TODO Auto-generated method stub
        System.out.println("wwwwwwwww");
        System.out.println("添加"+person.getPname()+person.getPage());
        personBiz.addPerson(person);
        //展示
        List<Person> persons=personBiz.getPersons(pageNo, pageSize);
        //得到请求域
        ServletActionContext.getRequest().setAttribute("persons", persons);


        return "success";
    }

    //chaxun
    public void query(){

        System.out.println("pageNo"+pageNo);
        List<Person> persons=personBiz.getPersons(pageNo, pageSize);
        //把查询到的值转为json（对象集合转json）
        JSONArray jsonArray=new JSONArray();
        jsonArray=JSONArray.fromObject(persons);
        String str=jsonArray.toString();

        try {
            HttpServletResponse response=ServletActionContext.getResponse();
            response.setCharacterEncoding("utf-8");
            PrintWriter printWriter=response.getWriter();
            printWriter.write(str);
            printWriter.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }


    }


}

接下来是关键的配置文件
struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
    "http://struts.apache.org/dtds/struts-2.3.dtd">
     <struts>
        <package name="myPackage" extends="struts-default">
            <action name="personAction*" class="personAction" method="{1}">
                <result name="success">/success.jsp</result>
            </action>

        </package>
    </struts>

hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!--被spring代替  -->
        <!-- <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password">password</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test</property>
        <pro perty name="hibernate.connection.username">root</property>-->

    <property name="show_sql">true</property>
    <property name="format_sql">true</property>


    </session-factory>
</hibernate-configuration>

db.properties连接数据库的信息

uname=root
upass=password
url=jdbc:mysql://localhost:3306/test
driver_class=com.mysql.jdbc.Driver

initPoolSize=5
maxPoolSize=10

关键的配置文件
applicationContext-public.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:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
  <!-- 引用db.properties -->
   <context:property-placeholder location="classpath:db.properties"/>
   <!-- 02.配置数据源：读取db.properties中的信息 -->
  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${uname}"></property>
        <property name="password" value="${upass}"></property>
        <property name="driverClass" value="${driver_class}"></property>
        <property name="jdbcUrl" value="${url}"></property>

        <property name="initialPoolSize" value="${initPoolSize}"></property>
        <property name="maxPoolSize" value="${maxPoolSize}"></property>
    </bean>
<!-- 03.配置SessionFactory -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <!-- 引用数据源 -->
        <property name="dataSource" ref="dataSource"></property>

        <!-- 加载hibernate配置文件 -->
        <property name="configLocation" value="classpath:hibernate.cfg.xml"></property>

        <!-- 关联hibernate映射文件 -->
        <property name="mappingLocations" value="classpath:com/zking/entity/*.hbm.xml"></property>
    </bean>

    <!-- 配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>

    <!-- 配置事务的属性 ：配置那个方法需要开事务-->
    <tx:advice id="myAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                <tx:method name="add*" propagation="REQUIRED"/>
                <tx:method name="update*"  propagation="REQUIRED"/>
                <tx:method name="delete*"  propagation="REQUIRED"/>
                <tx:method name="*"/>
            </tx:attributes>
    </tx:advice>

    <!-- 配置事务的切点：配置那个包下面的接口，下面的方法 -->
    <aop:config>
        <aop:pointcut expression="execution(* com.zking.dao.*.*(..))" id="myCut"/>
        <aop:advisor advice-ref="myAdvice" pointcut-ref="myCut"/>
    </aop:config>
</beans>

接下来的dao.biz.actio相关联
applicationContext-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"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!-- 配置personDaoImp -->
    <bean id="personDaoImp" class="com.zking.dao.PersonDaoImp">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
    </beans>

applicationContext-biz.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.xsd">
<!-- 配置personBizImp  -->
    <bean id="personBizImp" class="com.zking.biz.PersonBizImp" scope="prototype"> 
        <property name="personDao" ref="personDaoImp"></property>
    </bean>

</beans>

applicationContext-action.xml

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<form action="personActionadd.action" method="post">
<input type="text" name="person.pname"></br>
<input type="text" name="person.page"></br>
<input type="submit" value="添加">
</form>

</body>
</html>

跳转的成功页面
success.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<script type="text/javascript" src="js/json.js"></script>
<script type="text/javascript">
    var pageNo=1;

   function nextPage(){
       pageNo++;
       var xmlHttp;
        try {
            xmlHttp = new ActiveObject("Microsoft.XMLHTTP");
        } catch (e) {
            xmlHttp = new XMLHttpRequest();
        }

        xmlHttp.open("post", "personActionquery.action?pageNo="+pageNo, true);
        xmlHttp.setRequestHeader("Content-type",
                "application/x-www-form-urlencoded");
        xmlHttp.onreadystatechange = function() {
            if (xmlHttp.readyState == 4) {
                if (xmlHttp.status == 200) {
                        //接受
                   var str=xmlHttp.responseText;
                    //  alert(str);
                    //展示（把字符串装维对象）
                   var persons=JSON.parse(str);             
                    //alert(persons);   
                    //获取表格
                    var myTable=document.getElementById("myTable");
                    var s="<tr><th>编号</th><th>姓名</th><th>年龄</th></tr>";

                    for(var i=0;i<persons.length;i++){
                        s+="<tr><td>"+persons[i].pid+"</td><td>"+persons[i].pname+"</td><td>"+persons[i].page+"</td></tr>";
                    }
                    myTable.innerHTML=s;
                }
            }
        };
        xmlHttp.send(null); 

   }

</script>

</head>
<body>
<h1>展示数据</h1>
    <table border="1" id="myTable"> 
    <tr>
    <th>遍号</th>
    <th>姓名</th>
    <th>年龄</th>

    </tr>
    <c:forEach items="${persons}" var="p">
    <tr>
    <td>${p.pid}</td>
    <td>${p.pname}</td>
    <td>${p.page}</td>

    </tr>
    </c:forEach>

    </table>
    <a href="javascript:nextPage()">下一页</a>



</body>
</html>