spring-in-action-mvc-mybatis-annotation

 spring-in-action-mvc-mybatis-annotation代码

这个mybitas有大坑，把mybatis版本弄成3.2，不要3.3，要不不能注入userDaoBean，然后扫描mapper指向dao的package

 

这个sql应该说一下

修改密码流程

1 关闭mysql，用top然后把mysql pid干掉

2 修改/etc/my.cnf  加入skip-grant-tables

3 重新启动sudo /usr/local/mysql/support-files/mysql.server start

4 修改密码/usr/local/mysql/bin/mysqladmin -u root password "sanshuiyijing214"

5 登录 mysql -u root -psanshuiyijing214

 

-- 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