Skip to content
Tagged articles

MyBatis

500 articles · Page 4 of 5
Java Captain
Java Captain
Nov 11, 2023 · Backend Development

Analyzing and Reproducing OutOfMemoryError in MyBatis-based Java Services

This article examines the causes of Java OutOfMemoryError in a distributed backend service, analyzes MyBatis-related memory leaks, demonstrates a reproducible scenario with large SQL concatenations and multithreading, and offers practical mitigation strategies to prevent heap and metaspace overflow.

BackendJavaMemory Leak
0 likes · 6 min read
Analyzing and Reproducing OutOfMemoryError in MyBatis-based Java Services
Architect
Architect
Nov 6, 2023 · Backend Development

Unveiling MyBatis: A Deep Dive into Its Architecture and Execution Flow

This article provides a comprehensive, step‑by‑step analysis of MyBatis’s overall architecture, covering its core features, three‑layer design, configuration parsing, proxy generation, SQL execution process, and the underlying components that enable seamless Java‑to‑SQL mapping.

JavaMyBatisORM
0 likes · 11 min read
Unveiling MyBatis: A Deep Dive into Its Architecture and Execution Flow
macrozheng
macrozheng
Nov 6, 2023 · Backend Development

Mastering MyBatis PageHelper: Avoid Common Pagination Pitfalls

This article explains the core principles and multiple usage patterns of MyBatis PageHelper for pagination, demonstrates code examples, details its internal ThreadLocal and interceptor mechanisms, and highlights common pitfalls with safe versus unsafe practices to ensure reliable data retrieval.

JavaMyBatisPageHelper
0 likes · 9 min read
Mastering MyBatis PageHelper: Avoid Common Pagination Pitfalls
dbaplus Community
dbaplus Community
Nov 5, 2023 · Backend Development

Three Hidden Pagination Pitfalls That Can Break Your Production System

The article recounts three real‑world pagination bugs—batch‑processing loops, misuse of MyBatis PageHelper, and nondeterministic results from identical ORDER BY values—explaining why they occur, how they manifest in production, and concrete fixes to avoid data loss or endless loops.

MyBatisMySQLPageHelper
0 likes · 15 min read
Three Hidden Pagination Pitfalls That Can Break Your Production System
政采云技术
政采云技术
Nov 2, 2023 · Information Security

Design and Implementation of a Multi‑System Data Permission Control System

This article describes a unified, configurable data‑permission framework built on RBAC, detailing its architecture, rule definition, integration workflow, Java SDK implementation, and practical examples to achieve flexible, low‑coupling access control across multiple backend systems.

Data PermissionJavaMyBatis
0 likes · 11 min read
Design and Implementation of a Multi‑System Data Permission Control System
Java Architect Essentials
Java Architect Essentials
Oct 23, 2023 · Backend Development

Design Patterns Employed in the MyBatis Framework

This article analyzes the MyBatis source code, illustrating how it applies a variety of design patterns—including Factory, Singleton, Builder, Adapter, Proxy, Composite, Decorator, Template, Strategy, and Iterator—to solve complex architectural challenges and improve modularity, extensibility, and maintainability.

Factory PatternJavaMyBatis
0 likes · 8 min read
Design Patterns Employed in the MyBatis Framework
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Oct 21, 2023 · Backend Development

Comprehensive Spring Boot Tutorial: Configuration, Logging, MVC, Data Access, Docker, and Custom Starters

This tutorial provides an in‑depth guide to Spring Boot covering core concepts such as project setup, configuration files, logging frameworks, MVC architecture, CRUD examples, error handling, embedded servlet containers, Docker integration, JDBC/MyBatis/JPA data access, startup process, and how to create custom starter modules.

BackendConfigurationDocker
0 likes · 47 min read
Comprehensive Spring Boot Tutorial: Configuration, Logging, MVC, Data Access, Docker, and Custom Starters
Top Architect
Top Architect
Oct 17, 2023 · Backend Development

Implementation and Comparison of Fluent MyBatis, Native MyBatis, and MyBatis‑Plus for Student Score Statistics

This article presents a typical requirement to calculate count, minimum, maximum, and average scores for three subjects in a student_score table, demonstrates how to fulfill it using raw SQL, then shows step‑by‑step implementations with Fluent MyBatis, native MyBatis XML, and MyBatis‑Plus code generation, and finally compares the three approaches highlighting their pros and cons.

