网上银行存取与贷款系统
网上银行存取与贷款系统mysql数据库创建语句
网上银行存取与贷款系统oracle数据库创建语句
网上银行存取与贷款系统sqlserver数据库创建语句
网上银行存取与贷款系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
网上银行存取与贷款系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
网上银行存取与贷款系统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’);
SQLCopy
银行卡表创建语句如下:
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 ‘银行卡’;
SQLCopy
银行卡记录表创建语句如下:
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 ‘银行卡记录’;
SQLCopy
用户表创建语句如下:
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 ‘用户’;
SQLCopy
待还款记录表创建语句如下:
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 ‘待还款记录’;
SQLCopy
申请贷款表创建语句如下:
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 ‘申请贷款’;
SQLCopy
网上银行存取与贷款系统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 ‘超级管理员’;
SQLCopy
银行卡表创建语句如下:
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 ‘银行卡’;
SQLCopy
银行卡记录表创建语句如下:
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 ‘银行卡记录’;
SQLCopy
用户表创建语句如下:
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 ‘性别’;
–用户表加注释