Mybatis 传统 DAO 层开发[了解]

朱雀 2022-12-23 06:26 231阅读 0赞

使用 Mybatis 开发 Dao，通常有两个方法，即原始 Dao 开发方式和 Mapper 接口代理开发方式。而现在主流的开发方式是接口代理开发方式，这种方式总体上更加简便。我们的课程讲解也主要以接口代理开发方式为主。在第二章节已经给大家介绍了基于代理方式的 dao 开发，现在给大家介绍一下基于传统编写 Dao 实现类的开发方式。

### **Mybatis 实现 DAO 的传统开发方式** ###

#### **1 持久层 Dao 接口** ####

/\*\*

\* <p>Title: IUserDao</p>

\* <p>Description: 用户的业务层接口</p>

\* <p>Company: http://www.itheima.com/ </p>

\*/

public interface IUserDao \{

/\*\*

\* 查询所有用户

\* @return

\*/

List<User> findAll();

/\*\*

\* 根据 id 查询

\* @param userId

\* @return

\*/

User findById(Integer userId);

/\*\*

\* 保存用户

\* @param user

\* @return 影响数据库记录的行数

\*/

int saveUser(User user);

/\*\*

\* 更新用户

\* @param user

\* @return 影响数据库记录的行数

\*/

int updateUser(User user);

/\*\*

\* 根据 id 删除用户

\* @param userId

\* @return

\*/

int deleteUser(Integer userId);

/\*\*

\* 查询总记录条数

\* @return

\*/

int findTotal();

#### **2 持久层 Dao 实现类** ####

/\*\*

\* <p>Title: UserDaoImpl</p>

\* <p>Description: dao 的实现类</p>

\* <p>Company: http://www.itheima.com/ </p>

\*/

public class UserDaoImpl implements IUserDao \{

private SqlSessionFactory factory;

public UserDaoImpl(SqlSessionFactory factory) \{

this.factory = factory;

@Override

public List<User> findAll() \{

SqlSession session = factory.openSession();

List<User> users = session.selectList("com.itheima.dao.IUserDao.findAll");

session.close();

return users;

@Override

public User findById(Integer userId) \{

SqlSession session = factory.openSession();

User user = session.selectOne("com.itheima.dao.IUserDao.findById",userId);

session.close();

return user;

@Override

public int saveUser(User user) \{

SqlSession session = factory.openSession();

int res = session.insert("com.itheima.dao.IUserDao.saveUser",user);

session.commit();

session.close();

return res;

@Override

public int updateUser(User user) \{

SqlSession session = factory.openSession();

int res = session.update("com.itheima.dao.IUserDao.updateUser",user);

session.commit();

session.close();

return res;

@Override

public int deleteUser(Integer userId) \{

SqlSession session = factory.openSession();

int res = session.delete("com.itheima.dao.IUserDao.deleteUser",userId);

session.commit();

session.close();

return res;

@Override

public int findTotal() \{

SqlSession session = factory.openSession();

int res = session.selectOne("com.itheima.dao.IUserDao.findTotal");

session.close();

return res;

#### **3 持久层映射配置** ####

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select \* from user

</select>

<select id="findById" resultType="com.itheima.domain.User"

parameterType="int">

select \* from user where id = \#\{uid\}

</select>

<!-- 保存用户

ognl 表达式：它是 apache 提供的一种表达式语言，在 struts2 中也有应用。

Object Graphic Navigation Language 对象图导航语言

它是按照一定的语法格式来获取数据的。

语法格式就是使用 \#\{对象.对象\}的方式

\#\{user.username\}它会先去找 user 对象，然后在 user 对象中找到 username 属性，并把值取

出来

\-->

select last\_insert\_id();

</selectKey>

insert into user(username,birthday,sex,address)

values(\#\{username\},\#\{birthday\},\#\{sex\},\#\{address\})

</insert>

update user set

username=\#\{username\},birthday=\#\{birthday\},sex=\#\{sex\},address=\#\{address\} where

id=\#\{id\}

</update>

delete from user where id = \#\{uid\}

</delete>

select count(\*) from user;

</select>

</mapper>

#### **4 测试类** ####

/\*\*

\* <p>Title: MybastisCRUDTest</p>

\* <p>Description: 测试 mybatis 的 crud 操作</p>

\* <p>Company: http://www.itheima.com/ </p>

\*/

public class MybastisCRUDTest \{

private InputStream in ;

private SqlSessionFactory factory;

private IUserDao userDao;

@Test

public void testFindAll() \{

List<User> users = userDao.findAll();

for(User user : users) \{

System.out.println(user);

@Test

public void testFindOne() \{

//6.执行操作

User user = userDao.findById(56);

System.out.println(user);

@Test

public void testSaveUser() throws Exception \{

User user = new User();

user.setUsername("mybatis dao user");

//6.执行操作

int res = userDao.saveUser(user);

System.out.println(res);

System.out.println(user.getId());

@Test

public void testUpdateUser()throws Exception\{

//1.根据 id 查询

User user = userDao.findById(41);

//2.更新操作

user.setAddress("北京市顺义区");

int res = userDao.updateUser(user);

System.out.println(res);

@Test

public void testDeleteUser() throws Exception \{

//6.执行操作

int res = userDao.deleteUser(56);

System.out.println(res);

@Test

public void testFindTotal() throws Exception \{

//6.执行操作

int res = userDao.findTotal();

System.out.println(res);

@Before//在测试方法执行之前执行

public void init()throws Exception \{

//1.读取配置文件

in = Resources.getResourceAsStream("SqlMapConfig.xml");

//2.创建构建者对象

SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

//3.创建 SqlSession 工厂对象

factory = builder.build(in);

//4.创建 Dao 接口的实现类

userDao = new UserDaoImpl(factory);

@After//在测试方法执行完成之后执行

public void destroy() throws Exception\{

//7.释放资源

in.close();

热门文章

[Redis&nbsp;Cluster][Redis_nbsp_Cluster]

[spring&nbsp;整合JMS][spring_nbsp_JMS]

[Zookeeper集群][Zookeeper]

[SpringBoot入门][SpringBoot]

[Docker简介][Docker]

[SolrCloud][]

[走进电商-电商行业分析及技术特点][-]

![Image 1][]

长按图片识别二维码关注

![format_png][]

CSDN博客地址

[Redis_nbsp_Cluster]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6fdc7dcd174d15cb88893167b1266e56a38416f50d0c5bcd47b37340635447eba5c079d31&idx=1&mid=2247484064&scene=21&sn=8a8be02a579f8ae8f46adef1852a173b#wechat_redirect
[spring_nbsp_JMS]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6fdcedcd174d8e38bbd4cfeca8c59fb485095879c82f8446480d57427436866197b85c25a&idx=1&mid=2247484073&scene=21&sn=8e802757fa1b76e187d97a31239d0f88#wechat_redirect
[Zookeeper]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6fde9dcd174ff8a4a49af2cb411573d6a006065f912dc15d1dc523f7195f81cd75dd882bc&idx=1&mid=2247484046&scene=21&sn=62640d4f2b6f96f05d28c7be1a863a41#wechat_redirect
[SpringBoot]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6fd44dcd17452f945d1f7efcae57c1329acd7286cb491ce72bf24275a0266f7509128e2e6&idx=1&mid=2247483939&scene=21&sn=323f773baa13cb797afab8936e8cbfaf#wechat_redirect
[Docker]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6fd89dcd1749fdb626f603063894956db916da6bb057ba427989b35cabf00c783876a8f74&idx=1&mid=2247484142&scene=21&sn=508ceca070c3ab8b92161ed71e372479#wechat_redirect
[SolrCloud]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6fdc6dcd174d0a2be2655429a9aca69c727fae82b8f35e7671b8bcdd6e331934848651925&idx=1&mid=2247484065&scene=21&sn=bd9de4721926a0712efdf6f63e4a93e9#wechat_redirect
[-]: http://mp.weixin.qq.com/s?__biz=MzI4MTUzNzAzMg%3D%3D&chksm=eba6feabdcd177bd2b822221ea83e5618b2412f70f7165acba5731e58ff059b5a30e7aaeefbb&idx=1&mid=2247483852&scene=21&sn=82cac4bfb4027d41701c11ba977400aa#wechat_redirect
[Image 1]: https://imgconvert.csdnimg.cn/
[format_png]: /images/20221120/ddf995ec92ae411cb4e9efcae665b2df.png