spring4零配置集成mybatis3-优快云博客

本文详细介绍如何在Spring环境中配置并使用MyBatis框架。包括pom.xml中引入MyBatis依赖、AppConfig.java中配置数据源及SqlSessionFactory、sqlMapConfig.xml中设置MyBatis配置、test.xml文件定义SQL映射以及DAO层实现业务操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[size=x-large][b]pom.xml[/b][/size]

<!-- mybatis -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.3.0</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.3</version>
		</dependency>

[size=x-large][b]AppConfig.java[/b][/size]

@Bean
public DataSource dataSource(){
    connectionPoolDataSource.setDatabaseName(dataSourceSetting.getDatabaseName());                       connectionPoolDataSource.setDriverClassName(env.getProperty("db1.jdbc.driver"));
        connectionPoolDataSource.setUrl(env.getProperty("db1.jdbc.url"));
        connectionPoolDataSource.setUsername(env.getProperty("db1.jdbc.username"));
        connectionPoolDataSource.setPassword(env.getProperty("db1.jdbc.password"));     connectionPoolDataSource.setValidationQuery(env.getProperty("db1.jdbc.validationQuery"));
        connectionPoolDataSource.setMaxActive(16);
 connectionPoolDataSource.setDatabaseName(env.getProperty("db1.jdbc.databaseName"));       connectionPoolDataSource.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
        return connectionPoolDataSource;
    }

/**
* mybatis整合-SqlSessionFactory
* @return
*/

    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(){
    	SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    	sqlSessionFactoryBean.setDataSource(this.dataSource());
    	sqlSessionFactoryBean.setConfigLocation(new ClassPathResource("/config/sqlMapConfig.xml"));
    	return sqlSessionFactoryBean;
    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplate() throws Exception{
    	SqlSessionTemplate sqlSessionTemplate = new SqlSessionTemplate(this.sqlSessionFactory().getObject());
    	return sqlSessionTemplate;
    }

[size=x-large][b]sqlMapConfig.xml[/b][/size]

<?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>
     <mappers>
         <mapper resource="config/sqlMap/test.xml"/>
     </mappers>
 </configuration>

[size=x-large][b]test.xml[/b][/size]

<?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="test">

    <select id="testSelect" resultType="java.util.HashMap">
    	select * from sys_user where 1=1 and user_name=#{name}
    </select>

</mapper>

[size=x-large][b]DAO[/b][/size]

public class TestDao {
	private static final Logger logger = Logger.getLogger(TestDao.class);	
	@Inject
	SqlSessionTemplate sqlSessionTemplate;
 public void testMybatis(String name)
    {
    	Map<String, Object> _params = new HashMap<String, Object>();
    	_params.put("name", name);
    	List<Object> list  = sqlSessionTemplate.selectList("test.testSelect", _params);
        logger.info("list=="+list);
    }
}