springboot 启动报错 Error creating bean with name 'userDAOMapper' defined in file

最新推荐文章于 2024-09-11 12:43:28 发布

编码的三叔

最新推荐文章于 2024-09-11 12:43:28 发布

阅读量3w

点赞数 5

分类专栏： springboot 文章标签： mapper create false

本文链接：https://blog.csdn.net/ppwwp/article/details/84949051

版权

springboot 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2018-12-11 00:57:00.093 ERROR 152276 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'loginController': Unsatisfied dependency expressed through field 'userDAOMaaper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDAOMapper' defined in file [E:\os\tt\target\classes\com\ttxq\tt\mysqlutils\mapper\UserDAOMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:596) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:374) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1378) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:575) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:846) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:863) ~[spring-context-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) ~[spring-context-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142) ~[spring-boot-2.1.1.RELEASE.jar:2.1.1.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) [spring-boot-2.1.1.RELEASE.jar:2.1.1.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.1.1.RELEASE.jar:2.1.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [spring-boot-2.1.1.RELEASE.jar:2.1.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) [spring-boot-2.1.1.RELEASE.jar:2.1.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) [spring-boot-2.1.1.RELEASE.jar:2.1.1.RELEASE]
	at com.ttxq.tt.TtApplication.main(TtApplication.java:12) [classes/:na]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDAOMapper' defined in file [E:\os\tt\target\classes\com\ttxq\tt\mysqlutils\mapper\UserDAOMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1482) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1362) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:575) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:273) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1237) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1164) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:593) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	... 19 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:627) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:607) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1288) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1127) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:538) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:273) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1237) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1164) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1467) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	... 30 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:622) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	... 43 common frames omitted
Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:523) ~[mybatis-spring-1.3.2.jar:1.3.2]
	at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:380) ~[mybatis-spring-1.3.2.jar:1.3.2]
	at org.mybatis.spring.SqlSessionFactoryBean.getObject(SqlSessionFactoryBean.java:547) ~[mybatis-spring-1.3.2.jar:1.3.2]
	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration.sqlSessionFactory(MybatisAutoConfiguration.java:153) ~[mybatis-spring-boot-autoconfigure-1.3.2.jar:1.3.2]
	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$ba69079f.CGLIB$sqlSessionFactory$1(<generated>) ~[mybatis-spring-boot-autoconfigure-1.3.2.jar:1.3.2]
	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$ba69079f$$FastClassBySpringCGLIB$$fdba6c04.invoke(<generated>) ~[mybatis-spring-boot-autoconfigure-1.3.2.jar:1.3.2]
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:363) ~[spring-context-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$ba69079f.sqlSessionFactory(<generated>) ~[mybatis-spring-boot-autoconfigure-1.3.2.jar:1.3.2]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_161]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_161]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.1.3.RELEASE.jar:5.1.3.RELEASE]
	... 44 common frames omitted
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\os\tt\target\classes\mapper\UserDAOMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:120) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:92) ~[mybatis-3.4.6.jar:3.4.6]
	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:521) ~[mybatis-spring-1.3.2.jar:1.3.2]
	... 57 common frames omitted
Caused by: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.ttxq.tt.mysqlutils.mapper.UserDAOMapper.BaseResultMap
	at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:872) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:844) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.session.Configuration.addResultMap(Configuration.java:626) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.MapperBuilderAssistant.addResultMap(MapperBuilderAssistant.java:214) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.ResultMapResolver.resolve(ResultMapResolver.java:47) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:285) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:252) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:244) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:116) ~[mybatis-3.4.6.jar:3.4.6]
	... 59 common frames omitted

Disconnected from the target VM, address: '127.0.0.1:51219', transport: 'socket'

Process finished with exit code 1

generator生成的*Mapper.xml id重复。。。我想静静！
两个updateByPrimaryKey 但是我想知道为什么。。。。而且这两个方法的名称一样但是作用还不一样，，，谁写的这个generator？

<update id="updateByPrimaryKey" parameterType="com.ttxq.tt.mysqlutils.dao.UserDAO">

 <update id="updateByPrimaryKey" parameterType="com.ttxq.tt.mysqlutils.dao.UserDAO">

哎呦继续研究一下

