Skip to content
This repository has been archived by the owner on Nov 4, 2024. It is now read-only.

Latest commit

 

History

History
174 lines (152 loc) · 5.35 KB

MYDB操作手册.md

File metadata and controls

174 lines (152 loc) · 5.35 KB
title date updated categories tags keywords description
MYDB使用指南
2024-09-09 11:47:00 -0700
2024-09-09 11:47:00 -0700
学习
数据库
数据库
参考innoDB引擎，手写关系型数据库

进入项目路径

cd E:\Projects_Java\Project_xfg\MYDB

编译

mvn compile
E:\Projects_Java\Project_xfg\MYDB-master>mvn compile
[INFO] Scanning for projects...
[INFO] 
[INFO] -------------------------< top.guoziyang:MyDB >-------------------------
[INFO] Building MyDB 1.0-SNAPSHOT                                              
[INFO]   from pom.xml                                                          
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ MyDB ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory E:\Projects_Java\Project_xfg\MYDB-master\src\main\resources
[INFO]
[INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ MyDB ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 65 source files to E:\Projects_Java\Project_xfg\MYDB-master\target\classes
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  1.436 s
[INFO] Finished at: 2024-09-08T12:46:45+08:00
[INFO] ------------------------------------------------------------------------

创建数据库

mkdir E:\Projects_Java\Project_xfg\MYDB-database\mydatabase
mvn exec:java -Dexec.mainClass="top.guoziyang.mydb.backend.Launcher" -Dexec.args="-create E:\Projects_Java\Project_xfg\MYDB-database\mydatabase"
E:\Projects_Java\Project_xfg\MYDB-master>mvn exec:java -Dexec.mainClass="top.guoziyang.mydb.backend.Launcher" -Dexec.args="-create E:\Projects_Java\Project_xfg\tmp\mydb"
[INFO] Scanning for projects...
[INFO] 
[INFO] -------------------------< top.guoziyang:MyDB >-------------------------
[INFO] Building MyDB 1.0-SNAPSHOT
[INFO]   from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- exec-maven-plugin:3.4.1:java (default-cli) @ MyDB ---
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  0.342 s
[INFO] Finished at: 2024-09-08T12:49:07+08:00
[INFO] ------------------------------------------------------------------------

以默认参数启动数据库服务

mvn exec:java -Dexec.mainClass="top.guoziyang.mydb.backend.Launcher" -Dexec.args="-open E:\Projects_Java\Project_xfg\MYDB-database\mydatabase"
E:\Projects_Java\Project_xfg\MYDB-master>mvn exec:java -Dexec.mainClass="top.guoziyang.mydb.backend.Launcher" -Dexec.args="-open E:\Projects_Java\Project_xfg\tmp\mydb"
[INFO] Scanning for projects...
[INFO] 
[INFO] -------------------------< top.guoziyang:MyDB >-------------------------
[INFO] Building MyDB 1.0-SNAPSHOT
[INFO]   from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- exec-maven-plugin:3.4.1:java (default-cli) @ MyDB ---
Server listen to port: 9999
Establish connection: 127.0.0.1:52192
Execute: create table test_table id int32, value int32 (index id)
Execute: insert into test_table values 10 33
Execute: select * from test_table
Execute: begin
Execute: insert into test_table values 20 34
Execute: commit
Execute: select * from test_table
Execute: begin
Execute: delete from test_table where id = 10
Execute: abort
Execute: select * from test_table
Execute: delete from test_table where id = 10
Execute: select * from test_table

新起一个终端，启动客户端连接数据库

mvn exec:java -Dexec.mainClass="top.guoziyang.mydb.client.Launcher"
E:\Projects_Java\Project_xfg\MYDB-master>mvn exec:java -Dexec.mainClass="top.guoziyang.mydb.client.Launcher"
[INFO] Scanning for projects...
[INFO] 
[INFO] -------------------------< top.guoziyang:MyDB >-------------------------
[INFO] Building MyDB 1.0-SNAPSHOT                                              
[INFO]   from pom.xml                                                          
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- exec-maven-plugin:3.4.1:java (default-cli) @ MyDB ---
:>

测试

## 建表
:> create table test id int32, value int32 (index id)
create test_table
## 插入
:> insert into test values 10 33
insert
## 查询
:> select * from test
[10, 33]

# 事务提交
:> begin
begin
:> insert into test values 20 34
insert
:> commit
commit
:> select * from test            
[10, 33]
[20, 34]

## 事务中断
:> begin
begin
:> delete from test where id = 10
delete 1
:> abort
abort
:> select * from test             
[10, 33]
[20, 34]

## 删除
:> delete from test where id = 10
delete 1
:> select * from test
[20, 34]

:> quit