作为开源的Orm对象映射框架,ibatis是一个线程安全,学习容易,但是开发相对于hibernate来说的话,就要繁锁些,没有很好的工具支持ibatis所有的配置几乎是通过手写,这样增加了开发者的难度、、好啦,言归正转。下面编写实现。
一、引入spring,ibatis jar包.
二、编写log4j.properties日志文件
log4j.rootLogger=DEBUG,stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%c{1}% - %m%n
log4j.logger.java.sql.PreparedStatement=DEBUG
三、建立Student.java类映象属性
package org.terry.ibatis.pojo;
public class Student {
private Long id;
private String name;
private String subject;
private Long score;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Long getScore() {
return score;
}
public void setScore(Long score) {
this.score = score;
}
public String getSubject() {
return subject;
}
public void setSubject(String subject) {
this.subject = subject;
}
}
四、编写 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">
<typeAlias alias="student" type="org.terry.ibatis.pojo.Student"/>
<resultMap class="student" id="studentResult">
<result property="id" column="id" jdbcType="number" javaType="java.lang.Long"/>
<result property="name" column="name"/>
<result property="subject" column="subject"/>
<result property="score" column="score"/>
</resultMap>
<select id="selectAll" resultMap="studentResult">
select * from student
</select>
<select id="findbyId" parameterClass="java.lang.Long" resultClass="student">
select * from student where id=#id#
</select>
<insert id="insert" parameterClass="student">
insert into student(id,name,subject,score) values(#id#,#name#,#subject#,#score#)
</insert>
<update id="update" parameterClass="student">
update student set name=#name#,subject=#subject#,score=#score# where id=#id#
</update>
<delete id="delete" parameterClass="java.lang.Long">
delete from student where id=#id#
</delete>
</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>
<sqlMap resource="org/terry/ibatis/pojo/student.xml"/>
</sqlMapConfig>
六、编写 StudentDao.java(实现类)
package org.terry.ibatis.dao;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.orm.ibatis.SqlMapClientCallback;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.terry.ibatis.pojo.Student;
import com.ibatis.sqlmap.client.SqlMapExecutor;
public class StudentDao extends SqlMapClientDaoSupport implements Idao{
public void delete(Long id) {
this.getSqlMapClientTemplate().delete("delete", id);
}
public Object findbyId(Long id) {
return this.getSqlMapClientTemplate().queryForObject("findbyId", id);
}
public List getAll() {
return (List)this.getSqlMapClientTemplate().execute(new SqlMapClientCallback(){
public Object doInSqlMapClient(SqlMapExecutor sqlMapper) throws SQLException {
return sqlMapper.queryForList("selectAll");
}
});
}
public void save(Object o) {
this.getSqlMapClientTemplate().insert("insert", o);
}
public void update(Object o) {
this.getSqlMapClientTemplate().update("update", o);
}
public static void main(String[] args) throws IOException {
Resource re=new ClassPathResource("Ibatis-Context.xml");
XmlBeanFactory xml=new XmlBeanFactory(re);
StudentDao student=(StudentDao)xml.getBean("studentDao");
Student stu=new Student();
stu.setId(Long.valueOf(16));
stu.setName("terry");
stu.setScore(Long.valueOf(99));
stu.setSubject("数学");
student.delete(Long.valueOf(16));
}
}
七、配置 ApplicationContext.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@localhost:1521:orcl</value>
</property>
<property name="username">
<value>terry</value>
</property>
<property name="password">
<value>terry</value>
</property>
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="SqlMapConfig.xml"/>
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 配置事务拦截器 -->
<bean id="transactionIterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
<!-- 事务拦截器需要注入一个事务管理器 -->
<property name="transactionManager" ref="transactionManager"></property>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED</prop>
<prop key="find*,get*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
<bean class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
<property name="beanNames">
<list>
<value>*Dao</value>
</list>
</property>
<property name="interceptorNames">
<list>
<value>transactionIterceptor</value>
</list>
</property>
</bean>
<bean id="studentDao" class="org.terry.ibatis.dao.StudentDao">
<property name="sqlMapClient" ref="sqlMapClient"></property>
</bean>
</beans>
这样Ibatis 集成 Spring就实现啦