一个iBATIS的简单实现（含sql语句中表名等的动态传入）

 环境：

平台：netbeans IDE 6.5

引入包：classes12.jar、ibatis-2.3.4.726.jar

源程序包结构如下附件中的图片

 

ibatis配置文件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> <properties resource="ibatistest/config/SQLMapConfig.properties" /> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="true" /> <transactionManager type="JDBC" commitRequired="false"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="${driver}"/> <property name="JDBC.ConnectionURL" value="${url}"/> <property name="JDBC.Username" value="${username}"/> <property name="JDBC.Password" value="${password}"/> </dataSource> </transactionManager> <sqlMap resource="ibatistest/sqlmap/Ttree.xml" /> </sqlMapConfig>

 

数据库属性文件SQLMapConfig.properties如下：

driver=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@localhost:1521:db username=*** password=***

 

实体类Ttree.java（对应数据库中的一张表）：

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package ibatistest.entity; import java.util.List; /** * * @author */ public class Ttree { private int id; private String name; private String parentId; private String porderby; private String corderby; private String foldId; private int deltag; public String getCorderby() { return corderby; } public void setCorderby(String corderby) { this.corderby = corderby; } public int getDeltag() { return deltag; } public void setDeltag(int deltag) { this.deltag = deltag; } public String getFoldId() { return foldId; } public void setFoldId(String foldId) { this.foldId = foldId; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getParentId() { return parentId; } public void setParentId(String parentId) { this.parentId = parentId; } public String getPorderby() { return porderby; } public void setPorderby(String porderby) { this.porderby = porderby; } }

 

扩展实体类ExtEntity.java(用于传递值给映射文件中的sql语句)：

 /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package ibatistest.entity; /** * * @author */ public class ExtEntity { private int id; private String strtable; private String strcol; public String getStrcol() { return strcol; } public void setStrcol(String strcol) { this.strcol = strcol; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getStrtable() { return strtable; } public void setStrtable(String strtable) { this.strtable = strtable; } }

 

映射文件Ttree.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="Ttree"> <select id="getTree" parameterClass="ibatistest.entity.ExtEntity" resultClass="ibatistest.entity.Ttree"> SELECT $strcol$ FROM pubttree WHERE id = $id$ </select> <select id="getTrees" parameterClass="ibatistest.entity.ExtEntity" resultClass="ibatistest.entity.Ttree"> SELECT * FROM $strtable$ </select> <select id="getTreeByMap" parameterClass="java.util.Map" resultClass="ibatistest.entity.Ttree"> SELECT $mapstrcol$ FROM pubttree WHERE id = $mapid$ </select> </sqlMap>

 

SQLMapClient对象获取文件ConnectionDAO.java(用于读取配置文件，返回sqlmapclient对象)：

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package ibatistest.dao; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import java.io.Reader; import java.sql.SQLException; /** * * @author */ public class ConnectionDAO { private static final SqlMapClient sqlMap; static { try { String ss = "ibatistest/config/SQLMapConfig.xml"; Reader reader = Resources.getResourceAsReader(ss); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("Error initializing . Cause: " + e); }finally{ } } public static SqlMapClient getSqlMapInstance() { return sqlMap; } }

 

测试实例Example.java:

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package ibatistest.dao; import com.ibatis.sqlmap.client.SqlMapClient; import ibatistest.entity.ExtEntity; import ibatistest.entity.Ttree; import java.lang.reflect.Field; import java.lang.reflect.Method; import java.sql.SQLException; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.logging.Level; import java.util.logging.Logger; /** * * @author */ public class Example { public static void main(String[] arg){ try { SqlMapClient sqlMap = ConnectionDAO.getSqlMapInstance(); Integer id = new Integer(10); ExtEntity paraEntity = new ExtEntity(); paraEntity.setId(id); paraEntity.setStrtable("pubttree order by name"); paraEntity.setStrcol("name"); Ttree ttree = (Ttree) sqlMap.queryForObject("Ttree.getTree", paraEntity); System.out.println("name:"+ttree.getName()); System.out.println("id:"+ttree.getId()); List<Ttree> list = sqlMap.queryForList("Ttree.getTrees",paraEntity); System.out.println(list.size()); aa:for(Ttree e:list){ System.out.println("name1:"+e.getName()); break aa; } paraEntity.setStrtable("ttree"); list = sqlMap.queryForList("Ttree.getTrees",paraEntity); System.out.println(list.size()); bb:for(Ttree e:list){ System.out.println("name2:"+e.getName()); break bb; } Map paraMap = new HashMap(); paraMap.put("mapid", 10); paraMap.put("mapstrcol", "name,id"); ttree = (Ttree) sqlMap.queryForObject("Ttree.getTreeByMap", paraMap); System.out.println("name:"+ttree.getName()); System.out.println("id:"+ttree.getId()); } catch (SQLException ex) { Logger.getLogger(Example.class.getName()).log(Level.SEVERE, null, ex); } } }