欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识！
您现在的位置是： 首页

Structs 2 Action 与 JQuery Datatable 的整合

程序员文章站 2022-07-16 18:30:40
...

这篇文章主要讲述SSH框架下如何整合AngularJS， JQuery Datatable 以及Bootstrap。 

 

废话少说，进入主题，本篇主要以代码粘贴为主。 

 

第一步：新建Maven项目，pom文件如下：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.boyi.web</groupId>
	<artifactId>ssh-datatabase-example</artifactId>
	<version>1.0.0</version>
	<packaging>war</packaging>
	<name>ssh-datatabase-example</name>
	<description>ssh-datatable-example</description>
	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<spring.version>3.1.0.RELEASE</spring.version>
		<struts.version>2.3.15</struts.version>
		<hibernate.version>4.2.0.Final</hibernate.version>
		<mysql.version>5.1.6</mysql.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.apache.struts</groupId>
			<artifactId>struts2-core</artifactId>
			<version>${struts.version}</version>
		</dependency>
		<dependency>
			<groupId>org.apache.struts</groupId>
			<artifactId>struts2-convention-plugin</artifactId>
			<version>${struts.version}</version>
		</dependency>

		<!-- JASON Plug-in -->
		<dependency>
			<groupId>org.apache.struts</groupId>
			<artifactId>struts2-json-plugin</artifactId>
			<version>${struts.version}</version>
		</dependency>
		
		<dependency>
			<groupId>org.apache.struts</groupId>
			<artifactId>struts2-spring-plugin</artifactId>
			<version>${struts.version}</version>
		</dependency>

		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>${hibernate.version}</version>
		</dependency>

		<!-- for JPA, use hibernate-entitymanager instead of hibernate-core -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-entitymanager</artifactId>
			<version>${hibernate.version}</version>
		</dependency>

		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-c3p0</artifactId>
			<version>${hibernate.version}</version>
		</dependency>
		
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>${mysql.version}</version>
		</dependency>
		
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
			<scope>provided</scope>
		</dependency>
		
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>1.6.12</version>
		</dependency>
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjweaver</artifactId>
			<version>1.6.12</version>
		</dependency>
		<dependency>
			<groupId>cglib</groupId>
			<artifactId>cglib</artifactId>
			<version>2.2</version>
		</dependency>
		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-core-asl</artifactId>
			<version>1.8.8</version>
		</dependency>
		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-mapper-asl</artifactId>
			<version>1.8.8</version>
		</dependency>
	</dependencies>
	<build>
		<finalName>ssh</finalName>
	</build>
</project>

 可以看出SSH的版本：

Spring ： 3.1.0.RELEASE

Struts2： 2.3.15

Hibernate ： 4.2.0.Final

 

 第二步: 设置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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
  <display-name>ssh-datatable-example</display-name>
  <filter>
  <filter-name>CharacterEncoding</filter-name>
  <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  <init-param>
   <param-name>encoding</param-name>
   <param-value>UTF-8</param-value>
  </init-param>
  <init-param>
   <param-name>forceEncoding</param-name>
   <param-value>true</param-value>
  </init-param>
 </filter>
  <filter-mapping>
  <filter-name>CharacterEncoding</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>

 
 <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>
        /WEB-INF/dispatcher-servlet.xml
    </param-value>
</context-param>

 <listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 </listener>

 <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>*.action</url-pattern>  
    </filter-mapping>  
</web-app>
 

 

