ExtJs、Struts2、Hibernate3.2的Grid后台分页

1、大致思想模型

2、基本配置

2.1、创建数据库test，表student、mark

DROPTABLEIFEXISTS `test`.`student`;
CREATETABLE `test`.`student` (
`stuid` varchar(20) NOTNULL,
`stuname` varchar(20) NOTNULL,
`stusex` varchar(20) NOTNULL,
`stuaddress` varchar(20) NOTNULL,
PRIMARYKEY (`stuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROPTABLEIFEXISTS `test`.`mark`;
CREATETABLE `test`.`mark` (
`stuid` varchar(20) DEFAULTNULL,
`stumath` int(11) NOTNULL,
`stuchinese` int(11) NOTNULL,
`stuenglish` int(11) NOTNULL,
KEY `stuid` (`stuid`),
CONSTRAINT `stuid` FOREIGNKEY (`stuid`) REFERENCES `student` (`stuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2.2、配置hibernate

项目->点击右键->MyEclipse->Add Hibernate Capabilities...

2.3、配置hibernate.cfg.xml文件（如编码方式、sql在tomcat运行的显示）

<?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>
<property name="connection.username">root</property>
<property name="connection.url">
jdbc:mysql://localhost:3306
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="myeclipse.connection.profile">mysql</property>
<property name="connection.password">123</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>

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

<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property>
</session-factory>

</hibernate-configuration>

2.4、配置struts2，加入基本包和sturts.xml

commons-fileupload-1.2.1.jar

commons-io-1.3.2.jar

freemarker-2.3.16.jar

javassist-3.7.ga.jar

ognl-3.0.jar

struts2-core-2.2.1.jar

xwork-core-2.2.1.jar

2.5、配置web.xml（与struts2的交互）

<?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">
<filter>
<filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.FilterDispatcher
</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>

2.6、配置ExtJs

官网下载:http://www.sencha.com/products/js/

3、创建数据库持久层PO

（见源码）

4、创建数据库访问层DAO

4.1、创建DAO接口

package DAO;

import java.util.List;

publicinterface IStudentmarkDAO {
public List QueryAll(int start, int limit);
publicint FindAllRows();
}

4.2、创建DAO实现类

package DAO;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import HbmFactory.HibernateSessionFactory;

publicclass StudentmarkDAOImpl implements IStudentmarkDAO {
public List QueryAll(int start, int limit) {
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String sql ="select new map(p.stuid as stuid,p.stuname as stuname,p.stusex as stusex,p.stuaddress as stuaddress,"
+"q.stumath as stumath,q.stuchinese as stuchinese,q.stuenglish as stuenglish) from Student p,Mark q where p.stuid=q.stuid";

Query query = session.createQuery(sql);
session.getTransaction().commit();
if (query !=null) {
return query.setFirstResult(start).setMaxResults(limit).list();
}
returnnull;
}

publicint FindAllRows() {
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String sql ="select new map(p.stuid as stuid,p.stuname as stuname,p.stusex as stusex,p.stuaddress as stuaddress,"
+"q.stumath as stumath,q.stuchinese as stuchinese,q.stuenglish as stuenglish) from Student p,Mark q where p.stuid=q.stuid";

Query query = session.createQuery(sql);
session.getTransaction().commit();
if (query !=null) {
return query.list().size();
}
return0;
}
}

5、创建业务服务层Service

5.1、创建Service的Action控制器接口

package Service;

publicinterface IActionService {
public String execute() throws Exception;
}

5.2、创建Service实现类

package Service;

import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;

import org.apache.struts2.ServletActionContext;

import DAO.*;

publicclass StudentmarkServiceImpl implements IActionService {
private IStudentmarkDAO studentmark =new StudentmarkDAOImpl();
privateint start;
privateint limit;

publicint getStart() {
return start;
}

publicvoid setStart(int start) {
this.start = start;
}

publicint getLimit() {
return limit;
}

publicvoid setLimit(int limit) {
this.limit = limit;
}

public String execute() throws Exception {
HttpServletResponse response = ServletActionContext.getResponse();

// 编制响应的格式
response.setContentType("text/html;charset=UTF-8");

JSONArray json = JSONArray.fromObject(studentmark.QueryAll(getStart(),
getLimit()));
response.getWriter().write(
"{\"totalCount\":"+ studentmark.FindAllRows() +",\"data\":"
+ json.toString() +"}");
returnnull;
}

}

6、创建Action业务控制器

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>

<package name="Service" extends="struts-default">

<action name="showdata" class="Service.StudentmarkServiceImpl"></action>
</package>


</struts>