2024.12.18（SpringBoot知识点总结）

5.1.4 创建user表
在test数据库中创建user表

---

-- Table structure for user

---

DROP TABLE IF EXISTS user;
CREATE TABLE user (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL,
password varchar(50) DEFAULT NULL,
name varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

---

-- Records of user

---

INSERT INTO user VALUES ('1', 'zhangsan', '123', '张三');
INSERT INTO user VALUES ('2', 'lisi', '123', '李四');
5.1.5 创建实体Bean
public class User {
// 主键
private Long id;
// 用户名
private String username;
// 密码
private String password;
// 姓名
private String name;

//此处省略getter和setter方法 .. ..

}
5.1.6 编写Mapper
@Mapper
public interface UserMapper {
public List queryUserList();
}