第三步：设置dispatcher-servlet.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:c="http://www.springframework.org/schema/c" xmlns:cache="http://www.springframework.org/schema/cache"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:sec="http://www.springframework.org/schema/security" xmlns:jee="http://www.springframework.org/schema/jee"
	xmlns:lang="http://www.springframework.org/schema/lang" xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:p="http://www.springframework.org/schema/p" 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.1.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd
		http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-3.1.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd
		http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.1.xsd
		http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-3.1.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd
		http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.1.xsd
		http://www.springframework.org/schema/tx  http://www.springframework.org/schema/tx/spring-tx-3.1.xsd">

	<mvc:annotation-driven>
		<mvc:message-converters>
			<bean class="org.springframework.http.converter.StringHttpMessageConverter">
				<property name="supportedMediaTypes">
					<list>
						<value>text/html;charset=UTF-8</value>
						<value>text/plain;charset=UTF-8</value>
					</list>
				</property>
			</bean>
			<bean id="jsonHttpMessageConverter"
				class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter" />
		</mvc:message-converters>
	</mvc:annotation-driven>

	<context:component-scan base-package="com.boyi.web"></context:component-scan>

	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass" value="com.mysql.jdbc.Driver" />
		<property name="jdbcUrl"
			value="jdbc:mysql://localhost:3307/ssh?characterEncoding=UTF-8&amp;characterSetResults=UTF-8" />
		<property name="user" value="root" />
		<property name="password" value="admin" />
		<property name="maxPoolSize" value="100" />
		<property name="minPoolSize" value="20" />
		<property name="initialPoolSize" value="10" />
		<property name="maxIdleTime" value="1800" />
		<property name="acquireIncrement" value="10" />
		<property name="idleConnectionTestPeriod" value="600" />
		<property name="acquireRetryAttempts" value="30" />
		<property name="breakAfterAcquireFailure" value="false" />
		<property name="preferredTestQuery" value="SELECT NOW()" />
	</bean>

	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<constructor-arg ref="dataSource"></constructor-arg>
	</bean>

	<!-- hibernate 需要的信息 -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="packagesToScan">
			<list>
				<value>com.boyi.web.entity</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
			</props>
		</property>
	</bean>
	<aop:aspectj-autoproxy expose-proxy="true" />

	<tx:annotation-driven transaction-manager="txManager" />
	<bean id="txManager"
		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>

	<tx:advice id="txAdvice" transaction-manager="txManager">
		<tx:attributes>
			<tx:method name="save*" propagation="REQUIRED" />
			<tx:method name="add*" propagation="REQUIRED" />
			<tx:method name="create*" propagation="REQUIRED" />
			<tx:method name="insert*" propagation="REQUIRED" />
			<tx:method name="*" read-only="true" />
		</tx:attributes>
	</tx:advice>

	<aop:config proxy-target-class="true">
		<aop:advisor advice-ref="txAdvice"
			pointcut="execution(* com..service..*.*(..))" />
	</aop:config>
</beans>
 第四步，准备css和js目录

 

1. 从JQuery官网下载最新的jquery.min.js ，copy到js目录，这里我下载的是jQuery v1.11.1

2. 从Bootstrap官网下载最新的bootstrap.min.js， bootstrap.min.css，分别copy到js和css目录中，这里我下载的是Bootstrap v3.3.0

3. 从Datatables官网下载最新的jquery.dataTables.min.js， dataTables.bootstrap.min.js，dataTables.bootstrap.css， 分别copy到js和css目录中， 

目录结构如下：


Structs 2 Action 与 JQuery Datatable 的整合 博客分类： JavaAngularJSSSHJQueryDatatableBootstrap JavaAngularJSSSHJQueryDatatable 

第五步：写hibernate实体类

 

package com.boyi.web.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "PERSON")
public class Person {

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private int id;

	@Column(name = "NAME")
	private String name;

	@Column(name = "BIRTHDAY")
	private String birth;

	@Column(name = "GENDER")
	private String gender;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getBirth() {
		return birth;
	}

	public void setBirth(String birth) {
		this.birth = birth;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

}
 
 第六步：写hibernateDAO超类

 

 

package com.boyi.web.dao;

import java.io.Serializable;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Criterion;

public interface HqlBaseDao<T, PK extends Serializable> {
	int count();
	 /** 
     * Persist the newInstance object into database.
     * @param newInstance to save
     * @return The identifier
     **/
    PK save(T newInstance);

    /**
     * Save or update.
     * @param transientObject to save
     */
    void saveOrUpdate(T transientObject);
    
