银行数据库表的设计.doc

系统需求分析：
在学习了数据库之后，为了更进一步稳固所学知识，将其用于实践，我们选择了银行管理系统，来完成最基本的一些操作。
功能
(1).客户：包括存款，取款，转账，查询余额，查看流水，密码修改这些功能
(2)llect("Crmoney");
CString bid = (LPCTSTR)(_bstr_t)ResultSet->GetCollect("Bid");
CString str4 = (LPCTSTR)(_bstr_t)ResultSet->GetCollect("Cid");
CString str2= str; //将交易前钱数暂存
temp=atof(str);
temp1=(double);

temp+=temp1;
("%f",temp);
CString str3 = str; //暂存交易后金额
sql = "update Custom set Crmoney='"+str+"' "+"where Cname='"+Cname+"'";
((_bstr_t)sql);
sql = "select count(*) num from Operate";
ResultSet = ((_bstr_t)sql);
int num = atoi((LPCTSTR)(_bstr_t)ResultSet->GetCollect("num"));
str = "240600";CString Oid,Cid,Sid,Bid,Otime,Omoney,OAmoney,OBmoney;
("%d",++num); Oid=str+Oid;
Sid="7985001";Bid = bid; double temp2;
sql = "select * from Bank where Bid='"+Bid+"'";
ResultSet = ((_bstr_t)sql);
CString bmoney = (LPCTSTR)(_bstr_t)ResultSet->GetCollect("Bmoney");
temp2 = atof(bmoney); temp2+=temp1; ("%f",temp2);
sql = "update Bank set Bmoney='"+bmoney+"' where Bid='"+Bid+"'";
((_bstr_t)sql);
CString Otype = "存款";CString m_time; CTime time;
time = CTime::GetCurrentTime();
m_time = ("%Y年%m月%d日