Oracle-PLSQL-银行管理系统的简单实现.docVIP

--建数据库、数据表set nocount onuse mastergoif exists(select * from sysdatabases where name=bankDB)drop database bankDBgo create database bankDBon(name=bankDB_data,fileName=D:\temp\bankDB_data.mdf,size=1,filegrowth=15%)log on (name=bankDB_log,fileName=D:\temp\bankDB_log.ldf,size=1,filegrowth=15%)go use bankDBgoif exists(select * from sysobjects where name=userInfo)drop table userInfogo create table userInfo(customerID int identity(1,1) not null,customerName char(10) not null,PID varchar(18) not null,telephone varchar(13) not null,address varchar(50) null)use bankDBgo