ibatis 简单开发案例

最新推荐文章于 2017-03-01 13:46:00 发布

hanqf2010

最新推荐文章于 2017-03-01 13:46:00 发布

阅读量222

点赞数

CC 4.0 BY-SA版权

文章标签： ibatis encoding jdbc delete string insert

本文链接：https://blog.youkuaiyun.com/hanqf2010/article/details/6067689

本文介绍了一个使用MyBatis框架的配置示例，包括数据库连接设置和基本的CRUD操作映射。通过Config.xml文件配置了数据源和事务管理，并定义了针对Student实体的增删查改操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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>
    
    <sqlMap resource="cn/itcast/Student.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>