▲Struts+Spring和iBatis整合

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES gbk */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='SYSTEM' */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; DROP DATABASE IF EXISTS `sanguo`; CREATE DATABASE `sanguo` /*!40100 DEFAULT CHARACTER SET gbk */; USE `sanguo`; CREATE TABLE `department` ( `id` int(11) NOT NULL auto_increment, `dept_name` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; INSERT INTO `department` VALUES (1,'蜀汉'); INSERT INTO `department` VALUES (2,'曹魏'); INSERT INTO `department` VALUES (3,'孙吴'); INSERT INTO `department` VALUES (4,'其他'); CREATE TABLE `person` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, `age` int(11) default NULL, `address` varchar(50) default NULL, `dept_id` int(11) default NULL, PRIMARY KEY (`id`), KEY `dept_id` (`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; INSERT INTO `person` VALUES (1,'张飞(翼德)',23,'河北西乡(幽州涿郡)',1); INSERT INTO `person` VALUES (2,'关羽(云长)',24,'山西运城(并州河东解县)',1); INSERT INTO `person` VALUES (3,'刘备(玄德)',25,'河北涿州(幽州涿郡涿县)',1); INSERT INTO `person` VALUES (4,'曹操(孟德)',26,'安徽亳州(兖州沛国谯县)',2); INSERT INTO `person` VALUES (5,'赵云(子龙)',18,'河北正定(冀州常山真定)',1); INSERT INTO `person` VALUES (6,'黄忠(汉升)',45,'河南南阳(荆州南阳)',1); INSERT INTO `person` VALUES (7,'魏延(文长)',20,'河南桐柏(荆州益阳郡)',1); INSERT INTO `person` VALUES (8,'貂蝉(无)',18,'不详',4); INSERT INTO `person` VALUES (9,'黄盖(公覆)',36,'湖南零陵(荆州零陵泉陵)',3); INSERT INTO `person` VALUES (10,'孙权(仲谋)',21,'浙江富阳(扬州吴郡富春)',3); INSERT INTO `person` VALUES (11,'诸葛亮(孔明)',17,'山东沂南县南(徐州琅邪都)',1); INSERT INTO `person` VALUES (12,'大乔(无)',18,'安徽潜山(扬州庐江皖县)',3); INSERT INTO `person` VALUES (13,'马超(孟起)',19,'陕西兴平(司州扶风茂陵)',1); INSERT INTO `person` VALUES (14,'张辽(文远)',28,'雁门马邑 (山西朔县)',2); INSERT INTO `person` VALUES (15,'吕布(奉先)',27,'内蒙古包头(并州五原郡九原)',4); INSERT INTO `person` VALUES (16,'董卓(仲颖)',30,'甘肃临洮(凉州陇西临洮)',4); INSERT INTO `person` VALUES (17,'贾诩(文和)',29,'甘肃武威(凉州武威姑臧)',2); INSERT INTO `person` VALUES (18,'小乔(无)',17,'安徽潜山(扬州庐江皖县)',3); INSERT INTO `person` VALUES (19,'袁绍(本初)',32,'河南汝阳(豫州汝南汝阳)',4); INSERT INTO `person` VALUES (20,'太史慈(子义)',38,'东莱黄县 (今山东龙口)',3); INSERT INTO `person` VALUES (21,'司马懿(仲达)',28,'河南温县(司州河内温县)',2); INSERT INTO `person` VALUES (22,'甘宁(兴霸)',16,'重庆忠县(益州巴郡临江)',4); INSERT INTO `person` VALUES (23,'张郃(俊乂)',24,'河北任丘北(冀州河间鄚县)',2); INSERT INTO `person` VALUES (24,'庞德(令明)',20,'甘肃陇西东南(雍州南安狄道)',2); INSERT INTO `person` VALUES (25,'周泰(幼平)',21,'安徽凤台(扬州九江下蔡)',3); INSERT INTO `person` VALUES (26,'法正(孝直)',20,'陕西眉县(雍州扶风郿县)',1); INSERT INTO `person` VALUES (27,'许褚(仲康)',21,'安徽毫州(豫州谯国谯县)',2); INSERT INTO `person` VALUES (28,'陆逊(伯言)',18,'上海松江(扬州吴郡吴县华亭)',3); INSERT INTO `person` VALUES (29,'徐庶(元直)',22,'河南许昌一带(豫州颍川郡)',2); INSERT INTO `person` VALUES (30,'孔融(文举)',24,'山东曲阜(鲁国)',2); INSERT INTO `person` VALUES (31,'郭嘉(奉孝)',31,'河南禹州(豫州颖川阳翟)',2); INSERT INTO `person` VALUES (32,'乐进(文谦)',37,'阳平卫国(河南清丰)',2); INSERT INTO `person` VALUES (33,'夏侯渊(妙才)',32,'安徽亳州(兖州沛国谯县)',2); INSERT INTO `person` VALUES (34,'夏侯惇(元让)',34,'安徽亳州(兖州沛国谯县)',2); ALTER TABLE `person` ADD FOREIGN KEY (`dept_id`) REFERENCES `department` (`id`); /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;