目录
整合方法:配置两个Bean替代之前的配置文件编辑
目录结构
1.导坐标,准备核心配置文件jdbc.properties
2.配置SpringConfig
3.Dao层:创建实体类、写sql
4.service层:引用类型注入
5.Spring运行
6.测试
整合方法:配置两个Bean替代之前的配置文件
目录结构
目录结构
1.导坐标,准备核心配置文件jdbc.properties
4.0.0
com.mytest2
Spring_MyBatis-demo
1.0-SNAPSHOT
org.springframework
spring-context
5.2.10.RELEASE
com.alibaba
druid
1.1.10
org.mybatis
mybatis
3.5.5
mysql
mysql-connector-java
8.0.21
org.springframework
spring-jdbc
5.2.10.RELEASE
org.mybatis
mybatis-spring
1.3.0
junit
junit
4.12
test
org.springframework
spring-test
5.2.10.RELEASE
test
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring_db?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC
jdbc.userName=root
jdbc.passWord=1234
2.配置SpringConfig
package com.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;
public class JdbcConfig {
//1.定义一个方法获得要管理的对象
//2.添加@Bean,表示当前方法的返回值是一个bean
@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 druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(driver);
druidDataSource.setUrl(url);
druidDataSource.setUsername(userName);
druidDataSource.setPassword(passWord);
return druidDataSource;
}
}
package com.config;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;
public class MyBatisConfig {
@Bean
public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();
ssfb.setTypeAliasesPackage("com.pojo");
ssfb.setDataSource(dataSource);
return ssfb;
}
@Bean
public MapperScannerConfigurer mapperScannerConfigurer(){
//Mapper代理的配置
MapperScannerConfigurer msc = new MapperScannerConfigurer();
msc.setBasePackage("com.mapper");
return msc;
}
}
package com.config;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.context.annotation.PropertySource;
@Configuration
@ComponentScan({"com.mapper","com.service"})
@PropertySource("jdbc.properties")
@Import({JdbcConfig.class,MyBatisConfig.class})
public class SpringConfig {
}
4.0.0 com.mytest2 Spring_MyBatis-demo1.0-SNAPSHOT org.springframework spring-context5.2.10.RELEASE com.alibaba druid1.1.10 org.mybatis mybatis3.5.5 mysql mysql-connector-java8.0.21 org.springframework spring-jdbc5.2.10.RELEASE org.mybatis mybatis-spring1.3.0 junit junit4.12 test org.springframework spring-test5.2.10.RELEASE test
jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/spring_db?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC jdbc.userName=root jdbc.passWord=1234



