- 资产管理系统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_ptadmin(
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 '年龄'
) comment '普通管理员';
小类表创建语句如下：
create table t_types(
id int primary key auto_increment comment '主键',
typesName varchar(100) comment '小类名称'
) comment '小类';
资产表创建语句如下：
create table t_zc(
id int primary key auto_increment comment '主键',
bigtype varchar(100) comment '大类',
typesId int comment '小类',
zcmc varchar(100) comment '资产名称',
zcbh varchar(100) comment '资产编号',
pic varchar(100) comment '图片',
qx varchar(100) comment '使用期限',
gzrq datetime comment '购置日期',
sl varchar(100) comment '数量',
ewm varchar(100) comment '二维码'
) comment '资产';
资产报废表创建语句如下：
create table t_zcbf(
id int primary key auto_increment comment '主键',
zcmc varchar(100) comment '资产名称',
zcbh varchar(100) comment '资产编号',
bfsl varchar(100) comment '报废数量',
fzr varchar(100) comment '负责人',
content varchar(100) comment '详细说明',
bfDate datetime comment '报废日期'
) comment '资产报废';
资产维护表创建语句如下：
create table t_zcwh(
id int primary key auto_increment comment '主键',
zcmc varchar(100) comment '资产名称',
zcbh varchar(100) comment '资产编号',
bfsl varchar(100) comment '维护数量',
fzr varchar(100) comment '负责人',
content varchar(100) comment '维护说明',
bfDate 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_ptadmin(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.customerName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
小类表创建语句如下：
create table t_types(
id integer,
typesName varchar(100)
);
--小类字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '小类名称';
--小类表加注释
comment on table t_types is '小类';
资产表创建语句如下：
create table t_zc(
id integer,
bigtype varchar(100),
typesId int,
zcmc varchar(100),
zcbh varchar(100),
pic varchar(100),
qx varchar(100),
gzrq datetime,
sl varchar(100),
ewm varchar(100)
);
--资产字段加注释
comment on column t_zc.id is '主键';
comment on column t_zc.bigtype is '大类';
comment on column t_zc.typesId is '小类';
comment on column t_zc.zcmc is '资产名称';
comment on column t_zc.zcbh is '资产编号';
comment on column t_zc.pic is '图片';
comment on column t_zc.qx is '使用期限';
comment on column t_zc.gzrq is '购置日期';
comment on column t_zc.sl is '数量';
comment on column t_zc.ewm is '二维码';
--资产表加注释
comment on table t_zc is '资产';
资产报废表创建语句如下：
create table t_zcbf(
id integer,
zcmc varchar(100),
zcbh varchar(100),
bfsl varchar(100),
fzr varchar(100),
content varchar(100),
bfDate datetime
);
--资产报废字段加注释
comment on column t_zcbf.id is '主键';
comment on column t_zcbf.zcmc is '资产名称';
comment on column t_zcbf.zcbh is '资产编号';
comment on column t_zcbf.bfsl is '报废数量';
comment on column t_zcbf.fzr is '负责人';
comment on column t_zcbf.content is '详细说明';
comment on column t_zcbf.bfDate is '报废日期';
--资产报废表加注释
comment on table t_zcbf is '资产报废';
资产维护表创建语句如下：
create table t_zcwh(
id integer,
zcmc varchar(100),
zcbh varchar(100),
bfsl varchar(100),
fzr varchar(100),
content varchar(100),
bfDate datetime
);
--资产维护字段加注释
comment on column t_zcwh.id is '主键';
comment on column t_zcwh.zcmc is '资产名称';
comment on column t_zcwh.zcbh is '资产编号';
comment on column t_zcwh.bfsl is '维护数量';
comment on column t_zcwh.fzr is '负责人';
comment on column t_zcwh.content is '维护说明';
comment on column t_zcwh.bfDate is '维护日期';
--资产维护表加注释
comment on table t_zcwh is '资产维护';
oracle特有，对应序列如下：
create sequence s_t_ptadmin;
create sequence s_t_types;
create sequence s_t_zc;
create sequence s_t_zcbf;
create sequence s_t_zcwh;
资产管理系统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_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100)--年龄
);
小类表创建语句如下：
--小类表注释
create table t_types(
id int identity(1,1) primary key not null,--主键
typesName varchar(100)--小类名称
);
资产表创建语句如下：
--资产表注释
create table t_zc(
id int identity(1,1) primary key not null,--主键
bigtype varchar(100),--大类
typesId int,--小类
zcmc varchar(100),--资产名称
zcbh varchar(100),--资产编号
pic varchar(100),--图片
qx varchar(100),--使用期限
gzrq datetime,--购置日期
sl varchar(100),--数量
ewm varchar(100)--二维码
);
资产报废表创建语句如下：
--资产报废表注释
create table t_zcbf(
id int identity(1,1) primary key not null,--主键
zcmc varchar(100),--资产名称
zcbh varchar(100),--资产编号
bfsl varchar(100),--报废数量
fzr varchar(100),--负责人
content varchar(100),--详细说明
bfDate datetime--报废日期
);
资产维护表创建语句如下：
--资产维护表注释
create table t_zcwh(
id int identity(1,1) primary key not null,--主键
zcmc varchar(100),--资产名称
zcbh varchar(100),--资产编号
bfsl varchar(100),--维护数量
fzr varchar(100),--负责人
content varchar(100),--维护说明
bfDate datetime--维护日期
);
登录后主页.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_ptadmin")
public class Ptadmin {
//主键
@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;
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;}
}小类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_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}资产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_zc")
public class Zc {
//主键
@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 bigtype;
//小类
private Integer typesId;
//资产名称
private String zcmc;
//资产编号
private String zcbh;
//图片
private String pic;
//使用期限
private String qx;
//购置日期
private Date gzrq;
//数量
private String sl;
//二维码
private String ewm;
public String getBigtype() {return bigtype;}
public void setBigtype(String bigtype) {this.bigtype = bigtype;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
public Date getGzrq() {return gzrq;}
public void setGzrq(Date gzrq) {this.gzrq = gzrq;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getEwm() {return ewm;}
public void setEwm(String ewm) {this.ewm = ewm;}
}资产报废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_zcbf")
public class Zcbf {
//主键
@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 zcmc;
//资产编号
private String zcbh;
//报废数量
private String bfsl;
//负责人
private String fzr;
//详细说明
private String content;
//报废日期
private Date bfDate;
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getBfsl() {return bfsl;}
public void setBfsl(String bfsl) {this.bfsl = bfsl;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBfDate() {return bfDate;}
public void setBfDate(Date bfDate) {this.bfDate = bfDate;}
}资产维护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_zcwh")
public class Zcwh {
//主键
@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 zcmc;
//资产编号
private String zcbh;
//维护数量
private String bfsl;
//负责人
private String fzr;
//维护说明
private String content;
//维护日期
private Date bfDate;
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getBfsl() {return bfsl;}
public void setBfsl(String bfsl) {this.bfsl = bfsl;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBfDate() {return bfDate;}
public void setBfDate(Date bfDate) {this.bfDate = bfDate;}
}资产管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Ptadmin 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;
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;}
}小类javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//小类
public class Types extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//小类名称
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}资产javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//资产
public class Zc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//大类
private String bigtype;
//小类
private Integer typesId;
//资产名称
private String zcmc;
//资产编号
private String zcbh;
//图片
private String pic;
//使用期限
private String qx;
//购置日期
private Date gzrq;
//数量
private String sl;
//二维码
private String ewm;
public String getBigtype() {return bigtype;}
public void setBigtype(String bigtype) {this.bigtype = bigtype;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
public Date getGzrq() {return gzrq;}
public void setGzrq(Date gzrq) {this.gzrq = gzrq;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getEwm() {return ewm;}
public void setEwm(String ewm) {this.ewm = ewm;}
}资产报废javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//资产报废
public class Zcbf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资产名称
private String zcmc;
//资产编号
private String zcbh;
//报废数量
private String bfsl;
//负责人
private String fzr;
//详细说明
private String content;
//报废日期
private Date bfDate;
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getBfsl() {return bfsl;}
public void setBfsl(String bfsl) {this.bfsl = bfsl;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBfDate() {return bfDate;}
public void setBfDate(Date bfDate) {this.bfDate = bfDate;}
}资产维护javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//资产维护
public class Zcwh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资产名称
private String zcmc;
//资产编号
private String zcbh;
//维护数量
private String bfsl;
//负责人
private String fzr;
//维护说明
private String content;
//维护日期
private Date bfDate;
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getBfsl() {return bfsl;}
public void setBfsl(String bfsl) {this.bfsl = bfsl;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBfDate() {return bfDate;}
public void setBfDate(Date bfDate) {this.bfDate = bfDate;}
}