自己在做项目时用easyUI解决的分页的一些东西

来源：互联网发布：网络教育学什么专业好编辑：程序博客网时间：2024/05/21 15:49

/*分页的前台 user_show.jsp*/

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

String path = request.getContextPath();

String basePath = request.getScheme() + "://"

+ request.getServerName() + ":" + request.getServerPort()

+ path + "/";

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

var basePath="<%=basePath%>";

function addTab(title, url){

url=basePath+url;

if ($('#tt').tabs('exists', title)){

$('#tt').tabs('select', title);

} else {

var content = '<iframe scrolling="auto" frameborder="0" src='+url+' style="width:100%;height:100%;"></iframe>';

$('#tt').tabs('add',{

title:title,

content:content,

closable:true

});

}

</script>

</head>

<a href="#" class="easyui-linkbutton" onclick= "addTab('管沟成型进度','R_Views/sgjd/page/sgjd_list.jsp?j_type=管沟成型进度')">管沟成型进度</a>

<a href="#" class="easyui-linkbutton" onclick="addTab('焊接实时进度','R_Views/sgjd/page/sgjd_list.jsp?j_type=焊接实时进度')">焊接实时进度</a>

<a href="#" class="easyui-linkbutton" onclick="addTab('补口补伤进度','R_Views/sgjd/page/sgjd_list.jsp?j_type=补口补伤进度')">补口补伤进度</a>

<a href="#" class="easyui-linkbutton" onclick="addTab('管沟回填进度','R_Views/sgjd/page/sgjd_list.jsp?j_type=管沟回填进度')">管沟回填进度</a>

<a href="#" class="easyui-linkbutton" onclick="addTab('待开发进度施工','R_Views/sgjd/page/sgjd_list.jsp?j_type=待开发进度施工')">待开发进度施工</a>

</div>

</div>

</html>

/*分页的前台 sgjd_list.jsp*/

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

String path = request.getContextPath();

String basePath = request.getScheme() + "://"

+ request.getServerName() + ":" + request.getServerPort()

+ path + "/";

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

function doAdd(){

$("#addWindow").window("open");

}

function doEdit(){

var rows = $('#tt').datagrid('getSelections');

if(rows.length <= 0){

$.messager.alert("提示信息",'请选择一条数据','info');

}else if(rows.length >1){

$.messager.alert("提示信息","别急,一条一条地来",'info');

}else {

$('#editForm').form('load',rows[0]);

$('#editWindow').window("open");

}

function doDelete(){

var rows = $('#tt').datagrid('getSelections');

if(rows.length <= 0){

$.messager.alert("提示信息","请选中要删除的数据",'info')

}else{

$.messager.confirm("提示信息","您确定要删除莫",function(a){

if(a){

var aa = new Array();

for(var i = 0;i<rows.length;i++){

aa.push(rows[i].f_id);

}

var ids = aa.join();

location.href ="http://localhost:21000/app-sjcj/R_action/sgjd/sgjd_delete.action?ids="+ids;

}

})

}

</script>

</head>

<table id="tt" class="easyui-datagrid" style="width:1919px;height:890px"iconCls="icon-save" toolbar="#tb" pageList="[30,40,50]"

pagination="true" rownumbers="true" url ="<%=basePath%>R_action/sgjd/sgjd_list.action?j_type=<%=request.getParameter("j_type")%>">

<thead>

<tr>

<th field="j_startpianyi" width="200" align="center">开始偏移量</th>

<th field="j_endpianyi" width="200" align="center">结束偏移量</th>

</tr>

</thead>

</table>

</div>

$(function(){

$('#addWindow').window({

title: '用户添加',

width: 600,

modal: true,

shadow: true,

closed: true,

height: 600,

resizable:false

});

$('#save').click(function(){

var v = $('#addForm').form('validate');

if(v){

$('#addForm').submit();

}

});

</script>

</div>

<form id="addForm" method="post"

action="<%=basePath%>R_action/sgjd/sgjd_add.action?j_type=<%=request.getParameter("j_type")%>">

</tr>

<!-- <tr>

</tr> -->

<tr>

<td>

</td>

</tr>

<tr>

</tr>

<tr>

<td>开始偏移量</td>

</tr>

<tr>

</tr>

<tr>

<td>结束偏移量</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</div>

$(function(){

$('#editWindow').window({

title: '用户修改',

width: 600,

modal: true,

shadow: true,

closed: true,

height: 600,

resizable:false

});

$('#edit').click(function(){

var v = $('#editForm').form('validate');

if(v){

$('#editForm').submit();

}

})

});

</script>

</div>

<form id="editForm" method="post"

action="<%=basePath%>R_action/sgjd/sgjd_edit.action">

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

</tr>

<tr>

<td>开始偏移量</td>

</tr>

<tr>

</tr>

<tr>

<td>结束偏移量</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</div>

</body>

</html>

/*分页的后台*/

PageBean pageBean = new PageBean();

String p = request.getParameter("page");

String r = request.getParameter("rows");

int page = Integer.valueOf(p);

int rows = Integer.valueOf(r);

pageBean.setCurrentPage(page);

pageBean.setPageSize(rows);

String sql1 = "select count(*) aa from t_user_info";//查询总条数的sql

Map m2=db.searchToMap(sql1);

int total = Integer.valueOf(m2.get("aa").toString());

pageBean.setTotal(total);//设置总条数

int firstResult=(pageBean.getCurrentPage()-1)*(pageBean.getPageSize());

//这个获取每页显示条数

int maxResults=pageBean.getPageSize()+firstResult;

/*String sql = "SELECT * FROM(SELECT u.*,rownum rn FROM T_USER u) us WHERE us.rn > "

+ (page - 1) * rows + "AND us.rn <=" + page * rows;*/

/*String sql = "SELECT * FROM (SELECT F_ID,F_NAME,F_USERNAME,F_PASSWORD,F_DESC,F_TYPE,rownum rn FROM T_USER) us JOIN T_USER_INFO uu ON us.rn > "

+ (page - 1) * rows + "AND us.rn <=" + page * rows + "AND us.F_ID = uu.F_ID";*/

String sql ="SELECT * FROM (SELECT us.*,ROWNUM rn FROM T_USER us) tt JOIN T_USER_INFO uu ON tt.rn > "

+ firstResult + " AND tt.rn <=" + maxResults + " AND tt.F_ID = uu.F_ID";

ArrayList list = db.searchToMapList(sql);

pageBean.setRows(list);

try {

JsonConfig jsonConfig = new JsonConfig();

String[] excludes = {"currentPage","pageSize"};

jsonConfig.setExcludes(excludes);

JSONObject json = JSONObject.fromObject(pageBean,jsonConfig);

response.getWriter().print(json.toString());

System.out.println(json.toString());

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return NONE;

/*pageBean对象*/

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;

public class PageBean {
private int currentPage;
private int pageSize;
private DetachedCriteria criteria;
//以上三个都是在action中封装到pageBean中的

//下面两条数据是在dao中封装到pageBean中的
private long total;//因为我们数据库中查到的list的条数就是long类型的

private List<?> rows;
//封装离线查询的条件

public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public long getTotal() {
return total;
}
public void setTotal(long total) {
this.total = total;
}
public List<?> getRows() {
return rows;
}
public void setRows(List<?> rows) {
this.rows = rows;
}
public DetachedCriteria getCriteria() {
return criteria;
}
public void setCriteria(DetachedCriteria criteria) {
this.criteria = criteria;
}
}

阅读全文

0 0