Fluent-MyBatisJavaMyBatis
0 likes · 9 min read
Implementation and Comparison of Fluent MyBatis, Native MyBatis, and MyBatis‑Plus for Student Score Statistics
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 6, 2023 · Backend Development

Secure Your Spring Boot Data with MyBatis Custom TypeHandler Encryption

This tutorial demonstrates how to integrate a custom MyBatis TypeHandler in a Spring Boot 2.6.12 application to automatically encrypt sensitive fields before persisting them to MySQL and decrypt them on retrieval, covering dependencies, configuration, entity definition, encryption utilities, mapper XML, and test cases.

Custom TypeHandlerJPAJava
0 likes · 10 min read
Secure Your Spring Boot Data with MyBatis Custom TypeHandler Encryption
Selected Java Interview Questions
Selected Java Interview Questions
Oct 5, 2023 · Backend Development

Design Patterns Employed in the MyBatis Framework

The MyBatis source code, spanning over twenty thousand lines, extensively applies creational, structural, and behavioral design patterns—such as Factory, Singleton, Builder, Adapter, Proxy, Composite, Decorator, Template, Strategy, and Iterator—to decouple complex scenarios and illustrate advanced backend architecture practices.

JavaMyBatisORM
0 likes · 7 min read
Design Patterns Employed in the MyBatis Framework
Code Ape Tech Column
Code Ape Tech Column
Oct 2, 2023 · Backend Development

Design Patterns Used in the MyBatis Framework

This article reviews the various design patterns—creational, structural, and behavioral—employed within MyBatis's source code, illustrating each pattern with diagrams and explaining their roles in simplifying factory creation, singleton configuration, builders, adapters, proxies, decorators, templates, strategies, and iterators.

Factory PatternMyBatisbackend development
0 likes · 12 min read
Design Patterns Used in the MyBatis Framework
Su San Talks Tech
Su San Talks Tech
Oct 1, 2023 · Backend Development

How to Efficiently Insert 300,000 Records with MyBatis and JDBC

This article demonstrates multiple approaches—including direct MyBatis batch, per‑row insertion, and JDBC batch processing—to insert 300,000 user records into a MySQL table, compares their performance, and provides practical optimization tips such as batch size tuning, waiting intervals, index handling, and connection‑pool configuration.

JDBCJavaMyBatis
0 likes · 12 min read
How to Efficiently Insert 300,000 Records with MyBatis and JDBC
Architect's Tech Stack
Architect's Tech Stack
Sep 26, 2023 · Backend Development

Deep Dive into MyBatis SQL Execution Process and Custom TypeHandler

This article explains how MyBatis binds mapper interfaces to XML files, details the complete SQL execution flow—including mapper retrieval, statement preparation, parameter handling, and result mapping—and demonstrates how to create custom TypeHandlers for both parameter setting and result set processing.

JavaMyBatisORM
0 likes · 18 min read
Deep Dive into MyBatis SQL Execution Process and Custom TypeHandler
Java Architect Essentials
Java Architect Essentials
Sep 24, 2023 · Backend Development

Understanding MyBatis Dynamic SQL and XML Mapping Tags

This article provides a comprehensive guide to MyBatis dynamic SQL, explaining its features, common XML tags such as if, where, set, choose, trim, foreach, include, and sql, and demonstrates how to implement CRUD operations, conditional queries, batch processing, and association mappings with clear code examples.

Dynamic SQLJavaMyBatis
0 likes · 17 min read
Understanding MyBatis Dynamic SQL and XML Mapping Tags
MaGe Linux Operations
MaGe Linux Operations
Sep 23, 2023 · Information Security

How to Prevent SQL Injection in Java Projects: From PreparedStatement to Nginx Filters

This article explains what SQL injection is, demonstrates a vulnerable example, and presents four practical defenses for Java applications—including PreparedStatement, MyBatis #{} placeholders, request‑parameter filtering, and Nginx reverse‑proxy rules—complete with code snippets and configuration details.

JavaMyBatisPreparedStatement
0 likes · 8 min read
How to Prevent SQL Injection in Java Projects: From PreparedStatement to Nginx Filters
Java High-Performance Architecture
Java High-Performance Architecture
Sep 23, 2023 · Backend Development

From JDBC to MyBatis: Why Java Persistence Evolved and How to Optimize It

This article walks through the step‑by‑step JDBC query process, explains why wrapping JDBC in a framework like MyBatis is beneficial, analyzes MyBatis’s core components and execution flow, and presents five practical optimizations—from connection pooling to dynamic SQL and result caching—to improve Java backend performance.

