- 家庭数据管理系统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_book(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
bookName varchar(100) comment '书籍名称',
zz varchar(100) comment '作者',
lx varchar(100) comment '类型',
showDate datetime comment '购买日期',
content varchar(100) comment '说明内容',
fee varchar(100) comment '金额',
wz varchar(100) comment '位置'
) comment '书籍管理';
用户表创建语句如下：
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_sp(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
spName varchar(100) comment '食谱名称',
pic varchar(100) comment '图片',
showDate datetime comment '上传日期',
content varchar(100) comment '食谱详细',
zy varchar(100) comment '食谱作用'
) comment '食谱管理';
收支管理表创建语句如下：
create table t_sz(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
types varchar(100) comment '类型',
title varchar(100) comment '收支说明',
fee int comment '金额',
showDate datetime comment '日期'
) comment '收支管理';
相册管理表创建语句如下：
create table t_xc(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
xcName varchar(100) comment '标题',
pic varchar(100) comment '图片',
showDate datetime comment '拍照日期',
content varchar(100) 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_book(
id integer,
customerId int,
bookName varchar(100),
zz varchar(100),
lx varchar(100),
showDate datetime,
content varchar(100),
fee varchar(100),
wz varchar(100)
);
--书籍管理字段加注释
comment on column t_book.id is '主键';
comment on column t_book.customerId is '用户';
comment on column t_book.bookName is '书籍名称';
comment on column t_book.zz is '作者';
comment on column t_book.lx is '类型';
comment on column t_book.showDate is '购买日期';
comment on column t_book.content is '说明内容';
comment on column t_book.fee is '金额';
comment on column t_book.wz is '位置';
--书籍管理表加注释
comment on table t_book 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_sp(
id integer,
customerId int,
spName varchar(100),
pic varchar(100),
showDate datetime,
content varchar(100),
zy varchar(100)
);
--食谱管理字段加注释
comment on column t_sp.id is '主键';
comment on column t_sp.customerId is '用户';
comment on column t_sp.spName is '食谱名称';
comment on column t_sp.pic is '图片';
comment on column t_sp.showDate is '上传日期';
comment on column t_sp.content is '食谱详细';
comment on column t_sp.zy is '食谱作用';
--食谱管理表加注释
comment on table t_sp is '食谱管理';
收支管理表创建语句如下：
create table t_sz(
id integer,
customerId int,
types varchar(100),
title varchar(100),
fee int,
showDate datetime
);
--收支管理字段加注释
comment on column t_sz.id is '主键';
comment on column t_sz.customerId is '用户';
comment on column t_sz.types is '类型';
comment on column t_sz.title is '收支说明';
comment on column t_sz.fee is '金额';
comment on column t_sz.showDate is '日期';
--收支管理表加注释
comment on table t_sz is '收支管理';
相册管理表创建语句如下：
create table t_xc(
id integer,
customerId int,
xcName varchar(100),
pic varchar(100),
showDate datetime,
content varchar(100)
);
--相册管理字段加注释
comment on column t_xc.id is '主键';
comment on column t_xc.customerId is '用户';
comment on column t_xc.xcName is '标题';
comment on column t_xc.pic is '图片';
comment on column t_xc.showDate is '拍照日期';
comment on column t_xc.content is '备注';
--相册管理表加注释
comment on table t_xc is '相册管理';
oracle特有，对应序列如下：
create sequence s_t_book;
create sequence s_t_customer;
create sequence s_t_sp;
create sequence s_t_sz;
create sequence s_t_xc;
家庭数据管理系统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_book(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
bookName varchar(100),--书籍名称
zz varchar(100),--作者
lx varchar(100),--类型
showDate datetime,--购买日期
content varchar(100),--说明内容
fee varchar(100),--金额
wz varchar(100)--位置
);
用户表创建语句如下：
--用户表注释
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_sp(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
spName varchar(100),--食谱名称
pic varchar(100),--图片
showDate datetime,--上传日期
content varchar(100),--食谱详细
zy varchar(100)--食谱作用
);
收支管理表创建语句如下：
--收支管理表注释
create table t_sz(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
types varchar(100),--类型
title varchar(100),--收支说明
fee int,--金额
showDate datetime--日期
);
相册管理表创建语句如下：
--相册管理表注释
create table t_xc(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
xcName varchar(100),--标题
pic varchar(100),--图片
showDate datetime,--拍照日期
content varchar(100)--备注
);
登录后主页.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_book")
public class Book {
//主键
@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 bookName;
//作者
private String zz;
//类型
private String lx;
//购买日期
private Date showDate;
//说明内容
private String content;
//金额
private String fee;
//位置
private String wz;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getBookName() {return bookName;}
public void setBookName(String bookName) {this.bookName = bookName;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
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 getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
}用户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_sp")
public class Sp {
//主键
@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 spName;
//图片
private String pic;
//上传日期
private Date showDate;
//食谱详细
private String content;
//食谱作用
private String zy;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}收支管理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_sz")
public class Sz {
//主键
@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 types;
//收支说明
private String title;
//金额
private Integer fee;
//日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}相册管理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_xc")
public class Xc {
//主键
@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 xcName;
//图片
private String pic;
//拍照日期
private Date showDate;
//备注
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getXcName() {return xcName;}
public void setXcName(String xcName) {this.xcName = xcName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
}家庭数据管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
书籍管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//书籍管理
public class Book extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//书籍名称
private String bookName;
//作者
private String zz;
//类型
private String lx;
//购买日期
private Date showDate;
//说明内容
private String content;
//金额
private String fee;
//位置
private String wz;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getBookName() {return bookName;}
public void setBookName(String bookName) {this.bookName = bookName;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
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 getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
}用户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 Sp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//食谱名称
private String spName;
//图片
private String pic;
//上传日期
private Date showDate;
//食谱详细
private String content;
//食谱作用
private String zy;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}收支管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//收支管理
public class Sz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//类型
private String types;
//收支说明
private String title;
//金额
private Integer fee;
//日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}相册管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//相册管理
public class Xc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//标题
private String xcName;
//图片
private String pic;
//拍照日期
private Date showDate;
//备注
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getXcName() {return xcName;}
public void setXcName(String xcName) {this.xcName = xcName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
}