Author

Pan Zhi's Tech Notes

Sharing frontline internet R&D technology, dedicated to premium original content.

Articles

Likes

Views

Comments

Latest from Pan Zhi's Tech Notes

35 recent articles

Pan Zhi's Tech Notes

Feb 12, 2025 · Backend Development

Comprehensive Guide to Log Configuration and Performance Comparison of Major Java Logging Frameworks

The article explains why logging is essential for problem tracing, status monitoring, and security auditing, introduces Log4j, Log4j2, and Logback components and configuration files, demonstrates usage with Maven dependencies and code snippets, evaluates their synchronous and asynchronous performance, and offers practical recommendations for production environments.

Java loggingLogbackSLF4J

0 likes · 28 min read

Comprehensive Guide to Log Configuration and Performance Comparison of Major Java Logging Frameworks

Pan Zhi's Tech Notes

Feb 10, 2025 · Information Security

Is Your Site Vulnerable? Understanding the Common SQL Injection Attack

This article explains the fundamentals of SQL injection attacks, demonstrates step‑by‑step exploitation using the DVWA platform—including data extraction, login bypass, and injection point detection—and outlines practical prevention techniques such as input validation, regex filtering, and prepared statements.

DVWAInput ValidationMySQL

0 likes · 11 min read

Is Your Site Vulnerable? Understanding the Common SQL Injection Attack

Pan Zhi's Tech Notes

Feb 8, 2025 · Databases

How to Choose the Right Database Transaction Isolation Level

This article explains MySQL’s transaction isolation mechanisms, compares the four isolation levels with concrete examples, shows how they affect phenomena like dirty reads, non‑repeatable reads and phantom reads, and provides practical guidance on configuring and avoiding long transactions.

MVCCMySQLREPEATABLE READ

0 likes · 15 min read

How to Choose the Right Database Transaction Isolation Level

Pan Zhi's Tech Notes

Jan 26, 2025 · Backend Development

Mastering Spring Transaction Management: From JDBC to @Transactional

This article explains the fundamentals of transaction handling in Spring Boot, covering both programmatic approaches with PlatformTransactionManager and TransactionTemplate and declarative management using @Transactional, while detailing common pitfalls, propagation and isolation settings, and providing concrete code examples.

Declarative TransactionJDBCProgrammatic Transaction

0 likes · 23 min read

Mastering Spring Transaction Management: From JDBC to @Transactional

Pan Zhi's Tech Notes

Jun 15, 2024 · Backend Development

Build a Button‑Level User Permission System Step‑by‑Step with Spring Boot & MyBatisPlus

This tutorial walks through designing a button‑level user permission system—including a five‑table database schema, Spring Boot + MyBatisPlus project setup, code generation, menu CRUD operations, recursive menu tree construction, role‑based permission queries, and annotation‑driven request authorization—complete with runnable code snippets and sample data.

Backend DevelopmentJavaMenu Authorization

0 likes · 18 min read