Connection PoolingJDBCJava backend
0 likes · 35 min read
From JDBC to MyBatis: Why Java Persistence Evolved and How to Optimize It
Java Interview Crash Guide
Java Interview Crash Guide
Sep 22, 2023 · Backend Development

Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel – and How to Fix It

This article explains how Lombok’s unconventional getter/setter naming for fields with a lowercase‑first, uppercase‑second pattern causes MyBatis to map enum properties as null, and how the @Accessor(chain=true) annotation in EasyExcel triggers cglib reflection issues, then provides practical workarounds for both problems.

AccessorEasyExcelGetterSetter
0 likes · 9 min read
Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel – and How to Fix It
Java Interview Crash Guide
Java Interview Crash Guide
Sep 19, 2023 · Backend Development

How MyBatis Leverages 10+ Design Patterns to Simplify Complex Scenarios

The article examines how MyBatis applies a variety of creational, structural, and behavioral design patterns—such as Factory, Singleton, Builder, Adapter, Proxy, Composite, Decorator, Template, Strategy, and Iterator—to decouple its over‑twenty‑thousand‑line codebase, improve modularity, and handle complex ORM tasks efficiently.

AdapterBuilderFactory Pattern
0 likes · 8 min read
How MyBatis Leverages 10+ Design Patterns to Simplify Complex Scenarios
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Sep 18, 2023 · Backend Development

Why MyBatis SqlSession Crashes with Multiple Threads and How Spring Fixes It

This article examines the ClassCastException that occurs when 100 threads concurrently query MyBatis using a shared SqlSession, analyzes the root cause in DefaultSqlSession and BaseExecutor, and explains how Spring Boot’s MyBatis integration employs SqlSessionTemplate, ThreadLocal binding, and transaction management to guarantee thread‑safe SqlSession usage.

MyBatisSpring BootSqlSession
0 likes · 21 min read
Why MyBatis SqlSession Crashes with Multiple Threads and How Spring Fixes It
Java Interview Crash Guide
Java Interview Crash Guide
Sep 14, 2023 · Backend Development

Master MyBatis Dynamic SQL: Tags, Conditions, and Advanced Queries

This article explains MyBatis dynamic SQL, its nine XML tags, execution principle, and how to use if, where, set, choose, trim, foreach, sql, include, and association mappings for flexible query building, batch operations, and one‑to‑many, many‑to‑one, and many‑to‑many relationships.

Dynamic SQLJavaMyBatis
0 likes · 17 min read
Master MyBatis Dynamic SQL: Tags, Conditions, and Advanced Queries
Top Architect
Top Architect
Sep 12, 2023 · Backend Development

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

This article demonstrates how to insert 300,000 rows into a MySQL table efficiently by defining entity, mapper and configuration files, comparing direct batch insertion, row‑by‑row insertion, and optimized batch strategies with MyBatis and JDBC, and summarizing performance results and best‑practice tips.

JDBCJavaMyBatis
0 likes · 15 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
Java High-Performance Architecture
Java High-Performance Architecture
Sep 12, 2023 · Backend Development

From JDBC to MyBatis: Transforming Low‑Level SQL Calls into a Powerful Persistence Framework

This article walks through the step‑by‑step evolution from raw JDBC queries to the MyBatis persistence layer, highlighting why JDBC should be wrapped, the design improvements MyBatis introduces, core components, execution flow, initialization mechanisms, and related design patterns, all illustrated with code snippets and diagrams.

Database AccessJDBCJava Persistence
0 likes · 37 min read
From JDBC to MyBatis: Transforming Low‑Level SQL Calls into a Powerful Persistence Framework
Architect's Tech Stack
Architect's Tech Stack
Sep 11, 2023 · Databases

Performance Evaluation of Large-Scale Data Insertion into MySQL Using MyBatis, JDBC, and Batch Processing

This article presents a systematic performance test of inserting massive data into MySQL, comparing three strategies—MyBatis lightweight insertion, direct JDBC (with and without transactions), and JDBC batch processing—showing how transaction handling and batch execution dramatically affect insertion speed.

JDBCJavaMyBatis
0 likes · 15 min read
Performance Evaluation of Large-Scale Data Insertion into MySQL Using MyBatis, JDBC, and Batch Processing
Top Architect
Top Architect
Sep 7, 2023 · Backend Development

From JDBC to MyBatis: Evolution, Design, and Optimization of the Persistence Layer

