个人信息管理系统(xaa39)_mysql_oracle代码分享

• 个人信息管理系统mysql数据库创建语句
• 个人信息管理系统oracle数据库创建语句
• 个人信息管理系统sqlserver数据库创建语句
• 个人信息管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 个人信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

个人信息管理系统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 '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	sr varchar(100) comment '生日',
	mz varchar(100) comment '民族',
	xl varchar(100) comment '学历',
	gz varchar(100) comment '工作',
	zz varchar(100) comment '住址',
	yx varchar(100) comment '邮箱'
) comment '用户';

财务表创建语句如下：

create table t_cw(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	cwName varchar(100) comment '消费项目',
	fee int comment '金额',
	showDate datetime comment '消费时间',
	yue int comment '余额',
	remark text comment '备注'
) comment '财务';

日程表创建语句如下：

create table t_rc(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	rcName varchar(100) comment '事件',
	showDate datetime comment '时间',
	dd varchar(100) comment '地点',
	bz text comment '备注'
) comment '日程';

系统通知表创建语句如下：

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	remark text comment '内容',
	insertDate datetime comment '日期'
) comment '系统通知';

通讯录表创建语句如下：

create table t_txl(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	xm varchar(100) comment '姓名',
	lxfs varchar(100) comment '联系方式',
	gzdd varchar(100) comment '工作地点',
	bz text comment '备注',
	tx varchar(100) comment '头像'
) comment '通讯录';

文件表创建语句如下：

create table t_wj(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	wjName varchar(100) comment '文件名称',
	pic varchar(100) comment '文件',
	insertDate datetime 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),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	sr varchar(100),
	mz varchar(100),
	xl varchar(100),
	gz varchar(100),
	zz varchar(100),
	yx 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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '';
comment on column t_customer.sr is '生日';
comment on column t_customer.mz is '民族';
comment on column t_customer.xl is '学历';
comment on column t_customer.gz is '工作';
comment on column t_customer.zz is '住址';
comment on column t_customer.yx is '邮箱';
--用户表加注释
comment on table t_customer is '用户';

财务表创建语句如下：

create table t_cw(
	id integer,
	customerId int,
	cwName varchar(100),
	fee int,
	showDate datetime,
	yue int,
	remark text
);
--财务字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.customerId is '用户';
comment on column t_cw.cwName is '消费项目';
comment on column t_cw.fee is '金额';
comment on column t_cw.showDate is '消费时间';
comment on column t_cw.yue is '余额';
comment on column t_cw.remark is '备注';
--财务表加注释
comment on table t_cw is '财务';

日程表创建语句如下：

create table t_rc(
	id integer,
	customerId int,
	rcName varchar(100),
	showDate datetime,
	dd varchar(100),
	bz text
);
--日程字段加注释
comment on column t_rc.id is '主键';
comment on column t_rc.customerId is '用户';
comment on column t_rc.rcName is '事件';
comment on column t_rc.showDate is '时间';
comment on column t_rc.dd is '地点';
comment on column t_rc.bz is '备注';
--日程表加注释
comment on table t_rc is '日程';

系统通知表创建语句如下：

create table t_tongzhi(
	id integer,
	title varchar(100),
	remark text,
	insertDate datetime
);
--系统通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.remark is '内容';
comment on column t_tongzhi.insertDate is '日期';
--系统通知表加注释
comment on table t_tongzhi is '系统通知';

通讯录表创建语句如下：

create table t_txl(
	id integer,
	customerId int,
	xm varchar(100),
	lxfs varchar(100),
	gzdd varchar(100),
	bz text,
	tx varchar(100)
);
--通讯录字段加注释
comment on column t_txl.id is '主键';
comment on column t_txl.customerId is '用户';
comment on column t_txl.xm is '姓名';
comment on column t_txl.lxfs is '联系方式';
comment on column t_txl.gzdd is '工作地点';
comment on column t_txl.bz is '备注';
comment on column t_txl.tx is '头像';
--通讯录表加注释
comment on table t_txl is '通讯录';

文件表创建语句如下：

create table t_wj(
	id integer,
	customerId int,
	wjName varchar(100),
	pic varchar(100),
	insertDate datetime
);
--文件字段加注释
comment on column t_wj.id is '主键';
comment on column t_wj.customerId is '用户';
comment on column t_wj.wjName is '文件名称';
comment on column t_wj.pic is '文件';
comment on column t_wj.insertDate is '上传日期';
--文件表加注释
comment on table t_wj is '文件';

