传智博客ibatis 配置文件

  sqlMapConfig.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="oracle.jdbc.OracleDriver" />

<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@127.0.0.1:1521:oracle9i" />

<property name="JDBC.Username" value="itcast" />

<property name="JDBC.Password" value="itcast" />

</dataSource>

</transactionManager>

<sqlMap resource="com/itcast/Student.xml"></sqlMap>

</sqlMapConfig>

Student.xml

 

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

<typeAlias alias="Student" type="com.itcast.Student" />

<select id="selectAllStudent" resultClass="Student">

select * from student

</select>

<select id="selectStudentById" parameterClass="int" resultClass="Student">

select * from student where sid=#sid#

</select>

<insert id="insertStudent" parameterClass="student">

insert into

student(sid,sname,major,birth,score)

values(#sid#,#sname#,#major#,#birth#,#score#)

</insert>

<delete id="deleteStudentById" parameterClass="int">

delete from

Student where sid=#Fid#

</delete>

<update id="updateStudentById" parameterClass="Student">

update Student set

sname=#sname#,

major=#major#,

score=#score#,

birth=#birth#

where sid=#sid#

</update>

<select id="selectStudentByName" parameterClass="String"

resultClass="Student">

select sid,sname,major,birth,score from Student

where sname

like '%$sname$%' 

</select>

<insert id="insertStudentBySequence" parameterClass="Student">

<selectKey resultClass="int" keyProperty="sid">

select

studentPKSequence.nextVal

from dual

</selectKey>

insert into Student(sid,sname,birth,major,score)values

(#sid#,#sname#,#birth#,#major#,#score#)

</insert>

</sqlMap>