This article explains how JDBC evolves into MyBatis, detailing the seven-step JDBC query process, the motivations for encapsulating JDBC, MyBatis architecture, core components, initialization mechanisms, design patterns, and code examples, while offering optimization strategies for connection handling, SQL management, and result mapping.

JDBCMyBatisSQL
0 likes · 39 min read
From JDBC to MyBatis: Evolution, Design, and Optimization of the Persistence Layer
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Sep 7, 2023 · Backend Development

How to Configure Master‑Slave Data Sources in Spring Boot with JPA & MyBatis

This guide walks through setting up a Spring Boot 2.4.12 project with JDK 1.8, Oracle, and two data sources—master and slave—covering Maven dependencies, application.yml settings, custom property classes, HikariDataSource beans, JPA EntityManagerFactory, MyBatis SqlSessionFactory, mapper scanning, and testing entity creation to verify successful configuration.

HikariCPJPAMultiple Data Sources
0 likes · 21 min read
How to Configure Master‑Slave Data Sources in Spring Boot with JPA & MyBatis
Top Architect
Top Architect
Aug 29, 2023 · Databases

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

This article explains how to insert 300,000 rows into a MySQL table efficiently by defining a User entity, configuring MyBatis mappers, and comparing three approaches—direct bulk insert, per‑row loop insert, and batch insert with configurable batch sizes—while also providing JDBC equivalents and performance tips.

JDBCJavaMyBatis
0 likes · 15 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
Selected Java Interview Questions
Selected Java Interview Questions
Aug 23, 2023 · Information Security

Understanding SQL Injection and Prevention Techniques in Java Projects

SQL injection is a critical web security flaw where unsanitized user input can alter database queries, and this article explains its mechanics, demonstrates vulnerable Java code, and outlines four prevention methods—PreparedStatement, MyBatis #{}, request parameter filtering, and Nginx reverse‑proxy rules—complete with code examples.

JavaMyBatisPreparedStatement
0 likes · 9 min read
Understanding SQL Injection and Prevention Techniques in Java Projects
JD Tech
JD Tech
Aug 9, 2023 · Databases

MyBatis SQL Analysis Component for Slow Query Prevention and Real‑time Alerting

This article introduces a MyBatis‑based SQL analysis component that detects and prevents slow queries before they impact production by performing real‑time EXPLAIN analysis, offering optimization suggestions, and enabling dynamic SQL replacement, while detailing its design, configuration, performance testing, and practical advantages.

BackendMyBatisSQL analysis
0 likes · 12 min read
MyBatis SQL Analysis Component for Slow Query Prevention and Real‑time Alerting
Java Interview Crash Guide
Java Interview Crash Guide
Aug 5, 2023 · Databases

How to Efficiently Insert 300,000 Records with MyBatis and JDBC

This article demonstrates multiple approaches—including MyBatis batch inserts, per‑row inserts, and JDBC batch processing—to efficiently load 300,000 user records into a MySQL table, compares their performance, and provides practical optimization tips such as batch size, waiting intervals, and index handling.

JDBCJavaMyBatis
0 likes · 14 min read
How to Efficiently Insert 300,000 Records with MyBatis and JDBC
Selected Java Interview Questions
Selected Java Interview Questions
Jul 30, 2023 · Backend Development

Understanding MyBatis Dynamic SQL and XML Mapping Tags

This article explains MyBatis dynamic SQL, its execution principle, and the nine core XML tags (if, where, set, choose, trim, foreach, sql, include, resultMap) with detailed examples of CRUD operations, conditional queries, batch processing, and association mappings for Java backend development.

Dynamic SQLJavaMyBatis
0 likes · 15 min read
Understanding MyBatis Dynamic SQL and XML Mapping Tags
JD Tech
JD Tech
Jul 28, 2023 · Backend Development

Analyzing MyBatis ParameterType and ResultType Misconfiguration Causing Thread Blocking Under High Concurrency

Under high concurrency, improper configuration of MyBatis parameterType and resultType can lead to thread BLOCKED states due to repeated TypeHandler cache misses, and this article analyzes the root causes, demonstrates debugging steps, and provides recommendations to avoid such performance bottlenecks.

ConcurrencyMyBatisTypeHandler
0 likes · 13 min read
Analyzing MyBatis ParameterType and ResultType Misconfiguration Causing Thread Blocking Under High Concurrency
macrozheng
macrozheng
Jul 25, 2023 · Backend Development

Dynamic SQL with MyBatis Interceptors in Spring Boot

