更多成品,定做java毕业设计,请咨询管理员qq:2812491287

预算管理系统

预算管理系统登录注册界面

预算管理系统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_bm(
	id int primary key auto_increment comment '主键',
	bmName 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 '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	bmId int comment '部门'
) comment '员工';

预算科目表创建语句如下:


create table t_yskm(
	id int primary key auto_increment comment '主键',
	yskmName varchar(100) comment '预算科目'
) comment '预算科目';

预算类别表创建语句如下:


create table t_yslb(
	id int primary key auto_increment comment '主键',
	yslbName varchar(100) comment '预算类别'
) comment '预算类别';

预算申报表创建语句如下:


create table t_yssb(
	id int primary key auto_increment comment '主键',
	bmId int comment '部门',
	customerId int comment '员工',
	yslbId int comment '预算类别',
	yskmId int comment '预算科目',
	v1 varchar(100) comment '申报项目名称',
	content varchar(100) comment '内容说明',
	fileUrl varchar(100) comment '附件',
	fee int comment '金额',
	insertDate datetime comment '发起日期',
	status varchar(100) comment '状态',
	shDate datetime comment '审核日期',
	bakc varchar(100) comment '审核内容'
) comment '预算申报';

总经理表创建语句如下:


create table t_zjl(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	zjlName varchar(100) comment '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex 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_bm(
	id integer,
	bmName varchar(100)
);
--部门字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bmName is '部门';
--部门表加注释
comment on table t_bm 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),
	bmId int
);
--员工字段加注释
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.bmId is '部门';
--员工表加注释
comment on table t_customer is '员工';

预算科目表创建语句如下:


create table t_yskm(
	id integer,
	yskmName varchar(100)
);
--预算科目字段加注释
comment on column t_yskm.id is '主键';
comment on column t_yskm.yskmName is '预算科目';
--预算科目表加注释
comment on table t_yskm is '预算科目';

预算类别表创建语句如下:


create table t_yslb(
	id integer,
	yslbName varchar(100)
);
--预算类别字段加注释
comment on column t_yslb.id is '主键';
comment on column t_yslb.yslbName is '预算类别';
--预算类别表加注释
comment on table t_yslb is '预算类别';

预算申报表创建语句如下:


create table t_yssb(
	id integer,
	bmId int,
	customerId int,
	yslbId int,
	yskmId int,
	v1 varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	fee int,
	insertDate datetime,
	status varchar(100),
	shDate datetime,
	bakc varchar(100)
);
--预算申报字段加注释
comment on column t_yssb.id is '主键';
comment on column t_yssb.bmId is '部门';
comment on column t_yssb.customerId is '员工';
comment on column t_yssb.yslbId is '预算类别';
comment on column t_yssb.yskmId is '预算科目';
comment on column t_yssb.v1 is '申报项目名称';
comment on column t_yssb.content is '内容说明';
comment on column t_yssb.fileUrl is '附件';
comment on column t_yssb.fee is '金额';
comment on column t_yssb.insertDate is '发起日期';
comment on column t_yssb.status is '状态';
comment on column t_yssb.shDate is '审核日期';
comment on column t_yssb.bakc is '审核内容';
--预算申报表加注释
comment on table t_yssb is '预算申报';

总经理表创建语句如下:


create table t_zjl(
	id integer,
	username varchar(100),
	password varchar(100),
	zjlName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--总经理字段加注释
comment on column t_zjl.id is '主键';
comment on column t_zjl.username is '账号';
comment on column t_zjl.password is '密码';
comment on column t_zjl.zjlName is '姓名';
comment on column t_zjl.headPic is '头像';
comment on column t_zjl.phone is '电话';
comment on column t_zjl.age is '年龄';
comment on column t_zjl.sex is '性别';
--总经理表加注释
comment on table t_zjl is '总经理';

oracle特有,对应序列如下:


create sequence s_t_bm;
create sequence s_t_customer;
create sequence s_t_yskm;
create sequence s_t_yslb;
create sequence s_t_yssb;
create sequence s_t_zjl;

预算管理系统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_bm(
	id int identity(1,1) primary key not null,--主键
	bmName varchar(100)--部门
);

员工表创建语句如下:


--员工表注释
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),--性别
	bmId int--部门
);

预算科目表创建语句如下:


--预算科目表注释
create table t_yskm(
	id int identity(1,1) primary key not null,--主键
	yskmName varchar(100)--预算科目
);

