springBoot整合MyBatise及简单应用
springBoot整合MyBatise及简单应用
我采用的是 工具IDEA 框架是springBoot+maven+Mybatise
第一步:
pom.xml 引入相关jar包
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>cn.xudy.base</groupId> <artifactId>testMybase</artifactId> <version>1.0-SNAPSHOT</version> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.5.4.RELEASE</version> <relativePath/> </parent> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <java.version>1.8</java.version> <mybatis-spring-boot.version>1.2.0</mybatis-spring-boot.version> <mysql-connector.version>5.1.39</mysql-connector.version> </properties> <dependencies> <!-- MYSQL --> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!-- Spring Boot JDBC --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>com.google.code.gson</groupId> <artifactId>gson</artifactId> <version>2.7</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!--Mybatis--> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>${mybatis-spring-boot.version}</version> </dependency> </dependencies> <!--maven打包时应用--> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
第二部:
建立两个配置文件类
1、 我采用了c3p0 JDBC 连接池这个文件主要是配置mybatis 的xml配置文件位置
@Configuration //加上这个注解,使得支持事务 @EnableTransactionManagement public class MyBatisConfig implements TransactionManagementConfigurer { @Bean(name = "dataSource") @Qualifier(value = "dataSource") @Primary @ConfigurationProperties(prefix = "c3p0") public DataSource dataSource() { return DataSourceBuilder.create().type(com.mchange.v2.c3p0.ComboPooledDataSource.class).build(); } @Override public PlatformTransactionManager annotationDrivenTransactionManager() { return new DataSourceTransactionManager(dataSource()); } @Bean(name = "sqlSessionFactory") public SqlSessionFactory sqlSessionFactoryBean() { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource()); bean.setTypeAliasesPackage("cn.group.xudy.model");//每一张表对应的实体类 //添加XML目录 ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); try { bean.setMapperLocations(resolver.getResources("classpath:mapper/*Mapper.xml"));//每张表对应的xml文件 return bean.getObject(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } } @Bean public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } /** * 跨域 * @return */ @Bean public WebMvcConfigurer corsConfigurer() { return new WebMvcConfigurerAdapter() { @Override public void addCorsMappings(CorsRegistry registry) { registry.addMapping("/**"); } }; } }
2、配置mapper java文件
/** * 扫描mybatis的接口 *MyBatis扫描接口,使用的tk.mybatis.spring.mapper.MapperScannerConfigurer,如果你不使用通用Mapper,可以改为org.xxx... * @author zxj * */ @Configuration // 因为这个对象的扫描,需要在MyBatisConfig的后面注入,所以加上下面的注解 @AutoConfigureAfter(MyBatisConfig.class) public class MyBatisMapperScannerConfig { @Bean public MapperScannerConfigurer mapperScannerConfigurer() { MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer(); //获取之前注入的beanName为sqlSessionFactory的对象 mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory"); //每张表对应的XXMapper.java interface类型的Java文件 mapperScannerConfigurer.setBasePackage("cn.group.xudy.mapper"); // Properties properties = new Properties(); // properties.setProperty("mappers", "tk.mybatis.springboot.util.MyMapper"); // properties.setProperty("notEmpty", "false"); // properties.setProperty("IDENTITY", "MYSQL"); // mapperScannerConfigurer.setProperties(properties); return mapperScannerConfigurer; } }
注意 mybatis 的mapper.xml 在IDEA中一定要写到resources下面如图
第三步 :
1.sql以注解的形式访问数据库获取数据
在java下mapper文件下一个下一个简单的注解代码测试下 下面是三种模式
@Select("select * from claims;") List<Map<String,Object>> find(); @Select("Select * from claims where id = '${id}'") Map<String,Object> selectClaimsName(@Param("id") String id); @Select("Select * from claims where id = #{id}") Map<String,Object> selectClaimsName(@Param("id") String id);
写一个调用类根据自己的数据库配置 应该没什么问题了
2、sql语句以xml形式也就是大家常用的mybatis的形式获取数据
在java下mapper中写调用方法
List<ClaimsModel> getAll();
在resources下xml写到 我写的是一对多的形式 有点乱 ,这部分就不细说了,如果不懂可以看看相关Mybatis的使用这里只介绍集成
<?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="cn.group.xudy.mapper.claimsMapper"> <resultMap id="BaseResultMap" type="cn.group.xudy.model.ClaimsModel" > <id column="id" property="id" jdbcType="BIGINT" /> <id column="reason" property="reason" jdbcType="VARCHAR" /> <id column="files" property="files" jdbcType="VARCHAR" /> <!-- ofType指定students集合中的对象类型 --> <!--<association property="claimFilesModelList" javaType="cn.group.xudy.model.ClaimFilesModel">--> <!--</association>--> <collection property="claimFilesModelList" ofType="cn.group.xudy.model.ClaimFilesModel" column="id" select="getStudent"></collection> <!--<collection property="claimFilesModelList" ofType="cn.group.xudy.model.ClaimFilesModel" column="id">--> <!--<id column="file_name" property="fileName" jdbcType="VARCHAR" />--> <!--</collection>--> </resultMap> <sql id="Base_Column_List" > id,reason,files </sql> <select id="getAll" resultMap="BaseResultMap"> -- select * from claims c,claim_files f WHERE c.id=f.claim_id select * from claims c,claim_files </select> <select id="getStudent" parameterType="int" resultType="cn.group.xudy.model.ClaimFilesModel"> SELECT * FROM claim_files WHERE claim_id=#{id} </select> </mapper>
OK 代码附上
https://gitee.com/xdymemory00/testMybase.git