ssm mysql分页查询_ssm分页查询实例 ,只需一个查询就可以

牛牛们,最近写了一个分页,基于sping+ springMVC+mybatis,里面还有定时任务的配置!

tomcat 7.0

jdk 1.6

myeclipse 10

jar包下载地址

在此提前祝大家新年快乐!

上图:

1.

2.

3.

sql脚本:/*

Navicat MySQL Data Transfer

Source Server : localhost

Source Server Version : 50519

Source Host : localhost:3306

Source Database : ssm

Target Server Type : MYSQL

Target Server Version : 50519

File Encoding : 65001

Date: 2017-01-26 19:38:36

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

`id` int(11) NOT NULL COMMENT 'id',

`name` varchar(50) DEFAULT NULL COMMENT '姓名',

`age` char(2) DEFAULT NULL COMMENT '年龄',

`time` datetime DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('1', '张三', '19', '2016-11-10 11:06:59');

INSERT INTO `user` VALUES ('2', '方法', '99', '2016-11-10 11:07:05');

INSERT INTO `user` VALUES ('3', '吖吖', '45', '2016-11-10 11:07:02');

INSERT INTO `user` VALUES ('4', '啊啊', '34', '2016-11-10 11:07:09');

INSERT INTO `user` VALUES ('5', '等等', '45', '2016-11-10 11:07:14');

INSERT INTO `user` VALUES ('6', '试试', '89', '2016-11-10 11:07:11');

INSERT INTO `user` VALUES ('7', '王五', '67', '2016-11-10 11:06:56');

INSERT INTO `user` VALUES ('8', '张三', '19', '2016-11-10 11:05:53');

INSERT INTO `user` VALUES ('9', '王五', '67', '2016-11-10 11:06:56');

INSERT INTO `user` VALUES ('10', '王五', '67', '2016-11-10 11:06:56');

INSERT INTO `user` VALUES ('11', '张三', '19', '2016-11-10 11:05:53');

INSERT INTO `user` VALUES ('12', '123', '12', '2017-11-24 15:00:28');

祝牛牛们新年快乐!

由最代码官方编辑于2017-2-3 10:07:26