web第五次

idea配置Spring Boot2.7.6、MyBatis Framework、MySQL Driver

在console页面用SQL语句

创建数据库、数据表、实体类user

CREATE TABLE user (  
  id INT AUTO_INCREMENT PRIMARY KEY COMMENT 'ID',  
  username VARCHAR(20) NOT NULL UNIQUE COMMENT '用户名',  
  name VARCHAR(10) NOT NULL COMMENT '姓名',  
  age INT COMMENT '年龄',  
  gender CHAR(1) DEFAULT '女' COMMENT '性别'  
) COMMENT='用户表';

实现查询、更新、添加、删除、修改操作

查询

select _ from _ 

where _ 

更新

......

User.java

package com.itheima.pojo;
 
public class User {
    private Integer id;
    private  String name;
    private Short age;
    private Short gender;
    private String phone;
 
    public User(Integer id, String name, Short age, Short gender, String phone) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.gender = gender;
        this.phone = phone;
    }
 
    public User() {
    }
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
    public String getName() {
        return name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    public Short getAge() {
        return age;
    }
 
    public void setAge(Short age) {
        this.age = age;
    }
 
    public Short getGender() {
        return gender;
    }
 
    public void setGender(Short gender) {
        this.gender = gender;
    }
 
    public String getPhone() {
        return phone;
    }
 
    public void setPhone(String phone) {
        this.phone = phone;
    }
 
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", gender=" + gender +
                ", phone='" + phone + '\'' +
                '}';
    }
}

UserMapper——接口中定义查询，删除，修改，新增操作

@Mapper
public interface UserMapper {

    //查询所有数据
    @Select("select * from user" )
    public List<User> list();
 
    //删除id为#的数据
    @Select("delete from user where id=#{id}")
    public void delete(int id);
 
    //新增一条用户信息
    @Select("insert into user(name, age, gender, phone) values (#{name},#{age},#{gender},#{phone})")
    public void insert(User user);
 
    //修改id为#的用户名
    @Select("update user set name=#{name} where id=#{id}")
    public void update(User user);
 
    //查询id为#的用户信息
    @Select("select * from user where id= #{id} ")
    public User get(int id);
 
}

SpringbootMybatisQuickstartApplicationTest——test测试语句

Poet.java

package com.itheima.pojo;
 
public class Poet {
    private Integer id;
    private String name;
    private String dynasty;
    private String title;
    private String style;
 
    public Poet(Integer id, String name, String dynasty, String title, String style) {
        this.id = id;
        this.name = name;
        this.dynasty = dynasty;
        this.title = title;
        this.style = style;
    }
 
    public Poet() {
    }
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
    public String getName() {
        return name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    public String getDynasty() {
        return dynasty;
    }
 
    public void setDynasty(String dynasty) {
        this.dynasty = dynasty;
    }
 
    public String getTitle() {
        return title;
    }
 
    public void setTitle(String title) {
        this.title = title;
    }
 
    public String getStyle() {
        return style;
    }
 
    public void setStyle(String style) {
        this.style = style;
    }
 
    @Override
    public String toString() {
        return "Poet{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", dynasty='" + dynasty + '\'' +
                ", title='" + title + '\'' +
                ", style='" + style + '\'' +
                '}';
    }
}