Java Spring框架JDBC详解教程【多测师_何sir】

1，Mysql建表脚本

创建sys_user表

CREATE TABLE `sys_user` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `pass_word` varchar(50) DEFAULT NULL COMMENT '密码',
  `phone` varchar(50) DEFAULT NULL COMMENT '手机',
  `sex` tinyint(1) DEFAULT NULL COMMENT '状态(0：男，1：女)',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `address` varchar(50) DEFAULT NULL COMMENT '地址',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '加入时间',
  `state` char(1) DEFAULT NULL COMMENT '状态(0：禁用，1：启用，)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='系统用户'

表中导入数据

insert into `sys_user` (`name`, `user_name`, `pass_word`, `phone`, `sex`, `email`, `address`, `create_date`, `state`) values('duoceshi','zhangshan','123456','138000000','0','duoceshi@126.com','sz','2020-08-20 20:40:15','1');
insert into `sys_user` (`name`, `user_name`, `pass_word`, `phone`, `sex`, `email`, `address`, `create_date`, `state`) values('duoceshi','zhangshan','123456','138000000','1','duoceshi@126.com','sz','2020-08-21 18:15:40','1');
insert into `sys_user` (`name`, `user_name`, `pass_word`, `phone`, `sex`, `email`, `address`, `create_date`, `state`) values('duoceshi','zhangshan','123456','138000000','1','duoceshi@126.com','sz','2020-08-21 18:16:56','1');
insert into `sys_user` (`name`, `user_name`, `pass_word`, `phone`, `sex`, `email`, `address`, `create_date`, `state`) values('duoceshi','zhangshan','123456','138000000'