Mybatis-Spring项⽬编写测试类
因为想看⼀下mybatis-Spring项⽬的代码，所有从github上将源码下载下来了，我看了⼀下，可能是测试类太多了，就没有细⼊⼝类，所以⾃⼰写了⼀个主⼊⼝类，特此记录（我本地已经安装Mysql数据库）
⾸先项⽬没有数据库驱动，所以添加⼀下
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.34</version>
</dependency>
然后添加mapper接⼝类
batis.spring.demo.mapper;
public interface DemoMapper {
String getById();
}
添加对应的xml⽂件，在resource/mapper/⽬录下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-////DTD Mapper 3.0//EN"
"/dtd/mybatis-3-mapper.dtd">
<mapper namespace="batis.spring.demo.mapper.DemoMapper">
<select id="getById" resultType="String">
SELECT stu_id FROM record WHERE id = 1
</select>
</mapper>
最后添加⼀个配置类
batis.spring.demo;
batis.spring.SqlSessionFactoryBean;
batis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import t.annotation.Bean;
import t.annotation.Configuration;
import io.Resource;
spring framework版本import io.support.PathMatchingResourcePatternResolver;
import io.support.ResourcePatternResolver;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import javax.sql.DataSource;
@Configuration
@MapperScan("batis.spring.demo.mapper")
public class DemoConfig {
ResourcePatternResolver resourceResolver = new PathMatchingResourcePatternResolver();
@Bean
public SqlSessionFactoryBean getSqlSessionFactoryBean(@Autowired DataSource dataSource) throws Exception{
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
Resource[] resources = Resources("mapper/*.xml");
bean.setMapperLocations(resources);
return bean;
}
@Bean
public DataSource dataSource(){
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName("sql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/test");
dataSource.setUsername("root");
dataSource.setPassword("root");
return dataSource;
}
}
添加⼀个主类做⼀下测试即可
batis.spring;
batis.spring.demo.DemoConfig;
batis.spring.demo.mapper.DemoMapper;
import t.annotation.AnnotationConfigApplicationContext;
public class Main {
public static void main(String[] args) {
AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(DemoConfig.class); DemoMapper bean = Bean(DemoMapper.class);
System.out.ById());
System.out.String());
}
}
整体添加的⽬录结构是这样的
结束。
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论