springboot集成mybatis

接着上一篇( springboot 集成freemarker)继续搞，接下来集成mybatis

首先还是添加pom依赖

<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-mxj</artifactId>
			<version>5.0.12</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-mxj-db-files</artifactId>
			<version>5.0.12</version>
		</dependency>

		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.8</version>
		</dependency>

接下来配置文件添加

spring.datasource.url=jdbc:mysql://localhost:3306/dev?characterEncoding=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=198910
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

上面是mysql的配置，新建表TB_USER

CREATE TABLE `TB_USER` (
`ID`  varchar(32) NOT NULL ,
`USER_NAME`  varchar(32) NOT NULL ,
`PASSWORD`  varchar(32) NOT NULL ,
`ENABLE`  varchar(2) NOT NULL DEFAULT '1' ,
`PHONE`  varchar(11) NULL ,
`EMAIL`  varchar(32) NULL ,
`EXTEND_FIELD`  text NULL ,
`CREATE_TIME`  datetime NOT NULL DEFAULT now() ,
`UPDATE_TIME`  datetime NOT NULL DEFAULT now() ,
PRIMARY KEY (`ID`)
)
;

自定义DatabaseConfig，方便之后的扩展

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;

@EnableAutoConfiguration
@SpringBootApplication
@ComponentScan
@MapperScan("springboot.demo.mapper")
public class DatabaseConfig {

	@Bean
	@ConfigurationProperties(prefix = "spring.datasource")
	public DataSource dataSource() {
		return new org.apache.tomcat.jdbc.pool.DataSource();
	}

	@Bean
	public SqlSessionFactory sqlSessionFactoryBean() throws Exception {
		SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
		sqlSessionFactoryBean.setDataSource(dataSource());
		PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
		sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/*.xml"));
		return sqlSessionFactoryBean.getObject();
	}

	@Bean
	public PlatformTransactionManager transactionManager() {
		return new DataSourceTransactionManager(dataSource());
	}
}

resources目录下添加mybatis目录，用于存放mapper文件，然后编辑对应的service，controller，可以访问看看

git clone https://github.com/cm-jornada/demo.git
git checkout orm

附完整配置

# DATASOURCE (DataSourceAutoConfiguration & DataSourceProperties)  
spring.datasource.name= # name of the data source  
spring.datasource.initialize=true # populate using data.sql  
spring.datasource.schema= # a schema (DDL) script resource reference  
spring.datasource.data= # a data (DML) script resource reference  
spring.datasource.platform= # the platform to use in the schema resource (schema-${platform}.sql)  
spring.datasource.continueOnError=false # continue even if can't be initialized  
spring.datasource.separator=; # statement separator in SQL initialization scripts  
spring.datasource.driverClassName= # JDBC Settings...  
spring.datasource.url=  
spring.datasource.username=  
spring.datasource.password=  
spring.datasource.max-active=100 # Advanced configuration...  
spring.datasource.max-idle=8  
spring.datasource.min-idle=8  
spring.datasource.initial-size=10  
spring.datasource.validation-query=  
spring.datasource.test-on-borrow=false  
spring.datasource.test-on-return=false  
spring.datasource.test-while-idle=  
spring.datasource.time-between-eviction-runs-millis=  
spring.datasource.min-evictable-idle-time-millis=  
spring.datasource.max-wait-millis=