IBatis.Net学习笔记三--两种常用的DAO
在ibatis中我们可以灵活的选择dao类型,也就是可以在底层选用不同的数据库操作方式。有常规方式、配置文件的方式、hibernet的方式等:
1、常规方式
和我们之前的ado.net开发较为类似,都是将sql语句写在cs代码中进行调用:
首先通过配置文件初始化:
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
相对应的配置文件如下:
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
然后在对应的,比如accountdao中写具体的查询sql等
2、配置方式
将sql语句放在配置文件中,书写和修改较灵活,这也是比较常用的方式
首先通过配置文件初始化:
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
相对应的配置文件如下:
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
然后可以将每一张表的sql语句单独放在一个配置文件中,比如:
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
![](https://www.cnblogs.com/images/outliningindicators/none.gif)
3、使用hibernet方式
也就是使用hibernet的数据库操作。
原文地址: http://www.cnblogs.com/firstyi/archive/2007/08/17/859772.html