spring集成ibatis问题

0 0

spring集成ibatis问题 10

applicationContext.xml


    <tx:advice id="txAdvice" transaction-manager="txManager">

        <tx:attributes>

          <tx:method name="add*" propagation="REQUIRED"/>

          <tx:method name="del*" propagation="REQUIRED"/>

          <tx:method name="update*" propagation="REQUIRED"/>

          <tx:method name="*" read-only="true"/>

      </tx:attributes>

    </tx:advice>



    

    <aop:config>

      <aop:pointcut id="allManagerMethod" expression="execution(* add*(..))"/>

      <aop:advisor advice-ref="txAdvice" pointcut-ref="allManagerMethod"/>

    </aop:config>

    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

    <property name="dataSource" ref="dataSource"/>

    </bean>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

        <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>

        <property name="url" value="jdbc:sqlserver://localhost:1433;databasename=test"/>

        <property name="username" value="sa"/>

        <property name="password" value=""/>

    </bean>

<bean id="userDAO" class="dao.imp.BeanDaoImp">

    <property name="sqlMapClient" ref="sqlMapClient"/>

</bean>

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

    <property name="configLocation"> <value>classpath:SqlMapConfig.xml </value> </property>

    <property name="dataSource" ref="dataSource"> </property>

</bean>

SqlMapConfig.xml
<sqlMapConfig>

    <settings

      lazyLoadingEnabled="true"

        useStatementNamespaces="true" />

<sqlMap resource="com/tx/vo/Users.xml"/>

</sqlMapConfig>

Users.xml
<sqlMap namespace="Users">

    <typeAlias alias="users" type="com.tx.vo.Users"/>

    <cacheModel id="usersCache" type="MEMORY" readOnly="false" serialize="true">
        <flushInterval hours="24"/>
        <flushOnExecute statement="Users.update"/>
        <flushOnExecute statement="Users.insert"/>
        <flushOnExecute statement="Users.delete"/>
    </cacheModel>

    <resultMap id="usersResult" class="users">
    <result property="id" column="id"/>
        <result property="username" column="username"/>
        <result property="age" column="age"/>
    </resultMap>

    
    <select id="getAll" resultClass="users"> 
        SELECT
        id,
            username,
            age
        FROM users
    </select>

    <select id="getById" resultMap="usersResult" parameterClass="java.lang.Integer">
        SELECT id,username, age
        FROM users
        WHERE id = #value#
    </select>

    <update id="update" parameterClass="users">
        UPDATE users
        SET
            username = #username#,
            age = #age#
        WHERE id = #id#
    </update>

    <insert id="insert" parameterClass="users" >
        INSERT INTO users (username, age)
        VALUES (#username#, #age#)
    </insert>

    <delete id="delete" parameterClass="java.lang.Integer">
        DELETE FROM users WHERE id = #value#
    </delete>
</sqlMap>

dao.imp.BeanDaoImp.java
public class BeanDaoImp extends SqlMapClientDaoSupport implements BeanDao {

    public void addBean(Users u) {
this.getSqlMapClientTemplate().insert("Users.insert", u);
    }
}

测试类
ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
        BeanDao dao = (BeanDao) ctx.getBean("userDAO");
        Users u = new Users();
        u.setId(22);
        u.setUsername("tx");
        dao.addBean(u);

我现在程序执行到
this.getSqlMapClientTemplate()都没事，一调this.getSqlMapClientTemplate().insert("Users.insert", u);
就出错
java.lang.NoSuchMethodError: com.ibatis.sqlmap.client.SqlMapSession.getCurrentConnection()Ljava/sql/Connection;

iBATIS

2008年8月27日 13:42

magiclaugh3
20
0 0 0

2个答案按时间排序按投票排序

0 0

推荐你在JAVAEYE上搜索SUNCMS这个关键字，这个系统SPRING,IBATIS集成的比较好，我就是根据这个学的！

2008年8月28日 14:02

lijie250
70
0 0 1

添加评论

0 0

java.lang.NoSuchMethodError: com.ibatis.sqlmap.client.SqlMapSession.getCurrentConnection()Ljava/sql/Connection; ，一般来说java.lang.NoSuncMethodError都是由于加的jar的版本的问题，如用MyEclipse不要用它集成的包，自己单独加上所学的包，同一个包确保只有一个，以免引起错误

2008年8月27日 14:24