MyBatis实现拦截器分页功能

最新推荐文章于 2024-09-24 08:56:36 发布

炉边诗人

最新推荐文章于 2024-09-24 08:56:36 发布

阅读量1.8k

点赞数

分类专栏： J2EE与Web框架文章标签： mysql 分页 mybatis interceptor

J2EE与Web框架专栏收录该内容

6 篇文章 0 订阅

订阅专栏

1.原理

在mybatis使用拦截器（interceptor），截获所执行方法的sql语句与参数。
（1）修改sql的查询结果：将原sql改为查询count(*) 也就是条数
（2）将语句sql进行拼接 limit(MySql)或rownum(Oracle)语句达到分页效果
制作分页Page类，需要分页的bean继承分页Page类。
jsp界面通过Page类的属性参数实现对页数控制。

2.具体步骤

（1）首先创建PageBean
（2）配置分页使用的拦截器实现Interceptor接口，重写其抽象方法

@Intercepts({ @Signature(type = StatementHandler.class, method = "prepare", args = { Connection.class }),
		@Signature(type = ResultSetHandler.class, method = "handleResultSets", args = { Statement.class }) })
public class PageInterceptor implements Interceptor {

@Intercepts注解表示被会被拦截的类和方法参数

//SELECT_ID 根据被捕获的方法判断是否需要进行分页 如果方法名含有Page则进行分页
private static final String SELECT_ID = "Page";
//在intercept方法中获取mybatis.xml中的property属性值为PageCount赋值
private Properties properties;
//通过PageBean对象获取Count值的where条件后参数
private PageBean pageBean;

1. 拦截器的主方法则是具体功能的实现，主要做的事：

判断被拦截的方法是否需要进行分页
需要分页则截取sql语句，截取条件并拼接成查询条数，也就是将

