基于spring框架oracle数据库ajax 分页 - JAVA

rrentpage == url * 1) { alert("当前为第" + pcurrentpage + "页,无需跳转"); return; } } */ pageToolobj.gopage(url); }

css

/*------table----*/
.table {
	width: 96%;
	margin-top: 0;
	margin-bottom: 0px;
	border: 1px solid #009170;
	border-top: 3px solid #009170;
	TABLE-LAYOUT: fixed
}

.table thead {
	background: #BEF4DD;
	color: #2A4705;
}

.table thead th {
	border-right: 1px solid #009170;
	border-top: 1px solid #009170;
	height: 25px;
	text-align: center;
}

.table tfoot {
	font-size: 12px;
}

.table tfoot tr {
	text-align: center;
	padding-right: 1em;
}

.table tfoot tr td {
	border-top: 1px solid #009170;
	text-align: right;
	background: #EEEEEE
}

.table tbody {
	font-size: 12px
}

.table tbody tr td {
	border: 1px solid #1A9C7E;
	text-align: center;
	padding: 2px;
}

.table tbody td .text {
	line-height: 1.5em;
	text-decoration: none
}

.table tbody td .text:link {
	line-height: 1.5em;
	text-decoration: none
}

.table tbody td .text:hover {
	color: red;
	text-decoration: underline;
	background: #f0eeee
}

.table tbody td .text:visited {
	color: red
}

.text {
	height: 18px;
	padding: 1px 2px 0px 2px;
	border: solid 1px #7F9DB9;
}

.selectObj {
	color: green;
	background-color: #FFee11;
}

.hoverObj {
	color: green;
	background-color: #FBEC88;
}

/*------table----*/
#xuyw a {
	color: #3C6E31;
	text-decoration: none;
}

#xuyw a:hover {
	background-color: #3C6E31;
	color: white;
}

jsp代码

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@page isELIgnored="false"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>


<html>
	
		

		My JSP 'pagetag.jsp' starting page

		
  
		
  
		
  
		
  
		
  
		
  
		
  
		
		
		
	

	
		
  
			
    
    
      手机 
      
      
     
     
      
       
        ID  
        联系人  
        手机  
        收货地址  
        地区  
        创建人  
       
      
      
      
      
       
         
       
      
     
   
		
  
	
	<script type="text/java script">
	var pageToolobj = pageTool({
		"url" : "jsp/demo/pagetagdata.jsp",
		"formId" : "fm1",
		"submitbtnId" : "submitbtn",
		"pageToolId" : "pagetool",
		"pageRowsCount" : "10,15,20",
		"targetBody" : "pagetbody",
		"columnsName" : [ "ID", "CONTACT_NAME", "MOBILE", "ADDRESS", "DQ",
				"CREATE_USER" ]
	});

后台因为想简便,直接使用了jsp处理

<%@page import="com.xuyw.util.page.AjaxPageUtil"%>
<%@page import="com.google.gson.Gson"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.util.List"%>
<%@page import="com.xuyw.util.spring.BeanUtil"%>
<%@page import="org.springframework.jdbc.core.JdbcTemplate"%>
<%
	response.setContentType("text/html;charset=gbk;");
	request.setCharacterEncoding("gbk");
	String sj = request.getParameter("sj");
	JdbcTemplate jdbc = (JdbcTemplate) BeanUtil
			.getBean("ssejdbcTemplate", request.getSession()
					.getServletContext());
	String sql = "select * from CS_ADDRESS_BOOK where 1=1";
	if (!"null".equals(sj) &&!"".equals(sj) && sj != null) {
		sql = sql + " and mobile like '%" + sj + "%'";
	}

	/***********************action 执行下列代码**************************/
	int pagerowscount = 10;//一页显示条数
	int currentPage = 1;//当前页
	String tpage = request.getParameter("currentPage");
	String tpagecount = request.getParameter("pagerowscount");
	if (!"tpage".equals(tpagecount)&&tpage != null && !"".equals(tpage)) {
		currentPage = Integer.parseInt(tpage);
	}
	if (!"null".equals(tpagecount)&&tpagecount != null && !"".equals(tpagecount)) {
		pagerowscount = Integer.parseInt(tpagecount);
	}
	String sql2=AjaxPageUtil.createPageSql(sql,pagerowscount,currentPage);
	List list = jdbc.queryForList(sql2);
	response.setContentType("application/json;charset=utf-8");
	out.print(AjaxPageUtil.getJsonData(list,pagerowscount,currentPage));
	/*************************************************/
%>

AjaxPageUtil

package com.xuyw.util.page;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.google.gson.Gson;
/**
 *    
 * 项目名称：SSE   
 * 名称：AjaxPageUtil   
 * 类描述：   
 * 创建人: xuyw   
 * Email：xyw10000@163.com 
 * 创建时间：2014-1-9 上午10:27:55     
 * 备注：   
 * 版本：1.0    
 *
 */
public  class AjaxPageUtil {
	private static final Gson gson = new Gson();
	/**
	 * 
	 * 产生分页sql
	 * @param sql 原始查询SQL
	 * @param pagerowscount 一页显示多少条
	 * @param currentPage 当前页
	 * @return
	 * @return String
	 */
	public static String createPageSql(String sql, int pagerowscount, int currentPage) {
		int begin = 0;// rownum起始
		int end = 0;// rownum终止
		begin = (currentPage - 1) * pagerowscount + 1;
		end = currentPage * pagerowscount;
		StringBuilder builder = new StringBuilder();
		builder.append(" select * from (select a.*,(select COUNT(*) ");
		builder.append(" from ");
		builder.append(" ( ");
		builder.append(sql);
		builder.append(" ) ) ");
		builder.append(" pagecount,rownum row_num from ( ");
		builder.append(sql);
		builder.append(" ) a where rownum<=" + end + ") where row_num >= "
				+ begin);
		return builder.toString();
	}

	public static String getJsonData(List list,int pagerowscount, int currentPage) {
		int endpage = 0

基于spring框架oracle数据库ajax 分页(二)