ibatis与spring继承

作为开源的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>