预算类别表创建语句如下:


--预算类别表注释
create table t_yslb(
	id int identity(1,1) primary key not null,--主键
	yslbName varchar(100)--预算类别
);

预算申报表创建语句如下:


--预算申报表注释
create table t_yssb(
	id int identity(1,1) primary key not null,--主键
	bmId int,--部门
	customerId int,--员工
	yslbId int,--预算类别
	yskmId int,--预算科目
	v1 varchar(100),--申报项目名称
	content varchar(100),--内容说明
	fileUrl varchar(100),--附件
	fee int,--金额
	insertDate datetime,--发起日期
	status varchar(100),--状态
	shDate datetime,--审核日期
	bakc varchar(100)--审核内容
);

总经理表创建语句如下:


--总经理表注释
create table t_zjl(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	zjlName varchar(100),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--性别
);

预算管理系统登录后主页

预算管理系统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_bm")
public class Bm {
//主键
@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 bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}

员工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 Integer bmId;
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 Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
}

预算科目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_yskm")
public class Yskm {
//主键
@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 yskmName;
public String getYskmName() {return yskmName;}
public void setYskmName(String yskmName) {this.yskmName = yskmName;}
}

预算类别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_yslb")
public class Yslb {
//主键
@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 yslbName;
public String getYslbName() {return yslbName;}
public void setYslbName(String yslbName) {this.yslbName = yslbName;}
}

预算申报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_yssb")
public class Yssb {
//主键
@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 bmId;
//员工
private Integer customerId;
//预算类别
private Integer yslbId;
//预算科目
private Integer yskmId;
//申报项目名称
private String v1;
//内容说明
private String content;
//附件
private String fileUrl;
//金额
private Integer fee;
//发起日期
private Date insertDate;
//状态
private String status;
//审核日期
private Date shDate;
//审核内容
private String bakc;
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYslbId() {return yslbId;}
public void setYslbId(Integer yslbId) {this.yslbId = yslbId;}
public Integer getYskmId() {return yskmId;}
public void setYskmId(Integer yskmId) {this.yskmId = yskmId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getShDate() {return shDate;}
public void setShDate(Date shDate) {this.shDate = shDate;}
public String getBakc() {return bakc;}
public void setBakc(String bakc) {this.bakc = bakc;}
}

总经理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_zjl")
public class Zjl {
//主键
@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 zjlName;
//头像
private String headPic;
//电话
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 getZjlName() {return zjlName;}
public void setZjlName(String zjlName) {this.zjlName = zjlName;}
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;}
}

预算管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

部门javaBean创建语句如下:


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

//部门
public class Bm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}

员工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;
//部门
private Integer bmId;
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 Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
}

预算科目javaBean创建语句如下:


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

//预算科目
public class Yskm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预算科目
private String yskmName;
public String getYskmName() {return yskmName;}
public void setYskmName(String yskmName) {this.yskmName = yskmName;}
}

预算类别javaBean创建语句如下:


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

//预算类别
public class Yslb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预算类别
private String yslbName;
public String getYslbName() {return yslbName;}
public void setYslbName(String yslbName) {this.yslbName = yslbName;}
}

预算申报javaBean创建语句如下:


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

//预算申报
public class Yssb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private Integer bmId;
//员工
private Integer customerId;
//预算类别
private Integer yslbId;
//预算科目
private Integer yskmId;
//申报项目名称
private String v1;
//内容说明
private String content;
//附件
private String fileUrl;
//金额
private Integer fee;
//发起日期
private Date insertDate;
//状态
private String status;
//审核日期
private Date shDate;
//审核内容
private String bakc;
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYslbId() {return yslbId;}
public void setYslbId(Integer yslbId) {this.yslbId = yslbId;}
public Integer getYskmId() {return yskmId;}
public void setYskmId(Integer yskmId) {this.yskmId = yskmId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getShDate() {return shDate;}
public void setShDate(Date shDate) {this.shDate = shDate;}
public String getBakc() {return bakc;}
public void setBakc(String bakc) {this.bakc = bakc;}
}

总经理javaBean创建语句如下:


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

//总经理
public class Zjl  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 zjlName;
//头像
private String headPic;
//电话
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 getZjlName() {return zjlName;}
public void setZjlName(String zjlName) {this.zjlName = zjlName;}
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;}
}

评论