This tutorial demonstrates how to use the mybatis-plus-join (MPJ) library to perform left and right join queries in a Spring Boot project without writing XML, covering dependency setup, mapper changes, query construction, pagination, and practical code examples.
The article introduces Fluent Mybatis, a compile‑time code‑generating ORM that merges Mybatis‑Plus, Dynamic SQL and JPA features, eliminates XML mappers, offers a fluent, type‑safe Java API, and demonstrates through concise examples how it reduces boilerplate compared with native Mybatis and Mybatis‑Plus.
This article explains why the author created the EasyQuery ORM for Java, demonstrates a wide range of query patterns—including single‑record, pagination, joins, subqueries, streaming, custom VO mapping, dynamic conditions, grouping, native SQL, function columns, and high‑performance encryption—while providing complete code snippets and links to documentation and source repositories.
The latest ThinkORM release, now independent from ThinkPHP and requiring PHP 8.0+, introduces extensive JSON handling improvements, new query methods, mutator enhancements, and numerous bug fixes that boost performance and developer experience for PHP database applications.
This article explains why Java ORM frameworks are essential for simplifying database access, outlines the critical criteria for selecting the right ORM, compares popular choices such as Hibernate, JPA, EclipseLink, and DataNucleus, and provides a step‑by‑step guide for successful implementation.
This article provides a comprehensive guide to using MyBatis dynamic SQL tags such as foreach, if, choose, trim, selectKey, and sql fragments, illustrating best practices with detailed code examples for building flexible, error‑free queries and updates in Java backend applications.
This article explains what MyBatis second‑level cache is, why it’s needed, how to configure it globally and per‑mapper, the underlying CachingExecutor mechanism, and typical scenarios where enabling the cache can dramatically reduce database load and speed up read‑heavy applications.
This article introduces Easy‑Query, a Java ORM that provides a strongly‑typed, chainable query syntax covering basic CRUD, pagination, joins, sub‑queries, native SQL fragments, group‑by, custom VO mapping and high‑performance encryption, illustrated with extensive code examples and usage notes.
This guide walks you through installing, configuring, and using Egg‑Sequelize in Egg.js, explains core ORM features, demonstrates model definition and CRUD operations, and covers advanced topics such as complex queries, transactions, validation, migrations, associations, and common pitfalls to avoid.
This article explains the motivation behind creating the Easy-Query ORM for Java, demonstrates its fluent query capabilities—including single‑record, list, pagination, joins, sub‑queries, group‑by, native SQL and dynamic condition features—provides extensive code examples, and shares repository links for further exploration.
This article introduces Doctrine ORM, explains its key features such as an intuitive API, object‑oriented data modeling, powerful query builder, multi‑database support, and automatic schema synchronization, then shows how to install it via Composer and provides a complete PHP example.
This article walks through three ways to map JSON columns to Java objects in MyBatis, explains why simple String or JSONObject approaches are fragile, and provides a complete custom TypeHandler implementation, registration, and usage example for complex entity fields.
The article walks through MyBatis’s internal execution pipeline, from loading the configuration file and building a SqlSessionFactory, to creating a SqlSession, generating a MapperProxy for the mapper interface, and finally invoking the mapped method which triggers JDBC operations, while detailing caching and executor mechanisms.
MyBatis, a widely used Java ORM, embeds around ten classic design patterns—including Factory, Singleton, Builder, Adapter, Proxy, Composite, Decorator, Template Method, Strategy, and Iterator—to modularize object creation, structure, and behavior, thereby simplifying complex data access and caching mechanisms within its architecture.
This article walks through replacing MyBatis with MyBatis‑Plus in a legacy Java project, explains the “Conversion not supported for type java.time.LocalDateTime” error caused by MyBatis 3.5.1 and an outdated mysql‑connector‑java driver, and shows how upgrading the driver resolves the issue while offering debugging tips.
This article walks through migrating an existing MySQL‑based Java project from MyBatis 3.5.x to MyBatis‑Plus 3.1.1, diagnosing the LocalDateTime conversion exception, upgrading mysql‑connector‑java, handling subsequent null‑pointer issues, and learning from a related file‑validation bug to emphasize thorough testing during component upgrades.
MyBatis-Plus, an enhanced MyBatis toolkit, simplifies CRUD operations and injects dynamic SQL to boost productivity; this guide outlines its core features, important upgrade notes—including MyBatis 3.5.16 and JSqlParser 4.9 versions—provides a detailed changelog, and shows Maven dependencies for Spring Boot 3.x and 2.x.
This article details the major upgrades of WCDB, including expanded language support, a redesigned Winq SQL builder, robust data backup and repair mechanisms, seamless data migration, on‑the‑fly compression, automatic column addition, and performance optimizations such as interruptible transactions and WAL header improvements.
This article walks through replacing MyBatis with MyBatis‑Plus in a legacy Java project, uncovers the root cause of a LocalDateTime conversion error caused by MyBatis 3.5.1 and an outdated MySQL connector, demonstrates version upgrades and code fixes, and shares a related production bug and its remediation.
This article explains MyBatis dynamic SQL, its purpose, and how to use various tags such as if, where, trim, choose, foreach, include, sql, resultMap, association, and collection, providing detailed code examples and best‑practice guidelines for building flexible and secure SQL statements in Java applications.
This article explains MyBatis dynamic SQL concepts, details the nine dynamic tags (if, where, set, choose, trim, foreach, sql, include, association), provides complete XML mapper examples with code snippets, and demonstrates one‑to‑many, many‑to‑one, and many‑to‑many association queries for Java backend development.
This guide shows how to install ThinkORM for PHP 8, then demonstrates inserting, querying, and updating JSON‑type columns both with raw queries and model classes, covering whole‑JSON operations, conditional searches, and handling JSON arrays in a ThinkPHP environment.
This tutorial explains how to create a lightweight Python ORM without using metaclasses, covering the design of Field, Compare, Model, and Query classes, demonstrating insert and select operations, and extending query capabilities with LIMIT, OFFSET, GROUP BY, and HAVING.
This article explains Laravel's Eloquent ORM relationship loading methods, comparing the eager-loading `with` function and the lazy-loading `load` function, detailing their mechanisms, advantages, cautions, appropriate use cases, and providing practical code examples for backend developers.
This article introduces Easy-Es, an ORM framework built on Elasticsearch's RestHighLevelClient, explains its architecture and advantages, and provides step‑by‑step instructions—including Maven/Gradle setup, configuration, entity and mapper creation, and full CRUD test examples—so developers can quickly integrate powerful search capabilities into Spring Boot applications.
This article introduces Easy-Es, an Elasticsearch ORM that mimics MyBatis‑Plus syntax, explains its key features, shows how to integrate it into a Spring Boot project, and provides comprehensive code examples for index management, CRUD, simple and advanced product searches, recommendation and aggregation functionalities.
Easy-Query is a Java ORM framework offering strong-typed, database-agnostic CRUD operations, complex SQL generation, multi-table joins, group awareness, and extensive function support, demonstrated through numerous code examples covering queries, joins, subqueries, pagination, and advanced features like enum handling and anonymous type alternatives.
Easy-Es is a Java ORM framework built on Elasticsearch's RestHighLevelClient that simplifies search‑engine development, offers Mybatis‑Plus‑like usage, provides configuration and dependency details, and includes complete code examples for creating indexes and performing CRUD operations within Spring Boot applications.
This article explains how Ecotone abstracts database access in PHP by mapping domain objects to tables, hiding low‑level DAO code behind business interfaces, and providing annotations for inserts, updates, custom converters, expression language, pagination, result‑set transformation, and integration with Doctrine ORM and Eloquent models.
In 2024 the Prisma ORM outperforms TypeORM for Node.js projects thanks to more frequent updates, richer ecosystem, superior type safety, simpler integration, built‑in pagination and aggregation features, and a dramatically better developer experience illustrated with real code examples.
Learn how to connect Go applications to MySQL using the native driver and the GORM ORM, covering driver installation, basic connection code, database configuration, query execution, and best practices for model definition and handling common pitfalls.
This article explains how to use MyBatis's @MapKey annotation to map query results into a Java Map, compares common data‑retrieval approaches, provides a concrete example with mapper code, and delves into the internal parsing and result‑handling mechanisms that enable key‑value mapping.
This article provides a comprehensive, step‑by‑step analysis of MyBatis, covering its core features, three‑layer architecture, configuration file parsing, dynamic proxy generation, and the detailed process of executing SQL statements within the framework.
This article introduces MyBatis-Plus, an enhancement layer for MyBatis, and walks through its core features—non‑intrusive CRUD, Lambda queries, primary‑key strategies, automatic field filling, optimistic locking, pagination, logical delete, performance analysis, condition builders, and a code generator—providing complete code examples and configuration steps for Spring Boot integration.
This article provides a detailed, global‑level review of MyBatis, covering its main features such as SQL mapping, dynamic SQL, parameter and result mapping, transaction management, connection‑pool integration, second‑level cache, as well as the three‑layer architecture, configuration parsing, proxy creation, and SQL execution process.
This article explains MyBatis's first‑level and second‑level cache mechanisms, illustrates common consistency problems caused by default cache settings in both distributed and single‑session scenarios, and provides practical recommendations such as adjusting localCacheScope or deep‑copying results to avoid cache pitfalls.
This article examines the various design patterns—such as Factory, Singleton, Builder, Adapter, Proxy, Composite, Decorator, Template, Strategy, and Iterator—employed within the MyBatis source code, explaining their structures, usage scenarios, and related components to illustrate how the framework achieves modularity and flexibility.
This tutorial walks through creating a lightweight Go ORM—covering a custom logger, converting structs to table metadata, implementing basic CRUD operations, handling transactions, and adding hook callbacks—while exposing the core Session data structure and providing a GitHub reference.
This article explains how to use the MyBatis @MapKey annotation to map query results into a Java Map, provides a concrete code example, and delves into the internal processing steps—including MapperProxy, MapperMethod, MethodSignature, and DefaultMapResultHandler—that enable this functionality.
This article introduces MyBatis‑Flex, a lightweight and high‑performance MyBatis enhancement framework, outlines its key features, compares it with similar tools, presents benchmark results, lists supported databases, and provides a step‑by‑step quick‑start tutorial with complete code examples for Spring Boot integration.
Learn how to leverage MyBatis-Plus's built-in CRUD capabilities, create custom SQL methods like SelectByErp, integrate them via a custom SqlInjector, and modify existing operations such as AlwaysUpdateSomeColumnById and UpdateById for sharding scenarios, enabling reusable and efficient data access across your backend.
This article walks through the step‑by‑step evolution from raw JDBC to the MyBatis framework, explaining why JDBC should be wrapped, how MyBatis improves connection handling, SQL management, dynamic statements, result mapping, caching, and overall architecture with concrete code examples.
This article provides a comprehensive, step‑by‑step overview of MyBatis’s architecture—including its three‑layer design, configuration parsing, proxy generation, and SQL execution process—while highlighting key features such as SQL mapping, dynamic SQL, parameter and result mapping, transaction management, connection‑pool integration, and second‑level caching.
The article provides a detailed technical comparison of MyBatis-Flex with MyBatis-Plus and Fluent-MyBatis, covering feature matrices, code examples for basic queries, aggregation, complex conditions, multi‑table joins, partial updates, and a step‑by‑step Spring Boot integration guide, before concluding on its maturity and suitability for production.
This tutorial explains how to add enum types to GORM models in Go, covering definition of enum values, model integration, CRUD operations using enums, and alternative approaches such as string fields, custom types, and GORM's built‑in enum tag to enhance type safety and database reliability.
This tutorial walks through MyBatis-Plus's advanced capabilities—including high‑performance batch inserts, logical deletion with global config, automatic timestamp and user fields via MetaObjectHandler, JSON type handling, dynamic table name resolution, and multi‑tenant support—showing concrete code, configuration, and benchmark results for each feature.
This article introduces MyBatis-Plus, outlines its non‑intrusive features and CRUD enhancements, walks through integrating it with a Spring Boot project, demonstrates entity, mapper and service definitions, explains common annotations, showcases the powerful Wrapper condition builder, and covers pagination configuration for everyday backend development.
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.
This article introduces Easy-Es, a Java ORM framework built on Elasticsearch's RestHighLevelClient that simplifies query construction and CRUD operations, provides step‑by‑step setup including Maven dependencies, configuration, entity and mapper definitions, controller examples, and advanced features such as condition builders, index management, logging, and aggregation queries.
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.
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.
This article demonstrates how to implement a statistical query on a student_score table using three ORM frameworks—Fluent Mybatis, native Mybatis, and Mybatis‑Plus—showing code examples, configuration steps, and a side‑by‑side comparison of their ease of use and generated code.
Version 3.5.4‑SNAPSHOT of MyBatis‑Plus introduces auto‑increment primary key handling, generic extraction, new BaseMapper update and streaming query methods, batch operations, expanded Spring Boot 3 support, numerous dependency upgrades, and a series of optimizations and bug fixes that improve performance, compatibility, and developer ergonomics.
This article demonstrates how to implement a statistical query on a student_score table—calculating count, min, max, and average scores per term and subject—using Fluent Mybatis, native Mybatis, and Mybatis‑Plus, compares their code complexity, and provides code generation settings for each framework.
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.
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.
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.
MyBatis-Flex is a lightweight, high‑performance enhancement to MyBatis that offers flexible query tools, extensive database support, and impressive speed gains over MyBatis‑Plus, with a step‑by‑step quick‑start guide for Spring Boot integration.
Bean Searcher is an open‑source Java library that delivers a condition‑retrieval engine up to 100 times faster than MyBatis, natively supports multi‑table joins, pagination, sorting and aggregation, and enables developers to implement sophisticated list‑search APIs with a single line of code, dramatically reducing backend development effort.
This article explains MyBatis dynamic SQL, its powerful XML tags, how to build conditional queries, batch operations, and association mappings, providing clear code examples and best‑practice tips for Java backend developers.
This article introduces MyBatis‑Flex, a lightweight yet high‑performance MyBatis enhancement framework, outlines its key features, compares it with similar tools, lists supported databases, and provides a step‑by‑step Spring Boot quick‑start tutorial with complete code examples.
This article provides a step‑by‑step tutorial on integrating MyBatis‑Plus into a Spring Boot project, covering dependency setup, configuration of data sources, entity annotations, CRUD operations, pagination, logical deletion, enum handling, automatic field filling, and multi‑datasource usage with complete code examples.
This article evaluates MyBatis-Plus (MP) for Java backend development, highlighting its convenient CRUD shortcuts, code examples, maintenance challenges, magic value pitfalls, and recommended practices such as using LambdaQueryWrapper, pagination, and avoiding overly complex SQL within MP.
This article introduces MyBatis‑Flex, a lightweight yet powerful MyBatis enhancement framework, outlines its key features and advantages, compares it with similar tools, presents performance benchmarks, lists supported databases, and provides a step‑by‑step quick‑start tutorial with code examples for Spring Boot integration.
This article examines MyBatis-Plus, highlighting its convenient CRUD shortcuts and pagination features while warning about maintenance challenges, magic strings, and limited support for complex SQL, and offers practical recommendations for using LambdaQueryWrapper and organizing queries in backend Java projects.
This article introduces the MyBatis-Flex ORM framework, highlights its lightweight, flexible, and high‑performance design, compares its features and benchmark results with MyBatis‑Plus, and provides practical code examples for queries, multi‑table joins, partial updates, data masking, multi‑datasource support, and field encryption.
This article introduces MyBatis-Flex, a lightweight high‑performance MyBatis enhancement framework, outlines its key features, compares it with MyBatis‑Plus and Fluent‑MyBatis, lists supported databases, and provides a step‑by‑step quick‑start tutorial with code examples.
This article examines the ongoing debate around MyBatis‑Plus, highlighting its convenience for simple CRUD operations, the maintenance challenges it introduces, and practical guidelines—such as using LambdaQueryWrapper and pagination plugins—to decide when the framework is appropriate for Java backend projects.
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.
This article explains how MyBatis implements first‑level (session) and second‑level (cross‑session) caches, the conditions required for each to work, why the first‑level cache often fails in Spring Boot without transactions, how to enable and use the second‑level cache safely, and the hidden risks of stale data when different mappers share related tables.
This article introduces BeetlSQL's recent updates—including Oracle12Style support and a version upgrade—provides the Maven dependency configuration, lists the wide range of databases it works with, and presents detailed benchmark comparisons against other ORM frameworks.
This article explains how MyBatis delegates SQL execution to four core objects—Executor, StatementHandler, ParameterHandler, and ResultSetHandler—detailing their architecture, implementations such as SimpleExecutor, ReuseExecutor, BatchExecutor, and demonstrating three common batch insertion techniques with code examples.
Easy-Trans is a Spring Boot starter that leverages ORM frameworks like MyBatis‑Plus, JPA, and BeetlSQL to automatically translate IDs, dictionary codes, and enum values into human‑readable data, supporting caching, multi‑data‑source, micro‑service RPC, and flexible configuration for backend developers.
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.
This article explains what SQL injectors are in MyBatis‑Plus, lists the built‑in extended injectors, shows how to configure them globally, demonstrates custom mapper creation, provides complete code examples and test cases, and guides readers through building their own SQL injector for full‑field updates and batch operations.
This article introduces the MyBatis‑Plus‑Join library that adds join capabilities to MyBatis‑Plus, explains how to install it via Maven or Gradle, shows how to extend mapper and service interfaces, and provides detailed code examples for simple three‑table queries, pagination, and advanced custom SQL usage.
This article analyzes how 33% of data‑center defects stem from big‑data scheduling errors and proposes an automated testing system that monitors data metric integrity, accuracy, and timeliness through interface automation, visual dashboards, alert bots, and a custom ORM framework to dramatically improve ROI.
This article provides a step‑by‑step guide to building a PHP MVC framework from scratch, covering MVC basics, directory structure, routing, controllers, models, views, core utilities, and includes sample code snippets throughout for developers.
This tutorial shows how to use the MyBatis‑Plus‑Join (MPJ) extension to perform left‑join queries, modify mappers, build queries with MPJLambdaWrapper and MPJQueryWrapper, and add pagination, eliminating the need for manual XML SQL while improving development efficiency.
This article provides a detailed tutorial on setting up MyBatis Generator in a Spring Boot application, covering configuration file placement, XML adjustments, Maven dependencies, execution steps, and the resulting model, mapper, and XML files with full code examples.
SQLAlchemy 2.0.7 has been released, addressing a critical caching bug in custom operator expressions, fixing typing issues with composite(), adding the PostgreSQL CITEXT type, and improving dialect compatibility, with all changes back‑ported to earlier stable releases.
This article provides a detailed introduction to MyBatis‑Plus, covering its core features, step‑by‑step quick‑start instructions, CRUD operations, advanced configurations such as optimistic locking, logical deletion, pagination, performance analysis, and the built‑in code generator, all illustrated with complete Java code examples.
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.
This tutorial walks through integrating MyBatis‑Plus into a Spring Boot project, covering dependency setup, configuration of data sources, entity annotations, service and mapper layers, pagination, logical deletion, enum handling, automatic field filling, multi‑datasource support, and testing with full code examples.
The article explains how to replace repetitive raw SQL and manual row scanning in Go by building a lightweight custom ORM that combines a chainable SQLBuilder for dynamic query construction with a reflection‑based Scanner that maps results to structs, also covering code generation and optional non‑reflection optimizations.
This article presents the architecture, technology choices, and practical implementation details of FairPushy—a Dart‑driven backend and Flutter dynamic‑update platform—covering server development, concurrency handling, ORM integration, automated build pipelines, and deployment strategies for seamless hot‑reloading of mobile applications.
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.
This tutorial demonstrates how to use the MyBatis-Plus-Join (MPJ) library to perform left and right join queries in a Spring Boot project without writing XML SQL, covering dependency setup, mapper modification, query construction with MPJLambdaWrapper and MPJQueryWrapper, and pagination support.
This tutorial explains how to integrate MyBatis into a Spring Boot project, covering setup, basic CRUD examples, dynamic SQL techniques, one‑to‑one and one‑to‑many mappings, pagination support, and provides complete code snippets for each step.
This guide walks you through integrating MyBatis with Spring Boot, covering basic CRUD operations, dynamic SQL constructs like if, choose, where, set, foreach, as well as advanced mapping techniques, pagination plugins, and practical code examples to help you master MyBatis in real-world projects.
This article explains how MyBatis-Plus's saveOrUpdate method works, why a primary‑key annotation is required, and how to control insert or update operations using UpdateWrapper or QueryWrapper, including code examples, common pitfalls, and practical tips for handling auto‑increment IDs.
This article walks through MyBatis's complete query lifecycle—from configuration parsing, SqlSessionFactory creation, and mapper loading to the actual SELECT execution—while reproducing a pre‑3.4.5 bug caused by foreach variable leakage and presenting the official fix and upgrade recommendations.
This article explains how MyBatis‑Plus maps Mapper interface methods to executable SQL statements, detailing the auto‑configuration of SqlSessionFactory, XML parsing, mapper registration, SQL injection, and the dynamic proxy mechanism used at runtime.
This article compares Fluent MyBatis, native MyBatis, and MyBatis Plus by implementing a student score aggregation query, showcasing code examples, generator settings, and a detailed feature matrix to help developers choose the most efficient ORM for complex SQL construction.
This comprehensive guide explains MyBatis fundamentals, compares it with Hibernate, details its lifecycle, configuration, dynamic SQL, caching, lazy loading, batch operations, pagination, and plugin development, providing code examples and best‑practice recommendations for Java backend developers.
This article explains how Lombok annotations such as @Data, @Builder, @Wither, and @Accessors can simplify Java bean creation for ORM entities, builder pattern utilities, wither-style object modification, and fluent accessor methods, while addressing common pitfalls like missing constructors and default values.
The article demonstrates how to implement lightweight field-level encryption in MyBatis by adding encrypted columns, creating a custom interceptor that encrypts annotated parameters on write and decrypts them on read, handling executor, statement, parameter, and result set processing, and addressing pagination count queries.