去掉<property name="suppressAllComments" value="true"/> ok 生成的代码不再重复

  <update id="updateByPrimaryKey" parameterType="com.ttxq.tt.mysqlutils.dao.UserDAO">
    update user
    set Host = #{host,jdbcType=CHAR},
      Select_priv = #{selectPriv,jdbcType=CHAR},
      Insert_priv = #{insertPriv,jdbcType=CHAR},
      Update_priv = #{updatePriv,jdbcType=CHAR},
      Delete_priv = #{deletePriv,jdbcType=CHAR},
      Create_priv = #{createPriv,jdbcType=CHAR},
      Drop_priv = #{dropPriv,jdbcType=CHAR},
      Reload_priv = #{reloadPriv,jdbcType=CHAR},
      Shutdown_priv = #{shutdownPriv,jdbcType=CHAR},
      Process_priv = #{processPriv,jdbcType=CHAR},
      File_priv = #{filePriv,jdbcType=CHAR},
      Grant_priv = #{grantPriv,jdbcType=CHAR},
      References_priv = #{referencesPriv,jdbcType=CHAR},
      Index_priv = #{indexPriv,jdbcType=CHAR},
      Alter_priv = #{alterPriv,jdbcType=CHAR},
      Show_db_priv = #{showDbPriv,jdbcType=CHAR},
      Super_priv = #{superPriv,jdbcType=CHAR},
      Create_tmp_table_priv = #{createTmpTablePriv,jdbcType=CHAR},
      Lock_tables_priv = #{lockTablesPriv,jdbcType=CHAR},
      Execute_priv = #{executePriv,jdbcType=CHAR},
      Repl_slave_priv = #{replSlavePriv,jdbcType=CHAR},
      Repl_client_priv = #{replClientPriv,jdbcType=CHAR},
      Create_view_priv = #{createViewPriv,jdbcType=CHAR},
      Show_view_priv = #{showViewPriv,jdbcType=CHAR},
      Create_routine_priv = #{createRoutinePriv,jdbcType=CHAR},
      Alter_routine_priv = #{alterRoutinePriv,jdbcType=CHAR},
      Create_user_priv = #{createUserPriv,jdbcType=CHAR},
      Event_priv = #{eventPriv,jdbcType=CHAR},
      Trigger_priv = #{triggerPriv,jdbcType=CHAR},
      Create_tablespace_priv = #{createTablespacePriv,jdbcType=CHAR},
      ssl_type = #{sslType,jdbcType=CHAR},
      max_questions = #{maxQuestions,jdbcType=INTEGER},
      max_updates = #{maxUpdates,jdbcType=INTEGER},
      max_connections = #{maxConnections,jdbcType=INTEGER},
      max_user_connections = #{maxUserConnections,jdbcType=INTEGER},
      plugin = #{plugin,jdbcType=CHAR},
      password_expired = #{passwordExpired,jdbcType=CHAR},
      password_last_changed = #{passwordLastChanged,jdbcType=TIMESTAMP},
      password_lifetime = #{passwordLifetime,jdbcType=SMALLINT},
      account_locked = #{accountLocked,jdbcType=CHAR},
      Create_role_priv = #{createRolePriv,jdbcType=CHAR},
      Drop_role_priv = #{dropRolePriv,jdbcType=CHAR},
      Password_reuse_history = #{passwordReuseHistory,jdbcType=SMALLINT},
      Password_reuse_time = #{passwordReuseTime,jdbcType=SMALLINT},
      Password_require_current = #{passwordRequireCurrent,jdbcType=CHAR}
    where User = #{user,jdbcType=CHAR}
  </update>

<update id="updateByPrimaryKey" parameterType="com.ttxq.tt.mysqlutils.dao.UserDAO">
    update user
    set b_name = #{bName,jdbcType=VARCHAR},
      b_birthday = #{bBirthday,jdbcType=TIMESTAMP},
      b_constellation = #{bConstellation,jdbcType=VARCHAR},
      b_height = #{bHeight,jdbcType=VARCHAR},
      b_annualsalary = #{bAnnualsalary,jdbcType=VARCHAR},
      b_livecity = #{bLivecity,jdbcType=VARCHAR},
      b_expect = #{bExpect,jdbcType=VARCHAR},
      b_wechat = #{bWechat,jdbcType=VARCHAR},
      i_nation = #{iNation,jdbcType=VARCHAR},
      i_hometown = #{iHometown,jdbcType=VARCHAR},
      i_naritalstatus = #{iNaritalstatus,jdbcType=VARCHAR},
      i_occupation = #{iOccupation,jdbcType=VARCHAR},
      i_faith = #{iFaith,jdbcType=VARCHAR},
      i_drinkwine = #{iDrinkwine,jdbcType=VARCHAR},
      i_smoking = #{iSmoking,jdbcType=VARCHAR},
      i_sortinhome = #{iSortinhome,jdbcType=VARCHAR},
      i_hasson = #{iHasson,jdbcType=VARCHAR},
      i_weight = #{iWeight,jdbcType=VARCHAR},
      s_age = #{sAge,jdbcType=VARCHAR},
      s_height = #{sHeight,jdbcType=VARCHAR},
      s_annualincome = #{sAnnualincome,jdbcType=VARCHAR},
      s_hometown = #{sHometown,jdbcType=VARCHAR},
      s_maritalstatus = #{sMaritalstatus,jdbcType=VARCHAR},
      s_faith = #{sFaith,jdbcType=VARCHAR},
      s_drink = #{sDrink,jdbcType=VARCHAR},
      s_smoking = #{sSmoking,jdbcType=VARCHAR},
      s_hasson = #{sHasson,jdbcType=VARCHAR},
      s_weight = #{sWeight,jdbcType=VARCHAR},
      s_constellation = #{sConstellation,jdbcType=VARCHAR},
      p_moive = #{pMoive,jdbcType=VARCHAR},
      p_music = #{pMusic,jdbcType=VARCHAR},
      p_book = #{pBook,jdbcType=VARCHAR},
      p_food = #{pFood,jdbcType=VARCHAR},
      p_sport = #{pSport,jdbcType=VARCHAR},
      ts = #{ts,jdbcType=VARCHAR},
      usercol = #{usercol,jdbcType=TIMESTAMP},
      addtime = #{addtime,jdbcType=TIMESTAMP}
    where iduser = #{iduser,jdbcType=VARCHAR}
  </update>