JSqlParser | BestHub

macrozheng

Mar 4, 2025 · Backend Development

How to Implement Data Isolation in Spring Boot with MyBatis and JSqlParser

This article explains how to achieve data isolation in a Spring Boot application by creating a MyBatis interceptor that uses JSqlParser to parse and modify SQL statements at the prepare stage, covering tool introductions, dependency setup, interceptor code, testing examples, and the reasoning behind intercepting the prepare method.

Data IsolationJSqlParserMyBatis

0 likes · 14 min read

How to Implement Data Isolation in Spring Boot with MyBatis and JSqlParser

Code Ape Tech Column

Feb 10, 2025 · Backend Development

Implementing Data Isolation in Spring Boot with MyBatis Interceptor and JSqlParser

This article explains how to achieve data isolation in a Spring Boot application by using a MyBatis interceptor that leverages JSqlParser to parse and modify SQL statements at the StatementHandler.prepare stage, covering tool introductions, dependency setup, interceptor implementation, testing examples, and the rationale behind intercepting the prepare method.

Data IsolationJSqlParserMyBatis

0 likes · 13 min read

Implementing Data Isolation in Spring Boot with MyBatis Interceptor and JSqlParser

Selected Java Interview Questions

Feb 5, 2025 · Backend Development

Implementing Data Isolation in Spring Boot with MyBatis Interceptor and JSqlParser

This article demonstrates how to achieve data isolation in a Spring Boot application by creating a MyBatis interceptor that modifies SQL statements using JSqlParser, covering tool introductions, dependency setup, interceptor implementation, testing for SELECT/INSERT/UPDATE/DELETE, and the rationale for intercepting the prepare method.

Data IsolationJSqlParserMyBatis

0 likes · 14 min read

Spring Full-Stack Practical Cases

Jan 20, 2025 · Backend Development

Master SQL Parsing in Java with JSQLParser: Real‑World Examples and Tips

This article introduces the open‑source JSQLParser library, shows how to set it up in a Spring Boot 3 project, and provides step‑by‑step code examples for simple parsing, extracting tables, retrieving WHERE clauses, building or modifying SQL statements, and handling parsing errors.

Code ExampleJSqlParserJava

0 likes · 8 min read

Master SQL Parsing in Java with JSQLParser: Real‑World Examples and Tips

JD Tech Talk

Jan 8, 2025 · Backend Development

Dynamic Database Switching in MyBatis Using SQL Source Decoration

This article explains how to implement dynamic database switching in MyBatis by intercepting and modifying SQL statements to prepend database names to table names, using JSqlParser and MyBatis interceptors.

Database SwitchingDecorator PatternDynamic SQL

0 likes · 6 min read

Dynamic Database Switching in MyBatis Using SQL Source Decoration