基于SSH的企业债权管理,基于java的毕业设计

基于SSH的企业债权管理登录注册界面

基于SSH的企业债权管理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_csh(
	id int primary key auto_increment comment '主键',
	customerId int comment '客户',
	v1 varchar(100) comment '催收函类型',
	v2 varchar(100) comment '是否收到',
	v3 varchar(100) comment '跟进备注',
	status varchar(100) comment '状态',
	userId int comment '处理人'
) comment '催收函';

客户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账户',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	ywdbr varchar(100) comment '有无担保人',
	zc varchar(100) comment '资产',
	fz varchar(100) comment '负债',
	ywzv varchar(100) comment '有无子女',
	dwxz varchar(100) comment '单位性质',
	v1 int comment '年龄分数',
	v2 int comment '有无有无担保人分数',
	v3 int comment '资产分数',
	v4 int comment '负债分数',
	v5 int comment '有无子女分数',
	v6 int comment '单位性质分数',
	v7 int comment '总评分'
) comment '客户';

贷款表创建语句如下:


create table t_dk(
	id int primary key auto_increment comment '主键',
	customerId int comment '客户',
	v1 varchar(100) comment '信用评级分数',
	v2 varchar(100) comment '等级',
	v3 int comment '贷款金额',
	status varchar(100) comment '状态',
	userId int comment '处理人'
) comment '贷款';

普通管理员表创建语句如下:


create table t_user(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账户',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄'
) comment '普通管理员';

基于SSH的企业债权管理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_csh(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	status varchar(100),
	userId int
);
--催收函字段加注释
comment on column t_csh.id is '主键';
comment on column t_csh.customerId is '客户';
comment on column t_csh.v1 is '催收函类型';
comment on column t_csh.v2 is '是否收到';
comment on column t_csh.v3 is '跟进备注';
comment on column t_csh.status is '状态';
comment on column t_csh.userId is '处理人';
--催收函表加注释
comment on table t_csh is '催收函';

客户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100),
	ywdbr varchar(100),
	zc varchar(100),
	fz varchar(100),
	ywzv varchar(100),
	dwxz varchar(100),
	v1 int,
	v2 int,
	v3 int,
	v4 int,
	v5 int,
	v6 int,
	v7 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.name is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.ywdbr is '有无担保人';
comment on column t_customer.zc is '资产';
comment on column t_customer.fz is '负债';
comment on column t_customer.ywzv is '有无子女';
comment on column t_customer.dwxz is '单位性质';
comment on column t_customer.v1 is '年龄分数';
comment on column t_customer.v2 is '有无有无担保人分数';
comment on column t_customer.v3 is '资产分数';
comment on column t_customer.v4 is '负债分数';
comment on column t_customer.v5 is '有无子女分数';
comment on column t_customer.v6 is '单位性质分数';
comment on column t_customer.v7 is '总评分';
--客户表加注释
comment on table t_customer is '客户';

贷款表创建语句如下:


create table t_dk(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 int,
	status varchar(100),
	userId int
);
--贷款字段加注释
comment on column t_dk.id is '主键';
comment on column t_dk.customerId is '客户';
comment on column t_dk.v1 is '信用评级分数';
comment on column t_dk.v2 is '等级';
comment on column t_dk.v3 is '贷款金额';
comment on column t_dk.status is '状态';
comment on column t_dk.userId is '处理人';
--贷款表加注释
comment on table t_dk is '贷款';

普通管理员表创建语句如下:


create table t_user(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100)
);
--普通管理员字段加注释
comment on column t_user.id is '主键';
comment on column t_user.username is '账户';
comment on column t_user.password is '密码';
comment on column t_user.name is '姓名';
comment on column t_user.phone is '电话';
comment on column t_user.sex is '性别';
comment on column t_user.age is '年龄';
--普通管理员表加注释
comment on table t_user is '普通管理员';

oracle特有,对应序列如下:


create sequence s_t_csh;
create sequence s_t_customer;
create sequence s_t_dk;
create sequence s_t_user;

基于SSH的企业债权管理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_csh(
	id int identity(1,1) primary key not null,--主键
	customerId int,--客户
	v1 varchar(100),--催收函类型
	v2 varchar(100),--是否收到
	v3 varchar(100),--跟进备注
	status varchar(100),--状态
	userId int--处理人
);

客户表创建语句如下:


