准备工作:
jdbc.properties 要测试的接口 接口的映射文件
第一步:配置数据库连接对象
<!--整合数据库连接对象--> <context:property-placeholder location="classpath:jdbc.properties"/> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"> <property name="driverClassName" value="${jdbc.driver}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </bean>
第二步:配置mybaties
<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!--设置连接池--> <property name="dataSource" ref="dataSource"/> <!--关联mybaties配置文件--> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean>
第三步:自动扫描包
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="it.heima.mapper"/> </bean>
第四步:测试
@RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations = "classpath:beans.xml") public class BookMapperTest { @Value("#{bookMapper}") private BookMapper bookMapper; @Test public void test(){ Book book = bookMapper.queryById(1); System.out.println(book); } }