blocks|key|5130055|text|您可以使用支持JDBC的MockRunner。像Mockito这样的通用模拟框架也可以工作，但是JDBC是一组相互返回的接口，所以手工模拟将会很困难。亲眼看看：How+to+stub/mock+JDBC+ResultSet+to+work+both+with+Java+5+and+6?|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5130056|然而，模仿JDBC是如此脆弱和冗长(无论您使用什么工具)，以至于我建议要么在某个薄的DAO层中抽象JDBC访问(参见@duffymo回答)，要么选择内存中的数据库，比如H2。|5130057|另请参阅：|5130058|5130059|Mock+JDBC+driver+not+worth+it|unordered-list-item|5130060|5130061|entityMap|0|LINK|mutability|MUTABLE|url|http://mockrunner.sourceforge.net/examplesjdbc.html|1|http://mockrunner.sourceforge.net/|2|http://mockito.org/|3|https://stackoverflow.com/questions/919544|4|http://www.h2database.com/|5|http://jroller.com/MikeSlattery/entry/mock_jdbc_driver_not_worth^0|7|4|0|C|A|1|O|7|2|28|1R|3|0|2C|2|4|0|0|0|0|T|5|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]|$A|18|B|19|1|1A]|$A|1B|B|1C|1|1D]|$A|1E|B|1F|1|1G]]|C|$]]|$1|D|3|E|5|6|7|1H|8|@]|9|@$A|1I|B|1J|1|1K]]|C|$]]|$1|F|3|G|5|6|7|1L|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]|$1|I|3|J|5|K|7|1N|8|@]|9|@$A|1O|B|1P|1|1Q]]|C|$]]|$1|L|3|-4|5|6|7|1R|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]|W|$5|P|Q|R|C|$S|X]]|Y|$5|P|Q|R|C|$S|Z]]|10|$5|P|Q|R|C|$S|11]]|12|$5|P|Q|R|C|$S|13]]]]

You can use <a href="http://mockrunner.sourceforge.net" rel="noreferrer">MockRunner</a>, which has support for <a href="http://mockrunner.sourceforge.net/examplesjdbc.html" rel="noreferrer">JDBC</a>. General mocking frameworks like <a href="http://mockito.org/" rel="noreferrer">Mockito</a> will also work, but JDBC is a set of interfaces returning each other so hand-mocking will be hard. See for yourself: <a href="https://stackoverflow.com/questions/919544">How to stub/mock JDBC ResultSet to work both with Java 5 and 6?</a>

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 <a href="http://www.h2database.com" rel="noreferrer">H2</a>.

See also:

<ul>
<li><a href="http://jroller.com/MikeSlattery/entry/mock_jdbc_driver_not_worth" rel="noreferrer">Mock JDBC driver not worth it</a></li>
</ul>

blocks|key|5129988|text|连接是一个接口。任何模拟框架都可以模拟它：EasyMock，Mockito，...|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5129989|模拟它与模拟任何其他Java接口没有什么不同。|5129990|entityMap|0|LINK|mutability|MUTABLE|url|http://easymock.org/|1|http://code.google.com/p/mockito/^0|L|8|0|U|7|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Connection is an interface. Any mocking framework will be able to mock it: <a href="http://easymock.org/" rel="nofollow">EasyMock</a>, <a href="http://code.google.com/p/mockito/" rel="nofollow">Mockito</a>, ...

Mocking it isn't different from mocking any other Java interface.

blocks|key|5130099|text|我不会创建一个模拟连接--在我看来，这证明不了什么。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5130100|我明白了为什么在使用实时连接完全测试了存储库/DAO之后，您还要模拟它本身。您可以将模拟存储库/DAO提供给服务或其他客户端，因为您已经对其进行了测试-在进行集成测试之前，不需要证明它是有效的。|5130101|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I wouldn't create a mock connection - it proves nothing, in my opinion.

I can see why you'd mock the repository/DAO itself after you've tested it fully with a live connection. You'd give the mock repository/DAO to a service or other client because you've already tested it - no need to prove that it works until you do an integration test.

blocks|key|5414867|text|您可以使用上面答案中提到的模拟框架(我个人使用EasyMock)+或创建您自己的模拟对象：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|5414868|class+FakeConnection+extends+Connection{
+++++++//+Overrive+all+method+behavious+you+want+to+fake.
}|code-block|syntax|javascript|5414869|entityMap^0|X|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You can either use a mocking framework such as the ones mentioned in the above answer (I personally use EasyMock)
OR Create you own mock object:

<pre><code>class FakeConnection extends Connection{
 // Overrive all method behavious you want to fake.
}
</code></pre>

blocks|key|987538|text|你可以试试easymock。我认为它很容易使用。你可以找到一个可供参考的教程。easymock|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|987539|entityMap|0|LINK|mutability|MUTABLE|url|http://www.michaelminella.com/testing/unit-testing-with-junit-and-easymock.html^0|13|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

you can try easymock. it is easy to use i think.
you can find a tutorial for reference. <a href="http://www.michaelminella.com/testing/unit-testing-with-junit-and-easymock.html" rel="nofollow">easymock</a>

blocks|key|5130119|text|如果您打算在许多测试用例上重用该模拟，您还可以考虑实现自己的连接实现，并在任何地方重用该实现。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5130120|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are going to reuse that mock on many test cases you can also consider implementing your own implementation of connection and to reuse that implementation everywhere.

blocks|key|990381|text|我的助手框架对于这样的目的很有用，->+https://github.com/cchantep/acolyte。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|990382|有了这个库，您就可以创建一个为其提供处理程序的连接实例。通过实现处理程序，您可以“分派”查询或更新:生成结果集或更新计数(或警告)。|990383|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/cchantep/acolyte^0|K|Z|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

My Acolyte framework is useful for such purposes -> <a href="https://github.com/cchantep/acolyte" rel="nofollow noreferrer">https://github.com/cchantep/acolyte</a> .

With this lib you can create a connection instance for which you provide handler. Implementing handler, you are able to 'dispatch' query or update : producing resultsets or update count (or warning).

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

Java mock database connection

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

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

问Java模拟数据库连接
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Java模拟数据库连接EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Java模拟数据库连接
EN