xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 479KB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發(fā)布日期: 2021-05-13
  • 語言: C/C++
  • 標簽: 王珊??薩師煊??

資源簡介

1、設(shè)計特定的數(shù)據(jù)結(jié)構(gòu)，用于存儲數(shù)據(jù)表、視圖、索引等數(shù)據(jù)庫對象的信息，即建立數(shù)據(jù)庫系統(tǒng)的數(shù)據(jù)字典；（數(shù)據(jù)庫） 2、設(shè)計特定的數(shù)據(jù)結(jié)構(gòu)，用于存儲數(shù)據(jù)表中的數(shù)據(jù)；（數(shù)據(jù)表建立存儲） 3、執(zhí)行CREATE語句，創(chuàng)建數(shù)據(jù)表、視圖、索引等數(shù)據(jù)庫對象；創(chuàng)建數(shù)據(jù)表時需包含主碼、外碼、唯一性約束、非空約束等完整性約束的定義； 4、執(zhí)行SELECT語句，從自主設(shè)計的數(shù)據(jù)表中查詢數(shù)據(jù)，并輸出結(jié)果；在SELECT語句中需要支持GROUP BY、HAVING和ORDER BY子句，需要支持5種聚集函數(shù)； 5、用戶登錄時，需要輸入用戶名；如果用戶沒有被授權(quán)，則拒絕執(zhí)行用戶查詢或更新操作，并給出提示信息；

資源截圖

代碼片段和文件信息 

#include?
#include?
#include?
#include
#include?
#include
#include?
#include?
#include
#include
#include
#include
#include


using?namespace?std;


//數(shù)據(jù)結(jié)構(gòu)的定義放在這里！

struct?Table
{
????string?t_name;//表名
????int?col_num;//列數(shù)
????map?shuxing;//屬性以及相應(yīng)的類型
????string?primary_key;//主碼
????vector?>?data;//具體的元組
????int?yuanzu_num;//元組個數(shù)
????vectorunique1;//唯一約束的屬性
????vectornull;//非空約束的屬性
????vectorcol_primary;//主碼是哪個屬性
????vectoryueshu;//外碼約束
};

struct?View
{
????string?view_name;
????string?as;//查詢語句
};

//數(shù)據(jù)庫的數(shù)據(jù)結(jié)構(gòu)
struct?Database
{
????vector?tablebase;
????vector?viewbase;
};
//權(quán)限的數(shù)據(jù)結(jié)構(gòu)
struct?Authorization
{
????string?user_name;
????vector?table_name;
????int?select_;
????int?insert_;
????int?delete_;
????int?update_;
????int?count_qx;
????int?table_num;
};
//索引的數(shù)據(jù)結(jié)構(gòu)
struct?Indexx
{
????string?index_name;
????string?table_name;
????string?shuxing_name;


};
struct?users
{
????string?username;
????string?password;
};

vector
TABLE;
vectorVIEW;
Database?DATAbase;
vectorAuth;
vectorINDEX;
vectorUSER;

//文件的讀寫在這里！

//表
void?read_table（）
{
????fstream?ioFile;//文件流
????int?numnum1num2;
????string?tmp1tmp2;
????ioFile.open（“table.txt“ios::out）;
????if（ioFile>>num）
????{
????????//TABLE.clear（）;
????????for（int?i?=?0;?i?????????{
????????????Table?t2;
????????????t2.shuxing.clear（）;
????????????ioFile?>>tmp1;
????????????t2.t_name=tmp1;
????????????ioFile>>num1;
????????????t2.col_num=num1;

????????????for（int?j=0;?j????????????{
????????????????ioFile>>tmp1;
????????????????ioFile>>tmp2;
????????????????t2.shuxing.insert（make_pair（tmp1tmp2））;
????????????}
????????????ioFile>>num1;//主碼的屬性
????????????for（int?j=0;?j????????????{
????????????????ioFile>>tmp1;
????????????????t2.col_primary.push_back（tmp1）;
????????????}
????????????ioFile>>num1;//唯一的屬性
????????????for（int?j=0;?j????????????{
????????????????ioFile>>tmp1;
????????????????t2.unique1.push_back（tmp1）;
????????????}
????????????ioFile>>num1;//非空的屬性
????????????for（int?j=0;?j????????????{
????????????????ioFile>>tmp1;
????????????????t2.null.push_back（tmp1）;
????????????}
????????????ioFile>>num1;//外碼約束
????????????for（int?j=0;?j????????????{
????????????????getline（ioFile?tmp1）;

????????????????t2.col_primary.push_back（tmp1）;
????????????}
????????????ioFile>>tmp2;
????????????ioFile>>tmp1;
????????????t2.primary_key=tmp1;
????????????t2.yuanzu_num=0;
????????????TABLE.push_back（t2）;
????????????DATAbase.tablebase=TABLE;
????????}
????}
????ioFile.close（）;
}
void?write_table（）
{
????fstream?ioFile;
????map::iterator?it;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-11-30?21:38??.vscode\
?????文件?????????528??2020-11-24?17:48??.vscode\c_cpp_properties.json
?????文件????????1105??2020-11-24?23:16??.vscode\launch.json
?????文件?????????118??2020-11-30?22:39??.vscode\settings.json
?????文件?????????796??2020-11-24?17:48??.vscode\tasks.json
?????文件?????4253910??2019-07-03?17:59??auth.txt
?????文件????????1698??2017-12-28?13:46??database.cbp
?????文件????????3877??2017-12-29?16:37??database.depend
?????文件?????????927??2017-12-29?18:28??database.layout
?????文件??????????85??2019-07-03?17:56??index.txt
?????文件???????59061??2020-11-30?21:55??main.cpp
?????文件?????1335851??2020-11-30?21:57??main.exe
?????文件??????443760??2019-07-03?17:58??main.o
?????文件???????????0??2020-11-30?22:38??table.txt
?????文件?????????256??2019-07-03?17:56??table_data.txt
?????文件??????????53??2020-11-24?23:01??user.txt
?????文件???????????2??2017-07-06?17:42??view.ads
?????文件??????????63??2019-07-03?17:56??view.txt
?????文件??????155241??2020-11-30?22:40??山東科技大學(xué)C++數(shù)據(jù)庫課程設(shè)計.docx
?????文件????????2365??2020-11-30?22:33??測試數(shù)據(jù).txt
						   

						  
						 

						
						
					    
					   
					   
 
						   
 
							
							
							
 
							 
評論

							 
 
							  
 
							   
 
								 
								 
								 
								 
								 
								

								 
								 
								
 
								 
							    
							  
 
							 
 
							 
 共有  條評論