Spring整合Mybatis、Junit

一、Spring整合Mybatis

1.数据库准备

数据库名： mybatis_db           表名：user

2. 在pom.xml中添加相关依赖

新建一个Maven项目

在pom.xml中添加以下依赖

    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.9</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.9</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.16</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!--mybatis3.5.6对应的mybatis-spring是1.3.0-->
        <!--这里两个jar包版本要一一对应-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>
    </dependencies>

3.添加jdbc.properties文件 

在resources目录下添加jdbc.properties文件

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql:///mybatis_db?useSSL=false
jdbc.username=root
jdbc.password=1234

4.创建相关接口，类和对应的包

 Account类

public class Account implements Serializable {
    private Integer id;
    private String name;
    private String password;
    private Integer grade;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Integer getGrade() {
        return grade;
    }

    public void setGrade(Integer grade) {
        this.grade = grade;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", grade=" + grade +
                '}';
    }
}

AccountDao接口

public interface AccountDao {
    @Insert("insert into user(name,password,grade) values (#{name},#{password},#{grade})")
    void insert(Account account);

    @Delete("delete from user where id = #{id}")
    void delete(Integer id);

    @Update("update user set name = #{name},password = #{password} where id = #{id}")
    void update(Account account);

    @Select("select * from user")
    List<Account> findAll();

    @Select("select * from user where id = #{id}")
    Account findById(Integer id);
}

AccountService接口

public interface AccountService {

    //增加数据
    void insert(Account account);

    //删除数据
    void delete(Integer id);

    //更新数据
    void update(Account account);

    //查询所有
    List<Account> findAll();

    //按ID查询
    Account findById(Integer id);
}

 AccountServiceImpl类

@Service
public class AccountServiceImpl implements AccountService {
    @Autowired
    private AccountDao accountDao;

    @Override
    public void insert(Account account) {
        accountDao.insert(account);
    }

    @Override
    public void delete(Integer id) {
        accountDao.delete(id);
    }

    @Override
    public void update(Account account) {
        accountDao.update(account);
    }

    @Override
    public List<Account> findAll() {
        return accountDao.findAll();
    }

    @Override
    public Account findById(Integer id) {
        return accountDao.findById(id);
    }
}

5.编写Config配置类

在SpringConfig类中加入基本注解

//配置类扫描
@Configuration
//包扫描，扫描项目中的AccountServiceImpl类
@ComponentScan("com")
//读properties文件
@PropertySource("jdbc.properties")
public class SpringConfig {
}

配置数据源配置类JdbcConfig

public class JdbcConfig {
    @Value("${jdbc.driver}")
    private String driver;
    @Value("${jdbc.url}")
    private String url;
    @Value("${jdbc.username}")
    private String username;
    @Value("${jdbc.password}")
    private String password;

    @Bean
    public DataSource dataSource(){
        DruidDataSource ds = new DruidDataSource();

        ds.setDriverClassName(driver);
        ds.setUrl(url);
        ds.setUsername(username);
        ds.setPassword(password);

        return ds;
    }
}

配置Mybatis配置类MybatisConfig

public class MybatisConfig {
    //定义bean，SqlSessionFactoryBean用于产生sqlSessionFactory对象
    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
        SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();
        //设置模型类的别名扫描
        ssfb.setTypeAliasesPackage("com.domain");
        //设置数据源
        ssfb.setDataSource(dataSource);
        return ssfb;
    }

    //定义bean,返回MapperScannerConfigurer对象
    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer msc = new MapperScannerConfigurer();
        msc.setBasePackage("com.dao");
        return msc;
    }
}

在主配置类中引入数据源配置类、Mybatis配置类

//配置类扫描
@Configuration
//包扫描，扫描项目中的AccountServiceImpl类
@ComponentScan("com")
//读properties文件
@PropertySource("jdbc.properties")
//引入数据源配置类(JdbcConfig)和Mybatis配置类
@Import({JdbcConfig.class,MybatisConfig.class})
public class SpringConfig {
}

6.编写测试类

在测试类中从IOC容器中获取Service对象，调用方法获取结果

public class Test {
    public static void main(String[] args){
        ApplicationContext ctx = new AnnotationConfigApplicationContext(SpringConfig.class);

        AccountService accountService = ctx.getBean(AccountService.class);

        //查询单条数据
        Account account = accountService.findById(1);
        System.out.println(account);

        //删除数据
        accountService.delete(3);
    }
}

控制台输出

数据库变化

二、Spring整合Junit

Junit用于单元测试，只需在上文整合Mybatis的环境中导入对应的依赖，编写测试类即可

1.在pom.xml中加入Junit对应的依赖

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.3.9</version>
        </dependency>

2.在test\java下创建一个AccountServiceTest类

//设置类运行器
@RunWith(SpringJUnit4ClassRunner.class)
//加载配置类
@ContextConfiguration(classes = {SpringConfig.class})
//加载配置文件
//@ContextConfiguration(locations = {"classpath:applicationContext.xml"})
public class AccountServiceTest {
    @Autowired
    private AccountService accountService;

    @Test
    public void testFindById() {
        System.out.println(accountService.findById(1));
    }

    @Test
    public void testInsert() {
        String name = "张四";
        String password = "196";
        int grade = 98;
        Account account1 = new Account();
        account1.setName(name);
        account1.setPassword(password);
        account1.setGrade(grade);

        accountService.insert(account1);
    }
}

可以通过在测试方法旁的运行图标测试该方法

运行testFindById()，控制台输出

运行testInsert()，数据库变化