Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- com.XXX.org.mapper
- public interface EmployeeMapper {
- public Employee getEmployeeFullDetails(String employeeId);
- }
- <?xml version="1.0" encoding="UTF-8" ?>
- <!DOCTYPE mapper
- PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
- <mapper namespace="com.XXX.org.mapper.EmployeeMapper">
- <select id="getEmployeeFullDetails" parameterType="String" resultType="com.XXX.org.Domain.Employee">
- SELECT * from employee emp
- where emp.employeeId = #{employeeId}
- </select>
- </mapper>
- <context:annotation-config/>
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" >
- <property name="driverClassName" value="${dataSource.driverClassName}" />
- <property name="username" value="${dataSource.username}" />
- <property name="password" value="${dataSource.password}" />
- <property name="url" value="${dataSource.url}" />
- </bean>
- <context:component-scan base-package="com.XXX.org"/>
- <context:annotation-config/>
- <tx:annotation-driven />
- <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >
- <property name="dataSource" ref="dataSource" />
- <property name="typeAliasesPackage" value="com.XXX.org.domain" />
- </bean>
- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" >
- <property name="basePackage" value="com.XXX.org.mapper" />
- <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
- </bean>
- @RunWith(SpringJUnit4ClassRunner.class)
- @ContextConfiguration(locations = {"classpath:applicationContext.xml", "classpath:service-bean.xml"})
- @TestExecutionListeners({DependencyInjectionTestExecutionListener.class, DbUnitTestExecutionListener.class})
- public class EmployeeTest {
- @Autowired
- EmployeeMapper employeeMapper;
- @Test
- @DatabaseSetup(value = {"/employee.xml"} , type= com.github.springtestdbunit.annotation.DatabaseOperation.CLEAN_INSERT)
- public void testInsertEmployee() {
- Employee employee= employeeMapper.getEmployeeFullDetails("testUser");
- }
- <build>
- ...
- <resources>
- <resource>
- <directory>src/main/java</directory>
- <excludes>
- <exclude>**/.svn/*</exclude>
- </excludes>
- <includes>
- <include>**/*.xml</include>
- </includes>
- </resource>
- </resources>
- </build>
- mybatis.mapperLocations=classpath*:**/xml/*.xml
Add Comment
Please, Sign In to add comment