Ibaties使用实例一

本实例是只使用ibaties进行的开发，后续会分享使用spring的例子。

?

第一步：编写sqlmap.xml文件

<?xml version="1.0" encoding="UTF-8"?>
?<!DOCTYPE sqlMapConfig
?PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
?"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
?
?<sqlMapConfig>
? <settings cacheModelsEnabled="true" enhancementEnabled="true"
?? lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
?? maxTransactions="5" useStatementNamespaces="false" />
?
? <transactionManager type="JDBC">
?
?? <dataSource type="SIMPLE">
??? <property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />
??? <property name="JDBC.ConnectionURL" value="jdbc:mysql:///test" />
??? <property name="JDBC.Username" value="root" />
??? <property name="JDBC.Password" value="root" />
?? </dataSource>
? </transactionManager>

? <sqlMap resource="com/warefont/pojo/Employee.xml" />
?</sqlMapConfig>

?

第二步：编写Employee.xml

<?xml version="1.0" encoding="UTF-8"?>
?<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
?<sqlMap namespace="employee">
? <insert id="insert_employee" parameterresultparameterparameterClass="com.warefont.pojo.Employee">
?? update employee set name=#name#,gender=#gender#,department=#department#
?? where id=#id#
? </update>
?</sqlMap>

第三步：将配置文件注入到程序中

package com.warefont.util;

import java.io.IOException;
import java.io.Reader;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class GetSqlMapClient {

?private static SqlMapClient sqlMapClient;

?static {
? String resource = "sqlMap.xml";
? Reader reader = null;
? try {
?? reader = Resources.getResourceAsReader(resource);
?? sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
? } catch (IOException e) {
?? e.printStackTrace();
? }
?}

?public static SqlMapClient getSqlMapInstance() {
? return sqlMapClient;
?}

}
第四步：使用

package com.warefont.dao;

import java.sql.SQLException;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.warefont.pojo.Employee;
import com.warefont.util.*;

public class EmployeeDao {

?public void insertEmp(Employee emp){
??SqlMapClient sqlMap = GetSqlMapClient.getSqlMapInstance();
??try {
???sqlMap.insert("insert_employee", emp);
??} catch (SQLException e) {
???e.printStackTrace();
??}
?}

}
第五步：测试

package com.warefont.test;

import com.warefont.dao.EmployeeDao;
import com.warefont.pojo.Employee;

public class Test {

?/**
? * @param args
? */
?public static void main(String[] args) {
??Employee emp = new Employee();
??emp.setDepartment("dept");
??emp.setGender("testGender");
??emp.setName("hewei");
??
??EmployeeDao empDao = new EmployeeDao();
??empDao.insertEmp(emp);
?}

}

PS：这只是一个简单的应用，但是包含了其基本的使用。