iBATIS SQL Maps

iBATIS SQL Maps

What is iBATIS?

How is iBATIS different?

Why “iBATIS”?

How does it work?

How does it work? (cont’d)

iBATIS SQL Maps

Person.java

sqlMapConfig.xml

The SQL Map file (Person.xml)

Person.xml (cont’d)

A simple DAO

A simple DAO (cont’d)

iBATIS SQL Maps

Auto-mapping (of results)

Explicit mapping

Parameter maps

Using JavaBean mapped properties

Parameter maps (cont’d)

Using properties from java.util.Map

SqlMapClient

SqlMapExecutor

Result Maps

Result Maps (cont’d)

iBATIS SQL Maps

Complex properties (aggregation)

Complex properties (cont’d)

iBATIS SQL Maps

Configuring SQL Maps

Inserting data

Stored Procedures

Dynamic Mapped Statements

Logging

Conclusions