资源描述：
《框架整合SSH实现分页(Struts2+Spring2.5+Spring3.2)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、整合实现分页模块Struts2+Spring2.0+Spring3.0实验步骤准备数据库1）在mysql中创建数据库。/*MySQLDataTransferSourceHost:localhostSourceDatabase:testTargetHost:localhostTargetDatabase:testDate:2012-7-511:35:50*/SETFOREIGN_KEY_CHECKS=0;--------------------------------Tablestructureforadmin---------------------------
2、---CREATETABLE`admin`(`id`int(8)NOTNULLauto_increment,`username`varchar(20)NOTNULL,`password`varchar(20)defaultNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8;--------------------------------Tablestructureforbook------------------------------CREATETABLE`book`(`
3、id`int(11)NOTNULLauto_increment,`bookname`varchar(40)charactersetutf8NOTNULL,`title`varchar(40)defaultNULL,`description`varchar(400)defaultNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=15DEFAULTCHARSET=gbkROW_FORMAT=REDUNDANT;--------------------------------Tablestructureforcateg
4、ory------------------------------CREATETABLE`category`(`id`int(11)NOTNULLauto_increment,`name`varchar(40)NOTNULL,`description`varchar(100)defaultNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8;CREATETABLE`guestbook`(`id`int(8)NOTNULLauto_increment,`name`varchar
5、(20)NOTNULL,`phone`varchar(20)defaultNULL,`email`varchar(40)defaultNULL,`title`varchar(80)NOTNULL,`content`varchar(2000)defaultNULL,`createdTime`datetimeNOTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=5DEFAULTCHARSET=utf8;CREATETABLE`product`(`id`int(11)NOTNULLauto_increment,`na
6、me`varchar(255)NOTNULL,`price`floatdefaultNULL,`description`varchar(255)defaultNULL,`categoryId`int(11)defaultNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8;CREATETABLE`profile`(`id`int(11)NOTNULLauto_increment,`email`varchar(40)defaultNULL,`address`varchar(40
7、)defaultNULL,`postcode`varchar(40)defaultNULL,`mobile`varchar(40)defaultNULL,`phone`varchar(40)defaultNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=9DEFAULTCHARSET=utf8;CREATETABLE`user`(`id`int(11)NOTNULLauto_increment,`username`varchar(40)NOTNULL,`password`varchar(40)NOTNULL,PR
8、IMARYKEY(`id
