Tutorial ibatis

Data Mapper
(a.k.a SQL Maps)

Version 2.0

Developer Guide

August 9, 2006

Developer Guide

iBATIS Data Mapper 2.0

2

Table of Contents
Introduction.......................................................................................................................................................3 DataMapper..................................................................................................................................................... 3 Installation........................................................................................................................................................ 4 Upgrading from1.x.....................................................................................................................................5 The SQL Map XML Configuration File ..........................................................................................................7 The Element...........................................................................................................................8 TheElement...............................................................................................................................8 The Element......................................................................................................... 10 The Element......................................................................................................................... 11 TheElement......................................................................................................... 11 The Element.......................................................................................................................12 The Element.............................................................................................................................15 The SQL Map XML File............................................................................................................................... 16 Mapped Statements.........................................................................................................................................17 StatementTypes........................................................................................................................................ 17 The SQL....................................................................................................................................................19 Reusing SQL Fragments........................................................................................................................... 19 Auto-GeneratedKeys................................................................................................................................20 Stored Procedures..................................................................................................................................... 21 Parameter Maps and Inline Parameters.......................................................................................................... 26 InlineParameter Maps.............................................................................................................................. 28 Primitive Type Parameters........................................................................................................................30 Map TypeParameters............................................................................................................................... 30 Result Maps.................................................................................................................................................... 31 Implicit Result Maps................................................................................................................................. 33 Primitive...