Java 模拟数据库连接

Java mock database connection(Java 模拟数据库连接)

问题描述

我想用 make db connection 来测试类.我要测试的类在构造函数 Connection 类中接受为参数.我想将模拟对象传递给构造函数.你能告诉我一个好的框架，例如如何模拟数据库连接吗?

I want to test class with make db connection. Class that I want to test accept as param in constructor Connection class. I want to pass mock object to the constructor. Can you tell me good framework with example how to mock db connection?

推荐答案

可以使用MockRunner，支持对于 JDBC.像 Mockito 这样的通用模拟框架也可以工作，但是 JDBC 是一组相互返回的接口，所以手动模拟会很困难.亲自查看:如何存根/模拟 JDBC ResultSet 以同时使用 Java 5 和 6?

You can use MockRunner, which has support for JDBC. General mocking frameworks like Mockito will also work, but JDBC is a set of interfaces returning each other so hand-mocking will be hard. See for yourself: How to stub/mock JDBC ResultSet to work both with Java 5 and 6?

然而，模拟 JDBC 是如此脆弱和冗长(无论您使用哪种工具)，我建议在一些薄的 DAO 层中抽象 JDBC 访问(请参阅 @duffymo 答案)或者去 in-内存数据库，例如 H2.

However mocking JDBC is so brittle and verbose (no matter which tools you use) that I would either suggest abstracting JDBC access within some thin DAO layer (see @duffymo answer) or go for in-memory database like H2.

另见:

• 模拟 JDBC 驱动程序不值得

这篇关于Java 模拟数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！