关于 老年人能力评估 web部分的内容

create database testsystem;
use testsystem;
评估基本信息
create table plan(
number varbinary(8),
date date,
reason text
);
被评者基本信息
create table people(
name text,
sex text,
birthday date,
idnumber varbinary(11),
socialid varbinary(9),
nation text,
education text,
religion text,
marriage text,
reside text,
medical text,
income text,
stupid text,
mental text,
chronic text,
tumble text,
lost text,
dysphoria text,
suicide text,
other text
);
信息提供者及联系人信息
create table informat(
name text,
relation text,
contacts text,
phone text
);
create table user(
idnumber varbinary(11),
password text
); 对于这个项目的建表，其中对于登录是由评估人员还是老年人登录有疑问。这里是有老年人用身份证号登录，自设密码。但是对于这样的建表并不能保证后面的评估能够正常进行。所以接下来的目标是将登录改为评估员并实现评估的各个过程功能。
相关数据表的定义
信息提供者及联系人信息
public class informatdata {
private String name;
private String relation;
private String contacts;
private String phone;

public informatdata(String name, String relation, String contacts, String phone) {
    this.name = name;
    this.relation = relation;
    this.contacts = contacts;
    this.phone = phone;
}

public String getName() {
    return name;
}

public String getRelation() {
    return relation;
}

public String getContacts() {
    return contacts;
}

public String getPhone() {
    return phone;
}

}
被评估人基本信息
import java.sql.Date;
public class peopledata {
private String name;
private String sex;
private Date birthday;
private String idnumber;
private String socialid;
private String nation;//民族
private String education;//文化程度
private String religion;//宗教信仰
private String marriage;//婚姻状况
private String reside;//居住情况
private String medical;//医疗费用开支
private String income;//经济来源
private String stupid;//痴呆
private String mental;//精神疾病
private String chronic;//慢性疾病
private String tumble;//跌倒
private String lost;//走失
private String dysphoria;//噎食
private String suicide;//自杀
private String other;//其他

public peopledata(String name, String sex, Date birthday, String idnumber, String socialid, String nation, String education, String religion, String marriage, String reside, String medical, String income, String stupid, String mental, String chronic, String tumble, String lost, String dysphoria, String suicide, String other) {
    this.name = name;
    this.sex = sex;
    this.birthday = birthday;
    this.idnumber = idnumber;
    this.socialid = socialid;
    this.nation = nation;
    this.education = education;
    this.religion = religion;
    this.marriage = marriage;
    this.reside = reside;
    this.medical = medical;
    this.income = income;
    this.stupid = stupid;
    this.mental = mental;
    this.chronic = chronic;
    this.tumble = tumble;
    this.lost = lost;
    this.dysphoria = dysphoria;
    this.suicide = suicide;
    this.other = other;
}

public String getName() {
    return name;
}

public String getSex() {
    return sex;
}

public Date getBirthday() {
    return birthday;
}

public String getIdnumber() {
    return idnumber;
}

public String getSocialid() {
    return socialid;
}

public String getNation() {
    return nation;
}

public String getEducation() {
    return education;
}

public String getReligion() {
    return religion;
}

public String getMarriage() {
    return marriage;
}

public String getReside() {
    return reside;
}

public String getMedical() {
    return medical;
}

public String getIncome() {
    return income;
}

public String getStupid() {
    return stupid;
}

public String getMental() {
    return mental;
}

public String getTumble() {
    return tumble;
}

public String getChronic() {
    return chronic;
}

public String getLost() {
    return lost;
}

public String getDysphoria() {
    return dysphoria;
}

public String getSuicide() {
    return suicide;
}

public String getOther() {
    return other;
}

}

评估基本信息
import java.sql.Date;
public class plandata {
private String number;
private Date date;
private String reason;

public plandata(String number, Date date, String reason) {
    this.number = number;
    this.date = date;
    this.reason = reason;
}

public Date getDate() {
    return date;
}

public String getNumber() {
    return number;
}

public String getReason() {
    return reason;
}

}