ExtJs、Struts2、Hibernate32的Grid分页.doc

文件目录1、 分层思想2、 基本配置a) 创建数据库test，表student、markDROP TABLE IF EXISTS test.student;CREATE TABLE test.student ( stuid varchar(20) NOT NULL, stuname varchar(20) NOT NULL, stusex varchar(20) NOT NULL, stuaddress varchar(20) NOT NULL, PRIMARY KEY (stuid) ENGINE=InnoDB DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS test.mark;CREATE TABLE test.mark ( stuid varchar(20) DEFAULT NULL, stumath int(11) NOT NULL, stuchinese int(11) NOT NULL, stuenglish int(11) NOT NULL, KEY stuid (stuid), CONSTRAINT stuid FOREIGN KEY (stuid) REFERENCES student (stuid) ENGINE=InnoDB DEFAULT CHARSET=utf8;b) 配置hibernate项目-点击右键-MyEclipse-Add Hibernate Capabilitiesc) 配置hibernate.cfg.xml文件（如编码方式、sql显示）rootjdbc:mysql:/localhost:3306org.hibernate.dialect.MySQLDialectmysql123com.mysql.jdbc.DriverthreadtruetruetrueUTF-8d) 配置struts2，加入基本包和struts.xmlcommons-fileupload-1.2.1.jarcommons-io-1.3.2.jarfreemarker-2.3.16.jarjavassist-3.7.ga.jarognl-3.0.jarstruts2-core-2.2.1.jarxwork-core-2.2.1.jare) 配置web.xml（与struts2的交互）struts2org.apache.struts2.dispatcher.FilterDispatcherstruts2/*index.jspf) 配置json数据传送所需要的包commons-beanutils.jarcommons-collections-3.2.1.jarcommons-lang-2.4.jarezmorph-1.0.6.jarjson-lib-2.3-jdk15.jarg) 配置ExtJs官网下载: /products/js/3、 创建数据库持久层PO4、 创建数据库访问层DAOa) 创建DAO接口package DAO;import java.util.List;public interface IStudentmarkDAO public List QueryAll(int start, int limit);public int FindAllRows();b) 创建DAO实现类package DAO;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import HbmFactory.HibernateSessionFactory;public class 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();return null;public int 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();return 0;5、 创建业务服务层Servicea) 创建Service的Action控制器接口package Service;public interface IActionService public String execute() throws Exception;b) 创建Service实现类package Service;import javax.servlet.http.HttpServletResponse;import net.sf.json.JSONArray;import org.apache.struts2.ServletActionContext;import DAO.*;public class StudentmarkServiceImpl implements IActionService private IStudentmarkDAO studentmark = new StudentmarkDAOImpl();private int start;private int limit;public int getStart() return start;public void setStart(int start) this.start = start;public int getLimit() return limit;public void 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(