Java Student 实体类和数据库表创建 - 完整指南

以下是Java代码实现：

public class Student {
    private Long id;
    private String sname;
    private int sage;
    private String address;
    
    // 构造方法
    public Student(Long id, String sname, int sage, String address) {
        this.id = id;
        this.sname = sname;
        this.sage = sage;
        this.address = address;
    }
    
    // getter和setter方法
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public int getSage() {
        return sage;
    }

    public void setSage(int sage) {
        this.sage = sage;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

创建相应的数据库表可以使用下面的SQL语句：

CREATE TABLE student (
  id BIGINT NOT NULL PRIMARY KEY,
  sname VARCHAR(50) NOT NULL,
  sage INT NOT NULL,
  address VARCHAR(100) NOT NULL
);

该SQL语句创建了一个名为'student'的表，包含四列：id、sname、sage和address。id是主键，类型为BIGINT；sname和address是字符串类型，长度分别为50和100；sage是整数类型。