feat: 更新示例

dunwu · dunwu · commit 088d49c81ffc · 2023-10-26T07:02:27.000+08:00
diff --git a/codes/javadb/mysql/src/test/java/io/github/dunwu/javadb/mysql/springboot/MysqlDemoTest.java b/codes/javadb/mysql/src/test/java/io/github/dunwu/javadb/mysql/springboot/MysqlDemoTest.java
@@ -6,11 +6,15 @@
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 
-import java.sql.*;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
 
 /**
  * Mysql 测试例
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  * @see https://dev.mysql.com/doc/connector-j/5.1/en/
  */
 public class MysqlDemoTest {
diff --git a/codes/javadb/redis/src/test/java/io/github/dunwu/javadb/redis/RedissonStandaloneTest.java b/codes/javadb/redis/src/test/java/io/github/dunwu/javadb/redis/RedissonStandaloneTest.java
@@ -7,7 +7,7 @@
 import org.springframework.context.support.ClassPathXmlApplicationContext;
 
 /**
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  * @since 2018/6/19
  */
 public class RedissonStandaloneTest {
diff --git a/codes/javadb/redis/src/test/java/io/github/dunwu/javadb/redis/jedis/JedisDemoTest.java b/codes/javadb/redis/src/test/java/io/github/dunwu/javadb/redis/jedis/JedisDemoTest.java
@@ -15,7 +15,7 @@
 /**
  * Jedis 测试例
  *
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  * @see https://github.com/xetorthio/jedis
  */
 @Slf4j
diff --git a/codes/javadb/redis/src/test/java/io/github/dunwu/javadb/redis/jedis/JedisPoolDemoTest.java b/codes/javadb/redis/src/test/java/io/github/dunwu/javadb/redis/jedis/JedisPoolDemoTest.java
@@ -16,7 +16,7 @@
 import java.util.Set;
 
 /**
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  */
 @RunWith(SpringJUnit4ClassRunner.class)
 @ActiveProfiles("dev")
diff --git a/codes/javadb/sqlite/src/main/java/io/github/dunwu/javadb/sqlite/springboot/SpringBootDataSqliteApplication.java b/codes/javadb/sqlite/src/main/java/io/github/dunwu/javadb/sqlite/springboot/SpringBootDataSqliteApplication.java
@@ -6,7 +6,7 @@
 import org.springframework.boot.autoconfigure.SpringBootApplication;
 
 /**
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  * @since 2019-03-05
  */
 @Slf4j
diff --git a/codes/javadb/sqlite/src/main/java/io/github/dunwu/javadb/sqlite/springboot/SqliteDemo.java b/codes/javadb/sqlite/src/main/java/io/github/dunwu/javadb/sqlite/springboot/SqliteDemo.java
@@ -6,7 +6,7 @@
 import java.sql.Statement;
 
 /**
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  * @since 2019-03-05
  */
 public class SqliteDemo {
diff --git a/codes/mysql/Leetcode之SQL题/easy/查找重复的电子邮箱.sql b/codes/mysql/Leetcode之SQL题/easy/查找重复的电子邮箱.sql
@@ -1,7 +1,7 @@
 -- --------------------------------------------------------------------------------------
 -- 查找重复的电子邮箱
 -- @link https://leetcode-cn.com/problems/duplicate-emails/
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2020/02/29
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/SQL必知必会示例/select.sql b/codes/mysql/SQL必知必会示例/select.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- Mysql 查询示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2018/5/5
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/SQL性能优化/SQL函数影响索引.sql b/codes/mysql/SQL性能优化/SQL函数影响索引.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- 函数操作影响索引效率示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- ----------------------------------------------------------------------------------------
 
 -- 步骤 1、建表
diff --git a/codes/mysql/SQL性能优化/等MDL锁.sql b/codes/mysql/SQL性能优化/等MDL锁.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- 函数操作影响索引效率示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- ----------------------------------------------------------------------------------------
 
 CREATE TABLE t (
diff --git a/codes/mysql/事务/事务示例.sql b/codes/mysql/事务/事务示例.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- Mysql 事务示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2020/02/29
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/事务/幻读示例1.sql b/codes/mysql/事务/幻读示例1.sql
@@ -0,0 +1,55 @@
+-- --------------------------------------------------------------------------------------
+-- 幻读示例
+-- 实验说明：以下 SQL 脚本必须严格按照顺序执行，并且事务 A 和事务 B 必须在不同的 Client 中执行。
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
+-- @date 2023/10/25
+-- ----------------------------------------------------------------------------------------
+
+-- --------------------------------------------------------------------- （1）数据初始化
+
+-- 创建表 test
+CREATE TABLE `test` (
+	`id` INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
+	`value` INT(10) NOT NULL
+);
+
+-- 数据初始化
+INSERT INTO `test` (`id`, `value`) VALUES (1, 1);
+INSERT INTO `test` (`id`, `value`) VALUES (2, 2);
+INSERT INTO `test` (`id`, `value`) VALUES (3, 3);
+
+-- --------------------------------------------------------------------- （2）事务 A
+
+BEGIN;
+
+-- 查询 id = 4 的记录
+SELECT * FROM `test` WHERE `id` = 4;
+-- 结果为空
+
+-- --------------------------------------------------------------------- （3）事务 B
+
+BEGIN;
+
+INSERT INTO `test` (`id`, `value`) VALUES (4, 4);
+
+COMMIT;
+
+-- --------------------------------------------------------------------- （4）事务 A
+
+-- 查询 id = 4 的记录
+SELECT * FROM `test` WHERE `id` = 4;
+-- 结果依然为空
+
+-- 成功更新本应看不到的记录 id = 4
+UPDATE `test` SET `value` = 0 WHERE `id` = 4;
+
+-- 再一次查询 id = 4 的记录
+SELECT * FROM `test` WHERE `id` = 4;
+-- 结果为：
+-- +----+-------+
+-- | id | value |
+-- +----+-------+
+-- |  4 |     0 |
+-- +----+-------+
+
+COMMIT;
diff --git a/codes/mysql/事务/幻读示例2.sql b/codes/mysql/事务/幻读示例2.sql
@@ -0,0 +1,53 @@
+-- --------------------------------------------------------------------------------------
+-- 幻读示例
+-- 实验说明：以下 SQL 脚本必须严格按照顺序执行，并且事务 A 和事务 B 必须在不同的 Client 中执行。
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
+-- @date 2023/10/25
+-- ----------------------------------------------------------------------------------------
+
+-- --------------------------------------------------------------------- （1）数据初始化
+
+-- 创建表 test
+CREATE TABLE `test` (
+	`id` INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
+	`value` INT(10) NOT NULL
+);
+
+-- 数据初始化
+INSERT INTO `test` (`id`, `value`) VALUES (1, 1);
+INSERT INTO `test` (`id`, `value`) VALUES (2, 2);
+INSERT INTO `test` (`id`, `value`) VALUES (3, 3);
+
+-- --------------------------------------------------------------------- （2）事务 A
+
+BEGIN;
+
+-- 查询 id > 2 的记录数
+SELECT COUNT(*) FROM `test` WHERE `id` > 2;
+-- 结果为：
+-- +----------+
+-- | count(*) |
+-- +----------+
+-- |        1 |
+-- +----------+
+
+-- --------------------------------------------------------------------- （3）事务 B
+
+BEGIN;
+
+INSERT INTO `test` (`id`, `value`) VALUES (4, 4);
+
+COMMIT;
+
+-- --------------------------------------------------------------------- （4）事务 A
+
+-- 查询 id = 4 的记录
+SELECT COUNT(*) FROM `test` WHERE `id` > 2 FOR UPDATE;
+-- 结果为：
+-- +----------+
+-- | count(*) |
+-- +----------+
+-- |        2 |
+-- +----------+
+
+COMMIT;
diff --git a/codes/mysql/基本DDL示例.sql b/codes/mysql/基本DDL示例.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- Mysql 基本 DDL 语句示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2018/4/28
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/基本DML示例.sql b/codes/mysql/基本DML示例.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- Mysql 基本 DML 语句示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2018/4/28
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/基本TCL示例.sql b/codes/mysql/基本TCL示例.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- Mysql 基本 TCL 语句示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2018/4/28
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/常见查询示例.sql b/codes/mysql/常见查询示例.sql
@@ -1,6 +1,6 @@
 -- --------------------------------------------------------------------------------------
 -- Mysql 常见查询示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2018/5/4
 -- ----------------------------------------------------------------------------------------
 
diff --git a/codes/mysql/触发器示例.sql b/codes/mysql/触发器示例.sql
@@ -1,11 +1,11 @@
 /**
  * Mysql 触发器（TRIGGER）创建、使用示例
- * @author Zhang Peng
+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
  * @date 2018/5/2
  */
 -- --------------------------------------------------------------------------------------
 -- Mysql 基本 DDL 语句示例
--- @author Zhang Peng
+-- @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
 -- @date 2018/4/28
 -- ----------------------------------------------------------------------------------------
 

Original file line number	Diff line number	Diff line change
`@@ -15,7 +15,7 @@`
`15`	`15`	`/**`
`16`	`16`	`* Jedis 测试例`
`17`	`17`	`*`
`18`		`- * @author Zhang Peng`
	`18`	`+ * @author <a href="mailto:forbreak@163.com">Zhang Peng</a>`
`19`	`19`	`* @see https://github.com/xetorthio/jedis`
`20`	`20`	`*/`
`21`	`21`	`@Slf4j`