    /** 
     * Retrieve a persisted object with a given id from the database.
     * @param id to load
     * @return An object of type T
     */
    T load(PK id);
    
    /** 
     * Retrieve a persisted object with a given id from the database.
     * @param id to get
     * @return An object of type T
     */
    T get(PK id);
    /** 
     * Save changes made to a persistent object.  
     * @param transientObject object to update
     **/
    void update(T transientObject);

    /** 
     * Remove the given object from persistent storage in the database.
     * @param persistentObject object to delete.
     **/
    void delete(T persistentObject);
    
    /** 
     * Remove the given object from persistent storage in the database. 
     * @param s Query to execute 
     * @return A query object
     **/
    Query getQuery(String s);
    
    /** Deletes an object of a given Id. Will load the object internally so 
     * consider using delete (T obj) directly.
     * @param id Id of record
     */
    void delete(PK id);
    
    
    /** Delete object from disk.
     * @param persistentObject to delete
     * @param session to use
     * 
     */
    void delete(T persistentObject, Session session);

    /** Deletes an object of a given Id. Will load the object internally so consider using delete (T obj) directly.
     * @param id to delete 
     * @param session to use
     */
    void delete(PK id, Session session);

    /**
     * Loads the given Object.
     * @param id to load
     * @param session to use
     * @return  an object of type T
     */
    T load(PK id, Session session);

    /**
     * Loads the given Object.
     * @param id Id to load
     * @param session to use
     * @return An object of type T
     */
    T get(PK id, Session session);

    /** Save object to disk using given session.
     * @param o to save
     * @param session to use
     * @return the id of the saved object
     * 
     */
    PK save(T o, Session session);

    /** Save or update given object.
     * @param o item to save.
     * @param session to use
     * 
     */
    void saveOrUpdate(T o, Session session); 

    /** Update given object.
     * @param o item to update 
     * @param session to use
     * 
     */
    void update(T o, Session session); 
    
    /** Refreshes the object of type T.
     * @param persistentObject to refresh
     */
    void refresh(T persistentObject);
    
    /**
     * Get a query handle.
     * @param s Query to use
     * @param session to use
     * @return Query object
     */
    Query getQuery(String s, Session session);

    /** FindByExample.
     * @param exampleInstance to use
     * @param excludeProperty to exclude
     * @return A list of objects
     */
    List<T> findByExample(T exampleInstance, String... excludeProperty);
    
    /** Returns a list of objects.
     * @return list of objects
     */
    List<T> findAll();
    
    List<T> findListForPage(String hql, Integer page, Integer size, Object... objects);
    
    /** Flushes the cache of the currently-used session.
     * 
     */
    void flush();
    
    /** Object to evict from cache.
     * @param obj Object to evict
     */
    void evict(Object obj);
    
    /** Hibernate wrapper.
     * @param criterion to filter.
     * @return list of objects
     */
    List<T> findByCriteria(Criterion... criterion);
}
  
package com.boyi.web.dao.impl;

import java.io.Serializable;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Example;
import org.springframework.beans.factory.annotation.Autowired;

import com.boyi.web.dao.HqlBaseDao;

public class HqlBaseDaoImpl<T, PK extends Serializable> implements HqlBaseDao<T, PK>{

	/** Class type. */
	Class<T> type;
	
	@Autowired  
	SessionFactory sessionFactory;

	/**
	 * Default bean constructor for spring.
	 */
	public HqlBaseDaoImpl() {
		// default constructor for spring
	}

	/**
	 * Constructor.
	 * 
	 * @param type
	 *            class type
	 */
	public HqlBaseDaoImpl(Class<T> type) {
		this.type = type;
	}

	/**
	 * Helper functions.
	 * 
	 * @return the currently set class
	 */
	public Class<T> getPersistentClass() {
		return this.type;
	}

	/**
	 * Delete persistentObject from DB.
	 * 
	 * @param persistentObject
	 *            object to delete.
	 */
	public void delete(T persistentObject) {
		getSession().delete(persistentObject);
	}