--客户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账户
	password varchar(100),--密码
	name varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--性别
	age varchar(100),--年龄
	ywdbr varchar(100),--有无担保人
	zc varchar(100),--资产
	fz varchar(100),--负债
	ywzv varchar(100),--有无子女
	dwxz varchar(100),--单位性质
	v1 int,--年龄分数
	v2 int,--有无有无担保人分数
	v3 int,--资产分数
	v4 int,--负债分数
	v5 int,--有无子女分数
	v6 int,--单位性质分数
	v7 int--总评分
);

贷款表创建语句如下:


--贷款表注释
create table t_dk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--客户
	v1 varchar(100),--信用评级分数
	v2 varchar(100),--等级
	v3 int,--贷款金额
	status varchar(100),--状态
	userId int--处理人
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_user(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账户
	password varchar(100),--密码
	name varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--性别
	age varchar(100)--年龄
);

基于SSH的企业债权管理登录后主页

基于SSH的企业债权管理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_csh")
public class Csh {
//主键
@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 v1;
//是否收到
private String v2;
//跟进备注
private String v3;
//状态
private String status;
//处理人
private Integer userId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
}

客户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 name;
//电话
private String phone;
//性别
private String sex;
//年龄
private String age;
//有无担保人
private String ywdbr;
//资产
private String zc;
//负债
private String fz;
//有无子女
private String ywzv;
//单位性质
private String dwxz;
//年龄分数
private Integer v1;
//有无有无担保人分数
private Integer v2;
//资产分数
private Integer v3;
//负债分数
private Integer v4;
//有无子女分数
private Integer v5;
//单位性质分数
private Integer v6;
//总评分
private Integer v7;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getYwdbr() {return ywdbr;}
public void setYwdbr(String ywdbr) {this.ywdbr = ywdbr;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getFz() {return fz;}
public void setFz(String fz) {this.fz = fz;}
public String getYwzv() {return ywzv;}
public void setYwzv(String ywzv) {this.ywzv = ywzv;}
public String getDwxz() {return dwxz;}
public void setDwxz(String dwxz) {this.dwxz = dwxz;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public Integer getV6() {return v6;}
public void setV6(Integer v6) {this.v6 = v6;}
public Integer getV7() {return v7;}
public void setV7(Integer v7) {this.v7 = v7;}
}

贷款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_dk")
public class Dk {
//主键
@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 v1;
//等级
private String v2;
//贷款金额
private Integer v3;
//状态
private String status;
//处理人
private Integer userId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
}

普通管理员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_user")
public class User {
//主键
@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 name;
//电话
private String phone;
//性别
private String sex;
//年龄
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
}

基于SSH的企业债权管理spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

催收函javaBean创建语句如下:


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

//催收函
public class Csh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户
private Integer customerId;
//催收函类型
private String v1;
//是否收到
private String v2;
//跟进备注
private String v3;
//状态
private String status;
//处理人
private Integer userId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
}

客户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 name;
//电话
private String phone;
//性别
private String sex;
//年龄
private String age;
//有无担保人
private String ywdbr;
//资产
private String zc;
//负债
private String fz;
//有无子女
private String ywzv;
//单位性质
private String dwxz;
//年龄分数
private Integer v1;
//有无有无担保人分数
private Integer v2;
//资产分数
private Integer v3;
//负债分数
private Integer v4;
//有无子女分数
private Integer v5;
//单位性质分数
private Integer v6;
//总评分
private Integer v7;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getYwdbr() {return ywdbr;}
public void setYwdbr(String ywdbr) {this.ywdbr = ywdbr;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getFz() {return fz;}
public void setFz(String fz) {this.fz = fz;}
public String getYwzv() {return ywzv;}
public void setYwzv(String ywzv) {this.ywzv = ywzv;}
public String getDwxz() {return dwxz;}
public void setDwxz(String dwxz) {this.dwxz = dwxz;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public Integer getV6() {return v6;}
public void setV6(Integer v6) {this.v6 = v6;}
public Integer getV7() {return v7;}
public void setV7(Integer v7) {this.v7 = v7;}
}

贷款javaBean创建语句如下:


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

//贷款
public class Dk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户
private Integer customerId;
//信用评级分数
private String v1;
//等级
private String v2;
//贷款金额
private Integer v3;
//状态
private String status;
//处理人
private Integer userId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
}

普通管理员javaBean创建语句如下:


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

//普通管理员
public class User  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 name;
//电话
private String phone;
//性别
private String sex;
//年龄
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
}

源代码下载点这里

评论