更多成品,定做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_card(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	cardNum varchar(100) comment '卡号',
	password varchar(100) comment '密码',
	fee int comment '余额',
	status varchar(100) comment '状态'
) comment '银行卡';

银行卡记录表创建语句如下:


create table t_cardlog(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	cardNum varchar(100) comment '卡号',
	num int comment '金额',
	types varchar(100) comment '收入或支出',
	insertDate datetime comment '日期',
	remark 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 '真实姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	email varchar(100) comment '邮箱',
	sfz varchar(100) comment '身份证',
	sex varchar(100) comment '性别'
) comment '用户';

待还款记录表创建语句如下:


create table t_dhk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	cardNum varchar(100) comment '卡号',
	sqdkIId int comment '贷款合同',
	hkje int comment '还款本金',
	lx int comment '利息',
	ze int comment '还款总额',
	zhrq varchar(100) comment '最后还款日期',
	status varchar(100) comment '状态'
) comment '待还款记录';

申请贷款表创建语句如下:


create table t_sqdk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	cardNum varchar(100) comment '卡号',
	num int comment '贷款金额',
	cp varchar(100) comment '申请贷款产品',
	v1 varchar(100) comment '婚姻状况',
	v2 varchar(100) comment '家庭收入',
	v3 varchar(100) comment '家庭地址',
	remark varchar(100) comment '备注',
	status 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_card(
	id integer,
	customerId int,
	cardNum varchar(100),
	password varchar(100),
	fee int,
	status varchar(100)
);
--银行卡字段加注释
comment on column t_card.id is '主键';
comment on column t_card.customerId is '用户';
comment on column t_card.cardNum is '卡号';
comment on column t_card.password is '密码';
comment on column t_card.fee is '余额';
comment on column t_card.status is '状态';
--银行卡表加注释
comment on table t_card is '银行卡';

银行卡记录表创建语句如下:


create table t_cardlog(
	id integer,
	customerId int,
	cardNum varchar(100),
	num int,
	types varchar(100),
	insertDate datetime,
	remark varchar(100)
);
--银行卡记录字段加注释
comment on column t_cardlog.id is '主键';
comment on column t_cardlog.customerId is '用户';
comment on column t_cardlog.cardNum is '卡号';
comment on column t_cardlog.num is '金额';
comment on column t_cardlog.types is '收入或支出';
comment on column t_cardlog.insertDate is '日期';
comment on column t_cardlog.remark is '备注';
--银行卡记录表加注释
comment on table t_cardlog is '银行卡记录';

用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	email varchar(100),
	sfz varchar(100),
	sex 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.email is '邮箱';
comment on column t_customer.sfz is '身份证';
comment on column t_customer.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';

待还款记录表创建语句如下:


create table t_dhk(
	id integer,
	customerId int,
	cardNum varchar(100),
	sqdkIId int,
	hkje int,
	lx int,
	ze int,
	zhrq varchar(100),
	status varchar(100)
);
--待还款记录字段加注释
comment on column t_dhk.id is '主键';
comment on column t_dhk.customerId is '用户';
comment on column t_dhk.cardNum is '卡号';
comment on column t_dhk.sqdkIId is '贷款合同';
comment on column t_dhk.hkje is '还款本金';
comment on column t_dhk.lx is '利息';
comment on column t_dhk.ze is '还款总额';
comment on column t_dhk.zhrq is '最后还款日期';
comment on column t_dhk.status is '状态';
--待还款记录表加注释
comment on table t_dhk is '待还款记录';

申请贷款表创建语句如下:


create table t_sqdk(
	id integer,
	customerId int,
	cardNum varchar(100),
	num int,
	cp varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	remark varchar(100),
	status varchar(100)
);
--申请贷款字段加注释
comment on column t_sqdk.id is '主键';
comment on column t_sqdk.customerId is '用户';
comment on column t_sqdk.cardNum is '卡号';
comment on column t_sqdk.num is '贷款金额';
comment on column t_sqdk.cp is '申请贷款产品';
comment on column t_sqdk.v1 is '婚姻状况';
comment on column t_sqdk.v2 is '家庭收入';
comment on column t_sqdk.v3 is '家庭地址';
comment on column t_sqdk.remark is '备注';
comment on column t_sqdk.status is '状态';
--申请贷款表加注释
comment on table t_sqdk is '申请贷款';

oracle特有,对应序列如下:


create sequence s_t_card;
create sequence s_t_cardlog;
create sequence s_t_customer;
create sequence s_t_dhk;
create sequence s_t_sqdk;