	/**
	 * Deletes an object of a given Id. Will load the object internally so
	 * consider using delete (T obj) directly
	 * 
	 * @param id
	 *            Delete key
	 */
	public void delete(PK id) {
		getSession().delete(load(id));
	}

	/**
	 * Loads the given Object.
	 * 
	 * @param id
	 *            to load
	 * @return T Loaded object
	 */
	@SuppressWarnings("unchecked")
	public T load(PK id) {
		return (T) getSession().load(this.type, id);
	}

	/**
	 * Loads the given Object.
	 * 
	 * @param id
	 *            Id to load
	 * @return An object of type T
	 */
	@SuppressWarnings("unchecked")
	public T get(PK id) {
		return (T) getSession().get(this.type, id);
	}

	/**
	 * Item to save.
	 * 
	 * @param o
	 *            object to save
	 * @return PK
	 */
	@SuppressWarnings("unchecked")
	public PK save(T o) {
		return (PK) getSession().save(o);
	}

	/**
	 * Item to refresh.
	 * 
	 * @param o
	 *            object to refresh
	 */
	public void refresh(T o) {
		getSession().refresh(o);
	}

	/**
	 * Item to saveOrUpdate.
	 * 
	 * @param o
	 *            item to save.
	 */
	public void saveOrUpdate(T o) {
		getSession().saveOrUpdate(o);
	}

	/**
	 * Update object.
	 * 
	 * @param o
	 *            object to update
	 */
	public void update(T o) {
		getSession().update(o);
	}

	/**
	 * Gets the current session in use (creates one if necessary).
	 * 
	 * @return Session object
	 */
	public Session getSession() {
		return sessionFactory.getCurrentSession();
	}

	/**
	 * Get query.
	 * 
	 * @param s
	 *            Query to execute.
	 * @return Query object
	 */
	public Query getQuery(String s) {
		return getSession().createQuery(s);
	}

	/**
	 * Get Session factory.
	 * 
	 * @return SessionFactory Object
	 */
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	/**
	 * Set session factory.
	 * 
	 * @param sessionFactory
	 *            object
	 */
	@Autowired
	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}

	/**
	 * Delete object.
	 * 
	 * @param persistentObject
	 *            to delete
	 * @param session
	 *            to use
	 * 
	 */
	public void delete(T persistentObject, Session session) {
		session.delete(persistentObject);
	}

	/**
	 * Deletes an object of a given Id. Will load the object internally so
	 * consider using delete (T obj) directly.
	 * 
	 * @param id
	 *            to delete
	 * @param session
	 *            to use
	 */
	public void delete(PK id, Session session) {
		session.delete(load(id));
	}

	/**
	 * Loads the given Object.
	 * 
	 * @param id
	 *            to load
	 * @param session
	 *            to use
	 * @return an object of type T
	 */
	@SuppressWarnings("unchecked")
	public T load(PK id, Session session) {
		return (T) session.load(this.type, id);
	}

	/**
	 * Loads the given Object.
	 * 
	 * @param id
	 *            Id to load
	 * @param session
	 *            Session to use
	 * @return An object of type T
	 */
	@SuppressWarnings("unchecked")
	public T get(PK id, Session session) {
		return (T) session.get(this.type, id);
	}

	/**
	 * Save object.
	 * 
	 * @param o
	 *            to save
	 * @param session
	 *            to use
	 * @return the id of the saved object
	 * 
	 */
	@SuppressWarnings("unchecked")
	public PK save(T o, Session session) {
		return (PK) session.save(o);
	}

	/**
	 * Save Or Update object.
	 * 
	 * @param o
	 *            to save
	 * @param session
	 *            to use.
	 * 
	 */
	public void saveOrUpdate(T o, Session session) {
		session.saveOrUpdate(o);
	}

	/**
	 * Update record.
	 * 
	 * @param o
	 *            to update
	 * @param session
	 *            to use
	 * 
	 */
	public void update(T o, Session session) {
		session.update(o);
	}

