iBATIS入门实例测试
1. 下载iBATIS相关jar包并导入MyEclipse工程;
2. 创建测试数据库Student,以Oracle为例(此项目使用Oracle自带序列DEPT_SEQ做测试);
id number(10),
name varchar2(20),
address varchar2(20),
3. iBATIS SqlMap 配置(SqlMapConfig.xml)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@localhost:1521:orcl" />
<property name="JDBC.Username" value="scott" />
<property name="JDBC.Password" value="tiger" />
</dataSource>
</transactionManager>
<sqlMap resource="com/mybatis/data/Student.xml" />
</sqlMapConfig>
4. POJO(Student)
private int id;
private String name;
private String address;
setters/getters省略
5． 映射文件(Student.xml)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="Student">
<!-- 设置pojo类的别名(shortName) -->
<typeAlias alias="Student" type="com.mybatis.domain.Student" />
<!-- 输出映射,输入为parameterMap -->
<resultMap id="StudentResult" column="id" />
<result property="name" column="name" />
<result property="address" column="address" />
</resultMap>
<!-- 查询所有 -->
<select id="selectAllStudents" resultMap="StudentResult">
select * from Student
</select>
<!-- 根据id查询 -->
<select id="selectStudentById" parameterresultparameterparameterparameter+ studentList.size());
// 根据id查询
try {
Student student = new Student();
int id = 97;
student = IBatisUtil.selectStudentById(id);
if (student != null) {
System.out.println("Result:" + student.getName() + "-"
+ student.getAddress());
} else {
System.out.println("Sorry,there is no result relates your given id!");
}
System.out.println(student.getId() + " " + student.getName() + " "
+ student.getAddress());
} catch (Exception e) {
e.printStackTrace();
}
// 插入
try {
Student student = new Student();
student.setName("zhang san");
student.setAddress("UPC");
IBatisUtil.insertStudent(student);
System.out.println("...insert successfully...");
} catch (Exception e) {
e.printStackTrace();
}
// 更新
try {
Student student = new Student();
student.setId(113);
student.setName("zhang san");
student.setAddress("CPU");
IBatisUtil.updateStudent(student);
System.out.println("...update successfully...");
} catch (Exception e) {
e.printStackTrace();
}
// 删除
try {
int id = 113;
IBatisUtil.deleteStudent(id);
System.out.println("...delete successfully...");
} catch (Exception e) {
e.printStackTrace();
}
}
}