This tutorial explains how to use MyBatis interceptor mechanisms to dynamically modify SQL statements at runtime in a Spring Boot application, covering interceptor types, implementation steps, configuration, core code, testing, and common use cases such as SQL monitoring, pagination, and data permission filtering.

Dynamic SQLInterceptorJava
0 likes · 11 min read
Dynamic SQL with MyBatis Interceptors in Spring Boot
Selected Java Interview Questions
Selected Java Interview Questions
Jul 24, 2023 · Backend Development

Analyzing and Reproducing OutOfMemoryError Caused by MyBatis and DruidDataSource in a Java Backend Service

This article investigates the root causes of frequent OutOfMemoryError incidents in a distributed Java backend, explains how MyBatis and DruidDataSource can exhaust heap and metaspace, demonstrates a reproducible test with JVM options and multithreading, and offers practical mitigation strategies.

DockerJavaMemoryLeak
0 likes · 7 min read
Analyzing and Reproducing OutOfMemoryError Caused by MyBatis and DruidDataSource in a Java Backend Service
JavaEdge
JavaEdge
Jul 14, 2023 · Databases

How to Efficiently Insert 1,000 Records with MyBatis: Loop vs Batch

When interviewers ask how to insert a thousand rows with MyBatis, the answer isn’t just a simple Java for‑loop; you need to consider batch processing, disable autocommit, and understand MyBatis’s limits to choose the most reliable and performant approach.

JavaMyBatisbatch insert
0 likes · 3 min read
How to Efficiently Insert 1,000 Records with MyBatis: Loop vs Batch
Su San Talks Tech
Su San Talks Tech
Jul 14, 2023 · Backend Development

How to Use MyBatis Interceptor for Dynamic SQL in Spring Boot 3

This article demonstrates how to leverage MyBatis interceptor mechanism in a Spring Boot 3 application to dynamically modify SQL statements, showing step‑by‑step implementation, configuration, core code, testing, and common use cases such as SQL monitoring, pagination, and data permission filtering.

Dynamic SQLInterceptorJava
0 likes · 11 min read
How to Use MyBatis Interceptor for Dynamic SQL in Spring Boot 3
Laravel Tech Community
Laravel Tech Community
Jul 13, 2023 · Databases

MyBatis-Flex: An Elegant MyBatis Enhancement Framework

MyBatis-Flex is a lightweight, high‑performance extension to MyBatis that adds full CRUD, pagination, multi‑table and batch operations while preserving all MyBatis features, supports multi‑datasource relations, recursive queries, and provides extensive annotations such as @Relation for flexible data mapping, with recent v1.4.9 updates and bug fixes.

AnnotationsJavaMyBatis
0 likes · 5 min read
MyBatis-Flex: An Elegant MyBatis Enhancement Framework
Programmer DD
Programmer DD
Jul 4, 2023 · Backend Development

Unlock MyBatis Performance: Mastering First and Second Level Caches

This article explains how MyBatis first‑level (session) and second‑level (cross‑session) caches work, the conditions required for them to function, common pitfalls when integrating with SpringBoot, and step‑by‑step instructions to enable and safely use second‑level caching in real projects.

CacheJavaMyBatis
0 likes · 11 min read
Unlock MyBatis Performance: Mastering First and Second Level Caches
ITPUB
ITPUB
Jun 23, 2023 · Databases

Seamless Sharding Migration: Dual‑Write, Mapping Keys, and Diff Validation

This article explains how to smoothly migrate a legacy single‑database system to a sharded architecture by using dual‑write, mapping‑key routing, custom transaction handling, and offline/real‑time diff checks, while detailing the underlying MyBatis integration and component‑based design.

MyBatisShardingdatabase partitioning
0 likes · 36 min read
Seamless Sharding Migration: Dual‑Write, Mapping Keys, and Diff Validation
Selected Java Interview Questions
Selected Java Interview Questions
Jun 14, 2023 · Backend Development

Understanding MyBatis First‑Level and Second‑Level Cache and Their Integration with Spring Boot

The article explains MyBatis first‑level and second‑level caching mechanisms, their activation conditions, integration pitfalls with Spring Boot, and how to enable and use them safely, including configuration steps, code examples, and warnings about hidden risks of second‑level cache.

JavaMyBatisSpring Boot
0 likes · 12 min read
Understanding MyBatis First‑Level and Second‑Level Cache and Their Integration with Spring Boot
Java Architect Essentials
Java Architect Essentials
Jun 11, 2023 · Backend Development

Using MyBatis Dynamic SQL: if, choose, trim, foreach, and bind Tags