网上银行存取与贷款系统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_card(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	cardNum varchar(100),--卡号
	password varchar(100),--密码
	fee int,--余额
	status varchar(100)--状态
);

银行卡记录表创建语句如下:


--银行卡记录表注释
create table t_cardlog(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	cardNum varchar(100),--卡号
	num int,--金额
	types varchar(100),--收入或支出
	insertDate datetime,--日期
	remark varchar(100)--备注
);

用户表创建语句如下:


--用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--真实姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	email varchar(100),--邮箱
	sfz varchar(100),--身份证
	sex varchar(100)--性别
);

待还款记录表创建语句如下:


--待还款记录表注释
create table t_dhk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	cardNum varchar(100),--卡号
	sqdkIId int,--贷款合同
	hkje int,--还款本金
	lx int,--利息
	ze int,--还款总额
	zhrq varchar(100),--最后还款日期
	status varchar(100)--状态
);

申请贷款表创建语句如下:


--申请贷款表注释
create table t_sqdk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	cardNum varchar(100),--卡号
	num int,--贷款金额
	cp varchar(100),--申请贷款产品
	v1 varchar(100),--婚姻状况
	v2 varchar(100),--家庭收入
	v3 varchar(100),--家庭地址
	remark varchar(100),--备注
	status 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_card")
public class Card {
//主键
@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 cardNum;
//密码
private String password;
//余额
private Integer fee;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_cardlog")
public class Cardlog {
//主键
@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 cardNum;
//金额
private Integer num;
//收入或支出
private String types;
//日期
private Date insertDate;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

用户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 phone;
//年龄
private String age;
//邮箱
private String email;
//身份证
private String sfz;
//性别
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 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;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}

待还款记录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_dhk")
public class Dhk {
//主键
@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 cardNum;
//贷款合同
private Integer sqdkIId;
//还款本金
private Integer hkje;
//利息
private Integer lx;
//还款总额
private Integer ze;
//最后还款日期
private String zhrq;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getSqdkIId() {return sqdkIId;}
public void setSqdkIId(Integer sqdkIId) {this.sqdkIId = sqdkIId;}
public Integer getHkje() {return hkje;}
public void setHkje(Integer hkje) {this.hkje = hkje;}
public Integer getLx() {return lx;}
public void setLx(Integer lx) {this.lx = lx;}
public Integer getZe() {return ze;}
public void setZe(Integer ze) {this.ze = ze;}
public String getZhrq() {return zhrq;}
public void setZhrq(String zhrq) {this.zhrq = zhrq;}
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_sqdk")
public class Sqdk {
//主键
@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 cardNum;
//贷款金额
private Integer num;
//申请贷款产品
private String cp;
//婚姻状况
private String v1;
//家庭收入
private String v2;
//家庭地址
private String v3;
//备注
private String remark;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

网上银行存取与贷款系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

银行卡javaBean创建语句如下:


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

//银行卡
public class Card  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//密码
private String password;
//余额
private Integer fee;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Cardlog  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//金额
private Integer num;
//收入或支出
private String types;
//日期
private Date insertDate;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

用户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 phone;
//年龄
private String age;
//邮箱
private String email;
//身份证
private String sfz;
//性别
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 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;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}

待还款记录javaBean创建语句如下:


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

//待还款记录
public class Dhk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//贷款合同
private Integer sqdkIId;
//还款本金
private Integer hkje;
//利息
private Integer lx;
//还款总额
private Integer ze;
//最后还款日期
private String zhrq;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getSqdkIId() {return sqdkIId;}
public void setSqdkIId(Integer sqdkIId) {this.sqdkIId = sqdkIId;}
public Integer getHkje() {return hkje;}
public void setHkje(Integer hkje) {this.hkje = hkje;}
public Integer getLx() {return lx;}
public void setLx(Integer lx) {this.lx = lx;}
public Integer getZe() {return ze;}
public void setZe(Integer ze) {this.ze = ze;}
public String getZhrq() {return zhrq;}
public void setZhrq(String zhrq) {this.zhrq = zhrq;}
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 Sqdk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//卡号
private String cardNum;
//贷款金额
private Integer num;
//申请贷款产品
private String cp;
//婚姻状况
private String v1;
//家庭收入
private String v2;
//家庭地址
private String v3;
//备注
private String remark;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCardNum() {return cardNum;}
public void setCardNum(String cardNum) {this.cardNum = cardNum;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

评论