    select * from user    ---->  select count(*) from user

获取数据库连接对象，并执行拼接好的count(*)获取条数Sql语句获取数据库条数，并将值存到设计好的PageBean对象中

//获取数据库连接对象
Connection connection = (Connection) invocation.getArgs()[0];
//执行countSql语句 并获得Count值 为PageBean的totalCount赋值
PreparedStatement countStmt = null;
ResultSet rs = null;
int totalCount = 0;
try {
countStmt = connection.prepareStatement(countSql);
	rs = countStmt.executeQuery();
if (rs.next()) {
	totalCount = rs.getInt(1);
}
} catch (SQLException e) {
	System.out.println("Ignore this exception" + e);
} finally {
try {
	rs.close();
	countStmt.close();
} catch (SQLException e) {
	System.out.println("Ignore this exception" + e);
	}
}

将原sql语句增加limit a,b a为查询结果第一条，b为所查询的条数

public String concatPageSql(String sql, PageBean pageBean) {
		StringBuffer sb = new StringBuffer();
		sb.append(sql);
		sb.append(" limit ").append(pageBean.getPageLimit()).append(" ,").append(pageBean.getPageCount());
		return sb.toString();
	}

将拦截修改好的sql语句传递给dao层执行的方法并返回对应的结果


//将处理好的SQL语句绑定
String pageSql = concatPageSql(sql, pageBean);
//将修改好的sql语句返回给方法
metaStatementHandler.setValue("delegate.boundSql.sql", pageSql);

退出拦截器，开始执行dao层方法，执行sql语句进行数据处理

//执行dao层方法
return invocation.proceed();

Controller中配置接收参数与返回参数

参数为PageBean的子类对象–接收由JSP中传入的分页数据信息–模糊查询的参数等等
而参数在dao层方法完成后，会在拦截器中对其分页数据进行赋值–也就是经过拦截器处理后，对象的数据增加了
以User类为例

@RequestMapping("/selectLikeUser.do")
	//参数为user 而mav.addObject("pageBean", user); 也是user，这是拦截器有对user进行分页信息赋值
	public ModelAndView selectPageLikeAllUser(User user){
		//执行的顺序Service-->拦截器（修改sql语句，注入分页参数）-->Dao方法-->返回结果
		//所以有两个值 ① 分页的数据（当前页，总页数等数据）在user对象中
		//           ② 保存数据的集合userList
		List<User> userList=this.userService.selectPageLikeAllUser(user);
		ModelAndView mav=new ModelAndView();
		mav.addObject("userList", userList);
		//对应的前台Jsp界面
		mav.setViewName("userList");
		//将分页数据保存
		mav.addObject("pageBean", user);
		return mav;
	}

前台Jsp界面

翻页需要的button模块

<div class="div_input">
	//分页需要用到的参数有JS对应的方法进行表单提交时传递参数 而limtr 从0开始，后台执行sql语句 limit 0，每页的条数
	//每次点击下一页 变化的都是limit 前面的参数 limit 参数*条数，条数
	//第一页 limit 0*2,2
	//第二页 limit 1*2,2
	//第三页 limit 2*2,2 …………
	<input type="button" class="input_scan" value="首页" onclick="page(0)"/> 
	//判断上一页的方法，当表单无上一页是 当前input会被隐藏
	<c:if test="${pageBean.previous}">
		<input type="button" class="input_scan" value="上页" onclick="page(${pageBean.pageNo - 1})"/> 
	</c:if>
	//判断下一页的方法，当前为最大页时，input隐藏
	<c:if test="${pageBean.next}">
		<input type="button" class="input_scan" value="下页" onclick="nextPage(${pageBean.pageNo + 1},${pageBean.totalPage})"/>
	</c:if>
	<input type="button" class="input_scan" value="末页" onclick="page(${pageBean.totalPage -1})"/> 
	<span class="span_text">跳到第</span>
		<input type="text" class="input_text" name="pageNo" id="pageID"/>
	<span class="span_text">页</span> 
		<input type="button" class="input_scan" value="跳转" onclick="pageSubmit(${pageBean.totalPage})"/>
</div>

对应的JS方法

//每一次表单的提交，在controller中捕获的都是pageID的那个type='text'的那个文本框
//方法中的逻辑判断则是为了避免一些提交bug，保证pageID的文本框中数值显示正常以及跳转按钮等等
<script type="text/javascript">
function page(pageArg){
	var myform = document.getElementById("myform");
	var pageNo = document.getElementById("pageID");
	pageNo.value = pageArg;
	if(pageArg!=-1){
		myform.submit();
	}else{
		pageNo.value ="";
	}
		
}
function pageSubmit(pageArg){
	var myform = document.getElementById("myform");
	var pageNo = document.getElementById("pageID");
	if(pageNo.value-1 < pageArg){
		pageNo.value=Number(pageNo.value)-1;
		if(pageNo.value>-1){
			myform.submit();
		}else{
			pageNo.value="";
		}
	}
}
function nextPage(pageArg,totalPage){
	var myform = document.getElementById("myform");
	var pageNo = document.getElementById("pageID");
	pageNo.value = pageArg;
	if(pageArg<totalPage)
		myform.submit();
}
</script>

下面为完整代码

拦截器中，因为模糊查询，所以多了一些判断参数的方法，以及为sql语句的参数赋值的过程，仅供参考
PageBean为对应的分页model类，而selectInfo为模糊查询参数，在拦截器中会使用此参数在查询count条数时，修改参数

PageBean

package com.chinasofti.lexian.bean;

import java.util.HashMap;

public class PageBean {
	
	private int totalCount;//总的条数
	
	private int pageNo;//当前的页数
	
	private int pageCount;//每页的条数
	
	private int pageLimit;//下一页的条件 等于pageNo*pageCount
	
	private String storename;
	private String starttime;
	private String closetime;
	
	private String selectInfo;
	
	private int state;
	
	private static HashMap<String, String> infoHashMap;//模糊查询配置参数
	
	static{
		infoHashMap = new HashMap<String, String>();
	}
	
	//无参构造方法
	public PageBean() {
		super();
		// TODO Auto-generated constructor stub
	}
	
	//全参构造方法
	public PageBean(int totalCount, int pageNo, int pageCount) {
		this.totalCount = totalCount;
		this.pageNo = pageNo;
		this.pageCount = pageCount;
	}
	
	//属性的set，get 方法
	public int getPageCount() {
		return pageCount;
	}

