更多成品,定做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_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 '性别',
	province varchar(100) comment '省',
	city varchar(100) comment '市',
	area varchar(100) comment '区',
	address varchar(100) comment '详细地址'
) comment '客户';

贷款表创建语句如下:


create table t_dk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	orderNum varchar(100) comment '贷款编号',
	v1 varchar(100) comment '贷款额度',
	v2 varchar(100) comment '还款方式',
	v3 varchar(100) comment '抵押担保',
	v4 varchar(100) comment '有关资料',
	v5 datetime comment '借款时间',
	v6 datetime comment '还款时间',
	status varchar(100) comment '状态',
	back varchar(100) comment '反馈'
) comment '贷款';

开户销户表创建语句如下:


create table t_kxh(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sfz varchar(100) comment '身份证',
	phone varchar(100) comment '手机号',
	account varchar(100) comment '银行账号',
	types varchar(100) comment '类型',
	insertDate datetime comment '日期',
	status varchar(100) comment '状态',
	back varchar(100) comment '反馈'
) comment '开户销户';

延长还款申请表创建语句如下:


create table t_ychk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	orderNum varchar(100) comment '贷款编号',
	content varchar(100) comment '延长还款说明',
	v varchar(100) comment '申请延长还款时间点',
	status varchar(100) comment '状态',
	back varchar(100) comment '反馈'
) comment '延长还款申请';

员工表创建语句如下:


create table t_yg(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ygName 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	province varchar(100),
	city varchar(100),
	area varchar(100),
	address 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.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.province is '省';
comment on column t_customer.city is '市';
comment on column t_customer.area is '区';
comment on column t_customer.address is '详细地址';
--客户表加注释
comment on table t_customer is '客户';

贷款表创建语句如下:


create table t_dk(
	id integer,
	customerId int,
	orderNum varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 datetime,
	v6 datetime,
	status varchar(100),
	back varchar(100)
);
--贷款字段加注释
comment on column t_dk.id is '主键';
comment on column t_dk.customerId is '用户';
comment on column t_dk.orderNum 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.v4 is '有关资料';
comment on column t_dk.v5 is '借款时间';
comment on column t_dk.v6 is '还款时间';
comment on column t_dk.status is '状态';
comment on column t_dk.back is '反馈';
--贷款表加注释
comment on table t_dk is '贷款';

开户销户表创建语句如下:


create table t_kxh(
	id integer,
	customerId int,
	sfz varchar(100),
	phone varchar(100),
	account varchar(100),
	types varchar(100),
	insertDate datetime,
	status varchar(100),
	back varchar(100)
);
--开户销户字段加注释
comment on column t_kxh.id is '主键';
comment on column t_kxh.customerId is '用户';
comment on column t_kxh.sfz is '身份证';
comment on column t_kxh.phone is '手机号';
comment on column t_kxh.account is '银行账号';
comment on column t_kxh.types is '类型';
comment on column t_kxh.insertDate is '日期';
comment on column t_kxh.status is '状态';
comment on column t_kxh.back is '反馈';
--开户销户表加注释
comment on table t_kxh is '开户销户';

延长还款申请表创建语句如下:


create table t_ychk(
	id integer,
	customerId int,
	orderNum varchar(100),
	content varchar(100),
	v varchar(100),
	status varchar(100),
	back varchar(100)
);
--延长还款申请字段加注释
comment on column t_ychk.id is '主键';
comment on column t_ychk.customerId is '用户';
comment on column t_ychk.orderNum is '贷款编号';
comment on column t_ychk.content is '延长还款说明';
comment on column t_ychk.v is '申请延长还款时间点';
comment on column t_ychk.status is '状态';
comment on column t_ychk.back is '反馈';
--延长还款申请表加注释
comment on table t_ychk is '延长还款申请';

员工表创建语句如下:


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

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_dk;
create sequence s_t_kxh;
create sequence s_t_ychk;
create sequence s_t_yg;

乡镇农户评级系统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),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	province varchar(100),--省
	city varchar(100),--市
	area varchar(100),--区
	address varchar(100)--详细地址
);

