ibatIS需要注意的几个地方,否则很容易出错,避免低级错误的方法:
1.AmsReturnInfo.xml中,必须要定义namespace
2.AmsReturnInfoxml中 parameterClass="java.util.Map"
resultClass="HashMap"
注意:parameterClass是要传的参数;resultClass是返回值类型。这两个值不对触发'无效的对象类型异常'
3.sql-map-config.xml中一定要加入自己编写的AmsReturnInfo.xml引用,否则ibatIS无法找到,从而会报There is no statement named XXX in this SqlMap.
<sqlMapConfig>
<!-- <properties resource="com/bams/config/SqlMapOracle.properties"/>
<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>
Oracle的配置文件以后补充
<sqlMap resource="com/sample/pojo/oracle/Student.xml"/>
<sqlMap resource="com/sample/pojo/oracle/Book.xml"/>
<sqlMap resource="com/sample/pojo/oracle/ListTeacherStudent.xml"/>
....................................................................................................................................
-->
</sqlMapConfig>
4.实际中继承SqlMapClientDaoSupport,使用正确的方法