ibatis

Student.xml:

<?xml version="1.0" encoding="UTF-8"?>
<sqlMap>
<typeAlias alias="Student" type="com.cn.entity.Student"/>
<insert id="insertStudentBySequene" parameterClass="Student">
<selectKey resultClass="int" keyProperty="sid">
select studentPKSequence.nextVal as sid from dual
</selectKey>
insert into Student(sid,sname,major,birth) values (#sid#,#sname#,#major#,#birth#)
</insert>
<select id="selectAllStudents" resultClass="Student">
select * from student
</select>
<select id="selectStudentById" parametername="int" resultClass="Student">
select * from student where sid = #sid#
</select>
<insert id="insertStudent" parameterClass="Student">
insert into Student(sid,sname,major,birth) values (#sid#,#sname#,#major#,#birth#)
</insert>
<delete id="deleteStudentById" parameterClass="int">
delete from Student where sid = #sid#
</delete>
<update id="updateStudentById" parameterClass="Student">
update Student set sname=#sname#,marjor=#major#,birth=#birth# where id="#sid#"
</update>
<select id="selectStudentByName" parameterClass="String" resultClass="Student">
select * from student where sname like '%$sname$%'
</select>
<!--
以下个为例写动态sql
判断是否为空
判断是否存在
-->
<select id="selectStudentByName" parameterClass="String" resultClass="Student">
select * from student
<dynamic prepend=" where ">
<isNotEmpty property="sname" prepend="and" open="(" close=")">
sname like '%$sname$%'
</isNotEmpty>
<isNotNull property="sname">
...
</isNotNull>
</dynamic>
</select>
</sqlMap>

SqlMap.properties:

driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:orcl
username=scott
password=scott

SqlMapConfig.xml:

<?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="com/cn/SqlMap.properties"/>

<settings
useStatementNamespaces="true"
cacheModelsEnabled="true"/>

<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property value="${driver}" name="JDBC.Driver"/>
<property value="${url}" name="JDBC.ConnectionURL"/>
<property value="${username}" name="JDBC.Username"/>
<property value="${password}" name="JDBC.Password"/>
</dataSource>
</transactionManager>

<sqlMap resource="com/cn/entity/Student.xml"/>

</sqlMapConfig>