Java 模拟数据库连接

2022-01-08 00:00:00 mocking unit-testing tdd jakarta-ee 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 驱动程序不值得

相关文章