Java Spring框架JDBC详解教程
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'