	public void setPageCount(int pageCount) {
		this.pageCount = pageCount;
	}
		
	public void setPageNo(int pageNo) {
		this.pageNo = pageNo;
	}
	
	public int getPageNo() {
		return pageNo;
	}
	
	public int getPageLimit() {
		return pageLimit;
	}
	
	public void setPageLimit(int pageLimit) {
		this.pageLimit = pageLimit;
	}
	
	public int getTotalCount() {
		return totalCount;
	}

	public void setTotalCount(int totalCount) {
		this.totalCount = totalCount;
	}
	
	//获取总页数
	public int getTotalPage(){
		if(totalCount % pageCount == 0){
			return totalCount/pageCount;
		}else{
			return totalCount/pageCount+1;
		}
	}
	
	//多写一个判断下一页的方法
	public boolean isNext(){
		return pageNo + 1 < getTotalPage();
	}
	
	//上一页的方法
	public boolean isPrevious(){
		return pageNo > 0;
	}
	
	public String getInfoHashMap(String key) {
		return infoHashMap.get(key);
	}
	
	public void setInfoHashMap(String key, String value) {
		PageBean.infoHashMap.put(key, value);
	}

	public String getSelectInfo() {
		return selectInfo;
	}

	public void setSelectInfo(String selectInfo) {
		this.selectInfo = selectInfo;
	}

	public int getState() {
		return state;
	}

	public void setState(int state) {
		this.state = state;
	}

	public String getStorename() {
		return storename;
	}

	public void setStorename(String storename) {
		this.storename = storename;
	}

	public String getStarttime() {
		return starttime;
	}

	public void setStarttime(String starttime) {
		this.starttime = starttime;
	}

	public String getClosetime() {
		return closetime;
	}

	public void setClosetime(String closetime) {
		this.closetime = closetime;
	}

}

拦截器Interceptor

package com.chinasofti.lexian.interceptor;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import org.apache.ibatis.executor.resultset.ResultSetHandler;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Invocation;
import org.apache.ibatis.plugin.Plugin;
import org.apache.ibatis.plugin.Signature;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.reflection.SystemMetaObject;

import com.chinasofti.lexian.bean.PageBean;


	/**
	 * args 对应方法的参数
	 * method 想要拦截的方法
	 * type 想要拦截的类
	 */
@Intercepts({ @Signature(type = StatementHandler.class, method = "prepare", args = { Connection.class }),
		@Signature(type = ResultSetHandler.class, method = "handleResultSets", args = { Statement.class }) })
public class PageInterceptor implements Interceptor {

	/**
	 * SELECT * FROM USER ORDER BY ID LIMIT 0,2
	 */
	private static final String SELECT_ID = "Page";
	
	//在intercept方法中获取mybatis.xml中的property属性值为PageCount赋值
	private Properties properties;
	
	//通过PageBean对象获取Count值的where条件后参数
	private PageBean pageBean;
	