	/**
	 * GetQuery.
	 * 
	 * @param s
	 *            to return
	 * @param session
	 *            to use
	 * @return Query object
	 */
	public Query getQuery(String s, Session session) {
		return session.createQuery(s);
	}

	/**
	 * Wrapper around hibernate functions.
	 * 
	 * @param criterion
	 *            to use
	 * @return A list of matching objects
	 */
	@SuppressWarnings("unchecked")
	public List<T> findByCriteria(Criterion... criterion) {
		Session session = getSession();
		Criteria crit = session.createCriteria(getPersistentClass());

		for (Criterion c : criterion) {
			crit.add(c);
		}
		return crit.list();
	}

	/**
	 * FindAll.
	 * 
	 * @return A list of all the objects
	 */
	public List<T> findAll() {
		return findByCriteria();
	}

	/**
	 * Flushes the cache of the currently-used session.
	 * 
	 */
	public void flush() {
		getSession().flush();
	}

	/**
	 * Object to evict from cache.
	 * 
	 * @param obj
	 *            Object to evict
	 */
	public void evict(Object obj) {
		getSession().evict(obj);
	}

	/**
	 * FindByExample.
	 * 
	 * @param exampleInstance
	 *            to use
	 * @param excludeProperty
	 *            to use
	 * @return List of matching objects
	 */
	@SuppressWarnings("unchecked")
	public List<T> findByExample(T exampleInstance, String... excludeProperty) {
		Criteria crit = getSession().createCriteria(getPersistentClass());
		Example example = Example.create(exampleInstance);
		for (String exclude : excludeProperty) {
			example.excludeProperty(exclude);
		}
		crit.add(example);
		return crit.list();
	}

	public List<T> findListForPage(String hql, Integer page, Integer size, Object... objects) {

		Query query = getSession().createQuery(hql);
		if (objects != null) {
			for (int i = 0; i < objects.length; i++) {
				query.setParameter(i, objects[i]);
			}
		}
		if (page != null && size != null) {
			query.setFirstResult((page - 1) * size).setMaxResults(size);
		}
		@SuppressWarnings("unchecked")
		List<T> list = query.list();
		return list;
	}

	@Override
	public int count() {
		Query query = getSession().createQuery("select count(*) from " + this.type.getName());
		return ((Long)query.iterate().next()).intValue();
	}

}
 第七步：写hibernateDAO类

 

package com.boyi.web.dao;

import java.io.Serializable;
import java.util.List;

import com.boyi.web.entity.Person;

public interface PersonDao extends HqlBaseDao<Person, Serializable> {
	
	
	/**
	 * 
	 * @param page
	 * @param pageSize
	 * @return the person by pagination
	 * @throws Exception
	 */
	public List<Person> list(Integer page, Integer pageSize) throws Exception;
}
  
package com.boyi.web.dao.impl;

import java.io.Serializable;
import java.util.List;

import org.springframework.stereotype.Repository;

import com.boyi.web.dao.PersonDao;
import com.boyi.web.entity.Person;

@Repository 
public class PersonDaoImpl extends HqlBaseDaoImpl<Person, Serializable> implements PersonDao {

	public PersonDaoImpl() {
		super(Person.class);
	}
	
	public List<Person> list(Integer page, Integer pageSize) throws Exception {
		return findListForPage("from Person", page, pageSize);
	}

}
  第八步：写Service类 
package com.boyi.web.service;

import java.util.List;

import com.boyi.web.entity.Person;

public interface PersonService {
	/**
	 * return the person counts
	 * @return
	 * @throws Exception
	 */
	public int count() throws Exception;
	
	/**
	 * 
	 * @param page
	 * @param pageSize
	 * @return the person by pagination
	 * @throws Exception
	 */
	public List<Person> list(Integer page, Integer pageSize) throws Exception;
}
  
package com.boyi.web.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.boyi.web.dao.PersonDao;
import com.boyi.web.entity.Person;
import com.boyi.web.service.PersonService;

