ibatis快速入门(仅需两天)绝对经典,值得收藏.doc

Ibatis开发要点Ibatis提供了一种半自动化的O/R Mapping实现框架。它以牺牲工作量和移植性的代价换取了SQL语句设计的自由性和可优化性。典型Ibatis配置文件 /是否使用statment命名空间 /传统JDBC事务支持 /简单数据库连接池，对应SimpleDataSourceFactory /数据库连接池最大连接数 /允许挂起连接数 /连接任务允许占用最大时间 /允许等待最长时间 /连接状态检测语句 /是否开启连接状态检测 /连接状态检测时间设定 /空闲状态检测时间设定 !- JNDI /使用J2EE容器实现DataSource，对应实现类JndiDataSourceFactory - !- JTA /使用容器提供的JTA服务实现全局事务管理 - User模型类public class User implements Serializable private Integer id; private String name; private Integer sex; public User() public User(Integer id,String name,Integer sex) this.id=id; =name; this.sex=sex; public Integer getId() return id; public void setId(Integer id) this.id = id; public String getName() return name; public void setName(String name) = name; public Integer getSex() return sex; public void setSex(Integer sex) this.sex = sex; 模型类映射文件 /设置映射路径 /设置缓存类型 /设置缓存有效期 /执行特定statment是清空缓存 /设置缓存大小 /resultMap结果映射 /parameterClass参数类 /resultClass结果类 测试类 public void testIbatisSqlMap() throws SQLException String resource=sqlmap-config.xml; try Reader reader=Resources.getResourceAsReader(resource); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); /SqlMapClient核心类 try sqlMap.startTransaction();/ User user=new User();/ user.setId(new Integer(1);/ user.setName(Samantha);/ user.setSex(new Integer(11);/ sqlMap.insert(insertUser,user); Integer key=new Integer(2); User user1=(User)sqlMap.queryForObject(getUserById,key); sqlMmitTransaction(); System.out.println(user1.getName(); catch (SQLException e) e.printStackTrace(); finally sqlMap.endTransaction(); catch (IOException e) e.printStackTrace(); Ibatis高级特性：1.数据关联：（一对多关联） 对应代码：public void testIbatisSqlMap() throws SQLException, IOException String resource = sqlmap-config.xml; Reader reader = Resources.getResourceAsReader(resource); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); / sqlMap系统初始化完毕 List userList = sqlMap.queryForList(User.getUsers, 2); for (int i = 0; i + user.getName(); for (int k = 0; k user.getAddresses().size(); k+) Address addr = (Address)user.getAddresses().get(k); System.out.println(new String(addr.getAddress(); 这种对应在大数据量的情况下会产生性能问题如果是一对一关系： 2.延迟加载：当真正访问对象时才执行SQL语句，提高了系统性能。3.动态映射 (name like #name#) (address like #address#) 一元判定：is(Not)PropertyAvailable，is(Not)Null，is(Not)Empty二元判定：is(Not)Equal，isGreatThan，isGreatEqual，isLessThan，isLessEqual4.事务管理传统JDBC事务：try sqlMap.startTransaction(); . sqlMmitTransaction();finally sqlMap.endTransaction();JTA事务管理：提供了跨数据库事务管理能力外部事务管理：UserTransaction tx=new InitialContext().lookup(.);.mit();5.Cachereadonly、serialize(全局数据缓存)特性Type：MEMORY、LRU、FIFO、OSCACHESoftReference、WeakReference、PhantomReference Ibatis in Spring：接口：public interface IUserDAO public void insertUser(User user);实现类：public class UserDao extends SqlMapClientDaoSupport implements IUserDAO public void insertUser(User user) getSqlMapClientTemplate().update(insertUser,user); 模型类配置文件： INSERT INTO users(username,password) VALUES (#username#,#password#) 拦截器：public class SqlInterceptor extends SqlMapClientDaoSupport implements MethodInterceptor public Object invoke(MethodInvocation invocation) throws Throwable /可以doSomething Object returnValue=null; /可以doSomething returnValue=ceed(); return returnValue; ibatis配置文件： Spring配置文件： Spring Ibatis /DBCP连接数据库 com.p6spy.engine.spy.P6SpyDriver /利用P6Spy来显示执行的SQL语句 jdbc:mysql:/localhost:3306/mysql root password sqlmap-config.xml /实现一个拦截器 /设置切点 .*insert.* /设置代理类 com.ibatis.ao.IUserDAO myPointcutAdvisor 附：perties配置文件module.log=com.p6spy.engine.logging.P6LogFactoryrealdriver=com.mysql.jdbc.Driverderegisterdrivers=trueexecutionthreshold=outagedetection=falseoutagedetectioninterval=filter=falseinclude = exclude =sqlexpression = autoflush = truedateformat=includecategories=excludecategories=info,debug,result,batchstringmatcher=stacktrace=falsestacktraceclass=reloadproperties=falsereloadpropertiesinterval=60useprefix=falseappender=com.p6spy.engine.logging.appender.StdoutLoggerappend=truelog4j.appender.STDOUT=org.apache.log4j.ConsoleAppenderlog4j.appender.STDOUT.layout=org.apache.log4j.SimpleLayoutlog4j.appender.STDOUT.layout.ConversionPattern=p6spylog4j.logger.p6spy=DEBUG,STDOUT测试类：public void testIbatisSqlMap() ApplicationContext ctx=new FileSystemXmlApplicationContext(ibatiscontext.xml); IUserDAO userdao=(IUserDAO)ctx.getBean(userDAOProxy); User user=new User(); user.setUsername(Samantha); user.setPassword(miss); userdao.insertUser(user); 对dao配置文件举例说明： 1.来一个Person类 package com.Jdnis.ibatis.model;import java.io.Serializable;import java.sql.Date;public class Person implements Serializable private static final long serialVersionUID = 1L;private int id ;private String firstName ;private String lastName ;private Date birthDate = new Date(1900,1,1);private double weight ;private double height ;public int getId() return id;public void setId(int id) this.id = id;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 Date getBirthDate() return birthDate;public void setBirthDate(Date birthDate) this.birthDate = birthDate;public double getWeight() return weight;public void setWeight(double weight) this.weight = weight;public double getHeight() return height;public void setHeight(double height) this.height = height;2.oop编程中，面向接口编程是一种很好的编程风格。在这一步骤中，定义Person实例的一个操作接口： package com.Jerfaces;import java.util.List;import com.ibatis.dao.client.Dao;import com.Jdnis.ibatis.model.Person;public interface PersonInterface extends Dao public void insertPerson(Person p); public void updatePerson(Person p); public List selectAllPerson( );3.对接口的实现类 package com.Jerfaces;import java.sql.SQLException;import java.util.List;import com.ibatis.dao.client.DaoManager;import com.ibatis.dao.client.template.SqlMapDaoTemplate;import com.Jdnis.ibatis.model.Person;public class PersonImpl extends SqlMapDaoTemplate implements PersonInterface public PersonImpl(DaoManager daoManager) super(daoManager);/ TODO Auto-generated constructor stubpublic void insertPerson(Person p) / TODO Auto-generated method stubtry this.getSqlM