	@Override
	public Object intercept(Invocation invocation) throws Throwable {
		if (invocation.getTarget() instanceof StatementHandler) {
			
			//获取mappedStatement对象 通过mappedStatement，metaStatementHandler获取对SQL语句和参数进行操作
			StatementHandler statementHandler = (StatementHandler) invocation.getTarget();
			MetaObject metaStatementHandler = SystemMetaObject.forObject(statementHandler);
			MappedStatement mappedStatement = (MappedStatement) metaStatementHandler
					.getValue("delegate.mappedStatement");
			
			
			//mappedStatement.getId() 获取被截取的方法名字 输出的方法名为 包名.类名.方法名
			String selectId = mappedStatement.getId();
			
			//判断如果方法名字中出现Page 则为需要进行分页操作的方法
			if (selectId.indexOf(SELECT_ID) != -1) {
				
				//boundSql.getSql() 获取当前方法执行的Sql语句
				BoundSql boundSql = (BoundSql) metaStatementHandler.getValue("delegate.boundSql");
				String sql = boundSql.getSql();
				sql = sql.replaceAll("\n", " ").replaceAll("\t", "");
				/*
				 * boundSql.getParameterObject() 获取被截获方法的参数 需要强转
				 * PageBean 需要分页的Bean数据的父类
				 * User Controller方法中的参数类 获取User为了给Count的Where后条件 赋值
				 * 被拦截的方法中未赋值
				 */
				pageBean = (PageBean) (boundSql.getParameterObject());
				
				//获取mybatis.xml中的值(每页的条数) 为 PageCount赋值
				pageBean.setPageCount(Integer.parseInt(this.properties.getProperty("pageCount")));

				//concatCountSql()方法 截取sql查询方法 获取需要分页的表名 计算共有多少条数据
				String countSql="";
				if(pageBean.getState()==2){
					countSql ="select count(*) from (" + concatCountSql(sql) + ") as name";
				}else if(pageBean.getState()==3){
					countSql = concatCountSql_ji(sql);
				}else{
					countSql = concatCountSql(sql);
				}
				//获取数据库连接对象
				Connection connection = (Connection) invocation.getArgs()[0];
				
				//执行countSql语句 并获得Count值 为PageBean的totalCount赋值
				PreparedStatement countStmt = null;
				ResultSet rs = null;
				int totalCount = 0;
				try {
					countStmt = connection.prepareStatement(countSql);
					rs = countStmt.executeQuery();
					if (rs.next()) {
						totalCount = rs.getInt(1);
					}

				} catch (SQLException e) {
//					System.out.println("Ignore this exception" + e);
				} finally {
					try {
						rs.close();
						countStmt.close();
					} catch (SQLException e) {
						System.out.println("Ignore this exception" + e);
					}
				}
				
				//判断若下一页条数大于最大数 则按最大数取值
				pageBean.setTotalCount(totalCount);
				pageBean.setPageLimit(pageBean.getPageNo() * pageBean.getPageCount());
				if (pageBean.getPageLimit() > totalCount) {
					pageBean.setPageLimit(totalCount);
				}
				
				//将处理好的SQL语句绑定
				String pageSql = concatPageSql(sql, pageBean);
				metaStatementHandler.setValue("delegate.boundSql.sql", pageSql);
			}
		}

		return invocation.proceed();
	}

	/**
	 * 如果类型为StatementHandler则返回他本身
	 * 用于封装目标对象，通过该方法可以返回目标对象本身
	 */
	@Override
	public Object plugin(Object target) {
		if (target instanceof StatementHandler) {
			return Plugin.wrap(target, this);
		} else {
			return target;
		}
	}
	
	/**
	 * setProperties方法在intercept方法之前调用
	 * 需要在mybatis-config.xml中的<plugins>中配置property
	 * 能获取xml文件中对应的property值
	 */
	@Override
	public void setProperties(Properties properties) {
		this.properties = properties;
	}

