4.1 配置Mysql与注册登录模块（上）

1

---

2

点击查看sql代码

 create database kob;
 use kob;
  create table user(id int,username varchar(100),password varchar(100));
mysql> show tables;
+---------------+
| Tables_in_kob |
+---------------+
| user          |
+---------------+
1 row in set (0.00 sec)
 insert into user value(1,'yxc','pyxc');
Query OK, 1 row affected (0.02 sec)
mysql> insert into user values(2,'c','pc');
Query OK, 1 row affected (0.00 sec)

mysql> select * from user where username='c';
+------+----------+----------+
| id   | username | password |
+------+----------+----------+
|    2 | c        | pc       |
+------+----------+----------+
1 row in set (0.00 sec)

3用户新建用户insert into user value(2,'b','pb');

登录查询密码 select * from user where username="b";
4
之后哦就可以在idea界面处理数据库
5下载

6
*pojo,table转为class
*mapper,class的crud转为sql语句
*service,执行业务
*Controller,前端调用给service
所以pojo,mapper,mysql就是model,service,Controller就是views
7pojo的user变量最好用包装类Integer,不用int
8@Data@NoArgsConstructor@AllArgsConstructor
有什么用,运行只后,我们就可以看见帮我们自动生成
9.controller.user;
@RequestMapping映射前端的所有类型,get,post, @GetMapping("/user/all/")//接收get返回所有用户,更精准
用到数据库 就要加@Authorized,UserMapper userMapper;//使用接口
@Authorized这个是mybits帮我们实现的 ,例如return userMapper.selectList(null);//返回所有用户
10
11 List一个list就是一行数据
后面就跳转到我的gitee
https://gitee.com/fanhao000/kob-backend/blob/master/README.md