# DBMS 自主数据库原理设计及实现

**Repository Path**: Zerhan99/EricDBMS

## Basic Information

- **Project Name**: DBMS 自主数据库原理设计及实现
- **Description**: 使用C++、面向对象编程、CS结构、Socket连接、完成一个DBMS系统;
- **Primary Language**: C++
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 5
- **Forks**: 0
- **Created**: 2020-07-14
- **Last Updated**: 2026-03-05

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 文件结构说明:  

## DBMS_Client  
为DBMS项目客户端  

## DBMS_Server  
为DBMS服务器  

  

# 项目介绍:   
使用C++、面向对象编程、CS结构、Socket连接、完成一个DBMS系统; 包括内存管理、外存管理、缓存管理、索引、数据字典、SQL解析执行等完整的数据库运行部分.   

 


# 测试语句/用例:  
账号密码在客户端的main.cpp中;   
CREATE SCHEMA db;
CREATE SCHEMA db1;
CREATE SCHEMA db2;

SHOW SCHEMAS;

CREATE TABLE db.students ( Student_Number INT NOT NULL, Name VARCHAR(20) NOT NULL, TeamNum INT NOT NULL, Student_College VARCHAR(45) NOT NULL,Student_Email_Address VARCHAR(45), Phone_Number VARCHAR(20));

USE db;

SHOW TABLES;

SHOW COLUMNS students;

CREATE INDEX ON students(Student_Number);


insert into students values (55171019, '王洪来', 2010882, '软件学院', 'xxx@qq.com', '188xxxx8467');
insert into students values (55171114, '张迩瀚', 2011729, '软件学院', 'xxx@qq.com', '177xxxx9190');  

SELECT * FROM db.students;


SELECT Name,Phone_Number FROM db.students;


SELECT Student_Number,Name,TeamNum,Student_College FROM db.students WHERE TeamNum = 2011729;

SELECT * FROM db.students WHERE Student_Number>55171100;


SELECT * FROM db.students WHERE TeamNum = 2011725;
UPDATE students set TeamNum=2011725 where Student_Number=55171114;
SELECT * FROM db.students WHERE TeamNum = 2011725;

DELETE FROM db.students WHERE TeamNum = 2011725;
SELECT * FROM db.students WHERE Student_Number = 55171114;