	/**
	 * 
	 * @param sql 根据Sql 截取出获得查询数据条数的Sql语句
	 * @return 返回select count(*) from 表名 (where name = 值)
	 */
	public String concatCountSql_ji(String sql) {
		StringBuffer sb = new StringBuffer("select count(*) from ");
		//select count(*) from user
		//转小写
		sql = sql.toLowerCase();
//		System.out.println("-------------原sql文:"+sql);
		
		//sql.lastIndexOf("order") > sql.lastIndexOf(")") 如果有order by 则不截取order后  不需要排序
		if (sql.lastIndexOf("order by") > sql.lastIndexOf(")")) {
			sb.append(sql.substring(sql.indexOf("from") + 4, sql.lastIndexOf("order by")));
		} else {
			//截取from 后所有条件
			sb.append(sql.substring(sql.indexOf("from") + 4));
		}
		
		//StringBuffer转成String
		String newSql = sb.toString().replaceAll("\n", " ").replaceAll("\t", "");
//		System.out.println("去空格后的sql文："+newSql);
		
		//判断 如果 sql语句为有参查询 则替换参数
		/**
		 * select count(*) from  orders o,store s,commodity c
			where o.store_no = s.store_no 
			and o.commodity_no = c.commodity_no
			and o.states = ?
			and o.createtime >= ?
			and o.createtime <= ?
			and order_no like "%"?"%"
		 */
		//循环替换sql文中的?
		
		//只有一个?
		if(newSql.indexOf("?") > 0 && newSql.indexOf("?") == newSql.lastIndexOf("?")){
			return newSql.replaceAll("\\?", "'"+this.pageBean.getSelectInfo()+"'");
		}
		
		//有多个?
		while(newSql.indexOf("?") > 0) {
			
			String condition = newSql.substring(0, newSql.indexOf("?"));
			/**
			 * condition =
			 * select count(*) from  orders o,store s,commodity c
				where o.store_no = s.store_no 
				and o.commodity_no = c.commodity_no
				and o.states = 
			 */
			condition = condition.substring(condition.lastIndexOf("and")+3);
			/**
			 * condition =
			 *  o.states =
			 */
			/**
			 * 判断condition中的逻辑运算符
			 * >=、<=、>、<，需要保留，以便判断需要的是哪个参数
			 */
			if(condition.indexOf(">=") > 0 || condition.indexOf("<=") > 0){
				condition = condition.substring(condition.indexOf(".") > 0 ? condition.indexOf(".")+1 : 0, condition.indexOf("=")+1).trim();
			}else if(condition.indexOf(">") > 0){
				condition = condition.substring(condition.indexOf(".") > 0 ? condition.indexOf(".")+1 : 0, condition.indexOf(">")+1).trim();
			}else if(condition.indexOf("<") > 0){
				condition = condition.substring(condition.indexOf(".") > 0 ? condition.indexOf(".")+1 : 0, condition.indexOf("<")+1).trim();
			}else if(condition.indexOf("=") > 0){
				condition = condition.substring(condition.indexOf(".") > 0 ? condition.indexOf(".")+1 : 0, condition.indexOf("=")).trim();
			}else {
				condition = condition.substring(condition.indexOf(".") > 0 ? condition.indexOf(".")+1 : 0, condition.indexOf("like")).trim();
			}
			//去参数中的空格
			condition = condition.replace(" ", "");
			
			//去掉参数中的"_"并将后一字母大写
			while (condition.indexOf("_") > 0) {						//order_no
				int location = condition.indexOf("_");				//5
				String upCase = condition.substring(location+1, location+2).toUpperCase();//N
				String target = condition.substring(location, location+2);//_n
				condition = condition.replaceFirst(target, upCase); //orderNo
			}
			//调用pageBean的getSelectInfo方法根据参数名获取对应的参数值
			String strInfo = "'" + this.pageBean.getInfoHashMap(condition) + "'";
			
			newSql = newSql.replaceFirst("\\?", strInfo);// ?需要转义-->\?,\也需要转义-->\\,\?就要写成\\?
		}
		return newSql;
	}
	
