- 校友通信录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_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '用户';
分组表创建语句如下：
create table t_fz(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
fzName varchar(100) comment '分组'
) comment '分组';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
日程安排表创建语句如下：
create table t_rc(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
showDate datetime comment '日程时间',
content varchar(100) comment '内容',
fileUrl varchar(100) comment '附件'
) comment '日程安排';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
txName varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '通知';
通讯信息表创建语句如下：
create table t_txl(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
v1 varchar(100) comment '姓名',
phone1 varchar(100) comment '电话1',
phone2 varchar(100) comment '电话2',
address varchar(100) comment '地址',
yx varchar(100) comment '邮箱',
qq varchar(100) comment 'qq',
fzId 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex 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.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';
分组表创建语句如下：
create table t_fz(
id integer,
customerId int,
fzName varchar(100)
);
--分组字段加注释
comment on column t_fz.id is '主键';
comment on column t_fz.customerId is '用户';
comment on column t_fz.fzName is '分组';
--分组表加注释
comment on table t_fz is '分组';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
日程安排表创建语句如下：
create table t_rc(
id integer,
customerId int,
title varchar(100),
showDate datetime,
content varchar(100),
fileUrl varchar(100)
);
--日程安排字段加注释
comment on column t_rc.id is '主键';
comment on column t_rc.customerId is '用户';
comment on column t_rc.title is '标题';
comment on column t_rc.showDate is '日程时间';
comment on column t_rc.content is '内容';
comment on column t_rc.fileUrl is '附件';
--日程安排表加注释
comment on table t_rc is '日程安排';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
txName varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.txName is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
通讯信息表创建语句如下：
create table t_txl(
id integer,
customerId int,
v1 varchar(100),
phone1 varchar(100),
phone2 varchar(100),
address varchar(100),
yx varchar(100),
qq varchar(100),
fzId int
);
--通讯信息字段加注释
comment on column t_txl.id is '主键';
comment on column t_txl.customerId is '用户';
comment on column t_txl.v1 is '姓名';
comment on column t_txl.phone1 is '电话1';
comment on column t_txl.phone2 is '电话2';
comment on column t_txl.address is '地址';
comment on column t_txl.yx is '邮箱';
comment on column t_txl.qq is 'qq';
comment on column t_txl.fzId is '分组';
--通讯信息表加注释
comment on table t_txl is '通讯信息';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_fz;
create sequence s_t_gg;
create sequence s_t_rc;
create sequence s_t_tongzhi;
create sequence s_t_txl;
校友通信录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_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
分组表创建语句如下：
--分组表注释
create table t_fz(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
fzName varchar(100)--分组
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
showDate datetime,--日期
v3 varchar(100)--内容
);
日程安排表创建语句如下：
--日程安排表注释
create table t_rc(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
showDate datetime,--日程时间
content varchar(100),--内容
fileUrl varchar(100)--附件
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
txName varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
通讯信息表创建语句如下：
--通讯信息表注释
create table t_txl(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
v1 varchar(100),--姓名
phone1 varchar(100),--电话1
phone2 varchar(100),--电话2
address varchar(100),--地址
yx varchar(100),--邮箱
qq varchar(100),--qq
fzId 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_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 customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}分组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_fz")
public class Fz {
//主键
@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 fzName;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getFzName() {return fzName;}
public void setFzName(String fzName) {this.fzName = fzName;}
}公告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_gg")
public class Gg {
//主键
@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 Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}日程安排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_rc")
public class Rc {
//主键
@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 title;
//日程时间
private Date showDate;
//内容
private String content;
//附件
private String fileUrl;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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_txl")
public class Txl {
//主键
@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 v1;
//电话1
private String phone1;
//电话2
private String phone2;
//地址
private String address;
//邮箱
private String yx;
//qq
private String qq;
//分组
private Integer fzId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPhone1() {return phone1;}
public void setPhone1(String phone1) {this.phone1 = phone1;}
public String getPhone2() {return phone2;}
public void setPhone2(String phone2) {this.phone2 = phone2;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public Integer getFzId() {return fzId;}
public void setFzId(Integer fzId) {this.fzId = fzId;}
}校友通信录spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
用户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 customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}分组javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//分组
public class Fz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//分组
private String fzName;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getFzName() {return fzName;}
public void setFzName(String fzName) {this.fzName = fzName;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}日程安排javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//日程安排
public class Rc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//标题
private String title;
//日程时间
private Date showDate;
//内容
private String content;
//附件
private String fileUrl;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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 Txl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//姓名
private String v1;
//电话1
private String phone1;
//电话2
private String phone2;
//地址
private String address;
//邮箱
private String yx;
//qq
private String qq;
//分组
private Integer fzId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPhone1() {return phone1;}
public void setPhone1(String phone1) {this.phone1 = phone1;}
public String getPhone2() {return phone2;}
public void setPhone2(String phone2) {this.phone2 = phone2;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public Integer getFzId() {return fzId;}
public void setFzId(Integer fzId) {this.fzId = fzId;}
}