spring-in-action-mvc-mybatis-annotation代码
这个mybitas有大坑，把mybatis版本弄成3.2，不要3.3，要不不能注入userDaoBean，然后扫描mapper指向dao的package
这个sql应该说一下
-- MySQL dump 10.13 Distrib 5.6.24, for osx10.8 (x86_64) -- -- Host: 127.0.0.1 Database: test -- ------------------------------------------------------ -- Server version 5.7.9 /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE=‘+00:00‘ */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO‘ */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `family` -- DROP TABLE IF EXISTS `family`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `family` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT ‘‘, `role` varchar(50) NOT NULL DEFAULT ‘‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=802 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `family` -- LOCK TABLES `family` WRITE; /*!40000 ALTER TABLE `family` DISABLE KEYS */; INSERT INTO `family` VALUES (502,‘儿子‘,‘崔小淼‘),(504,‘儿子‘,‘崔小淼‘),(505,‘儿子‘,‘崔小淼‘),(506,‘儿子‘,‘崔小淼‘),(507,‘儿子‘,‘崔小淼‘),(508,‘儿子‘,‘崔小淼‘),(509,‘儿子‘,‘崔小淼‘),(510,‘儿子‘,‘崔小淼‘),(511,‘儿子‘,‘崔小淼‘),(513,‘儿子‘,‘崔小淼‘),(514,‘儿子‘,‘崔小淼‘),(515,‘儿子‘,‘崔小淼‘),(516,‘儿子‘,‘崔小淼‘),(517,‘崔淼‘,‘老公‘),(518,‘聂绎静‘,‘老婆‘),(519,‘嘿嘿‘,‘小三‘),(520,‘儿子‘,‘崔小淼‘),(524,‘崔淼‘,‘老公‘),(525,‘聂绎静‘,‘老婆‘),(526,‘嘿嘿‘,‘小三‘),(527,‘儿子‘,‘崔小淼‘),(537,‘儿子‘,‘崔小淼‘),(538,‘儿子‘,‘崔小淼‘),(539,‘儿子‘,‘崔小淼‘),(543,‘儿子‘,‘崔小淼‘),(544,‘儿子‘,‘崔小淼‘),(545,‘儿子‘,‘崔小淼‘),(549,‘崔淼‘,‘老公‘),(550,‘聂绎静‘,‘老婆‘),(551,‘嘿嘿‘,‘小三‘),(562,‘崔淼‘,‘老公‘),(563,‘聂绎静‘,‘老婆‘),(564,‘嘿嘿‘,‘小三‘),(565,‘1‘,‘2‘),(566,‘崔淼‘,‘老公‘),(567,‘聂绎静‘,‘老婆‘),(568,‘嘿嘿‘,‘小三‘),(569,‘1‘,‘2‘),(582,‘崔淼‘,‘老公‘),(583,‘聂绎静‘,‘老婆‘),(584,‘嘿嘿‘,‘小三‘),(600,‘崔淼‘,‘老公‘),(601,‘聂绎静‘,‘老婆‘),(602,‘嘿嘿‘,‘小三‘),(609,‘崔淼‘,‘老公‘),(610,‘聂绎静‘,‘老婆‘),(612,‘崔小静‘,‘女儿‘),(613,‘崔淼‘,‘老公‘),(614,‘聂绎静‘,‘老婆‘),(616,‘崔小静‘,‘女儿‘),(617,‘崔淼‘,‘老公‘),(618,‘聂绎静‘,‘老婆‘),(620,‘女儿‘,‘崔小静‘),(621,‘崔淼‘,‘老公‘),(622,‘聂绎静‘,‘老婆‘),(624,‘崔小静‘,‘女儿‘),(625,‘崔淼‘,‘老公‘),(626,‘聂绎静‘,‘老婆‘),(628,‘崔小静‘,‘女儿‘),(638,‘22‘,‘‘),(642,‘崔淼‘,‘老公‘),(643,‘聂绎静‘,‘老婆‘),(645,‘女儿‘,‘崔小静‘),(646,‘崔淼‘,‘老公‘),(647,‘聂绎静‘,‘老婆‘),(649,‘女儿‘,‘崔小静‘),(650,‘崔淼‘,‘老公‘),(651,‘聂绎静‘,‘老婆‘),(653,‘女儿‘,‘崔小静‘),(654,‘崔淼‘,‘老公‘),(655,‘聂绎静‘,‘老婆‘),(657,‘女儿‘,‘崔小静‘),(658,‘崔淼‘,‘老公‘),(659,‘聂绎静‘,‘老婆‘),(661,‘女儿‘,‘崔小静‘),(662,‘崔淼‘,‘老公‘),(663,‘聂绎静‘,‘老婆‘),(665,‘女儿‘,‘崔小静‘),(666,‘崔淼‘,‘老公‘),(667,‘聂绎静‘,‘老婆‘),(669,‘女儿‘,‘崔小静‘),(670,‘崔淼‘,‘老公‘),(671,‘聂绎静‘,‘老婆‘),(673,‘女儿‘,‘崔小静‘),(674,‘崔淼‘,‘老公‘),(675,‘聂绎静‘,‘老婆‘),(677,‘女儿‘,‘崔小静‘),(678,‘崔淼‘,‘老公‘),(679,‘聂绎静‘,‘老婆‘),(681,‘女儿‘,‘崔小静‘),(682,‘崔淼‘,‘老公‘),(683,‘聂绎静‘,‘老婆‘),(685,‘女儿‘,‘崔小静‘),(686,‘崔淼‘,‘老公‘),(687,‘聂绎静‘,‘老婆‘),(689,‘女儿‘,‘崔小静‘),(690,‘崔淼‘,‘老公‘),(691,‘聂绎静‘,‘老婆‘),(693,‘女儿‘,‘崔小静‘),(694,‘崔淼‘,‘老公‘),(695,‘聂绎静‘,‘老婆‘),(697,‘女儿‘,‘崔小静‘),(698,‘崔淼‘,‘老公‘),(699,‘聂绎静‘,‘老婆‘),(701,‘女儿‘,‘崔小静‘),(702,‘崔淼‘,‘老公‘),(703,‘聂绎静‘,‘老婆‘),(705,‘女儿‘,‘崔小静‘),(706,‘崔淼‘,‘老公‘),(707,‘聂绎静‘,‘老婆‘),(709,‘女儿‘,‘崔小静‘),(710,‘崔淼‘,‘老公‘),(711,‘聂绎静‘,‘老婆‘),(713,‘女儿‘,‘崔小静‘),(714,‘崔淼‘,‘老公‘),(715,‘聂绎静‘,‘老婆‘),(717,‘女儿‘,‘崔小静‘),(718,‘崔淼‘,‘老公‘),(719,‘聂绎静‘,‘老婆‘),(721,‘女儿‘,‘崔小静‘),(722,‘崔淼‘,‘老公‘),(723,‘聂绎静‘,‘老婆‘),(725,‘女儿‘,‘崔小静‘),(726,‘崔淼‘,‘老公‘),(727,‘聂绎静‘,‘老婆‘),(729,‘女儿‘,‘崔小静‘),(730,‘崔淼‘,‘老公‘),(731,‘聂绎静‘,‘老婆‘),(733,‘女儿‘,‘崔小静‘),(734,‘崔淼‘,‘老公‘),(735,‘聂绎静‘,‘老婆‘),(737,‘女儿‘,‘崔小静‘),(738,‘崔淼‘,‘老公‘),(739,‘聂绎静‘,‘老婆‘),(741,‘女儿‘,‘崔小静‘),(742,‘崔淼‘,‘老公‘),(743,‘聂绎静‘,‘老婆‘),(745,‘女儿‘,‘崔小静‘),(746,‘崔淼‘,‘老公‘),(747,‘聂绎静‘,‘老婆‘),(749,‘女儿‘,‘崔小静‘),(750,‘崔淼‘,‘老公‘),(751,‘聂绎静‘,‘老婆‘),(753,‘女儿‘,‘崔小静‘),(754,‘崔淼‘,‘老公‘),(755,‘聂绎静‘,‘老婆‘),(757,‘女儿‘,‘崔小静‘),(758,‘崔淼‘,‘老公‘),(759,‘聂绎静‘,‘老婆‘),(761,‘女儿‘,‘崔小静‘),(762,‘崔淼‘,‘老公‘),(763,‘聂绎静‘,‘老婆‘),(765,‘女儿‘,‘崔小静‘),(766,‘崔淼‘,‘老公‘),(767,‘聂绎静‘,‘老婆‘),(769,‘女儿‘,‘崔小静‘),(770,‘崔淼‘,‘老公‘),(771,‘聂绎静‘,‘老婆‘),(773,‘女儿‘,‘崔小静‘),(774,‘崔淼‘,‘老公‘),(775,‘聂绎静‘,‘老婆‘),(777,‘女儿‘,‘崔小静‘),(778,‘崔淼‘,‘老公‘),(779,‘聂绎静‘,‘老婆‘),(781,‘女儿‘,‘崔小静‘),(782,‘崔淼‘,‘老公‘),(783,‘聂绎静‘,‘老婆‘),(785,‘女儿‘,‘崔小静‘),(786,‘崔淼‘,‘老公‘),(787,‘聂绎静‘,‘老婆‘),(789,‘女儿‘,‘崔小静‘),(790,‘崔淼‘,‘老公‘),(791,‘聂绎静‘,‘老婆‘),(793,‘女儿‘,‘崔小静‘),(794,‘崔淼‘,‘老公‘),(795,‘聂绎静‘,‘老婆‘),(797,‘女儿‘,‘崔小静‘),(798,‘崔淼‘,‘老公‘),(799,‘聂绎静‘,‘老婆‘),(801,‘女儿‘,‘崔小静‘); /*!40000 ALTER TABLE `family` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2015-12-30 23:50:09
-- MySQL dump 10.13 Distrib 5.6.24, for osx10.8 (x86_64) -- -- Host: 127.0.0.1 Database: test -- ------------------------------------------------------ -- Server version 5.7.9 /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE=‘+00:00‘ */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO‘ */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT ‘‘, `password` varchar(50) NOT NULL DEFAULT ‘‘, `email` varchar(50) NOT NULL DEFAULT ‘‘, `phone` varchar(50) NOT NULL DEFAULT ‘‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES (1,‘崔淼‘,‘nieyijing214‘,‘suiling-1989@163.com‘,‘18621645768‘),(2,‘聂绎静‘,‘nieyijing214‘,‘suiling-1989@163.com‘,‘18657198568‘),(3,‘狗子‘,‘111‘,‘11‘,‘1111‘),(4,‘大为‘,‘22‘,‘222‘,‘2222‘),(5,‘史蒂夫‘,‘22‘,‘233‘,‘444‘),(6,‘的地方‘,‘圣诞‘,‘ww‘,‘ssv‘),(7,‘11‘,‘222‘,‘333‘,‘444‘),(8,‘sss‘,‘ss‘,‘ss‘,‘sss‘),(9,‘22‘,‘22‘,‘333‘,‘444‘),(10,‘111‘,‘22‘,‘2‘,‘2222‘),(11,‘dd‘,‘ddd‘,‘dddd‘,‘ddddd‘),(12,‘水电费水电费‘,‘3‘,‘史蒂夫‘,‘订单‘); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2015-12-30 23:50:07
spring-in-action-mvc-mybatis-annotation
原文：http://www.cnblogs.com/damiao-hungry/p/5090458.html