	public String concatCountSql(String sql) {
		StringBuffer sb = new StringBuffer("select count(*) from ");
		//select count(*) from user
		//转小写
		sql = sql.toLowerCase();
		//sql.lastIndexOf("order") > sql.lastIndexOf(")") 如果有order by 则不截取order后  不需要排序
		if (sql.lastIndexOf("order") > sql.lastIndexOf(")")) {
			sb.append(sql.substring(sql.indexOf("from") + 4, sql.lastIndexOf("order")));
		} else {
			//截取form 后所有条件
			sb.append(sql.substring(sql.indexOf("from") + 4));
		}
		
		//StringBuffer转成String
		String newSql = sb.toString();
		//判断 如果 sql语句为有参查询 则替换参数
		if (sb.indexOf("?") > 0) {
			if(pageBean.getState()!=2){
				String strInfo = "'" + this.pageBean.getSelectInfo() + "'";
				newSql = newSql.replace("?", strInfo);
			}else{
				String [] arr = newSql.split("\\?");
				String storename=pageBean.getStorename();
				String starttime=pageBean.getStarttime();
				String closetime=pageBean.getClosetime();
				String selectInfo = pageBean.getSelectInfo();
				switch (arr.length) {
				case 2:
					if(storename != null&&(!storename.equals(""))){
//						System.out.println("a1");
						newSql=arr[0]+"'"+storename+"'"+arr[1];
					}else if(starttime!=null&&(!starttime.equals(""))){
//						System.out.println("a2");
						newSql=arr[0]+"'"+starttime+"'"+arr[1];
					}else if(closetime!=null&&(!closetime.equals(""))){
//						System.out.println("a3");
						newSql=arr[0]+"'"+closetime+"'"+arr[1];
					}else{
						newSql=arr[0]+"'"+selectInfo+"'"+arr[1];
					}
					break;
				case 3:
					if((storename==null||storename.equals(""))&&(starttime==null||starttime.equals(""))){
						newSql=arr[0]+"'"+closetime+"'"+arr[1]+"'"+selectInfo+"'"+arr[2];
					}else if((storename==null||storename.equals(""))&&(closetime==null||closetime.equals(""))){
						newSql=arr[0]+"'"+starttime+"'"+arr[1]+"'"+selectInfo+"'"+arr[2];
					}else if((storename==null||storename.equals(""))&&(selectInfo==null||selectInfo.equals(""))){
						newSql=arr[0]+"'"+starttime+"'"+arr[1]+"'"+closetime+"'"+arr[2];
					}else if((starttime==null||starttime.equals(""))&&(closetime==null||closetime.equals(""))){
						newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+selectInfo+"'"+arr[2];
					}else if((selectInfo==null||selectInfo.equals(""))&&(closetime==null||closetime.equals(""))){
						newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+starttime+"'"+arr[2];
					}else{
						newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+closetime+"'"+arr[2];
					}
					break;
				case 4:
					if(storename==null||storename.equals("")){
						newSql=arr[0]+"'"+starttime+"'"+arr[1]+"'"+closetime+"'"+arr[2]+"'"+selectInfo+"'"+arr[3];
					}else if(starttime==null||starttime.equals("")){
						newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+closetime+"'"+arr[2]+"'"+selectInfo+"'"+arr[3];
					}else if(closetime==null||closetime.equals("")){
						newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+starttime+"'"+arr[2]+"'"+selectInfo+"'"+arr[3];
					}else{
						newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+starttime+"'"+arr[2]+"'"+closetime+"'"+arr[3];
					}
					break;
				case 5:
					newSql=arr[0]+"'"+storename+"'"+arr[1]+"'"+starttime+"'"+arr[2]+"'"+closetime+"'"+arr[3]+"'"+selectInfo+"'"+arr[4];
					break;
				default:
					break;
				}
			}
		}
		return newSql;
	}
	
	/**
	 * 
	 * @param sql 为截取到的Sql语句
	 * @param pageBean 分页model类 为limit 添加参数 
	 * @return 拼接好的Sql语句
	 * limit(初始从0开始，条数)
	 */
	public String concatPageSql(String sql, PageBean pageBean) {
		StringBuffer sb = new StringBuffer();
		sb.append(sql);
		sb.append(" limit ").append(pageBean.getPageLimit()).append(" ,").append(pageBean.getPageCount());
		return sb.toString();
	}

}

JSP界面

<%@page import="com.chinasofti.lexian.manager.user.vo.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib prefix="spring" uri="http://www.springframework.org/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>Insert title here</title>
<style type="text/css">
a{
	text-decoration: none;
}
#div_right {
	width: 100%;
	height: 640px;
	margin: 0 auto;
}

#div_login {
	width: 100%;
	height: 25px;
	padding-top: 4px;
	font-family: "微软雅黑";
	font-size: 13px;
}

.table_txt {
	font-family: "微软雅黑";
	font-size: 12px;
	height: 20px;
	border: 0.1px solid gray;
	text-align: center;
	width: 100%
}

.div_info_all {
	float: left;
	width: 100%;
	height: 24px;
	font-family: "微软雅黑";
}

.div_info_all_text {
	font-size: 12px;
	margin-top: 7px;
	float: right;
}

.span_txt {
	font-weight: bold;
	margin-left: -3px;
}

.div_input {
	float: left;
	margin-right: 5px;
}

.input_scan {
	border: 1px solid black;
	margin-left: -1px;
	margin-right: -1px;
}

.input_text {
	width: 25px;
	height: 13px;
}

.span_text {
	font-family: "微软雅黑";
	font-size: 12px;
}

