使用IDEA的视图来直接创建表的实体类,而不是手写:
顶部设置,打开数据库的视图: View -> Tools Windows -> Database
在对应的表上右键:
生成的表实体:
package com.sample; public class Users { private long id; private String phone; private String nickname; private String personalSign; private String sex; private String realName; private String personalId; private java.sql.Timestamp createTime; private java.sql.Timestamp updateTime; public long getId() { return id; } public void setId(long id) { this.id = id; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getNickname() { return nickname; } public void setNickname(String nickname) { this.nickname = nickname; } public String getPersonalSign() { return personalSign; } public void setPersonalSign(String personalSign) { this.personalSign = personalSign; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getRealName() { return realName; } public void setRealName(String realName) { this.realName = realName; } public String getPersonalId() { return personalId; } public void setPersonalId(String personalId) { this.personalId = personalId; } public java.sql.Timestamp getCreateTime() { return createTime; } public void setCreateTime(java.sql.Timestamp createTime) { this.createTime = createTime; } public java.sql.Timestamp getUpdateTime() { return updateTime; } public void setUpdateTime(java.sql.Timestamp updateTime) { this.updateTime = updateTime; } }
over ...