cub

module

• code block：./cub/README.md
• PATH ：./jdk1.8/
• The cub script is automatically pushed to git ：./gitsync.sh

contribution

fork the repository to your local

clone：

git clone https://github.com/c-ub/cub.git 

add origin：

cd cub

You need to update frequently：

git pull origin main 

branch？main : master

• main：The main propulsion module
• master：Test module, last year's record, no javaspring

push？

1. The normal way

   git add .
   git commit -s -m "You-commits"
   git push origin main
   

2. You can choose the script （💡 recommendations）

   gitsync.sh You-commits

   You need an sh environment and just run it

   

MySQL

⚡ 导入sql

数据库名称：create 数据库编码 utf8mb4

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ps
-- ----------------------------
DROP TABLE IF EXISTS `ps`;
CREATE TABLE `ps`  (
  `paddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学校校长的账户地址',
  `saddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学校的智能合约地址',
  PRIMARY KEY (`paddress`, `saddress`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ps

-- ----------------------------
INSERT INTO `ps` VALUES ('0x7Fa0CD079dFe44F3659b1A0fB4ad3c22aae8280F', '0x63F988E17982C155a1Ff96c6490Ac00dA411CCb2');

-- ----------------------------
-- Table structure for sc
-- ----------------------------
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc`  (
  `saddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学生账号的地址',
  `caddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学生对应合约账号的地址',
  PRIMARY KEY (`saddress`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sc
-- ----------------------------
INSERT INTO `sc` VALUES ('0xc2a7324d5340aF9dB8de298Cf3f96295B24ca988', '0x958CE095AC459485Ed26a38fd904F011979643D0');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `snumber` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学号',
  `sname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
  `mail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`snumber`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tc
-- ----------------------------
DROP TABLE IF EXISTS `tc`;
CREATE TABLE `tc`  (
  `taddress` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '教师的区块链节点地址',
  `caddress` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '教师对应的智能合约的区块链地址',
  PRIMARY KEY (`taddress`, `caddress`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学号或者工号',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `identify` int(11) NULL DEFAULT NULL COMMENT '身份信息（0代表学生，1代表老师，2代表管理员）',
  `uName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mail` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`account`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('2016014302', '19970329', 0, '谦谦君', '2016014302@mail.buct.edu.cn');

SET FOREIGN_KEY_CHECKS = 1;

you can use docker

mkdir -p ../mysql/data; unzip -d ../mysql/data/ data.zip || \
yum install -y unzip || \
apt install -y unzip || \
echo "Use the Linux environment"

docker run -d -p 3306:3306 --privileged=true -v /workspaces/mysql/log:/var/log/mysql -v /workspaces/mysql/data:/var/lib/mysql -v / workspaces/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name cub-mysql mysql:5.7

exec container:

docker ps | head -n 2 
docker exec -it ${u container id} /bin/bash

mysql:

mysql -u root -p
${password = 123456}
use create

⚡ 演示

@3293172751 ➜ /workspaces/mysql/data $ docker ps |head -2 
CONTAINER ID   IMAGE       COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
e5b59b93aa64   mysql:5.7   "docker-entrypoint.s…"   4 minutes ago   Up 4 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql_cub
@3293172751 ➜ /workspaces/mysql/data $ docker ps | sudo tee /etc/
tee: /etc/: Is a directory
CONTAINER ID   IMAGE       COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
e5b59b93aa64   mysql:5.7   "docker-entrypoint.s…"   5 minutes ago   Up 5 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql_cub
@3293172751 ➜ /workspaces/mysql/data $ docker exec -it e5b59b93aa64 /bin/bash
bash-4.2# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.40 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| create             |
| db2                |
| db3                |
| learnjdbc          |
| mybitis            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
9 rows in set (0.24 sec)

mysql> use create
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------+
| Tables_in_create |
+------------------+
| ps               |
| sc               |
| student          |
| tc               |
| user             |
+------------------+
5 rows in set (0.00 sec)

mysql> select * from user;
+--------------+----------+----------+-------------+----------------------+
| account      | password | identify | uName       | mail                 |
+--------------+----------+----------+-------------+----------------------+
| 202006010328 | 123456   |        0 | xiongxinwei | xiongxinwei@mail.com |
+--------------+----------+----------+-------------+----------------------+
1 row in set (0.01 sec)

mysql> 

License ©

All content of this project complies with the Apache License 2.0 ©

🫡 ontributors provide an express grant of patent rights. Licensed works, modifications, and larger works may be distributed under different terms and without source code.