Guest User

Untitled

a guest
Jan 19th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.45 KB | None | 0 0
  1. com.XXX.org.mapper
  2. public interface EmployeeMapper {
  3. public Employee getEmployeeFullDetails(String employeeId);
  4. }
  5.  
  6. <?xml version="1.0" encoding="UTF-8" ?>
  7. <!DOCTYPE mapper
  8. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  9.  
  10. <mapper namespace="com.XXX.org.mapper.EmployeeMapper">
  11. <select id="getEmployeeFullDetails" parameterType="String" resultType="com.XXX.org.Domain.Employee">
  12. SELECT * from employee emp
  13. where emp.employeeId = #{employeeId}
  14. </select>
  15. </mapper>
  16.  
  17. <context:annotation-config/>
  18.  
  19. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" >
  20. <property name="driverClassName" value="${dataSource.driverClassName}" />
  21. <property name="username" value="${dataSource.username}" />
  22. <property name="password" value="${dataSource.password}" />
  23. <property name="url" value="${dataSource.url}" />
  24. </bean>
  25.  
  26. <context:component-scan base-package="com.XXX.org"/>
  27.  
  28. <context:annotation-config/>
  29.  
  30. <tx:annotation-driven />
  31.  
  32.  
  33. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >
  34. <property name="dataSource" ref="dataSource" />
  35. <property name="typeAliasesPackage" value="com.XXX.org.domain" />
  36. </bean>
  37.  
  38. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" >
  39. <property name="basePackage" value="com.XXX.org.mapper" />
  40. <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
  41. </bean>
  42.  
  43. @RunWith(SpringJUnit4ClassRunner.class)
  44. @ContextConfiguration(locations = {"classpath:applicationContext.xml", "classpath:service-bean.xml"})
  45. @TestExecutionListeners({DependencyInjectionTestExecutionListener.class, DbUnitTestExecutionListener.class})
  46. public class EmployeeTest {
  47.  
  48. @Autowired
  49. EmployeeMapper employeeMapper;
  50.  
  51.  
  52. @Test
  53. @DatabaseSetup(value = {"/employee.xml"} , type= com.github.springtestdbunit.annotation.DatabaseOperation.CLEAN_INSERT)
  54. public void testInsertEmployee() {
  55.  
  56. Employee employee= employeeMapper.getEmployeeFullDetails("testUser");
  57. }
  58.  
  59. <build>
  60. ...
  61. <resources>
  62. <resource>
  63. <directory>src/main/java</directory>
  64. <excludes>
  65. <exclude>**/.svn/*</exclude>
  66. </excludes>
  67. <includes>
  68. <include>**/*.xml</include>
  69. </includes>
  70. </resource>
  71. </resources>
  72. </build>
  73.  
  74. mybatis.mapperLocations=classpath*:**/xml/*.xml
Add Comment
Please, Sign In to add comment