个回答

• qq_安静_77

  2021-10-22 01:20:08

  用火狐浏览器可以注册

  0

• ahuwhq

  2021-05-25 11:41:31

  断点调试发现是数据库设计问题，在userService.register(userModel);时跳出异常。

  解决是重新设计数据库，删除原来的数据库，运行下面这段SQL：
  

  SET FOREIGN_KEY_CHECKS=0;

  
  

  
  

  -- ----------------------------

  -- Table structure for user_info

  -- ----------------------------

  DROP TABLE IF EXISTS `user_info`;

  CREATE TABLE `user_info` (

    `id` int(11) NOT NULL AUTO_INCREMENT,

    `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

    `gender` tinyint(4) NOT NULL DEFAULT '0',

    `age` int(11) NOT NULL DEFAULT '0',

    `telphone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

    `register_mode` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

    `third_party_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

    PRIMARY KEY (`id`)

  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  
  

  -- ----------------------------

  -- Records of user_info

  -- ----------------------------

  
  

  
  

  -- ----------------------------

  -- Table structure for user_password

  -- ----------------------------

  DROP TABLE IF EXISTS `user_password`;

  CREATE TABLE `user_password` (

    `id` int(11) NOT NULL AUTO_INCREMENT,

    `encrpt_password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,

    `user_id` int(11) NOT NULL,

    PRIMARY KEY (`id`)

  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  
  

  
  

  
  

  

  
  

  1