ibatis 搭建环境

1、导入相应的jar包

2、配置文件：

jdbc连接的属性文件

driver = oracle.jdbc.driver.OracleDriver

url = jdbc:oracle:thin:@127.0.0.1:1521:orcl

username = itcast

password = itcast

总配置文件

<？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>

  <properties resource = "sqlMap.properties"/>

 <transactionManager type="JDBC">

      <dataSource type="SIMPLE">

                   <property value="${driver}" name="JDBC.Driver"/>  来自.properties文件上面的

                  <property value="${url}" name="JDBC.ConnectionURL"/>

                 <property value="${username}" name="JDBC.Username"/>

                  <property value="${password}" name="JDBC.Password"/>

    </dataSource>

</transactionManager>

<sqlMap resource="Student.xml"/>

</sqlMapConfig>

关于每个实体的映射文件（map 文件）

 

<？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-2.dtd " >

<sqlMap>

<!-- Result maps describe the mapping between the columns returned from a query, and the class properties. A result map isn't necessary if the columns (or allases)

match to the properties exactly.-->

<resultMap id="StudentResult" class="Student">

    <result property = "sid" column="sid"/>

     <result property = "sname"  column="sname"/>

    <result property = "major" column="major"/>

    <result property = "birth" column="birth"/>

</resultMap>

</sqlMap>