This article provides a comprehensive guide to MyBatis dynamic SQL, demonstrating how to use if, choose, trim, foreach, and bind tags for conditional queries, updates, inserts, batch operations, and database‑agnostic expressions, complete with Maven project setup, SQL scripts, and test cases.

BackendDynamic SQLJava
0 likes · 15 min read
Using MyBatis Dynamic SQL: if, choose, trim, foreach, and bind Tags
Sohu Tech Products
Sohu Tech Products
Jun 7, 2023 · Backend Development

MyBatis Streaming Query (Cursor) Tutorial and Best Practices

This article introduces MyBatis streaming query using the Cursor interface, explains its core methods, demonstrates implementation with code examples, discusses suitable application scenarios, and outlines important considerations for efficient and safe large‑scale data processing in Java backend development.

BackendCursorMyBatis
0 likes · 11 min read
MyBatis Streaming Query (Cursor) Tutorial and Best Practices
Top Architect
Top Architect
Jun 5, 2023 · Backend Development

MyBatis Streaming Query: Concepts, Cursor API, Implementation, and Use Cases

This article introduces MyBatis streaming queries, explains the Cursor interface and its methods, provides step‑by‑step code examples for configuration and implementation, discusses practical application scenarios such as large‑scale data processing, and highlights important considerations for efficient and safe usage.

CursorJavaMyBatis
0 likes · 11 min read
MyBatis Streaming Query: Concepts, Cursor API, Implementation, and Use Cases
Qunar Tech Salon
Qunar Tech Salon
May 30, 2023 · Databases

Smooth Migration to Sharding: Design, Implementation, and Componentization of Qunar's Database Sharding Solution

This article describes the challenges of migrating a long‑running monolithic database to a sharded architecture, presents a two‑stage smooth migration strategy using double‑write, diff verification, and mapping‑key techniques, and details the componentized design, core implementation, and configuration of a reusable sharding framework built on MyBatis and Spring.

Database MigrationMyBatisSharding
0 likes · 34 min read
Smooth Migration to Sharding: Design, Implementation, and Componentization of Qunar's Database Sharding Solution
Java Interview Crash Guide
Java Interview Crash Guide
May 24, 2023 · Backend Development

Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel: Hidden Pitfalls Explained

This article explores how Lombok’s auto‑generated getter/setter methods can conflict with MyBatis property naming conventions and cause null values, examines the underlying reflection logic in MyBatis, and also reveals why the @Accessor(chain=true) annotation disrupts EasyExcel’s CGLIB‑based mapping, offering practical solutions.

CGLIBEasyExcelGetterSetter
0 likes · 7 min read
Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel: Hidden Pitfalls Explained
Selected Java Interview Questions
Selected Java Interview Questions
May 4, 2023 · Backend Development

Understanding Spring Boot Starters with MyBatis: mybatis‑spring vs mybatis‑spring‑boot‑starter

This article explains the concept and purpose of Spring Boot starters, compares mybatis‑spring with mybatis‑spring‑boot‑starter through code examples, and details how the starter simplifies MyBatis integration by handling dependencies, configuration files, auto‑configuration, and mapper scanning for Java backend projects.

Auto-configurationJavaMyBatis
0 likes · 7 min read
Understanding Spring Boot Starters with MyBatis: mybatis‑spring vs mybatis‑spring‑boot‑starter
Top Architect
Top Architect
Mar 31, 2023 · Backend Development

Why MyBatis PageHelper Pagination Is Slow and How to Optimize It

The article explains that MyBatis PageHelper performs an extra full‑table count query causing pagination to take over eight seconds on a 10,000‑row table, analyzes the root cause, and provides a concrete solution by customizing the count SQL with a _COUNT method and optimized mapper definitions.

JavaMyBatisPageHelper
0 likes · 6 min read
Why MyBatis PageHelper Pagination Is Slow and How to Optimize It
Top Architect
Top Architect
Mar 27, 2023 · Backend Development

Three MyBatis Batch Insert Methods and Their Performance Comparison

The article explains three ways to perform batch inserts with MyBatis—ordinary single-row inserts, foreach‑based bulk inserts, and ExecutorType.BATCH—analyzes their SQL logs, performance bottlenecks, MySQL limits, and provides practical recommendations for large‑scale data insertion.

ExecutorTypeJavaMyBatis
0 likes · 13 min read
Three MyBatis Batch Insert Methods and Their Performance Comparison
macrozheng
macrozheng
Mar 20, 2023 · Backend Development