@Service
public class PersonServiceImpl implements PersonService {

	@Autowired
	PersonDao dao;
	
	public int count() throws Exception {
		return dao.count();
	}

	public List<Person> list(Integer page, Integer pageSize) throws Exception {
		return dao.list(page, pageSize);
	}

}
 
第九步：写Action类
package com.boyi.web.action;

import java.util.List;

import javax.annotation.Resource;

import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.springframework.stereotype.Controller;

import com.boyi.web.entity.Person;
import com.boyi.web.service.PersonService;
import com.opensymphony.xwork2.ActionSupport;

@ParentPackage("json-default")
@Controller
public class PersonAjaxAction extends ActionSupport {

	private static final long serialVersionUID = 1L;

	/**
	 * datatable start value
	 */
	private int start;

	/**
	 * datatable page size
	 */
	private int length;
	private int recordsTotal;
	private int recordsFiltered;
	private int recordsDisplay;
	private List<Person> aaData;
	@Resource
	PersonService service;

	@Override
	@Action(value = "/persons", results = { @Result(name = "success", type = "json") })
	public String execute() throws Exception {
		// calculate the total records
		recordsTotal = service.count();

		// calculate the current page
		int page = start / length + 1;

		// query the persons
		aaData = service.list(page, length);
		
		recordsFiltered = recordsTotal;
		
		recordsDisplay = aaData.size();
		
		return ActionSupport.SUCCESS;
	}

	public int getStart() {
		return start;
	}

	public void setStart(int start) {
		this.start = start;
	}

	public int getLength() {
		return length;
	}

	public void setLength(int length) {
		this.length = length;
	}

	public int getRecordsTotal() {
		return recordsTotal;
	}

	public void setRecordsTotal(int recordsTotal) {
		this.recordsTotal = recordsTotal;
	}

	public int getRecordsFiltered() {
		return recordsFiltered;
	}

	public void setRecordsFiltered(int recordsFiltered) {
		this.recordsFiltered = recordsFiltered;
	}

	public List<Person> getAaData() {
		return aaData;
	}

	public void setAaData(List<Person> aaData) {
		this.aaData = aaData;
	}

	public static long getSerialversionuid() {
		return serialVersionUID;
	}

	public int getRecordsDisplay() {
		return recordsDisplay;
	}

	public void setRecordsDisplay(int recordsDisplay) {
		this.recordsDisplay = recordsDisplay;
	}
	
}
 
第十步：写JSP
<%@ 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>SHH - Datatable - Example</title>
<link rel='stylesheet' type='text/css' href='css/bootstrap.min.css'>
<link rel='stylesheet' type='text/css' href='css/dataTables.bootstrap.css'>
</head>
<body>
	<hr>
	<center>
		<h1>SHH - Datatable - Example</h1>
	</center>
	<hr>
	<div class="container">
		<div class="row">
			<table class="table table-striped table-bordered table-hover datatable" id="example"></table>
		</div>
		
	</div>
	
	<script src='js/jquery.min.js'></script>
	<script src='js/jquery.dataTables.min.js'></script>
	<script src='js/dataTables.bootstrap.min.js'></script>
	<script src='js/bootstrap.min.js'></script>
	<script src='js/index.js'></script>
</body>
</html>
 
