- 基于JSP项目合同管理系统mysql数据库创建语句
- 基于JSP项目合同管理系统oracle数据库创建语句
- 基于JSP项目合同管理系统sqlserver数据库创建语句
- 基于JSP项目合同管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于JSP项目合同管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
【合同拟稿】
3个合同范本选其一，填空，内容可编辑，但不会改变范本。拟稿完成后可以导出合同，合同状态显示（未审核），系统自动弹出列表窗口提示律师审查。
【审查授权】
律师审查：在此页面可显示需要审核的列表，对不合适的条款可用红色指出，给出意见（增加或删除或修改），通过审核后合同状态显示（已审核），生成审查表（审查编号，审查的合同，修改意见，审查人，审查日期），系统自动弹出列表窗口提示董事长授权。
董事长授权：在此页面可显示需要授权的列表，可以查看合同、审查表，指定授权委托人，生成授权委托书，合同状态显示（已授权）
【合同状态】
状态更改：工程部的人可以把合同状态更改为已签署、变更中、补录中、已终止，在改为“变更中”的状态时，点击确定后自动跳转到【合同变更】模块中的变更审批，在改为“补录中”的状态时，点击确定后自动跳转到【合同变更】模块中的补录合同。财务部的人可以把已签署的合同，状态更改为已支付
合同查询：具有指定权限的个人可按合同编号、合同金额、合同状态、签订日期等要素进行查询。查询结果按页显示，显示合同的编号、名称、状态已经签订日期，点击合同编号或合同名称可打开查看该合同。
【合同变更】
变更审批：工程部填写变更申请单（变更编号，合同编号，变更原因，变更内容，申请人，申请日期） 变更原因可以下拉框选择“天气恶劣”，等不可抗逆原因，
需要律师审查通过，董事长批准。
补录合同：工程部填写补录的内容，律师通过即可。
缺陷责任期管理：记录产品、工程缺陷责任期内的重大事件。
【系统设置】
用户管理：可以添加用户；可以为忘记密码的用户初使化密码；可以修改用户所在的权限组；可以设置员工的个人信息（工号，姓名，性别，年龄，所属部门）。
权限管理：可以将每个用户设置到不同的权限组中以保证不同用户具有与其身份相对应的权限。可以自由设置每个权限组的权限，不具备权限的功能用户是不能看到不能使用的。
登录注册界面.jpg?x-oss-process=style/00001)
基于JSP项目合同管理系统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 '姓名',
gh varchar(100) comment '工号',
zw varchar(100) comment '职位',
bm varchar(100) comment '部门',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '住址',
js varchar(100) comment '角色'
) comment '员工';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
合同表创建语句如下：
create table t_ht(
id int primary key auto_increment comment '主键',
customerId int comment '拟定人',
htbh varchar(100) comment '合同编号',
htName varchar(100) comment '合同名称',
fee int comment '金额',
htUrl varchar(100) comment '合同文件',
qdDate varchar(100) comment '签订日期',
status varchar(100) comment '状态',
sqwtr varchar(100) comment '授权委托人',
sqwts varchar(100) comment '授权委托书'
) comment '合同';
变更申请单表创建语句如下：
create table t_htbg(
id int primary key auto_increment comment '主键',
customerId int comment '申请人',
htId int comment '合同',
htbgbh varchar(100) comment '变更编号',
scDate varchar(100) comment '申请日期',
bgFile varchar(100) comment '附件',
v1 varchar(100) comment '变更原因',
v2 varchar(100) comment '变更内容',
status varchar(100) comment '状态'
) comment '变更申请单';
合同补录表创建语句如下：
create table t_htbl(
id int primary key auto_increment comment '主键',
customerId int comment '申请人',
htId int comment '合同',
scDate varchar(100) comment '申请日期',
blFile varchar(100) comment '附件',
v2 varchar(100) comment '补录内容',
status varchar(100) comment '状态'
) comment '合同补录';
缺陷责任期记录表创建语句如下：
create table t_qxzrq(
id int primary key auto_increment comment '主键',
customerId int comment '记录人',
htId int comment '合同',
title varchar(100) comment '记录说明',
scDate varchar(100) comment '日期',
content varchar(100) comment '详细内容'
) comment '缺陷责任期记录';
审查表表创建语句如下：
create table t_scb(
id int primary key auto_increment comment '主键',
customerId int comment '审查人',
htId int comment '合同',
scbh varchar(100) comment '审查编号',
scDate varchar(100) comment '审查日期',
xgyj varchar(100) comment '修改意见'
) comment '审查表';
基于JSP项目合同管理系统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),
gh varchar(100),
zw varchar(100),
bm varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100),
js 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.gh is '工号';
comment on column t_customer.zw is '职位';
comment on column t_customer.bm is '部门';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.address is '住址';
comment on column t_customer.js is '角色';
--员工表加注释
comment on table t_customer is '员工';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.content is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
合同表创建语句如下：
create table t_ht(
id integer,
customerId int,
htbh varchar(100),
htName varchar(100),
fee int,
htUrl varchar(100),
qdDate varchar(100),
status varchar(100),
sqwtr varchar(100),
sqwts varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.customerId is '拟定人';
comment on column t_ht.htbh is '合同编号';
comment on column t_ht.htName is '合同名称';
comment on column t_ht.fee is '金额';
comment on column t_ht.htUrl is '合同文件';
comment on column t_ht.qdDate is '签订日期';
comment on column t_ht.status is '状态';
comment on column t_ht.sqwtr is '授权委托人';
comment on column t_ht.sqwts is '授权委托书';
--合同表加注释
comment on table t_ht is '合同';
变更申请单表创建语句如下：
create table t_htbg(
id integer,
customerId int,
htId int,
htbgbh varchar(100),
scDate varchar(100),
bgFile varchar(100),
v1 varchar(100),
v2 varchar(100),
status varchar(100)
);
--变更申请单字段加注释
comment on column t_htbg.id is '主键';
comment on column t_htbg.customerId is '申请人';
comment on column t_htbg.htId is '合同';
comment on column t_htbg.htbgbh is '变更编号';
comment on column t_htbg.scDate is '申请日期';
comment on column t_htbg.bgFile is '附件';
comment on column t_htbg.v1 is '变更原因';
comment on column t_htbg.v2 is '变更内容';
comment on column t_htbg.status is '状态';
--变更申请单表加注释
comment on table t_htbg is '变更申请单';
合同补录表创建语句如下：
create table t_htbl(
id integer,
customerId int,
htId int,
scDate varchar(100),
blFile varchar(100),
v2 varchar(100),
status varchar(100)
);
--合同补录字段加注释
comment on column t_htbl.id is '主键';
comment on column t_htbl.customerId is '申请人';
comment on column t_htbl.htId is '合同';
comment on column t_htbl.scDate is '申请日期';
comment on column t_htbl.blFile is '附件';
comment on column t_htbl.v2 is '补录内容';
comment on column t_htbl.status is '状态';
--合同补录表加注释
comment on table t_htbl is '合同补录';
缺陷责任期记录表创建语句如下：
create table t_qxzrq(
id integer,
customerId int,
htId int,
title varchar(100),
scDate varchar(100),
content varchar(100)
);
--缺陷责任期记录字段加注释
comment on column t_qxzrq.id is '主键';
comment on column t_qxzrq.customerId is '记录人';
comment on column t_qxzrq.htId is '合同';
comment on column t_qxzrq.title is '记录说明';
comment on column t_qxzrq.scDate is '日期';
comment on column t_qxzrq.content is '详细内容';
--缺陷责任期记录表加注释
comment on table t_qxzrq is '缺陷责任期记录';
审查表表创建语句如下：
create table t_scb(
id integer,
customerId int,
htId int,
scbh varchar(100),
scDate varchar(100),
xgyj varchar(100)
);
--审查表字段加注释
comment on column t_scb.id is '主键';
comment on column t_scb.customerId is '审查人';
comment on column t_scb.htId is '合同';
comment on column t_scb.scbh is '审查编号';
comment on column t_scb.scDate is '审查日期';
comment on column t_scb.xgyj is '修改意见';
--审查表表加注释
comment on table t_scb is '审查表';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_ht;
create sequence s_t_htbg;
create sequence s_t_htbl;
create sequence s_t_qxzrq;
create sequence s_t_scb;
基于JSP项目合同管理系统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),--姓名
gh varchar(100),--工号
zw varchar(100),--职位
bm varchar(100),--部门
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100),--住址
js varchar(100)--角色
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
showDate datetime--日期
);
合同表创建语句如下：
--合同表注释
create table t_ht(
id int identity(1,1) primary key not null,--主键
customerId int,--拟定人
htbh varchar(100),--合同编号
htName varchar(100),--合同名称
fee int,--金额
htUrl varchar(100),--合同文件
qdDate varchar(100),--签订日期
status varchar(100),--状态
sqwtr varchar(100),--授权委托人
sqwts varchar(100)--授权委托书
);
变更申请单表创建语句如下：
--变更申请单表注释
create table t_htbg(
id int identity(1,1) primary key not null,--主键
customerId int,--申请人
htId int,--合同
htbgbh varchar(100),--变更编号
scDate varchar(100),--申请日期
bgFile varchar(100),--附件
v1 varchar(100),--变更原因
v2 varchar(100),--变更内容
status varchar(100)--状态
);
合同补录表创建语句如下：
--合同补录表注释
create table t_htbl(
id int identity(1,1) primary key not null,--主键
customerId int,--申请人
htId int,--合同
scDate varchar(100),--申请日期
blFile varchar(100),--附件
v2 varchar(100),--补录内容
status varchar(100)--状态
);
缺陷责任期记录表创建语句如下：
--缺陷责任期记录表注释
create table t_qxzrq(
id int identity(1,1) primary key not null,--主键
customerId int,--记录人
htId int,--合同
title varchar(100),--记录说明
scDate varchar(100),--日期
content varchar(100)--详细内容
);
审查表表创建语句如下：
--审查表表注释
create table t_scb(
id int identity(1,1) primary key not null,--主键
customerId int,--审查人
htId int,--合同
scbh varchar(100),--审查编号
scDate varchar(100),--审查日期
xgyj varchar(100)--修改意见
);
登录后主页.jpg?x-oss-process=style/00001)
基于JSP项目合同管理系统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 gh;
//职位
private String zw;
//部门
private String bm;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//住址
private String address;
//角色
private String js;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}公告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 title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_ht")
public class Ht {
//主键
@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 htbh;
//合同名称
private String htName;
//金额
private Integer fee;
//合同文件
private String htUrl;
//签订日期
private String qdDate;
//状态
private String status;
//授权委托人
private String sqwtr;
//授权委托书
private String sqwts;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getHtbh() {return htbh;}
public void setHtbh(String htbh) {this.htbh = htbh;}
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getHtUrl() {return htUrl;}
public void setHtUrl(String htUrl) {this.htUrl = htUrl;}
public String getQdDate() {return qdDate;}
public void setQdDate(String qdDate) {this.qdDate = qdDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getSqwtr() {return sqwtr;}
public void setSqwtr(String sqwtr) {this.sqwtr = sqwtr;}
public String getSqwts() {return sqwts;}
public void setSqwts(String sqwts) {this.sqwts = sqwts;}
}变更申请单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_htbg")
public class Htbg {
//主键
@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 Integer htId;
//变更编号
private String htbgbh;
//申请日期
private String scDate;
//附件
private String bgFile;
//变更原因
private String v1;
//变更内容
private String v2;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getHtbgbh() {return htbgbh;}
public void setHtbgbh(String htbgbh) {this.htbgbh = htbgbh;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getBgFile() {return bgFile;}
public void setBgFile(String bgFile) {this.bgFile = bgFile;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}合同补录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_htbl")
public class Htbl {
//主键
@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 Integer htId;
//申请日期
private String scDate;
//附件
private String blFile;
//补录内容
private String v2;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getBlFile() {return blFile;}
public void setBlFile(String blFile) {this.blFile = blFile;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}缺陷责任期记录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_qxzrq")
public class Qxzrq {
//主键
@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 Integer htId;
//记录说明
private String title;
//日期
private String scDate;
//详细内容
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}审查表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_scb")
public class Scb {
//主键
@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 Integer htId;
//审查编号
private String scbh;
//审查日期
private String scDate;
//修改意见
private String xgyj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getScbh() {return scbh;}
public void setScbh(String scbh) {this.scbh = scbh;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getXgyj() {return xgyj;}
public void setXgyj(String xgyj) {this.xgyj = xgyj;}
}基于JSP项目合同管理系统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 gh;
//职位
private String zw;
//部门
private String bm;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//住址
private String address;
//角色
private String js;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}公告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 title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Ht extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//拟定人
private Integer customerId;
//合同编号
private String htbh;
//合同名称
private String htName;
//金额
private Integer fee;
//合同文件
private String htUrl;
//签订日期
private String qdDate;
//状态
private String status;
//授权委托人
private String sqwtr;
//授权委托书
private String sqwts;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getHtbh() {return htbh;}
public void setHtbh(String htbh) {this.htbh = htbh;}
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getHtUrl() {return htUrl;}
public void setHtUrl(String htUrl) {this.htUrl = htUrl;}
public String getQdDate() {return qdDate;}
public void setQdDate(String qdDate) {this.qdDate = qdDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getSqwtr() {return sqwtr;}
public void setSqwtr(String sqwtr) {this.sqwtr = sqwtr;}
public String getSqwts() {return sqwts;}
public void setSqwts(String sqwts) {this.sqwts = sqwts;}
}变更申请单javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//变更申请单
public class Htbg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//申请人
private Integer customerId;
//合同
private Integer htId;
//变更编号
private String htbgbh;
//申请日期
private String scDate;
//附件
private String bgFile;
//变更原因
private String v1;
//变更内容
private String v2;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getHtbgbh() {return htbgbh;}
public void setHtbgbh(String htbgbh) {this.htbgbh = htbgbh;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getBgFile() {return bgFile;}
public void setBgFile(String bgFile) {this.bgFile = bgFile;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}合同补录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//合同补录
public class Htbl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//申请人
private Integer customerId;
//合同
private Integer htId;
//申请日期
private String scDate;
//附件
private String blFile;
//补录内容
private String v2;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getBlFile() {return blFile;}
public void setBlFile(String blFile) {this.blFile = blFile;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}缺陷责任期记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//缺陷责任期记录
public class Qxzrq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//记录人
private Integer customerId;
//合同
private Integer htId;
//记录说明
private String title;
//日期
private String scDate;
//详细内容
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}审查表javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//审查表
public class Scb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//审查人
private Integer customerId;
//合同
private Integer htId;
//审查编号
private String scbh;
//审查日期
private String scDate;
//修改意见
private String xgyj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHtId() {return htId;}
public void setHtId(Integer htId) {this.htId = htId;}
public String getScbh() {return scbh;}
public void setScbh(String scbh) {this.scbh = scbh;}
public String getScDate() {return scDate;}
public void setScDate(String scDate) {this.scDate = scDate;}
public String getXgyj() {return xgyj;}
public void setXgyj(String xgyj) {this.xgyj = xgyj;}
}