Boost MyBatis Batch Insert Speed: Avoid foreach Pitfalls and Use ExecutorType.BATCH

This article explains why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, demonstrates how the generated giant SQL statement hurts performance, and shows how switching to ExecutorType.BATCH or limiting rows per INSERT dramatically reduces insertion time.

ExecutorType.BATCHJavaMyBatis
0 likes · 9 min read
Boost MyBatis Batch Insert Speed: Avoid foreach Pitfalls and Use ExecutorType.BATCH
Architect
Architect
Mar 17, 2023 · Backend Development

Million‑Scale Data Export with JPA and MyBatis in Spring Boot

This article explains how to export tens of millions of rows from MySQL using Spring Boot by streaming data with JPA or MyBatis, avoiding OutOfMemoryError, switching to CSV format, and provides complete code examples, performance comparison, and tips for generating test data.

CSVDataExportJPA
0 likes · 12 min read
Million‑Scale Data Export with JPA and MyBatis in Spring Boot
Code Ape Tech Column
Code Ape Tech Column
Mar 17, 2023 · Backend Development

Using MybatisX Plugin with Spring Boot for Rapid MyBatis Development

This guide demonstrates how to integrate the MybatisX IDEA plugin with a Spring Boot project, covering database setup, Maven dependency configuration, plugin installation, connection testing, code generation, and sample controller implementation to accelerate MyBatis and MyBatis-Plus development.

IDEA PluginJavaMyBatis
0 likes · 5 min read
Using MybatisX Plugin with Spring Boot for Rapid MyBatis Development
Programmer DD
Programmer DD
Mar 15, 2023 · Information Security

How to Prevent XSS and SQL Injection in SpringBoot: Filters and Code Examples

This article explains XSS attack types, SQL injection risks, and provides practical SpringBoot filter implementations with MyBatis prepared statements and custom deserializers to sanitize request parameters, JSON bodies, and prevent malicious script and database attacks.

MyBatisRequest SanitizationSQL injection
0 likes · 13 min read
How to Prevent XSS and SQL Injection in SpringBoot: Filters and Code Examples
Programmer DD
Programmer DD
Mar 14, 2023 · Backend Development

How to Supercharge MyBatis Batch Inserts: From 14‑Minute Loads to Sub‑2‑Second Performance

This article explains why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, analyzes the underlying SQL generation and parsing costs, and demonstrates how using ExecutorType.BATCH or limiting rows per INSERT can reduce a 14‑minute operation to under two seconds.

ExecutorType.BATCHMyBatisSQL Optimization
0 likes · 9 min read
How to Supercharge MyBatis Batch Inserts: From 14‑Minute Loads to Sub‑2‑Second Performance
Java Architect Essentials
Java Architect Essentials
Mar 3, 2023 · Backend Development

Master FastMyBatis: Quick Spring Boot Integration and CRUD Guide

This article introduces FastMyBatis—a lightweight, zero‑configuration MyBatis extension for Spring Boot—covering its core principles, Maven setup, sample CRUD controller, service and mapper implementations, a comprehensive list of mapper methods, Query object usage examples, and links to the open‑source repository.

CRUDFastMyBatisJava
0 likes · 10 min read
Master FastMyBatis: Quick Spring Boot Integration and CRUD Guide
Programmer DD
Programmer DD
Mar 1, 2023 · Backend Development

Unlock MyBatis: 10 Essential Design Patterns Powering Its Architecture

This article examines how MyBatis leverages around ten core design patterns—including Factory, Singleton, Builder, Adapter, Proxy, Composite, Decorator, Template, Strategy, and Iterator—to decouple complex scenarios, improve modularity, and streamline ORM operations within its extensive codebase.

JavaMyBatisORM
0 likes · 10 min read
Unlock MyBatis: 10 Essential Design Patterns Powering Its Architecture
Java Architect Essentials
Java Architect Essentials
Jan 10, 2023 · Backend Development

MyBatis and MyBatis-Plus Batch Insert Techniques with Performance Comparison

This article presents five common batch‑insert approaches for MyBatis and MyBatis‑Plus—including a for‑loop, manual batch commit, collection‑based batch, saveBatch, and InsertBatchSomeColumn—provides complete code examples, configuration steps, and measured execution times to help Java backend developers choose the most efficient method.

MyBatisMyBatis PlusSpring Boot
0 likes · 11 min read
MyBatis and MyBatis-Plus Batch Insert Techniques with Performance Comparison
Top Architect
Top Architect
Jan 9, 2023 · Backend Development

