近日学习Easyui，发现非常好用，界面很美观。将学习的心得在此写下，这篇博客写SSh结合Easyui实现Datagrid的分页显示，其他的例如添加、修改、删除、批量删除等功能将在后面一一写来。

首先看一下要实现的效果：当每页显示5行数据：

当每页显示10行数据，效果如下：

具体步骤：

1、下载Easyui，并搭建环境。

2、搭建SSH工程，整个工程的目录结构如图所示：

3、在Oracle数据库中创建表Student。并且输入下面6行数据，因为添加操作还没有实现，所以先在数据库表中添加数据。默认设定的值是每行5个数据，所以请至少输入6行数据，便于分页的测试。

4、web.xml的配置

<"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.ng.filter.StrutsPrepareAndExecuteFilter</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:applicationContext.xml</param-value> </context-param> </web-app>

5、applicationContext.xml的配置

<"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: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-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <import resource="applicationContext_bean.xml"/> <import resource="applicationContext_db.xml"/> </beans>

6、在com.model中创建模型类Student.Java

package com.model; public class Student { String studentid;// 主键 String name;// 姓名 String gender;// 性别 String age;// 年龄 public String getStudentid() { return studentid; } public void setStudentid(String studentid) { this.studentid = studentid; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getGender() { return gender; } public void setGender(String gender) { this.gender = gender; } public String getAge() { return age; } public void setAge(String age) { this.age = age; } }

7、根据Student.java生成对应的映射文件Student.hbm.xml

<"1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <> <hibernate-mapping> <class name="com.model.Student" table="STUDENT"> <id name="studentid" type="java.lang.String"> <column name="STUDENTID" /> <generator /> </id> <property name="name" type="java.lang.String"> <column name="NAME" /> </property> <property name="gender" type="java.lang.String"> <column name="GENDER" /> </property> <property name="age" type="java.lang.String"> <column name="AGE" /> </property> </class> </hibernate-mapping>

8、编写接口StudentService.java

package com.service; import java.util.List; public interface StudentService { public List getStudentList(String page,String rows) throws Exception;//根据第几页获取，每页几行获取数据 public int getStudentTotal() throws Exception;//统计一共有多少数据 }

9、编写接口的实现类StudentServiceImpl.java

package com.serviceImpl; import java.util.List; import org.hibernate.SessionFactory; import com.service.StudentService; public class StudentServiceImpl implements StudentService { private SessionFactory sessionFactory; // 根据第几页获取，每页几行获取数据 public List getStudentList(String page, String rows) { //当为缺省值的时候进行赋值 int currentpage = Integer.parseInt((page == null || page == "0") ": page);//第几页 int pagesize = Integer.parseInt((rows == null || rows == "0") ": rows);//每页多少行 List list = this.sessionFactory.getCurrentSession().createQuery("from Student") .setFirstResult((currentpage - 1) * pagesize).setMaxResults(pagesize).list(); return list; } // 统计一共有多少数据 public int getStudentTotal() throws Exception { return this.sessionFactory.getCurrentSession().find("from Student").size(); } public SessionFactory getSessionFactory() { return sessionFactory; } public void setSessionFactory(SessionFactory sessionFactory) { this.sessionFactory = sessionFactory; } }

10、配置连接数据库的配置文件applicationContext_db.xml

<"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: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-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <> <bean id="dataSource" destroy-method="close"> <> <property name="driverClass"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <> <property name="jdbcUrl"> <value>jdbc:oracle:thin:@localhost:1521:orcl</value> </property> <> <property name="user"> <value>lhq</value> </property> <> <property name="password"> <value>lhq</value> </property> <property name="minPoolSize"> <value>1</value> </property> <property name="maxPoolSize"> <value>40</value> </property> <property name="maxIdleTime"> <value>1800</value> </property> <property name="acquireIncrement"> <value>2</value> </property> <property name="maxStatements"> <value>0</value> </property> <property name="initialPoolSize"> <value>2</value> </property> <property name="idleConnectionTestPeriod"> <value>1800</value> </property> <property name="acquireRetryAttempts"> <value>30</value> </property> <property name="breakAfterAcquireFailure"> <value>true</value> </property> <property name="testConnectionOnCheckout"> <value>false</value> </property> </bean> <> <bean id="sessionFactory" > <> <property name="dataSource"> <ref bean="dataSource" /> </property> <> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect"> org.hibernate.dialect.Oracle10gDialect </prop> </props> </property> <> <property name="mappingResources"> <list> <value>com/model/Student.hbm.xml</value> </list> </property> </bean> <> <bean id="transactionManager" > <property name="sessionFactory" ref="sessionFactory" /> </bean> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="save*" propagation="REQUIRED" /><> <tx:method name="delete*" propagation="REQUIRED" /> <tx:method name="update*" propagation="REQUIRED" /> <tx:method name="*" propagation="SUPPORTS" read-only="true" /><> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="interceptorPointCuts" expression="execution(* com.serviceImpl..*.*(..))" /> <> <aop:advisor advice-ref="txAdvice" pointcut-ref="interceptorPointCuts" /> </aop:config> </beans>

11、在控制层编写StudentAction.java类型

package com.action; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONObject; import org.apache.log4j.Logger; import org.apache.struts2.ServletActionContext; import com.service.StudentService; public class StudentAction { static Logger log = Logger.getLogger(StudentAction.class); private JSONObject jsonObj; private String rows;// 每页显示的记录数 private String page;// 当前第几页 private StudentService student_services;//String依赖注入 //查询出所有学生信息 public String getAllStudent() throws Exception { log.info("查询出所有学生信息"); List list = student_services.getStudentList(page, rows); this.toBeJson(list,student_services.getStudentTotal()); return null; } //转化为Json格式 public void toBeJson(List list,int total) throws Exception{ HttpServletResponse response = ServletActionContext.getResponse(); HttpServletRequest request = ServletActionContext.getRequest(); JSONObject jobj = new JSONObject();//new一个JSON jobj.accumulate("total",total );//total代表一共有多少数据 jobj.accumulate("rows", list);//row是代表显示的页的数据 response.setCharacterEncoding("utf-8");//指定为utf-8 response.getWriter().write(jobj.toString());//转化为JSOn格式 log.info(jobj.toString()); } public StudentService getStudent_services() { return student_services; } public void setStudent_services(StudentService student_services) { this.student_services = student_services; } public void setJsonObj(JSONObject jsonObj) { this.jsonObj = jsonObj; } public void setRows(String rows) { this.rows = rows; } public void setPage(String page) { this.page = page; } }

12、编写spring的依赖注入applicationContext_bean.xml配置文件

<"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: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-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <> <bean id="student_service"> <property name="sessionFactory"> <ref bean="sessionFactory"></ref> </property> </bean> <> <bean id="student_action"> <property name="student_services"> <ref bean="student_service" /> </property> </bean> </beans>

13、编写struts.xml配置文件

<"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="Easyui" extends="json-default"> <> <action name="getAllStudentAction" method="getAllStudent"> <result type="json"> </result> </action> </package> </struts>

14、编写JSP----index.jsp

<%@ page language="java" pageEncoding="utf-8" isELIgnored="false"%> <% String path = request.getContextPath(); %> <%@ taglib prefix="s" uri="/struts-tags"%> <!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>数字框</title> <> <script type="text/javascript" src="<%=path%>/js/easyui/jquery-1.8.0.min.js" charset="utf-8"></script> <> <script type="text/javascript" src="<%=path%>/js/easyui/jquery.easyui.min.js" charset="utf-8"></script> <中文 --> <script type="text/javascript" src="<%=path%>/js/easyui/locale/easyui-lang-zh_CN.js" charset="utf-8"></script> <蓝色 --> <link rel="stylesheet" type="text/css" href="<%=path%>/js/easyui/themes/default/easyui.css" /> <> <link rel="stylesheet" type="text/css" href="<%=path%>/js/easyui/themes/icon.css" /> <script type="text/javascript"> $(function() { $('#mydatagrid').datagrid({ title : 'datagrid实例', iconCls : 'icon-ok', width : 600, pageSize : 5,//默认选择的分页是每页5行数据 pageList : [ 5, 10, 15, 20 ],//可以选择的分页集合 nowrap : true,//设置为true，当数据长度超出列宽时将会自动截取 striped : true,//设置为true将交替显示行背景。 collapsible : true,//显示可折叠按钮 toolbar:"#tb",//在添加 增添、删除、修改操作的按钮要用到这个 url:'getAllStudentAction.action',//url调用Action方法 loadMsg : '数据装载中......', singleSelect:true,//为true时只能选择单行 fitColumns:true,//允许表格自动缩放，以适应父容器 //sortName : 'xh',//当数据表格初始化时以哪一列来排序 //sortOrder : 'desc',//定义排序顺序，可以是'asc'或者'desc'（正序或者倒序）。 remoteSort : false, frozenColumns : [ [ { field : 'ck', checkbox : true } ] ], pagination : true,//分页 rownumbers : true//行数 }); }); </script> </head> <body> <h2> <b>easyui的DataGrid实例</b> </h2> <table id="mydatagrid"> <thead> <tr> <th data-options="field:'studentid',width:100,align:'center'">学生学号</th> <th data-options="field:'name',width:100,align:'center'">姓名</th> <th data-options="field:'gender',width:100,align:'center'">性别</th> <th data-options="field:'age',width:100,align:'center'">年龄</th> </tr> </thead> </table> </body> </html>

15、启动程序，输入http://localhost:8080/easyui/index.jsp进行测试。

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持查字典教程网。