第十一步：写JS
$(document).ready(function() {

	$("#example").dataTable({
		dom:
			"<'row'<'col-sm-12'tr>>" +
			"<'row'<'col-sm-3'i><'col-sm-3'l><'col-sm-6'p>>",
		"processing" : true,
		"serverSide" : true,
		"length" : 5,
		"paging" : true,
		"ordering" : true,
		"pageLength" : 5,
		"paginationType" : "full_numbers",
		"lengthMenu" : [ 5, 10, 25, 50, 75, 100 ],
		"ajax" : {
			"url" : "persons.action",
			"type" : "POST"
		},
		"columns" : [ {
			"title" : "ID",
			"data" : "id",
			"visible" : true,
			"orderable" : true,
			"render" : function(data, type, full, meta){
				return '<a href="http://www.baidu.com">' + data +'</a>';
			}
		}, {
			"title" : "NAME",
			"data" : "name",
			"visible" : true,
			"orderable" : true
		}, {
			"title" : "BIRTHDAY",
			"data" : "birth",
			"visible" : true,
			"orderable" : true
		}, {
			"title" : "GENDER",
			"data" : "gender",
			"visible" : true,
			"orderable" : true
		} ],
		"language" : {
			"emptyTable" : "没有数据",
			"info" : "显示 第 _START_ 到 _END_ 条数据  总共 _TOTAL_ 条数据 ",
			"infoEmpty" : "没有数据",
			"infoFiltered" : "(filtered from _MAX_ total entries)",
			"infoPostFix" : "",
			"thousands" : ",",
			"lengthMenu" : "每页显示条数 _MENU_ ",
			"loadingRecords" : "加载中...",
			"processing" : "处理中...",
			"search" : "搜索:",
			"zeroRecords" : "找不到匹配的数据",
			"paginate" : {
				"first" : "首页",
				"last" : "尾页",
				"next" : "下页",
				"previous" : "上页"
			}
		}
	});

});
 第十二步：数据库建表 
DROP DATABASE IF EXISTS `ssh`;
CREATE DATABASE IF NOT EXISTS `ssh` 
USE `ssh`;

DROP TABLE IF EXISTS `PERSON`;
CREATE TABLE IF NOT EXISTS `PERSON` (
  `ID` int(9) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(20) NOT NULL,
  `BIRTHDAY` varchar(20) NOT NULL,
  `GENDER` varchar(5) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
INSERT INTO `PERSON` (`ID`, `NAME`, `BIRTHDAY`, `GENDER`) VALUES
	(1, 'NAME1', '1984-01-02', '男'),
	(2, 'NAME2', '1984-01-03', '男'),
	(3, 'NAME3', '1984-01-04', '男'),
	(4, 'NAME4', '1984-01-05', '女'),
	(5, 'NAME5', '1984-01-06', '男'),
	(6, 'NAME6', '1984-01-07', '女'),
	(7, 'NAME7', '1984-01-08', '男'),
	(8, 'NAME8', '1984-01-09', '男'),
	(9, 'NAME9', '1984-01-10', '男'),
	(10, 'NAME10', '1984-01-11', '女'),
	(11, 'NAME11', '1984-01-12', '男'),
	(12, 'NAME12', '1984-01-13', '男'),
	(13, 'NAME13', '1984-01-14', '女'),
	(14, 'NAME14', '1984-01-15', '男'),
	(15, 'NAME15', '1984-01-16', '男'),
	(16, 'NAME16', '1984-01-17', '女'),
	(17, 'NAME17', '1984-01-18', '男'),
	(18, 'NAME18', '1984-01-19', '人妖'),
	(19, 'NAME19', '1984-01-20', '男'),
	(20, 'NAME20', '1984-01-12', '男'),
	(21, 'NAME21', '1984-01-22', '男');
 第十三步：打包部署，测试

Structs 2 Action 与 JQuery Datatable 的整合 博客分类： JavaAngularJSSSHJQueryDatatableBootstrap JavaAngularJSSSHJQueryDatatable 
  
完整代码在附件中，有兴趣的可以下载。
  • Structs 2 Action 与 JQuery Datatable 的整合 博客分类： JavaAngularJSSSHJQueryDatatableBootstrap JavaAngularJSSSHJQueryDatatable 
  • 大小: 41.8 KB
  • Structs 2 Action 与 JQuery Datatable 的整合 博客分类： JavaAngularJSSSHJQueryDatatableBootstrap JavaAngularJSSSHJQueryDatatable 
  • 大小: 38.1 KB
相关标签： Java AngularJS SSH JQuery Datatable

上一篇： jquery datatable 参数

下一篇： Spring Data 系列之JPA（二）

推荐阅读