ibatis 配置文件 SqlMapConfig&SqlMap 示例

最新推荐文章于 2021-02-16 08:41:35 发布

orclight

最新推荐文章于 2021-02-16 08:41:35 发布

阅读量981

点赞数

CC 4.0 BY-SA版权

分类专栏： java web框架文章标签： ibatis insert jdbc delete sql mysql

本文链接：https://blog.youkuaiyun.com/orclight/article/details/6771904

java web框架专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个具体的MyBatis配置文件示例，包括数据库连接设置、SQL映射文件定义及基本的CRUD操作实现。通过示例展示了如何进行数据库交互。

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

#######################SqlMapConfig#######################

<!DOCTYPE sqlMapConfig
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
   <settings
       useStatementNamespaces="true"
   />
   <transactionManager type="JDBC">
       <dataSource type="SIMPLE">
           <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
           <property name="JDBC.ConnectionURL" value="jdbc:mysql://127.0.0.1:3306/orclight" />
           <property name="JDBC.Username" value="root"/>
           <property name="JDBC.Password" value="1234"/>
       </dataSource>
   </transactionManager>
   <sqlMap resource="com/buct/sqlmap/user.ibatis.xml"/>
   <sqlMap resource="com/buct/sqlmap/notebook.ibatis.xml"/>
</sqlMapConfig>

#######################SqlMap#######################

<!DOCTYPE sqlMap
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="NotebookDao">
   <typeAlias alias="notebook" type="com.buct.model.Notebook" />

   <insert id="insertNotebook" parameterClass="notebook">
       <![CDATA[
           insert into t_notebook(
               id,
               cpu,
               ram,
               logo,
               price)
           values(
               #id#,
               #cpu#,
               #ram#,
               #logo#,
               #price#)
       ]]>
   </insert>

   <delete id="deleteNotebook" parameterClass="notebook">
       <![CDATA[
           delete from t_notebook where id = #id#
       ]]>
   </delete>

   <update id="updateNotebook" parameterClass="notebook">
       <![CDATA[
           update t_notebook set
               cpu = #cpu#,
               ram = #ram#,
               logo = #logo#,
               price = #price#
           where id = #id#
       ]]>
   </update>


   <select id="selectNotebook" resultClass="notebook">
       <![CDATA[
           select * from t_notebook
       ]]>
   </select>

select count(*) from t_notebook

</select>

</sqlMap>

#############################测试代码################################

Reader reader = Resources.getResourceAsReader("sqlMapConfig.xml");
SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
result = (Integer)sqlMapClient.queryForObject("NotebookDao.selectNotebookCount", filterMap);