Setup and Configuration
iBATIS is one of the best ORM mapping tools available
which maps the JDBC result sets to objects. It provides a clean separation
between SQLs and the objects which are mapped to result sets.
This helps DB Administrators to concentrate on SQLs and Java Developers on actual results.
DB Setup
02DROP USER ibatis_tests CASCADE;
03PROMPT Creating User ibatis_tests ...
04CREATE USER ibatis_tests IDENTIFIED BY ibatis_tests DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
05GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM TO ibatis_tests;
06connect ibatis_tests/ibatis_tests;
10 student_id number(8) primary key,
11 first_name varchar2(30) not null,
12 last_name varchar2(30) not null,
13 age number(3) not null,
15 hobby varchar2(30) not null
19CREATE SEQUENCE STUDENT_ID_SEQ
20 MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 NOCYCLE ;
01Insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY) Values
02 (STUDENT_ID_SEQ.NEXTVAL, 'Jim', 'Attic', 32, '+919999999999', 'Painting');
03Insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY) Values
04 (STUDENT_ID_SEQ.NEXTVAL, 'Raj', 'Kumar', 18, '+914444488888', 'Reading books');
05Insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY) Values
06 (STUDENT_ID_SEQ.NEXTVAL, 'Ram', 'Prasad', 24, '+918888888888', 'Painting');
07Insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY) Values
08 (STUDENT_ID_SEQ.NEXTVAL, 'Arjun', 'Mishra', 28, '+917777777777', 'Football');
09Insert into STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME, AGE, PHONE, HOBBY) Values
10 (STUDENT_ID_SEQ.NEXTVAL, 'Vishal', 'Pratap', 19, '+91666666666', 'Cricket');
iBatis Configuration iBATIS requires driver name, connection url, user name and password
as basic configuration parameters which has to be provided through SqlMapConfig.xml file.
The SQL Mapping Configuration file has to be in classpath.
01<?xml version="1.0" encoding="UTF-8"?>
02<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
06 <settings useStatementNamespaces="true" />
07 <transactionManager type="JDBC">
08 <dataSource type="SIMPLE">
09 <property name="JDBC.Driver" value="oracle.jdbc.OracleDriver" />
10 <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521/ORADBVENKAT" />
11 <property name="JDBC.Username" value="ibatis_tests" />
12 <property name="JDBC.Password" value="ibatis_tests" />
16 <sqlMap resource="basic/GetAll.xml" />
The mapping of SQLs and result sets has to be provided through sqlMap tag.
Next examples in this series shows mapping of STUDENT table with Student POJO.
package com.bethecoder.tutorials.ibatis.common; public class Student { private int studentId; private String firstName; private String lastName; private short age; private String phone; private String hobby; public Student () { } public Student ( String firstName, String lastName, short age, String phone, String hobby ) { super () ; this .firstName = firstName; this .lastName = lastName; this .age = age; this .phone = phone; this .hobby = hobby; } public int getStudentId () { return studentId; } public void setStudentId ( int studentId ) { this .studentId = studentId; } public String getFirstName () { return firstName; } public void setFirstName ( String firstName ) { this .firstName = firstName; } public String getLastName () { return lastName; } public void setLastName ( String lastName ) { this .lastName = lastName; } public short getAge () { return age; } public void setAge ( short age ) { this .age = age; } public String getPhone () { return phone; } public void setPhone ( String phone ) { this .phone = phone; } public String getHobby () { return hobby; } public void setHobby ( String hobby ) { this .hobby = hobby; } public String toString () { return "Student[" + studentId + ", " + firstName + ", " + lastName + ", " + age + ", " + hobby + ", " + phone + "]" ; } }
