欢迎来到天天文库
浏览记录
ID:34723346
大小:115.68 KB
页数:13页
时间:2019-03-10
《ibatis和mybatis的区别》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、ibatis和mybatis的区别作者:iroad@sina.com1概述这个区别不是很大,最主要的区别就是mybatis简化了编码的过程,不需要去写dao的实现类,直接写一个dao的接口,再写一个xml配置文件,整个mybatis就配置好了,也就是数据库就连接好了,然后在service里面直接调用dao就可以了,但是ibatis则不可以,必须要写dao的实现类,再写个returngetSqlMapClientTemplate().queryForList()神马的,mybatis是ibatis的升级版本。还有些区别就是xml
2、里面的sql语句的写法有些小变化,但是不大。2Mybatis实现了接口绑定,使用更加方便。在ibatis2.x中我们需要在DAO的实现类中指定具体对应哪个xml映射文件,而Mybatis实现了DAO接口与xml映射文件的绑定,自动为我们生成接口的具体实现,使用起来变得更加省事和方便。这可以说是Mybatis最重要的改进。2.1举例2.1.1Mybatis的使用方法:只需要如下做好SBookMapper.xml、ISBookMapper,就可以直接在services中直接调用ISBookMapper中的接口方法,该方法就在xml
3、中定义的id,如findAllBook,这个方法名称在ISBookMapper和SBookMapper.xml中必须完全一致!2.1.1.1SBookMapper.xml中定义的id与mapper接口中定义的方法名称必须是完全一致的">4、Book"id="sBookResultMap">5、publisher"column="publisher"/>SELECT*fromsbook;SELECTLAST_INSERT_ID()ASVALUE6、ectKey>INSERTINTOsbook(title,author,total,price,isbn,publisher)VALUES(#{title},#{author},#{total},#{price},#{isbn},#{publisher})SELECT*fromsbookwhereid=#{id};7、k"parameterType="int">updatesbooksettitle=#{title},author=#{author},total=#{total},price=#{price},isbn=#{isbn},publisher=#{publisher}whereid=#{id}deletefromsbookwhereid=#{id}1.1.1.1ISBookMapper:pac8、kagecom.yksc.b2c.books.mapper;importjava.util.List;importcom.yksc.b2c.books.pojo.SBook;publicinterfaceISBookMapper{/***添加一本图书至数据库中**@param
4、Book"id="sBookResultMap">5、publisher"column="publisher"/>SELECT*fromsbook;SELECTLAST_INSERT_ID()ASVALUE6、ectKey>INSERTINTOsbook(title,author,total,price,isbn,publisher)VALUES(#{title},#{author},#{total},#{price},#{isbn},#{publisher})SELECT*fromsbookwhereid=#{id};7、k"parameterType="int">updatesbooksettitle=#{title},author=#{author},total=#{total},price=#{price},isbn=#{isbn},publisher=#{publisher}whereid=#{id}deletefromsbookwhereid=#{id}1.1.1.1ISBookMapper:pac8、kagecom.yksc.b2c.books.mapper;importjava.util.List;importcom.yksc.b2c.books.pojo.SBook;publicinterfaceISBookMapper{/***添加一本图书至数据库中**@param
5、publisher"column="publisher"/>SELECT*fromsbook;SELECTLAST_INSERT_ID()ASVALUE6、ectKey>INSERTINTOsbook(title,author,total,price,isbn,publisher)VALUES(#{title},#{author},#{total},#{price},#{isbn},#{publisher})SELECT*fromsbookwhereid=#{id};7、k"parameterType="int">updatesbooksettitle=#{title},author=#{author},total=#{total},price=#{price},isbn=#{isbn},publisher=#{publisher}whereid=#{id}deletefromsbookwhereid=#{id}1.1.1.1ISBookMapper:pac8、kagecom.yksc.b2c.books.mapper;importjava.util.List;importcom.yksc.b2c.books.pojo.SBook;publicinterfaceISBookMapper{/***添加一本图书至数据库中**@param
6、ectKey>INSERTINTOsbook(title,author,total,price,isbn,publisher)VALUES(#{title},#{author},#{total},#{price},#{isbn},#{publisher})SELECT*fromsbookwhereid=#{id};7、k"parameterType="int">updatesbooksettitle=#{title},author=#{author},total=#{total},price=#{price},isbn=#{isbn},publisher=#{publisher}whereid=#{id}deletefromsbookwhereid=#{id}1.1.1.1ISBookMapper:pac8、kagecom.yksc.b2c.books.mapper;importjava.util.List;importcom.yksc.b2c.books.pojo.SBook;publicinterfaceISBookMapper{/***添加一本图书至数据库中**@param
7、k"parameterType="int">updatesbooksettitle=#{title},author=#{author},total=#{total},price=#{price},isbn=#{isbn},publisher=#{publisher}whereid=#{id}deletefromsbookwhereid=#{id}1.1.1.1ISBookMapper:pac
8、kagecom.yksc.b2c.books.mapper;importjava.util.List;importcom.yksc.b2c.books.pojo.SBook;publicinterfaceISBookMapper{/***添加一本图书至数据库中**@param
此文档下载收益归作者所有