iBATIS SQL Maps Tutorial

Short Description
iBATIS SQL Maps. Tutorial. For SQL Maps Version 2.0. February 18, 2006 … This brief tutorial will take you through a walkthrough of a typical use of SQL …

Website: ibatis.apache.org | Filesize: 175kb

Content
iBATIS SQL Maps
Tutorial
For SQL Maps Version 2.0
February 18, 2006Introduction
This brief tutorial will take you through a walkthrough of a typical use of SQL Maps. The details of each of
the topics below can be found in the SQL Maps developer guide available from http://ibatis.apache.org
Preparing to Use SQL Maps
The SQL Maps framework is very tolerant of bad database models and even bad object models. Despite
this, it is recommended that you use best practices when designing your database (proper normalization)
and your object model. By doing so, you will get good performance and a clean design.
The easiest place to start is to analyze what you’re working with. What are your business objects? What
are your database tables? How do they relate to each other? For the first example, consider the following
simple Person class that conforms to the typical JavaBeans pattern.
Person.java
package examples.domain;
//imports implied..
public class Person {
private int id;
private String firstName;
private String lastName;
private Date birthDate;
private double weightInKilograms;
private double heightInMeters;
public int getId () {
return id;
}
public void setId (int id) {
this.id = id;
}
//.let’s assume we have the other getters and setters…