#div_select {
	float: right;
	margin-right: 5px;
	margin-top: -5px;
}
#td_text1{
	color:blue;
}
#td_text2{
	color:red;
}
tr:hover{
	background-color: white;
}
</style>
<script type="text/javascript">
function page(pageArg){
	var myform = document.getElementById("myform");
	var pageNo = document.getElementById("pageID");
	pageNo.value = pageArg;
	if(pageArg!=-1){
		myform.submit();
	}else{
		pageNo.value ="";
	}
		
}
function pageSubmit(pageArg){
	var myform = document.getElementById("myform");
	var pageNo = document.getElementById("pageID");
	if(pageNo.value-1 < pageArg){
		pageNo.value=Number(pageNo.value)-1;
		if(pageNo.value>-1){
			myform.submit();
		}else{
			pageNo.value="";
		}
	}
}
function nextPage(pageArg,totalPage){
	var myform = document.getElementById("myform");
	var pageNo = document.getElementById("pageID");
	pageNo.value = pageArg;
	if(pageArg<totalPage)
		myform.submit();
}
</script>
</head>
<body background="#F3F3F3">
<form action="selectLikeUser.do" method="post" id="myform">
	<div id="div_right">
		<div id="div_login">
			会员管理 > 查看会员信息
			<div id="div_select">
					<select name="selectType">
						<option value="username" ${pageBean.selectType=='username' ? 'selected' : ""}>会员名</option>
						<option value="phone" ${pageBean.selectType=='phone' ? 'selected' : ""}>手机号</option>
					</select>
					<input type="text" name="selectInfo" value="${pageBean.selectInfo}"/> 
					<input type="button" value="查找" onclick="page(0)"/>
			</div>
		</div>
		<table border="1px" cellspacing="0px" cellpadding="5px"
			class="table_txt">
			<tr style="background-color:  #c3dde0;">
				<th></th>
				<th>会员名</th>
				<th>手机号</th>
				<th>最后登陆时间</th>
				<th>状态</th>
				<th>操作</th>
			</tr>

			<c:forEach items="${userList}" var="key" varStatus="state">
				<tr>
					<td>${state.count}</td>
					<td>${key.username}</td>
					<td>${key.phone}</td>
<%-- 					<td>${key.lastlogintime}</td> --%>
					<td><spring:eval expression="key.lastlogintime" /></td>
					<td><span id="td_text1">${key.status==1 ? "启用" :"禁用"}</span></td>
<%-- 					<td>${key.statusInfo}</td> --%>
<%-- 					<td><a href="changeStatus.do?id=${key.id}&status=${key.status}">${key.checkStatus}</a></td> --%>
					<td><a href="changeStatus.do?selectType=${pageBean.selectType}&id=${key.id}&status=${key.status}&selectInfo=${pageBean.selectInfo}&pageNo=${pageBean.pageNo}"><span id="td_text2">${key.status==1 ? "禁用" :"启用"}</span></a></td>
				</tr>
			</c:forEach>
		</table>
		<div class="div_info_all">
			<div class="div_info_all_text">
				共 <span class="span_txt">${pageBean.totalCount}</span> 条结果，分成 <span class="span_txt">${pageBean.totalPage}</span>页显示，当前第
				<span class="span_txt">${pageBean.pageNo+1}</span>页
			</div>
			<div class="div_input">
					<input type="button" class="input_scan" value="首页" onclick="page(0)"/> 
					<c:if test="${pageBean.previous}">
					<input type="button" class="input_scan" value="上页" onclick="page(${pageBean.pageNo - 1})"/> 
					</c:if>
					<c:if test="${pageBean.next}">
					<input type="button" class="input_scan" value="下页" onclick="nextPage(${pageBean.pageNo + 1},${pageBean.totalPage})"/>
					</c:if>
					<input type="button" class="input_scan" value="末页" onclick="page(${pageBean.totalPage -1})"/> 
					<span class="span_text">跳到第</span>
					<input type="text" class="input_text" name="pageNo" id="pageID"/>
					<span class="span_text">页</span> 
					<input type="button" class="input_scan" value="跳转" onclick="pageSubmit(${pageBean.totalPage})"/>
			</div>
		</div>
	</div>
	</form>
</body>
</html>