Mybatis-03（表字段与实体属性对应）

目录结构

实际练习

• 建立数据库表

//建立orders表并插入三条数据
CREATE TABLE orders{
    order_id INT PRIMARY KEY AUTO_INCREMENT,
		order_no VARCHAR(20),
		order_price FLOAT
};
INSERT INTO orders(order_no,order_price)VALUES('aaa',23
INSERT INTO orders(order_no,order_price)VALUES('bbb',33);
INSERT INTO orders(order_no,order_price)VALUES('ccc',22);

• 建实体类

public class Order {
    private int id;
    private String orderNo;
    private float price;
    
    public int getId() {return id;}
    public void setId(int id) {this.id = id;}
    public String getOrderNo() { return orderNo;}
    public void setOrderNo(String orderNo) {this.orderNo = orderNo;}