MyBatis SQL Query Implementation Techniques
UNION operations combine results from multiple tables while eliminating duplicate records:
<resultMap id="TransactionResult" type="com.example.Transaction">
<id column="txn_id" property="id"/>
<result column="order_ref" property="orderReference"/>
<result col ...
Posted on Tue, 14 Jul 2026 16:38:23 +0000 by r3dn3ck
Importing Excel Files with XML Column Mapping in ASP.NET
When handling Excel imports, hardcoding column indices or names can be fragile. A more resilient approach involves decoupling the Excel column headers from database model properties using an XML configuration file. This configuration maps the Excel header names to the corresponding database fields, allowing flexibility if the spreadsheet templa ...
Posted on Thu, 02 Jul 2026 16:13:56 +0000 by neoboffins
Implementing MyBatis XML ResultMap for Entity Associations
Relational database interactions often involve navigating relationships between tables. In MyBatis, the <resultMap> element provides a robust mechanism to map these relationships—One-to-One, One-to-Many, and Many-to-Many—directly to Java object graphs. This process relies heavily on the <association> and <collection> tags wit ...
Posted on Tue, 19 May 2026 05:08:37 +0000 by Bill H