oracle特有，对应序列如下：

create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_rc;
create sequence s_t_tongzhi;
create sequence s_t_txl;
create sequence s_t_wj;

个人信息管理系统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),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--
	sr varchar(100),--生日
	mz varchar(100),--民族
	xl varchar(100),--学历
	gz varchar(100),--工作
	zz varchar(100),--住址
	yx varchar(100)--邮箱
);

财务表创建语句如下：

--财务表注释
create table t_cw(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	cwName varchar(100),--消费项目
	fee int,--金额
	showDate datetime,--消费时间
	yue int,--余额
	remark text--备注
);

日程表创建语句如下：

--日程表注释
create table t_rc(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	rcName varchar(100),--事件
	showDate datetime,--时间
	dd varchar(100),--地点
	bz text--备注
);

系统通知表创建语句如下：

--系统通知表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	remark text,--内容
	insertDate datetime--日期
);

通讯录表创建语句如下：

--通讯录表注释
create table t_txl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	xm varchar(100),--姓名
	lxfs varchar(100),--联系方式
	gzdd varchar(100),--工作地点
	bz text,--备注
	tx varchar(100)--头像
);

文件表创建语句如下：

--文件表注释
create table t_wj(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	wjName varchar(100),--文件名称
	pic varchar(100),--文件
	insertDate datetime--上传日期
);

个人信息管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//生日
private String sr;
//民族
private String mz;
//学历
private String xl;
//工作
private String gz;
//住址
private String zz;
//邮箱
private String yx;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public String getSr() {return sr;}
public void setSr(String sr) {this.sr = sr;}
public String getMz() {return mz;}
public void setMz(String mz) {this.mz = mz;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getGz() {return gz;}
public void setGz(String gz) {this.gz = gz;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
}

财务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_cw")
public class Cw {
//主键
@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 Long customerId;
//消费项目
private String cwName;
//金额
private Integer fee;
//消费时间
private Date showDate;
//余额
private Integer yue;
//备注
private String remark;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getYue() {return yue;}
public void setYue(Integer yue) {this.yue = yue;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

日程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 Long customerId;
//事件
private String rcName;
//时间
private Date showDate;
//地点
private String dd;
//备注
private String bz;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getRcName() {return rcName;}
public void setRcName(String rcName) {this.rcName = rcName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}

系统通知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 String title;
//内容
private String remark;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Long customerId;
//姓名
private String xm;
//联系方式
private String lxfs;
//工作地点
private String gzdd;
//备注
private String bz;
//头像
private String tx;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
public String getGzdd() {return gzdd;}
public void setGzdd(String gzdd) {this.gzdd = gzdd;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
}

文件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_wj")
public class Wj {
//主键
@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 Long customerId;
//文件名称
private String wjName;
//文件
private String pic;
//上传日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getWjName() {return wjName;}
public void setWjName(String wjName) {this.wjName = wjName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

个人信息管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//生日
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String sr;
//民族
private String mz;
//学历
private String xl;
//工作
private String gz;
//住址
private String zz;
//邮箱
private String yx;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public String getSr() {return sr;}
public void setSr(String sr) {this.sr = sr;}
public String getMz() {return mz;}
public void setMz(String mz) {this.mz = mz;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getGz() {return gz;}
public void setGz(String gz) {this.gz = gz;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
}

财务javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//财务
public class Cw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//消费项目
private String cwName;
//金额
private Integer fee;
//消费时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//余额
private Integer yue;
//备注
private String remark;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getYue() {return yue;}
public void setYue(Integer yue) {this.yue = yue;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

日程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 Long customerId;
//事件
private String rcName;
//时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//地点
private String dd;
//备注
private String bz;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getRcName() {return rcName;}
public void setRcName(String rcName) {this.rcName = rcName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}

系统通知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 String title;
//内容
private String remark;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Long customerId;
//姓名
private String xm;
//联系方式
private String lxfs;
//工作地点
private String gzdd;
//备注
private String bz;
//头像
private String tx;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
public String getGzdd() {return gzdd;}
public void setGzdd(String gzdd) {this.gzdd = gzdd;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
}

文件javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//文件
public class Wj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//文件名称
private String wjName;
//文件
private String pic;
//上传日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getWjName() {return wjName;}
public void setWjName(String wjName) {this.wjName = wjName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}