- 基于安卓的四级英语学习软件mysql数据库创建语句
- 基于安卓的四级英语学习软件oracle数据库创建语句
- 基于安卓的四级英语学习软件sqlserver数据库创建语句
- 基于安卓的四级英语学习软件spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于安卓的四级英语学习软件spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于安卓的四级英语学习软件mysql数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '超级管理员账号',
password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');
根据发音选答案表创建语句如下：
create table t_a1(
id int primary key auto_increment comment '主键',
fy varchar(100) comment '发音',
v1 varchar(100) comment '中文A',
v2 varchar(100) comment '中文B',
v3 varchar(100) comment '中文C',
v4 varchar(100) comment '中文D',
v5 varchar(100) comment '答案'
) comment '根据发音选答案';
根据中文选答案表创建语句如下：
create table t_a2(
id int primary key auto_increment comment '主键',
zw varchar(100) comment '中文',
v1 varchar(100) comment '英文A',
v2 varchar(100) comment '英文B',
v3 varchar(100) comment '英文C',
v4 varchar(100) comment '英文D',
v5 varchar(100) comment '答案'
) comment '根据中文选答案';
单词翻译表创建语句如下：
create table t_a3(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '中文',
v2 varchar(100) comment '英文'
) comment '单词翻译';
单词背诵表创建语句如下：
create table t_a4(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '单词中文',
v2 varchar(100) comment '音标',
v3 varchar(100) comment '英文拼写',
v4 varchar(100) comment '词性',
v5 varchar(100) comment '中文'
) comment '单词背诵';
单词本表创建语句如下：
create table t_a5(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '单词中文',
v2 varchar(100) comment '单词英文',
customerId int comment '用户'
) comment '单词本';
题目表创建语句如下：
create table t_a6(
id int primary key auto_increment comment '主键',
fy varchar(100) comment '题目',
v1 varchar(100) comment '答案A',
v2 varchar(100) comment '答案B',
v3 varchar(100) comment '答案C',
v4 varchar(100) comment '答案D',
v5 varchar(100) comment '答案'
) comment '题目';
建议表创建语句如下：
create table t_contact(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
phone varchar(100) comment '联系方式',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '建议';
错题本表创建语句如下：
create table t_ctb(
id int primary key auto_increment comment '主键',
a6Id int comment '题目',
customerId int comment '用户',
insertDate datetime comment '日期'
) comment '错题本';
客户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
sex varchar(100) comment '性别',
address varchar(100) comment '地址',
mobile varchar(100) comment '手机'
) comment '客户';
做题日志表创建语句如下：
create table t_log(
id int primary key auto_increment comment '主键',
a6Id int comment '题目',
customerId int comment '用户',
insertDate datetime comment '日期',
types varchar(100) comment '正确还是错误'
) comment '做题日志';
信息交流表创建语句如下：
create table t_message(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
messageContent varchar(100) comment '内容',
types int comment '',
insertDate datetime comment '时间'
) comment '信息交流';
收藏表创建语句如下：
create table t_sc(
id int primary key auto_increment comment '主键',
a6Id int comment '题目',
customerId int comment '用户'
) comment '收藏';
基于安卓的四级英语学习软件oracle数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';
根据发音选答案表创建语句如下：
create table t_a1(
id integer,
fy varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--根据发音选答案字段加注释
comment on column t_a1.id is '主键';
comment on column t_a1.fy is '发音';
comment on column t_a1.v1 is '中文A';
comment on column t_a1.v2 is '中文B';
comment on column t_a1.v3 is '中文C';
comment on column t_a1.v4 is '中文D';
comment on column t_a1.v5 is '答案';
--根据发音选答案表加注释
comment on table t_a1 is '根据发音选答案';
根据中文选答案表创建语句如下：
create table t_a2(
id integer,
zw varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--根据中文选答案字段加注释
comment on column t_a2.id is '主键';
comment on column t_a2.zw is '中文';
comment on column t_a2.v1 is '英文A';
comment on column t_a2.v2 is '英文B';
comment on column t_a2.v3 is '英文C';
comment on column t_a2.v4 is '英文D';
comment on column t_a2.v5 is '答案';
--根据中文选答案表加注释
comment on table t_a2 is '根据中文选答案';
单词翻译表创建语句如下：
create table t_a3(
id integer,
v1 varchar(100),
v2 varchar(100)
);
--单词翻译字段加注释
comment on column t_a3.id is '主键';
comment on column t_a3.v1 is '中文';
comment on column t_a3.v2 is '英文';
--单词翻译表加注释
comment on table t_a3 is '单词翻译';
单词背诵表创建语句如下：
create table t_a4(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--单词背诵字段加注释
comment on column t_a4.id is '主键';
comment on column t_a4.v1 is '单词中文';
comment on column t_a4.v2 is '音标';
comment on column t_a4.v3 is '英文拼写';
comment on column t_a4.v4 is '词性';
comment on column t_a4.v5 is '中文';
--单词背诵表加注释
comment on table t_a4 is '单词背诵';
单词本表创建语句如下：
create table t_a5(
id integer,
v1 varchar(100),
v2 varchar(100),
customerId int
);
--单词本字段加注释
comment on column t_a5.id is '主键';
comment on column t_a5.v1 is '单词中文';
comment on column t_a5.v2 is '单词英文';
comment on column t_a5.customerId is '用户';
--单词本表加注释
comment on table t_a5 is '单词本';
题目表创建语句如下：
create table t_a6(
id integer,
fy varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--题目字段加注释
comment on column t_a6.id is '主键';
comment on column t_a6.fy is '题目';
comment on column t_a6.v1 is '答案A';
comment on column t_a6.v2 is '答案B';
comment on column t_a6.v3 is '答案C';
comment on column t_a6.v4 is '答案D';
comment on column t_a6.v5 is '答案';
--题目表加注释
comment on table t_a6 is '题目';
建议表创建语句如下：
create table t_contact(
id integer,
customerId int,
phone varchar(100),
content varchar(100),
insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.customerId is '用户';
comment on column t_contact.phone is '联系方式';
comment on column t_contact.content is '内容';
comment on column t_contact.insertDate is '日期';
--建议表加注释
comment on table t_contact is '建议';
错题本表创建语句如下：
create table t_ctb(
id integer,
a6Id int,
customerId int,
insertDate datetime
);
--错题本字段加注释
comment on column t_ctb.id is '主键';
comment on column t_ctb.a6Id is '题目';
comment on column t_ctb.customerId is '用户';
comment on column t_ctb.insertDate is '日期';
--错题本表加注释
comment on table t_ctb is '错题本';
客户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
sex varchar(100),
address varchar(100),
mobile varchar(100)
);
--客户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.name is '姓名';
comment on column t_customer.sex is '性别';
comment on column t_customer.address is '地址';
comment on column t_customer.mobile is '手机';
--客户表加注释
comment on table t_customer is '客户';
做题日志表创建语句如下：
create table t_log(
id integer,
a6Id int,
customerId int,
insertDate datetime,
types varchar(100)
);
--做题日志字段加注释
comment on column t_log.id is '主键';
comment on column t_log.a6Id is '题目';
comment on column t_log.customerId is '用户';
comment on column t_log.insertDate is '日期';
comment on column t_log.types is '正确还是错误';
--做题日志表加注释
comment on table t_log is '做题日志';
信息交流表创建语句如下：
create table t_message(
id integer,
customerId int,
messageContent varchar(100),
types int,
insertDate datetime
);
--信息交流字段加注释
comment on column t_message.id is '主键';
comment on column t_message.customerId is '用户';
comment on column t_message.messageContent is '内容';
comment on column t_message.types is '';
comment on column t_message.insertDate is '时间';
--信息交流表加注释
comment on table t_message is '信息交流';
收藏表创建语句如下：
create table t_sc(
id integer,
a6Id int,
customerId int
);
--收藏字段加注释
comment on column t_sc.id is '主键';
comment on column t_sc.a6Id is '题目';
comment on column t_sc.customerId is '用户';
--收藏表加注释
comment on table t_sc is '收藏';
oracle特有，对应序列如下：
create sequence s_t_a1;
create sequence s_t_a2;
create sequence s_t_a3;
create sequence s_t_a4;
create sequence s_t_a5;
create sequence s_t_a6;
create sequence s_t_contact;
create sequence s_t_ctb;
create sequence s_t_customer;
create sequence s_t_log;
create sequence s_t_message;
create sequence s_t_sc;
基于安卓的四级英语学习软件sqlserver数据库版本源码：
超级管理员表创建语句如下：
--超级管理员
create table t_admin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--超级管理员账号
password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');
根据发音选答案表创建语句如下：
--根据发音选答案表注释
create table t_a1(
id int identity(1,1) primary key not null,--主键
fy varchar(100),--发音
v1 varchar(100),--中文A
v2 varchar(100),--中文B
v3 varchar(100),--中文C
v4 varchar(100),--中文D
v5 varchar(100)--答案
);
根据中文选答案表创建语句如下：
--根据中文选答案表注释
create table t_a2(
id int identity(1,1) primary key not null,--主键
zw varchar(100),--中文
v1 varchar(100),--英文A
v2 varchar(100),--英文B
v3 varchar(100),--英文C
v4 varchar(100),--英文D
v5 varchar(100)--答案
);
单词翻译表创建语句如下：
--单词翻译表注释
create table t_a3(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--中文
v2 varchar(100)--英文
);
单词背诵表创建语句如下：
--单词背诵表注释
create table t_a4(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--单词中文
v2 varchar(100),--音标
v3 varchar(100),--英文拼写
v4 varchar(100),--词性
v5 varchar(100)--中文
);
单词本表创建语句如下：
--单词本表注释
create table t_a5(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--单词中文
v2 varchar(100),--单词英文
customerId int--用户
);
题目表创建语句如下：
--题目表注释
create table t_a6(
id int identity(1,1) primary key not null,--主键
fy varchar(100),--题目
v1 varchar(100),--答案A
v2 varchar(100),--答案B
v3 varchar(100),--答案C
v4 varchar(100),--答案D
v5 varchar(100)--答案
);
建议表创建语句如下：
--建议表注释
create table t_contact(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
phone varchar(100),--联系方式
content varchar(100),--内容
insertDate datetime--日期
);
错题本表创建语句如下：
--错题本表注释
create table t_ctb(
id int identity(1,1) primary key not null,--主键
a6Id int,--题目
customerId int,--用户
insertDate datetime--日期
);
客户表创建语句如下：
--客户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
name varchar(100),--姓名
sex varchar(100),--性别
address varchar(100),--地址
mobile varchar(100)--手机
);
做题日志表创建语句如下：
--做题日志表注释
create table t_log(
id int identity(1,1) primary key not null,--主键
a6Id int,--题目
customerId int,--用户
insertDate datetime,--日期
types varchar(100)--正确还是错误
);
信息交流表创建语句如下：
--信息交流表注释
create table t_message(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
messageContent varchar(100),--内容
types int,--
insertDate datetime--时间
);
收藏表创建语句如下：
--收藏表注释
create table t_sc(
id int identity(1,1) primary key not null,--主键
a6Id int,--题目
customerId int--用户
);
登录后主页.jpg?x-oss-process=style/00001)
基于安卓的四级英语学习软件spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
根据发音选答案javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//根据发音选答案
@Table(name = "t_a1")
public class A1 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发音
private String fy;
//中文A
private String v1;
//中文B
private String v2;
//中文C
private String v3;
//中文D
private String v4;
//答案
private String v5;
public String getFy() {return fy;}
public void setFy(String fy) {this.fy = fy;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}根据中文选答案javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//根据中文选答案
@Table(name = "t_a2")
public class A2 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//中文
private String zw;
//英文A
private String v1;
//英文B
private String v2;
//英文C
private String v3;
//英文D
private String v4;
//答案
private String v5;
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}单词翻译javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//单词翻译
@Table(name = "t_a3")
public class A3 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//中文
private String v1;
//英文
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}单词背诵javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//单词背诵
@Table(name = "t_a4")
public class A4 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//单词中文
private String v1;
//音标
private String v2;
//英文拼写
private String v3;
//词性
private String v4;
//中文
private String v5;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}单词本javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//单词本
@Table(name = "t_a5")
public class A5 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//单词中文
private String v1;
//单词英文
private String v2;
//用户
private Integer customerId;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}题目javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//题目
@Table(name = "t_a6")
public class A6 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private String fy;
//答案A
private String v1;
//答案B
private String v2;
//答案C
private String v3;
//答案D
private String v4;
//答案
private String v5;
public String getFy() {return fy;}
public void setFy(String fy) {this.fy = fy;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}建议javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//建议
@Table(name = "t_contact")
public class Contact {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}错题本javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//错题本
@Table(name = "t_ctb")
public class Ctb {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private Integer a6Id;
//用户
private Integer customerId;
//日期
private Date insertDate;
public Integer getA6Id() {return a6Id;}
public void setA6Id(Integer a6Id) {this.a6Id = a6Id;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}客户javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//客户
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String name;
//性别
private String sex;
//地址
private String address;
//手机
private String mobile;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}做题日志javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//做题日志
@Table(name = "t_log")
public class Log {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private Integer a6Id;
//用户
private Integer customerId;
//日期
private Date insertDate;
//正确还是错误
private String types;
public Integer getA6Id() {return a6Id;}
public void setA6Id(Integer a6Id) {this.a6Id = a6Id;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}信息交流javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//信息交流
@Table(name = "t_message")
public class Message {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//内容
private String messageContent;
//
private Integer types;
//时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMessageContent() {return messageContent;}
public void setMessageContent(String messageContent) {this.messageContent = messageContent;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}收藏javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//收藏
@Table(name = "t_sc")
public class Sc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private Integer a6Id;
//用户
private Integer customerId;
public Integer getA6Id() {return a6Id;}
public void setA6Id(Integer a6Id) {this.a6Id = a6Id;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}基于安卓的四级英语学习软件spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
根据发音选答案javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//根据发音选答案
public class A1 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发音
private String fy;
//中文A
private String v1;
//中文B
private String v2;
//中文C
private String v3;
//中文D
private String v4;
//答案
private String v5;
public String getFy() {return fy;}
public void setFy(String fy) {this.fy = fy;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}根据中文选答案javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//根据中文选答案
public class A2 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//中文
private String zw;
//英文A
private String v1;
//英文B
private String v2;
//英文C
private String v3;
//英文D
private String v4;
//答案
private String v5;
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}单词翻译javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//单词翻译
public class A3 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//中文
private String v1;
//英文
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}单词背诵javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//单词背诵
public class A4 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//单词中文
private String v1;
//音标
private String v2;
//英文拼写
private String v3;
//词性
private String v4;
//中文
private String v5;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}单词本javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//单词本
public class A5 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//单词中文
private String v1;
//单词英文
private String v2;
//用户
private Integer customerId;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}题目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//题目
public class A6 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private String fy;
//答案A
private String v1;
//答案B
private String v2;
//答案C
private String v3;
//答案D
private String v4;
//答案
private String v5;
public String getFy() {return fy;}
public void setFy(String fy) {this.fy = fy;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}建议javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//建议
public class Contact extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}错题本javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//错题本
public class Ctb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private Integer a6Id;
//用户
private Integer customerId;
//日期
private Date insertDate;
public Integer getA6Id() {return a6Id;}
public void setA6Id(Integer a6Id) {this.a6Id = a6Id;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}客户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//客户
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String name;
//性别
private String sex;
//地址
private String address;
//手机
private String mobile;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}做题日志javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//做题日志
public class Log extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private Integer a6Id;
//用户
private Integer customerId;
//日期
private Date insertDate;
//正确还是错误
private String types;
public Integer getA6Id() {return a6Id;}
public void setA6Id(Integer a6Id) {this.a6Id = a6Id;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}信息交流javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//信息交流
public class Message extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//内容
private String messageContent;
//
private Integer types;
//时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMessageContent() {return messageContent;}
public void setMessageContent(String messageContent) {this.messageContent = messageContent;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}收藏javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//收藏
public class Sc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//题目
private Integer a6Id;
//用户
private Integer customerId;
public Integer getA6Id() {return a6Id;}
public void setA6Id(Integer a6Id) {this.a6Id = a6Id;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}