5、导入c3p0数据库连接池
在pom.xml中添加字句:
保存后Maven会自动下载依赖包,注意等待右下角进度条完成。
6、配置DataSource数据源和SessionFactory
新建com.zzz.springboot_maven_ssm_demo.config包下,创建SSMConfiguration类,代码如下:
package com.zzz.springboot_maven_ssm_demo.config;
import java.beans.PropertyVetoException;
import java.io.IOException;
import javax.sql.DataSource;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import com.mchange.v2.c3p0.ComboPooledDataSource;
/**
* @ClassName: SSMConfiguration
* @Description:配置DataSource数据源和持久层的SessionFactory
* @author Administrator
* @date: 2022年3月21日 下午5:08:48
* @Copyright:
*/
@Configuration
@MapperScan("com.zzz.springboot_maven_ssm_demo.dao") //mapper的扫描路径
public class SSMConfiguration {
//自动装配@Bean(name="dataSource")
@Autowired
private DataSource dataSource;
@Bean(name="dataSource")
public ComboPooledDataSource createDataSource() throws PropertyVetoException {
ComboPooledDataSource dataSource = new ComboPooledDataSource();
//driver url username password
dataSource.setDriverClass("com.mysql.jdbc.Driver");
dataSource.setJdbcUrl("jdbc:mysql://::1:3306/ssm_mybatis?serverTimezone=UTC&characterEncoding=utf-8&useSSL=true");
dataSource.setUser("root");
dataSource.setPassword("root");
dataSource.setAutoCommitOnClose(false);
return dataSource;
}
@Bean(name="sqlSessionFactory")
public SqlSessionFactoryBean createSqlSessionFactoryBean() throws IOException {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
//加载主配置文件mybatis-config.xml
bean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
//Mapper扫描路径
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
String packageSearchPath = "classpath*:/mapper/**.xml";
bean.setMapperLocations(resolver.getResources(packageSearchPath));
//配置实体数据包
bean.setTypeAliasesPackage("com.zzz.springboot_maven_ssm_demo.entity");
//设置dataSource
bean.setDataSource(dataSource);
return bean;
}
}
然后创建的工程目录结构如下:
注意:一定要以com.zzz.springboot_maven_ssm_demo为根包。
mybatis-config.xml的配置内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 获取主键自增的值 -->
<setting name="useGeneratedKeys" value="true"/>
<!-- 开启驼峰命名的转化 -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>
7、运行测试
对着com.zzz.springboot_maven_ssm_demo根包右键运行:
控制台窗口出现Tomcat started字句就成功运行了。