ibatis 简单开发案例

Config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
 <transactionManager type="JDBC" >
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />
            <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/cldc"/>
            <property name="JDBC.Username" value="root"/>
            <property name="JDBC.Password" value="123"/>
        </dataSource>
    </transactionManager>
    <!-- 把对应的xml文件添加到这里 -->
    <sqlMap resource="cn/itcast/Student.xml" />
    <!-- <sqlMap resource="com/xyc/ibatis/domain/emp.xml" /> -->
</sqlMapConfig>

xml 映射

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap>
 <typeAlias alias="Student" type="cn.itcast.Student" />
 
 <select id="selectAllStudent" resultClass="Student">
 <![CDATA[
  select * from student
 ]]>
 </select>
 
 <select id="selectStuedentById" parameterClass="int" resultClass="Student">
 select id,name,age from student where id=#id#
 </select>
  <select id="selectStuedentByName" parameterClass="String" resultClass="Student">
  <![CDATA[ select id,name,age from student where name=#name#]]>

 </select>
 <insert id="insertStudent" parameterClass="Student">
  insert into student(name,age) values(#name#,#age#)
  </insert>
  <delete id="deleteStudent" parameterClass="int">
  delete from student where id=#id#
  </delete>
  <select id="selectStudentLikeName" parameterClass="String" resultClass="Student">
  select id,name,age from student where name like '%$name$%'
  </select>
</sqlMap>