Advanced Query Techniques in MyBatis-Plus: Date Filtering, Subqueries, and Dynamic SQL with apply and inSql

This article demonstrates how to use MyBatis-Plus for complex queries—including date filtering, sub‑queries, INNER JOIN, dynamic SQL with the apply method, and the inSql helper—while highlighting potential SQL‑injection pitfalls and providing complete runnable code examples.

Backend DevelopmentDynamic QueryJava

0 likes · 6 min read

Advanced Query Techniques in MyBatis-Plus: Date Filtering, Subqueries, and Dynamic SQL with apply and inSql

Wukong Talks Architecture

Jan 31, 2020 · Backend Development

MyBatis-Plus Tutorial: Creating User Table, Entity, Mapper, and Basic Query Methods

This tutorial demonstrates how to create a User table, define the corresponding entity and mapper classes, and perform basic MyBatis-Plus queries such as selectList, selectById, selectBatchIds, and selectByMap, including the required SQL scripts and Java code examples.

DatabaseJavaMybatis-Plus

0 likes · 8 min read

MyBatis-Plus Tutorial: Creating User Table, Entity, Mapper, and Basic Query Methods

Wukong Talks Architecture

Jan 31, 2020 · Backend Development

Advanced MyBatis-Plus Query Examples: AND, Nested, IN, and LIMIT

This tutorial demonstrates several advanced MyBatis-Plus query scenarios—including combined AND conditions, nested expressions, IN clauses, and limiting results—by providing complete SQL setup, Java QueryWrapper code samples, execution logs, and result screenshots for each case.

Backend DevelopmentJavaMybatis-Plus

0 likes · 7 min read

Advanced MyBatis-Plus Query Examples: AND, Nested, IN, and LIMIT

Wukong Talks Architecture

Jan 31, 2020 · Backend Development

Advanced Query Techniques in MyBatis‑Plus: Using apply, inSql, and JOIN for Complex Conditions

This article demonstrates how to perform sophisticated MyBatis‑Plus queries—such as date filtering, manager name prefix matching, sub‑queries, INNER JOIN, dynamic SQL with apply, and inSql—while highlighting potential SQL‑injection risks and providing complete Java test code examples.

JavaMybatis-PlusQueryWrapper

0 likes · 7 min read

Advanced Query Techniques in MyBatis‑Plus: Using apply, inSql, and JOIN for Complex Conditions

Wukong Talks Architecture

Jan 31, 2020 · Backend Development

MyBatis-Plus Advanced Query Cases and Detailed Explanations

This article presents a series of MyBatis-Plus advanced query examples, including how to filter users by name patterns, age ranges, and email presence, and demonstrates ordering and combined conditions with complete Java test code and a sample User table schema.

JavaMybatis-PlusQueryWrapper

0 likes · 6 min read

MyBatis-Plus Advanced Query Cases and Detailed Explanations

Wukong Talks Architecture

Jan 30, 2020 · Backend Development

Advanced Query Techniques in MyBatis-Plus: Using apply, inSql, and Subqueries

This tutorial demonstrates how to perform advanced MyBatis-Plus queries—including subqueries, INNER JOIN, apply, and inSql methods—while highlighting difficulty levels, code examples, and the risk of SQL injection in dynamic query construction.

JavaMybatis-PlusQueryWrapper

0 likes · 7 min read

Advanced Query Techniques in MyBatis-Plus: Using apply, inSql, and Subqueries

Wukong Talks Architecture

Jan 29, 2020 · Backend Development

Advanced Query Examples with MyBatis-Plus: Case Studies and Code Walkthrough

This tutorial showcases MyBatis-Plus advanced query techniques through three practical case studies, providing sample data, detailed SQL conditions, and complete Java test code snippets to help developers master complex database queries.

Advanced QueriesBackend DevelopmentJava

0 likes · 6 min read

Advanced Query Examples with MyBatis-Plus: Case Studies and Code Walkthrough