- 银行账目管理系统mysql数据库创建语句
- 银行账目管理系统oracle数据库创建语句
- 银行账目管理系统sqlserver数据库创建语句
- 银行账目管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 银行账目管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
银行账目管理系统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 '主键',
cardName varchar(100) comment '卡号',
password varchar(100) comment '密码',
xm varchar(100) comment '姓名',
sfz varchar(100) comment '身份证',
age varchar(100) comment '年龄',
phone varchar(100) comment '电话',
ssq varchar(100) comment '省市区',
xxdz varchar(100) comment '详细地址',
fee int comment '余额',
insertDate datetime comment '开户日期',
status varchar(100) comment '状态'
) comment '银行卡';
银行柜员表创建语句如下：
create table t_employee(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
employeeName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
gh varchar(100) comment '工号'
) comment '银行柜员';
流水记录表创建语句如下：
create table t_liushui(
id int primary key auto_increment comment '主键',
cardName varchar(100) comment '卡号',
insertDate datetime comment '日期',
types varchar(100) comment '入账出账',
ff varchar(100) comment '交易类型',
fee int comment '交易金额',
ye int comment '当前余额',
remark varchar(100) comment '备注'
) comment '流水记录';
登录记录表创建语句如下：
create table t_loginlog(
id int primary key auto_increment comment '主键',
employeeId int comment '银行柜员',
insertDate datetime comment '登录日期',
ipaddress varchar(100) comment 'IP地址'
) 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,
cardName varchar(100),
password varchar(100),
xm varchar(100),
sfz varchar(100),
age varchar(100),
phone varchar(100),
ssq varchar(100),
xxdz varchar(100),
fee int,
insertDate datetime,
status varchar(100)
);
--银行卡字段加注释
comment on column t_card.id is '主键';
comment on column t_card.cardName is '卡号';
comment on column t_card.password is '密码';
comment on column t_card.xm is '姓名';
comment on column t_card.sfz is '身份证';
comment on column t_card.age is '年龄';
comment on column t_card.phone is '电话';
comment on column t_card.ssq is '省市区';
comment on column t_card.xxdz is '详细地址';
comment on column t_card.fee is '余额';
comment on column t_card.insertDate is '开户日期';
comment on column t_card.status is '状态';
--银行卡表加注释
comment on table t_card is '银行卡';
银行柜员表创建语句如下：
create table t_employee(
id integer,
username varchar(100),
password varchar(100),
employeeName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
gh varchar(100)
);
--银行柜员字段加注释
comment on column t_employee.id is '主键';
comment on column t_employee.username is '账号';
comment on column t_employee.password is '密码';
comment on column t_employee.employeeName is '姓名';
comment on column t_employee.headPic is '头像';
comment on column t_employee.phone is '电话';
comment on column t_employee.age is '年龄';
comment on column t_employee.sex is '性别';
comment on column t_employee.gh is '工号';
--银行柜员表加注释
comment on table t_employee is '银行柜员';
流水记录表创建语句如下：
create table t_liushui(
id integer,
cardName varchar(100),
insertDate datetime,
types varchar(100),
ff varchar(100),
fee int,
ye int,
remark varchar(100)
);
--流水记录字段加注释
comment on column t_liushui.id is '主键';
comment on column t_liushui.cardName is '卡号';
comment on column t_liushui.insertDate is '日期';
comment on column t_liushui.types is '入账出账';
comment on column t_liushui.ff is '交易类型';
comment on column t_liushui.fee is '交易金额';
comment on column t_liushui.ye is '当前余额';
comment on column t_liushui.remark is '备注';
--流水记录表加注释
comment on table t_liushui is '流水记录';
登录记录表创建语句如下：
create table t_loginlog(
id integer,
employeeId int,
insertDate datetime,
ipaddress varchar(100)
);
--登录记录字段加注释
comment on column t_loginlog.id is '主键';
comment on column t_loginlog.employeeId is '银行柜员';
comment on column t_loginlog.insertDate is '登录日期';
comment on column t_loginlog.ipaddress is 'IP地址';
--登录记录表加注释
comment on table t_loginlog is '登录记录';
oracle特有，对应序列如下：
create sequence s_t_card;
create sequence s_t_employee;
create sequence s_t_liushui;
create sequence s_t_loginlog;
银行账目管理系统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,--主键
cardName varchar(100),--卡号
password varchar(100),--密码
xm varchar(100),--姓名
sfz varchar(100),--身份证
age varchar(100),--年龄
phone varchar(100),--电话
ssq varchar(100),--省市区
xxdz varchar(100),--详细地址
fee int,--余额
insertDate datetime,--开户日期
status varchar(100)--状态
);
银行柜员表创建语句如下：
--银行柜员表注释
create table t_employee(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
employeeName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
gh varchar(100)--工号
);
流水记录表创建语句如下：
--流水记录表注释
create table t_liushui(
id int identity(1,1) primary key not null,--主键
cardName varchar(100),--卡号
insertDate datetime,--日期
types varchar(100),--入账出账
ff varchar(100),--交易类型
fee int,--交易金额
ye int,--当前余额
remark varchar(100)--备注
);
登录记录表创建语句如下：
--登录记录表注释
create table t_loginlog(
id int identity(1,1) primary key not null,--主键
employeeId int,--银行柜员
insertDate datetime,--登录日期
ipaddress varchar(100)--IP地址
);
登录后主页.jpg?x-oss-process=style/00001)
银行账目管理系统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 String cardName;
//密码
private String password;
//姓名
private String xm;
//身份证
private String sfz;
//年龄
private String age;
//电话
private String phone;
//省市区
private String ssq;
//详细地址
private String xxdz;
//余额
private Integer fee;
//开户日期
private Date insertDate;
//状态
private String status;
public String getCardName() {return cardName;}
public void setCardName(String cardName) {this.cardName = cardName;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSsq() {return ssq;}
public void setSsq(String ssq) {this.ssq = ssq;}
public String getXxdz() {return xxdz;}
public void setXxdz(String xxdz) {this.xxdz = xxdz;}
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;}
}银行柜员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_employee")
public class Employee {
//主键
@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 employeeName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
}流水记录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_liushui")
public class Liushui {
//主键
@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 cardName;
//日期
private Date insertDate;
//入账出账
private String types;
//交易类型
private String ff;
//交易金额
private Integer fee;
//当前余额
private Integer ye;
//备注
private String remark;
public String getCardName() {return cardName;}
public void setCardName(String cardName) {this.cardName = cardName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getFf() {return ff;}
public void setFf(String ff) {this.ff = ff;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getYe() {return ye;}
public void setYe(Integer ye) {this.ye = ye;}
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_loginlog")
public class Loginlog {
//主键
@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 employeeId;
//登录日期
private Date insertDate;
//IP地址
private String ipaddress;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getIpaddress() {return ipaddress;}
public void setIpaddress(String ipaddress) {this.ipaddress = ipaddress;}
}银行账目管理系统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 String cardName;
//密码
private String password;
//姓名
private String xm;
//身份证
private String sfz;
//年龄
private String age;
//电话
private String phone;
//省市区
private String ssq;
//详细地址
private String xxdz;
//余额
private Integer fee;
//开户日期
private Date insertDate;
//状态
private String status;
public String getCardName() {return cardName;}
public void setCardName(String cardName) {this.cardName = cardName;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSsq() {return ssq;}
public void setSsq(String ssq) {this.ssq = ssq;}
public String getXxdz() {return xxdz;}
public void setXxdz(String xxdz) {this.xxdz = xxdz;}
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;}
}银行柜员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//银行柜员
public class Employee 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 employeeName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
}流水记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//流水记录
public class Liushui extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//卡号
private String cardName;
//日期
private Date insertDate;
//入账出账
private String types;
//交易类型
private String ff;
//交易金额
private Integer fee;
//当前余额
private Integer ye;
//备注
private String remark;
public String getCardName() {return cardName;}
public void setCardName(String cardName) {this.cardName = cardName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getFf() {return ff;}
public void setFf(String ff) {this.ff = ff;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getYe() {return ye;}
public void setYe(Integer ye) {this.ye = ye;}
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 Loginlog extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//银行柜员
private Integer employeeId;
//登录日期
private Date insertDate;
//IP地址
private String ipaddress;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getIpaddress() {return ipaddress;}
public void setIpaddress(String ipaddress) {this.ipaddress = ipaddress;}
}