文件名称:jdbc写的模拟银行转账系统
文件大小:8KB
文件格式:RAR
更新时间:2017-08-19 08:46:37
java mysql
create table bank ( bankId int primary key auto_increment, bankname varchar(13), bankareaId int, foreign key(bankareaId)references bankarea(bankareaId) ); insert into bank values(1,'中国农业银行',1),(2,'交通银行',2); ,(3,'中国农业银行',2),(4,'交通银行',1); create table bankarea ( bankareaId int primary key auto_increment, bankareaname varchar(20) ); insert into bankarea values(1,'南宁'),(2,'北京'); create table user( userId int primary key auto_increment, username varchar(13), bankId int, usermoney double, foreign key(bankId)references bank(bankId) ); insert into user values(1,'小明',1,100),(2,'张三',2,0);
【文件预览】:
aaaa
----bin()
--------bankproject()
--------newfile.sql(1KB)
----.settings()
--------org.eclipse.jdt.core.prefs(635B)
----src()
--------bankproject()
--------newfile.sql(1KB)
----.project(380B)
----.classpath(374B)