dao 单元测试

本文探讨了单元测试中针对DAO层测试的方法。通过对比mockdbutil和dbunit,提出了一种利用mock对象进行数据库操作模拟的方式,以此验证DAO层SQL操作的正确性,并避免了实际数据库操作带来的复杂性。

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

单元测试之mockdbutil和dbunit对比。

我们在自己做单元测试的时候,增对DAO做单元测试是一个比较敏感的问题。如果保证我们的dao对数据库的sql操作是正确的?
这个时候,单元测试就不得不和数据库进行交互,如果用dbutil,问题是大量的xml数据种子文件,其是dbunit核心还是dbunit
帮助我们来进行数据库操作,单元测试还是需要有和数据库真是操作的部分。

倒不如像我们这样,在每个固定的dao测试中,做mock对象,负责插入,删除,查询,更新等基本工作,其结果来和dao操作的来
进行对比,操作完开发库后,在删除变动的数据。

DAO编写单元测试,其中的如下<br>package com.javaeedev.dao.impl;<br><br>import java.util.List;<br>import java.util.UUID;<br><br>import com.javaeedev.dao.UserDao;<br>import com.javaeedev.domain.PasswordTicket;<br>import com.javaeedev.domain.User;<br>import com.javaeedev.exception.LockException;<br>import com.javaeedev.util.HibernateUtil;<br><br>public class UserDaoImpl implements UserDao {<br><br> public User queryForSignOn(String username) {<br> User user = queryUser(username);<br> if(user.getLocked())<br> throw new LockException(user.getLockDate());<br> return user;<br> }<br><br> public User queryUser(String username) {<br> return (User) HibernateUtil.query(User.class, username);<br> }<br><br> public void createUser(User user) {<br> user.setEmailValidation((int)(Math.random() * 1000000) + 0xf);<br> HibernateUtil.createEntity(user);<br> }<br><br> public void updateUser(User user) {<br> HibernateUtil.updateEntity(user);<br> }<br><br> public boolean updateEmailValidation(String username, int ticket) {<br> if(ticket==0)<br> return false;<br> return 1==HibernateUtil.executeUpdate(<br> "update User as u set u.emailValidation=0 where u.username=? and u.emailValidation=?",<br> new Object[] { username, ticket }<br> );<br> }<br><br> public String createPasswordTicket(User user) {<br> HibernateUtil.executeUpdate(<br> "delete from PasswordTicket as pt where pt.user=?",<br> new Object[] { user }<br> );<br> String ticket = UUID.randomUUID().toString().replaceAll("\\-", "");<br> PasswordTicket pt = new PasswordTicket();<br> pt.setUser(user);<br> pt.setTicket(ticket);<br> pt.setCreatedDate(System.currentTimeMillis());<br> HibernateUtil.createEntity(pt);<br> return ticket;<br> }<br><br> public boolean updatePassword(String username, String oldPassword, String newPassword) {<br> if(!newPassword.matches(User.REGEX_PASSWORD))<br> return false;<br> return 1==HibernateUtil.executeUpdate(<br> "update User as u set u.password=? where u.username=? and u.password=?",<br> new Object[] { newPassword, username, oldPassword }<br> );<br> }<br><br> public boolean queryResetPassword(User user, String ticket) {<br> long time = System.currentTimeMillis() - 48L * 3600000L;<br> return !HibernateUtil.queryForList(<br> "select pt from PasswordTicket as pt where pt.user=? and pt.ticket=? and pt.createdDate>?",<br> new Object[] { user, ticket, time}<br> ).isEmpty();<br> }<br><br> @SuppressWarnings("unchecked")<br> public boolean updateResetPassword(User user, String ticket, String password) {<br> if(!password.matches(User.REGEX_PASSWORD))<br> return false;<br> long time = System.currentTimeMillis() - 48L * 3600000L;<br> List<PasswordTicket> list = HibernateUtil.queryForList(<br> "select pt from PasswordTicket as pt where pt.user=? and pt.ticket=? and pt.createdDate>?",<br> new Object[] { user, ticket, time}<br> );<br> if(list.isEmpty())<br> return false;<br> HibernateUtil.executeUpdate(<br> "delete from PasswordTicket as pt where pt.user=?",<br> new Object[] { user }<br> );<br> HibernateUtil.executeUpdate(<br> "update User as u set u.password=? where u.username=?",<br> new Object[] { password, user.getUsername() }<br> );<br> return true;<br> }<br><br> public void updateLock(User user, long lockTime) {<br> HibernateUtil.executeUpdate(<br> "update User as u set u.lockDate=? where u.username=?",<br> new Object[] { System.currentTimeMillis() + lockTime, user.getUsername() }<br> );<br> }<br><br> public void updateUnlock(User user) {<br> HibernateUtil.executeUpdate(<br> "update User as u set u.lockDate=0 where u.username=?",<br> new Object[] { user.getUsername() }<br> );<br> }<br><br>}<br>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值