贷款表创建语句如下:


--贷款表注释
create table t_dk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	orderNum varchar(100),--贷款编号
	v1 varchar(100),--贷款额度
	v2 varchar(100),--还款方式
	v3 varchar(100),--抵押担保
	v4 varchar(100),--有关资料
	v5 datetime,--借款时间
	v6 datetime,--还款时间
	status varchar(100),--状态
	back varchar(100)--反馈
);

开户销户表创建语句如下:


--开户销户表注释
create table t_kxh(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sfz varchar(100),--身份证
	phone varchar(100),--手机号
	account varchar(100),--银行账号
	types varchar(100),--类型
	insertDate datetime,--日期
	status varchar(100),--状态
	back varchar(100)--反馈
);

延长还款申请表创建语句如下:


--延长还款申请表注释
create table t_ychk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	orderNum varchar(100),--贷款编号
	content varchar(100),--延长还款说明
	v varchar(100),--申请延长还款时间点
	status varchar(100),--状态
	back varchar(100)--反馈
);

员工表创建语句如下:


--员工表注释
create table t_yg(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ygName 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_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 String province;
//市
private String city;
//区
private String area;
//详细地址
private String address;
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 String getProvince() {return province;}
public void setProvince(String province) {this.province = province;}
public String getCity() {return city;}
public void setCity(String city) {this.city = city;}
public String getArea() {return area;}
public void setArea(String area) {this.area = area;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

贷款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 orderNum;
//贷款额度
private String v1;
//还款方式
private String v2;
//抵押担保
private String v3;
//有关资料
private String v4;
//借款时间
private Date v5;
//还款时间
private Date v6;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
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 getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Date getV5() {return v5;}
public void setV5(Date v5) {this.v5 = v5;}
public Date getV6() {return v6;}
public void setV6(Date v6) {this.v6 = v6;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

开户销户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_kxh")
public class Kxh {
//主键
@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 sfz;
//手机号
private String phone;
//银行账号
private String account;
//类型
private String types;
//日期
private Date insertDate;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAccount() {return account;}
public void setAccount(String account) {this.account = account;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

延长还款申请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_ychk")
public class Ychk {
//主键
@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 orderNum;
//延长还款说明
private String content;
//申请延长还款时间点
private String v;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getV() {return v;}
public void setV(String v) {this.v = v;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

员工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_yg")
public class Yg {
//主键
@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 ygName;
//头像
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 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 String province;
//市
private String city;
//区
private String area;
//详细地址
private String address;
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 String getProvince() {return province;}
public void setProvince(String province) {this.province = province;}
public String getCity() {return city;}
public void setCity(String city) {this.city = city;}
public String getArea() {return area;}
public void setArea(String area) {this.area = area;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

贷款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 orderNum;
//贷款额度
private String v1;
//还款方式
private String v2;
//抵押担保
private String v3;
//有关资料
private String v4;
//借款时间
private Date v5;
//还款时间
private Date v6;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
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 getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Date getV5() {return v5;}
public void setV5(Date v5) {this.v5 = v5;}
public Date getV6() {return v6;}
public void setV6(Date v6) {this.v6 = v6;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

开户销户javaBean创建语句如下:


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

//开户销户
public class Kxh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//身份证
private String sfz;
//手机号
private String phone;
//银行账号
private String account;
//类型
private String types;
//日期
private Date insertDate;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAccount() {return account;}
public void setAccount(String account) {this.account = account;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

延长还款申请javaBean创建语句如下:


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

//延长还款申请
public class Ychk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//贷款编号
private String orderNum;
//延长还款说明
private String content;
//申请延长还款时间点
private String v;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getV() {return v;}
public void setV(String v) {this.v = v;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

员工javaBean创建语句如下:


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

//员工
public class Yg  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 ygName;
//头像
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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;}
}

评论