给丫头学习打卡开发的系统

最新推荐文章于 2021-08-04 23:43:11 发布

weixin_34232744

最新推荐文章于 2021-08-04 23:43:11 发布

阅读量126

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/qianjinyan/p/10895719.html

博客展示了学习打卡系统的数据库操作代码，包括创建buser、btype、bcontent等表，进行数据的增删改查操作，如插入、更新、查询记录，还涉及日期格式转换等操作，为学习打卡系统的数据库管理提供了实现方案。

DROP TABLE IF EXISTS `buser`;
CREATE TABLE `buser`  (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `userid` varchar(40) NULL DEFAULT NULL,
  `password` varchar(400)  NULL DEFAULT NULL,
  `mobile` varchar(50)  NULL DEFAULT NULL,
  `role` varchar(100)  NULL DEFAULT NULL,
  `creationdt` datetime(0) NOT NULL,
  `updatedt` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  ROW_FORMAT = Dynamic;
 
 
DROP TABLE IF EXISTS `btype`;
CREATE TABLE `btype`  (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NULL DEFAULT NULL,
  `cid` int(4) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  ROW_FORMAT = Dynamic;
 
 
DROP TABLE IF EXISTS `bcontent`;
CREATE TABLE `bcontent`  (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `tid` int(4) NOT NULL,
    `uid` int(4) NOT NULL,
  `time` datetime(0) NOT NULL,
  `description` varchar(50)  NULL DEFAULT NULL,
  `details` varchar(400)  NULL DEFAULT NULL,
  `creationdt` datetime(0) NOT NULL,
  `updatedt` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  ROW_FORMAT = Dynamic;
 
 
 
select * from buser;
select id,name from btype where cid =1;
 
 
select id,tid,uid,time ,description,details,creationdt,updatedt from bcontent;
 
insert bcontent(tid,uid,time ,description,details,creationdt,updatedt)
values(1,1,now(),'大学','大学之道在明明德',now(),now())
 
 
 
 
update bcontent set tid = #{tid},description = #{desc},details = #{details},updatedt = #{tasknum,jdbcType=LONGVARCHAR}
where id = #{id}
 
 
        INSERT INTO BBUG
(BUG_PROJECT_ID,BUG_CR_TYPE_ID,BUG_CR_NUM,BUG_TASK_NUM,BUG_TYPE_ID,
BUG_DESCRIPTION,BUG_RCA,BUG_SOLUTION,BUG_ASSIGNEE_ID,BUG_TESTER_ID,
BUG_CREATIONDT,BUG_UPDATEDT,BUG_STATUS_ID,BUG_CREATIONUID,BUG_UPDATEUID)
VALUES (4, 2, #{crnum,jdbcType=LONGVARCHAR}, #{tasknum,jdbcType=LONGVARCHAR}, 4,
 #{description,jdbcType=LONGVARCHAR},  #{rca,jdbcType=LONGVARCHAR},  #{solution,jdbcType=LONGVARCHAR}, 3, 8,
#{creationdt,jdbcType=LONGVARCHAR}, #{updatedt,jdbcType=LONGVARCHAR}, 1,#{creationuid,jdbcType=LONGVARCHAR},#{updateuid,jdbcType=LONGVARCHAR});
     
 
select * from bcontent;
select FROM_UNIXTIME(time,'%Y年%m月%d') from bcontent
 
SELECT  FROM_UNIXTIME('time', '%Y-%m-%d %H:%i:%s')   FROM bcontent
 
 
select str_to_date(time, '%Y.%m.%d %h:%i:%s') FROM bcontent; --输出空
select str_to_date(time, '%m.%d.%Y %h:%i:%s') as time  FROM bcontent; --输出'2008-08-09 08:09:30'
 
 
SELECT FROM_UNIXTIME(1542470399,'%Y年%m月%d日');   输出结果为2018-11-17
 
 
 
SELECT DATE_FORMAT(time,'%Y年%m月%d日') as time from bcontent;
 
 
insert btype(name,cid) values('儿歌',1);
insert btype(name,cid) values('古诗',1);
insert btype(name,cid) values('歌曲',1);
insert btype(name,cid) values('体育',1);
insert btype(name,cid) values('英语',1);
insert btype(name,cid) values('数学',1);
insert btype(name,cid) values('舞蹈',1);
insert btype(name,cid) values('画画',1);
 
desc buser;
desc bcontent;
 
 
select count(*) from buser where userid =
select * from buser;
 
 
select id,userid,password, mobile,role from buser where userid  = 'admin'
 
update buser set role = 'ROLE_ADMIN,ROLE_USER'
 
 
insert buser(userid,password,mobile,role,creationdt,updatedt)
values('admin','$2a$10$iwc36dEXMLLiTzoq71XZbeCzhOd5OyKDDvEsT3i3Mi73EUhdt4VsK','','ROLE_ADMIN',now(),now())

转载于:https://www.cnblogs.com/qianjinyan/p/10895719.html