Categories: All - properties

by aakarsh nair 17 years ago

524

iBatis Data Mapper 2.0

iBatis DataMapper 2.0 offers a comprehensive framework for mapping SQL database results to Java objects. It provides efficient caching mechanisms, allowing developers to store previously executed statement results to improve performance.

iBatis Data Mapper 2.0

iBatis DataMapper 2.0

SimpleDataSource

Resources

One page Java Beans Cource

Logging SQLMap Activity

Programming with Data Mapper API

Simple Dynamic SQL Elements

Dyanamic Mapped Statemetns

Caching Mapped Statement Results

Result Maps

Implicit Result Maps
Use resultClass attribute in select
for simple maps make column names match up to getter setters
properties
result

used to map result ma p property to java bean method

typeHandler

or com.ibatis.sqlmap.client.extensions.TypeHandlerCallback interface

implements com.ibatis.sqlmap.engine.type.TypeHandler

override ibatis type handler

used to specify custom types

resultMap

1:N requires a group by property

This sounds interesting how is this done ?

can specify 1:1 and 1:N relationships

descibe nested result map that can be resued

select

column must support primitve property type

Must be name of mapped statement

describe rel between obj and complex property

nullValue

value for nullabe object types

javaType

Used for Map and xml mapping types

explicitly specify java property type

jdbcType

for things like date where ??

columnIndex

optional/ minimal performance improvement

column

name of column in result set

property

name of java bean property

group by

used to identify unique rows

list of resutl map properties

extends

super properties always inserted before sub

used as base result Map

Name of another result map

class

or

fully qualified name of class

type alias

id

Subtopic

Parameter maps and Inline Parameters

Mapped Statements

SQL Map File

SQL Map XML Configuration File

Installation

Introduction

Param Object
Primitive (Integer,String
Map
JavaBean
Concept
Easy map Java Beans to PreparedStatement params and Results