unit14.dfm

用delphi实现的一个酒店管理系统框架

inherited DM14: TDM14
  Height = 260
  Width = 379
  inherited ADOCommand2: TADOCommand
    CommandText = 
      'Create Table MyUser('#24207#21495' int Identity,'#22995#21517' varchar(10) primary key,'#21475 +
      #20196' varchar(10),'#31561#32423' varchar(2))'#13#10'Insert  MyUser  values('#39#30000#27665#26684#39','#39'888'#39 +
      ','#39'A'#39')'#13#10'Insert  MyUser  values('#39#25805#20316#21592#39','#39'123'#39','#39'G'#39')'#13#10'Insert  MyUser  ' +
      'values('#39#27983#35272#32773#39','#39#39','#39'R'#39')'#13#10'--'#28155#21152#20854#20182#29992#25143#20449#24687#13#10#13#10'Create Table '#29992#25143#31867#22411'('#31867#22411#21517' varcha' +
      'r(10) primary key,'#31561#32423' varchar(2))  -- '#20849#26377#22914#19979#19977#31181#13#10'Insert  '#29992#25143#31867#22411'  value' +
      's('#39#31649#29702#21592#39','#39'A'#39')'#13#10'Insert  '#29992#25143#31867#22411'  values('#39#25805#20316#21592#39','#39'G'#39')'#13#10'Insert  '#29992#25143#31867#22411'  val' +
      'ues('#39#27983#35272#32773#39','#39'R'#39')'#13#10#13#10'create table '#36755#20837#34920'('#32534#21495' int Identity primary key,'#20998 +
      #31867' varchar(12),'#24207#21495' int,'#20869#23481' varchar(20))'#13#10'Insert '#36755#20837#34920' values('#39#27665#26063#39',1,'#39 +
      #27721#26063#39')'#13#10'Insert '#36755#20837#34920' values('#39#27665#26063#39',2,'#39#33945#21476#26063#39')'#13#10'Insert '#36755#20837#34920' values('#39#27665#26063#39',3,' +
      #39#30066#26063#39')'#13#10'Insert '#36755#20837#34920' values('#39#23398#21382#39',1,'#39#30740#31350#29983#39')'#13#10'Insert '#36755#20837#34920' values('#39#23398#21382#39',2' +
      ','#39#26412#31185#39')'#13#10#13#10'use JD'#13#10'create table rooms('#26631#35782' int primary key,'#27004#21495' varch' +
      'ar(10),'#25151#38388#21495' varchar(10),'#27004#23618' varchar(10),'#24202#20301#25968' int,'#31354#24202#25968' int ,'#22791#27880' varcha' +
      'r(200))'#13#10'create table student('#23398#21495' int primary key,'#22995#21517' varchar(10),' +
      #24615#21035' varchar(2),'#38498#31995' varchar(20),'#29677#32423' varchar(10),'#25152#22312#23487#33293#27004#21495' varchar(10),'#25152 +
      #22312#23487#33293#25151#38388#21495' varchar(10))'#13#10'create table Guest('#26631#35782' int primary key,'#26469#35775#20154#22995#21517 +
      ' varchar(10),'#26469#35775#20154#21333#20301' varchar(10),'#27004#21495' varchar(10),'#25151#38388#21495' varchar(10),'#34987#35775 +
      #20154#22995#21517' varchar(10),'#34987#35775#20154#23398#21495' int,'#26469#35775#30331#35760#26085#21069' datetime,'#26159#21542#30331#35760#31163#24320' real,'#31163#24320#26085#21069' datet' +
      'ime)'#13#10'create table Sanitation('#26631#35782' int primary key,'#27004#21495' varchar(10),' +
      #25151#38388#21495' varchar(10),'#35780#27604#26102#38388' datetime,'#22320#38754#38376#31383' varchar(10),'#20070#26550#26700#26885' varchar(10),' +
      #24202#38138' varchar(10),'#24635#20307#24418#35937' varchar(10))'#13#10'create table Mistake('#26631#35782' int pr' +
      'imary key,'#27004#21495' varchar(10),'#25151#38388#21495' varchar(10),'#36829#32426#20154#22995#21517' varchar(10),'#36829#32426#26102#38388' ' +
      'datetime,'#23398#21495' int,'#22788#29702#35828#26126' varchar(200))'#13#10'Insert '#36755#20837#34920' values('#39#23398#21382#39',3,'#39#19987#31185 +
      #39')'#13#10'Insert '#36755#20837#34920' values('#39#23398#21382#39',4,'#39#20013#19987#39')'#13#10'--'#28155#21152#20854#23427#31181#31867#21450#20854#21021#20540#13#10#13#10'create table' +
      ' PCInfo(xh int identity primary key,Pname varchar(30),CpuId varc' +
      'har(11),CpuSp float,'#13#10'IP varchar(20),host varchar(30),mac varcha' +
      'r(30),ds varchar(30),LogTime datetime)'#13#10'--  '#29992#20110#20445#23384#30331#24405#35745#31639#26426#30340'CPU'#21378#21830#21644#31995#21015#21495#21450 +
      #20027#39057#12289#35745#31639#26426'IP'#21644#21517#31216#12289#30828#30424#31995#21015#21495#21644#30331#24405#26102#38388#13#10#13#10'CREATE TABLE '#24403#21069' ('#36719#20214' varchar (10) PRIMA' +
      'RY KEY,'#29256#26412' varchar (52),'#25991#20214' image)  '#13#10#13#10'--'#20197#19979#28155#21152#31649#29702#31995#32479#25152#35201#21019#24314#34920#30340'SQL'#35821#21477#31561#13#10
  end
  inherited ADOConnection2: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security In' +
      'fo=False;Initial Catalog=master;Data Source=.'
  end
end