Using MyBatis Dynamic SQL Tags: foreach, if, choose, trim, selectKey and More

This article provides a comprehensive guide to MyBatis dynamic SQL tags—including foreach, if, choose, trim, selectKey, and related constructs—explaining their attributes, usage scenarios, and offering detailed Java and XML code examples for building flexible and error‑free database queries.

Dynamic SQLJavaMyBatis
0 likes · 16 min read
Using MyBatis Dynamic SQL Tags: foreach, if, choose, trim, selectKey and More
Top Architect
Top Architect
Dec 12, 2022 · Backend Development

MyBatis Introduction, Setup Steps, and Dynamic Proxy Implementation

This article provides a comprehensive guide to MyBatis, covering its basic concepts, Maven dependency configuration, XML setup, entity and mapper definitions, execution flow using dynamic proxies, and a custom lightweight framework implementation with full Java code examples.

JavaMyBatisORM
0 likes · 12 min read
MyBatis Introduction, Setup Steps, and Dynamic Proxy Implementation
Architect's Tech Stack
Architect's Tech Stack
Dec 8, 2022 · Backend Development

Implementing Streaming Reads with MyBatis for Large-Scale Java Report Export

This article explains how to overcome export failures caused by large data volumes in a legacy Java system by switching from default full-result JDBC reads to a forward‑only streaming approach using MyBatis, detailing environment setup, configuration changes, and complete code examples for controller, service, DAO, and mapper layers.

JDBCJavaMyBatis
0 likes · 5 min read
Implementing Streaming Reads with MyBatis for Large-Scale Java Report Export
Top Architect
Top Architect
Dec 8, 2022 · Backend Development

Common MyBatis Batch Insert Techniques and Performance Comparison

This article presents a detailed overview of five commonly used MyBatis and MyBatis-Plus batch insertion methods, including code examples, configuration steps, and performance measurements for inserting ten thousand records, helping developers choose the most efficient approach for large‑scale data insertion in Java backend projects.

JavaMyBatisMyBatis Plus
0 likes · 11 min read
Common MyBatis Batch Insert Techniques and Performance Comparison
Top Architect
Top Architect
Dec 5, 2022 · Backend Development

Integrating Spring Batch with Spring Boot: Full Tutorial and Example

This article provides a comprehensive step‑by‑step guide on integrating Spring Batch with Spring Boot, covering configuration, entity and mapper definitions, job, step, reader, processor, writer implementations, database setup, error handling, and execution via a REST controller, complete with code examples.

JavaMyBatisMySQL
0 likes · 22 min read
Integrating Spring Batch with Spring Boot: Full Tutorial and Example
Architect's Tech Stack
Architect's Tech Stack
Dec 4, 2022 · Backend Development

Unified Exception Handling in Spring Boot Using @ControllerAdvice, Assert, and Enum‑Based Business Errors

This article explains how to replace repetitive try‑catch blocks in Java Spring applications with a unified exception handling strategy that leverages @ControllerAdvice, custom Assert utilities, enum‑based error codes, and standardized response objects to improve code readability, maintainability, and internationalisation.

EnumExceptionHandlingJava
0 likes · 21 min read
Unified Exception Handling in Spring Boot Using @ControllerAdvice, Assert, and Enum‑Based Business Errors
Selected Java Interview Questions
Selected Java Interview Questions
Dec 1, 2022 · Backend Development

Five Common Batch Insert Techniques for MyBatis and MyBatis‑Plus

This article presents and compares five practical batch‑insert methods for MyBatis and MyBatis‑Plus, covering preparation steps, code implementations, configuration details, and performance results, helping developers choose the most efficient approach for inserting large volumes of data in Java backend projects.

JavaMyBatisMyBatis Plus
0 likes · 9 min read
Five Common Batch Insert Techniques for MyBatis and MyBatis‑Plus
Java Captain
Java Captain
Nov 23, 2022 · Backend Development

Free Comprehensive Collection of Big‑Tech Interview Questions and Answers (Java, Spring, Redis, MyBatis, etc.)

This post shares a free, extensive compilation of interview questions and detailed explanations covering Java fundamentals, multithreading, Spring framework, Redis, MyBatis and other backend technologies, encouraging systematic preparation and offering a QR‑code method to obtain the full document.

Interview questionsJavaMyBatis
0 likes · 8 min read
Free Comprehensive Collection of Big‑Tech Interview Questions and Answers (Java, Spring, Redis, MyBatis, etc.)