spring_mybatis 核心配置文件

spring_mybatis 核心配置文件：

package com.entor.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.github.pagehelper.PageInterceptor;
import org.apache.ibatis.logging.stdout.StdOutImpl;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.sql.DataSource;

@Configuration
/**
 * 指定扫描的接口包，相当于配置文件MapperScannerConfigurer类
 */
@MapperScan(basePackages = "com.entor.mapper")//指定扫描的接口包
@ComponentScan(basePackages = "com.entor")
@PropertySource(value = "classpath:db.properties")
@EnableTransactionManagement
public class SpringMybatisConfig {
    @Value("${entor.driver}")
    private String driver;
    @Value("${entor.url}")
    private String url;
    @Value("${entor.username}")
    private String username;
    @Value("${entor.password}")
    private String password;
    @Value("${entor.mapperLocations}")
    private String mapperLocations;
    @Value("${entor.typeAliasesPackage}")
    private String typeAliasesPackage;

    @Bean
    public DataSource dataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName(driver);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        return dataSource;
    }
    @Bean
    public TransactionManager transactionManager(DataSource dataSource){
        return new DataSourceTransactionManager(dataSource);
    }
    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws  Exception{
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();

        //设置数据源
        bean.setDataSource(dataSource);
        PathMatchingResourcePatternResolver patternResolver = new PathMatchingResourcePatternResolver();
        //加载orm映射文件
       bean.setMapperLocations(patternResolver.getResources(mapperLocations));
        //配置别名包
        bean.setTypeAliasesPackage(typeAliasesPackage);
        //配置参数类型,封装各种参数配置类型
        org.apache.ibatis.session.Configuration config = new org.apache.ibatis.session.Configuration();
        //下划线转驼峰
        config.setMapUnderscoreToCamelCase(true);
        //开控制台sql输出
        config.setLogImpl(StdOutImpl.class);
        //开启二级缓存
        config.setCacheEnabled(true);

        //设置参数封装对象类型
        bean.setConfiguration(config);
        //设置分页插件
        bean.setPlugins(new PageInterceptor());
        return bean.getObject();
    }
}

增删改查测试代码

package com.entor.test;

import com.entor.config.SpringMybatisConfig;
import com.entor.entity.User;
import com.entor.service.UserService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import java.util.ArrayList;
import java.util.Date;

public class Test {
    public static void main(String[] args) {
        ApplicationContext context = new AnnotationConfigApplicationContext(SpringMybatisConfig.class);
        UserService userService = context.getBean(UserService.class);

        /**
         * 查询测试
         */
//        System.out.println(userService.queryById(1001));

        /**
         * 删除测试
         */
//        userService.deleteById(120);

//        userService.deleteByIds("49,50,51");

        /**
         * 分页查询测试
         */
       /* User user = userService.queryById(52);
        List<User> users = userService.queryByPage(1, 10);
        users.forEach(System.out::println);*/


        /**
         * 新增测试
         */
/*
        User user = new User();
        user.setName("李华12");
        user.setUsername("lihua12");
        user.setPassword("123456");
        user.setSex(0);
        user.setAge(20);
        user.setBirthday(new Date());
        userService.add(user);*/

        /**
         * 更新测试
         */
        /*User user = new User();
        user.setId(10725);
        user.setName("李华12");
        user.setUsername("lihua12");
        user.setPassword("999999");
        user.setSex(0);
        user.setAge(21);
        user.setBirthday(new Date());
        userService.update(user);*/


        /**
         * 批量新增测试
         */
        ArrayList<User> list = new ArrayList<>();
        for (int i=1;i<10;i++){
            User user = new User();
            user.setName("赵露思");
            user.setUsername("zhaolusi");
            user.setPassword("999999");
            user.setSex(1);
            user.setAge(20);
            user.setBirthday(new Date());
            list.add(user);
        }
        userService.addMore(list);
    }
}