iBATIS入门之一：环境和配置文件
这个是mybatis的GoogleCode下载页
http://code.google.com/p/mybatis/downloads/list?can=1
我能下到的 ibatis的最新版本是： ibatis-2.3.4.726.zip
<?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="Stu_namespace"> <!-- 别名，起别名以后class里就不用每次都写包了 --> <typeAlias alias="Student" type="com.rt.ibatisdemo.vo.Student"/> <!-- 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 aliases) match to the properties exactly.--> <resultMap id="StudentResult" class="Student"> <result property="studentid" column="studentid"/> <result property="name" column="name"/> <result property="age" column="age"/> </resultMap> <!-- 1.查找全部，官方推荐用resultMap，暂时用简单的resultClass代替 --> <select id="selectAllStudent" resultClass="Student"> SELECT * FROM Student </select> <!-- 2.查询主键，多了一个接收参数的类型parameterClass，这里井号中是占位符 --> <select id="selectStudentById" parameterClass="int" resultClass="Student"> SELECT studentid,name,age FROM student WHERE studentid = #id# </select> <!-- 3.模糊查找，占位符必须用$ --> <select id="selectStudentByName" parameterClass="String" resultClass="Student"> SELECT studentid, name, age FROM student WHERE name LIKE '%$name$%' </select> <!-- 4.删除操作 --> <delete id="deleteStudentById" parameterClass="int"> DELETE FROM student WHERE studentid = #studentid# </delete> <!-- 5.增加指定 --> <insert id="insertStudent" parameterClass="Student"> INSERT into Student (studentid,name,age) VALUES (#studentid#, #name#, #age#) </insert> <!-- 6.序列增长,要指定自增长的主键字段名 --> <!-- selectKey相当于查询一次，把int类型的结果赋值给：传参的studentid： --> <insert id="insertStudentBySequence" parameterClass="Student"> <selectKey resultClass="int" keyProperty="studentid"> SELECT studentPKSequence.nextVal AS studentid FROM dual </selectKey> INSERT into Student (studentid,name,age) VALUES (#studentid#, #name#, #age#) </insert> <!-- 7.按主键更新 --> <update id="updateStudent" parameterClass="Student"> update Student set studentid = #studentid#, name = #name#, age = #age# where studentid = #studentid# </update> </sqlMap>
<insert><delete><update><select>对应增删改查，在标签中手写sql语句
parameterClass是接收的传参的类型
resultClass是语句返回值的类型
