- 浏览: 187303 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (83)
- J2EE/Core Java (24)
- J2EE/Portal (2)
- J2EE/UI (4)
- J2EE/ATG (1)
- J2EE/Report (1)
- J2EE/Web Service/Rest API (2)
- Design Pattern (2)
- Arithmetic (4)
- Linux (12)
- Ruby&Rails (17)
- Database (5)
- J2EE/Payment (1)
- J2EE/JVM (1)
- Encryption/Decryption (3)
- J2EE/Multi Threading (4)
- SQL (1)
- https://community.teamviewer.com/t5/Knowledge-Base/Where-can-I-download-older-TeamViewer-versions-nbsp/ta-p/7729 (0)
最新评论
引用
本文针对常见的springmvc+spring+springjdbc的架构提供啦一些单元测试和集成测试的范例,附件是完整的demo
示例代码安装:
1 安装maven
2 准备mysql数据库,运行脚本: Spring3\schema\sampledb.sql
3 maven dbunit:export可以导出数据库数据到export.xml
4 maven test可以测试所有testing 代码
5 maven jetty:run 可以启动jetty服务器
1. maven pom 文件
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.wilson</groupId> <artifactId>Spring3</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>Spring3 Maven Webapp</name> <url>http://maven.apache.org</url> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>3.0.6.RELEASE</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>3.0.6.RELEASE</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.10</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>3.0.6.RELEASE</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>3.0.6.RELEASE</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>3.0-alpha-1</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.17</version> </dependency> <dependency> <groupId>org.easymock</groupId> <artifactId>easymock</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>dbunit</groupId> <artifactId>dbunit</artifactId> <version>2.2</version> </dependency> </dependencies> <build> <finalName>Spring3</finalName> <plugins> <plugin> <groupId>org.mortbay.jetty</groupId> <artifactId>jetty-maven-plugin</artifactId> <version>8.0.4.v20111024</version> </plugin> <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>dbunit-maven-plugin</artifactId> <version>1.0-beta-3</version> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.17</version> </dependency> </dependencies> <configuration> <driver>com.mysql.jdbc.Driver</driver> <url>jdbc:mysql://localhost/sampledb</url> <username>root</username> <password>root</password> <type>CLEAN_INSERT</type> <!-- ataset file format type. Valid types are: flat, xml, csv, and dtd Default value is: xml. --> <format>xml</format> <src>src/test/resources/export.xml</src> <dest>src/test/resources/export.xml</dest> </configuration> <executions> <execution> <phase>process-test-classes</phase> <goals> <goal>operation</goal> </goals> <!-- specific configurations 我们可以在这里指定不同的配置--> <configuration> <format>xml</format> <src>src/test/resources/export.xml</src> <type>CLEAN_INSERT</type> </configuration> </execution> </executions> </plugin> </plugins> </build> </project>
2 测试spring mvc的controler
public class LoginControllerTest { @Test public void testingHandlerWithUserInSession() throws Exception { MockHttpServletRequest request = new MockHttpServletRequest(); // LoginCommand command = new LoginCommand(); MockHttpSession session = new MockHttpSession(); session.setAttribute("user", new User()); request.setSession(session); LoginController controller = new LoginController(); ModelAndView mv1 = controller.handle(request, null, null, null); assertEquals(mv1.getViewName(), "target"); } }
3利用easymock对userService类做单元测试
public class UserServiceImplTest extends TestCase { public void testHasMatchUser() { System.out.println("teste1"); UserServiceImpl s = new UserServiceImpl(); UserDao dao = EasyMock.createMock(UserDao.class); s.setUserDao(dao); EasyMock.expect(dao.getMatchCount("tom", "1231")).andReturn(1); EasyMock.expect(dao.getMatchCount("tom", "234")).andReturn(0); EasyMock.replay(dao); assertEquals(s.hasMatchUser("tom", "1231"), true); assertEquals(s.hasMatchUser("tom", "234"), false); } }
4 利用Dbunit对userDao做单元测试
dbunit的测试数据
<?xml version='1.0' encoding='UTF-8'?> <dataset> <table name="t_user"> <column>user_id</column> <column>user_name</column> <column>credits</column> <column>password</column> <column>last_visit</column> <column>last_ip</column> <row> <value>3</value> <value>user001</value> <null/> <value>123456</value> <null/> <null/> </row> </table> </dataset>
测试dao
package com.baobaotao.dao.jdbc; @RunWith(SpringJUnit4ClassRunner.class) @Transactional @TransactionConfiguration(transactionManager="transactionManager", defaultRollback=true) @ContextConfiguration(locations={"classpath:baobaotao-dao.xml","classpath:baobaotao-service.xml"}) public class UserDaoTest extends DBTestCase { public UserDaoTest() { super(); System.setProperty( PropertiesBasedJdbcDatabaseTester.DBUNIT_DRIVER_CLASS, "com.mysql.jdbc.Driver" ); System.setProperty( PropertiesBasedJdbcDatabaseTester.DBUNIT_CONNECTION_URL, "jdbc:mysql://localhost/sampledb" ); System.setProperty( PropertiesBasedJdbcDatabaseTester.DBUNIT_USERNAME, "root" ); System.setProperty( PropertiesBasedJdbcDatabaseTester.DBUNIT_PASSWORD, "root" ); // System.setProperty( PropertiesBasedJdbcDatabaseTester.DBUNIT_SCHEMA, "" ); } @Resource private JdbcTemplate jdbcTemplate; @Autowired protected UserDao userDao; @Autowired private DataSource dataSource; private IDatabaseConnection conn; @Before public void initDbunit() throws Exception { super.setUp(); conn = new DatabaseConnection(DataSourceUtils.getConnection(dataSource)); } // @Test @Timed(millis=1000) public void testRegisterUser() throws SQLException, IOException, DatabaseUnitException, ParseException { // SimpleDateFormat dateFormatter = new SimpleDateFormat("dd.MM.yyyy"); User user = new User(); user.setUserId(3); user.setUserName("user001"); user.setPassword("123456"); // user.setCredits(40); // user.setLastIp("192.168.12.7"); // user.setLastVisit(dateFormatter.parse("24.11.2011")); userDao.RegisterUser(user); QueryDataSet actual = new QueryDataSet(conn); actual.addTable("t_user", "select * from t_user where t_user.user_name = 'user001'"); IDataSet expected = new XmlDataSet(new ClassPathResource("com/baobaotao/dao/jdbc/user001.xml").getInputStream()); Assertion.assertEquals(expected, actual); } @Test @Transactional public void testCleanInsertInitial() { String sqlStr = " select count(*) from t_login_log where login_log_id = '9'"; int count = jdbcTemplate.queryForInt(sqlStr); Assert.assertEquals(1, count); } @Override protected IDataSet getDataSet() throws Exception { return new XmlDataSet(new ClassPathResource("export.xml").getInputStream()); } }
5 利用spring的test包做集成测试
@RunWith(SpringJUnit4ClassRunner.class) @Transactional @TransactionConfiguration(transactionManager="transactionManager", defaultRollback=true) @ContextConfiguration(locations={"classpath:baobaotao-dao.xml","classpath:baobaotao-service.xml"}) public class UserServiceIntegrateWithJdbcTestSpring3 { @Resource private JdbcTemplate jdbcTemplate; @Autowired protected UserService userService; @Before public void prepareTestData() { System.out.println("before"); } @Test @Timed(millis=1000) public void testRegisterUser() { User user = new User(); // user.setUserId(2); user.setUserName("johnaaaa"); user.setPassword("123456"); userService.registerUser(user); String sqlStr = " select user_id from t_user where user_name = 'johnaaaa'"; int userId = jdbcTemplate.queryForInt(sqlStr); Assert.assertEquals(userId, user.getUserId()); } @Test public void testUserMatchService() { User user = new User(); // user.setUserId(2); user.setUserName("wilson"); user.setPassword("123456"); userService.registerUser(user); Assert.assertFalse(userService.hasMatchUser("john11", "123456")); Assert.assertTrue(userService.hasMatchUser("wilson", "123456")); } //要求测试方法丢出异常 @Test @ExpectedException(RuntimeException.class) public void testThrowException() { throw new RuntimeException("test"); } @After public void after() { System.out.println("after"); } }
引用
了解 dbunit,easy mock,spring3,maven的资源
http://newwhx2011.iteye.com/blog/1089559
http://www.dbunit.org/howto.html
http://www.iteye.com/topic/475172
- Spring3.zip (76 KB)
- 下载次数: 73
- DBunit.zip (20.1 KB)
- 下载次数: 43
发表评论
-
Start tomcat with port 80 without Linux root user-Use iptables mapping
2016-05-25 17:39 830引用In linux system. only root us ... -
Format XML in JAVA
2016-01-11 12:23 601public static String format ... -
HttpURLConnection下载文件
2015-08-07 11:25 793public class HttpDownloadUtilit ... -
Ehcache RMI Replicated Cluster(RMI集群)
2013-04-25 23:39 1067引用本文是ehcache RMI集群的例子,导入附件中的jav ... -
Integrete unitils for database(dao) testing
2013-02-01 18:39 1691引用Database testing Unit tests f ... -
JAXB入门
2012-10-16 11:59 785引用jaxb是一个读写xml的工具,还可以提供验证,不需要额外 ... -
Freemarker使用入门
2012-10-16 11:54 1017引用freemarker是一种模板标记工具,可以做页面静态化, ... -
perforce java api使用
2012-10-16 11:43 1253引用perforce是种版本管理软件,提供啦完整的java a ... -
XPath 入门
2012-10-16 11:29 879引用xpath可以快速定位获取XML文件中指定属性和值,jdk ... -
Java File Diff-diffutils
2012-09-27 17:35 74441. Maven Dependency <depende ... -
XSD 入门使用
2012-09-18 23:20 775<?xml version="1.0" ... -
nexus-2.1.1安装及使用入门
2012-08-13 22:52 14461. 安装 地址http://www.sonatype.org ... -
File Demo
2012-06-25 22:55 1310package org.springside.examples ... -
Java 访问sharepoint webservice(NTLM & SSL)
2012-06-12 09:47 3771引用遇到需要使用java访问微软的sharepoint的web ... -
Selenium Web Driver入门
2012-05-27 23:17 58351 What is Selenium? 引用Selenium ... -
HttpClient4.1.2 & HtmlUnit2.9 处理文件下载
2012-01-09 18:18 1025TestCode import java.io.Fi ... -
HttpClient4.1.2 & HtmlUnit2.9 NTLM 验证 和 Httpclient4.1.2 https/SSL
2012-01-09 18:13 15951. HttpClient4.1.2 & HtmlUn ... -
HttpClient4登陆ITeye
2012-01-08 23:33 1895import java.io.IOException; im ... -
Spring2集成测试
2011-08-25 22:21 761Spring2测试类继承层次 集成测试例子 public ... -
Learning EasyMock3.0 By Official Example
2011-08-24 16:48 1375Maven Installation+ add followi ...
相关推荐
主要介绍了Spring Boot 单元测试和集成测试实现详解,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
通过Spring集成单元测试,以后测试service层内容时,就不用getBean()来获得Service层对象了
最简单的含单元测试的spring boot+activiti集成demo
spring集成TestNG与Mockito框架单元测试方法,方便学习者能快速上手如何单测,对自己的代码能够有质量保证。
对于复杂的业务层如何进行单元测试与集成测试? spring给了我们答案
spring3 + mybatis3 + junit4 可运行项目示例 可进行单元测试,集成测试。。。
为了后期测试基于spring的单元测试,我们直接新建spring工程。新建之后,我们先讲一般在java项目中怎么去做单元测试。我们先定义一个实体User在service包中新建一个接口,在接口中定义一个方法,方法的返回值就是...
spring集成TestNG与Mockito框架单元测试方法
集成测试示例使用Spring Boot和Maven创建单元和集成测试的简单示例命令mvn全新安装仅运行单元测试mvn全新安装-Dit 运行单元测试以及集成测试。 src / test /中有两个脚本,run-pre-integration.sh和run-post-...
Spring集成JUnit4,进行单元测试,包括数据和服务器mock等等
文章是redisUtils工具类的封装,和基于springboot环境的单元测试; 文中封装了redis的众多方法,希望对您有所帮助。
【第八章】 对ORM的支持 之 8.1 概述 ——跟我学spring3 【第八章】 对ORM的支持 之 8.2 集成Hibernate3 ——跟我学spring3 【第八章】 对ORM的支持 之 8.3 ...【第十三章】 测试 之 13.3 集成测试 ——跟我学spring3
Spring EAI单元和集成测试 单元测试-空指针 集成测试-由以下原因导致:javax.naming.NoInitialContextException:需要在环境或系统属性中或作为applet参数或在应用程序资源文件中指定类名称:java.naming.factory....
概述在单元测试时,我们尽量在屏蔽模块间相互干扰的情况下,重点关注模块内部逻辑的正确性。而集成测试则是在将模块整合在一起后...),在单元测试时,你不应该依赖于Spring容器。换言之,你不应该在单元测试时启动Appl
NULL 博文链接:https://copperfield.iteye.com/blog/1170901
MockWebServerKit可以在单元测试中轻松模拟和测试WebClient 。 HttpClientKit可以轻松地将请求发送到集成测试中的控制器。 WireMockKit可以轻松地在集成测试中对我们的第三方依赖WireMockKit进行存根。 您可以在...
spring3基础知识 IoC DI Spring表达式 SpEL Spring JDBC支持 Spring ORM集成 Spring与其他web框架集成 Spring注解零配置 Spring单元测试与集成测试