這里講的是Spring與mybatis簡(jiǎn)單使用砂竖。
配置bean
@Bean
public DataSource dataSource() {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName(environment.getProperty("driverClass"));
dataSource.setUrl(environment.getProperty("url"));
dataSource.setUsername(environment.getProperty("d_username"));
dataSource.setPassword(environment.getProperty("password"));
return dataSource;
}
@Bean
public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource);
sqlSessionFactoryBean.setTypeAliasesPackage("com.ming.web.domain");
return sqlSessionFactoryBean.getObject();
}
public MapperFactoryBean<UserMapper> userMapper(SqlSessionFactory sqlSessionFactory) {
MapperFactoryBean<UserMapper> factoryBean = new MapperFactoryBean<>(UserMapper.class);
factoryBean.setSqlSessionFactory(sqlSessionFactory);
return factoryBean;
}
創(chuàng)建UserMapper
public interface UserMapper {
User getUser(long userId);
}
創(chuàng)建UserMapper.xml
這里得注意的是，UserMapper.xml必須和UserMapper路徑是一樣的谭跨。比如UserMapper全名師com.ming.dao.UserMapper,那么UserMapper.xml必須放在com/ming/dao/UserMapper.xml資源路徑下蚕愤。當(dāng)然這個(gè)路徑可以在sqlSessionFactoryBean中配置修改。
<?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">
<!--namespace是UserMapper類全路徑-->
<mapper namespace="com.ming.web.dao.UserMapper">
<select id="getUser" resultType="User">/*dialect*/
SELECT * FROM t_user WHERE id = #{userId}
</select>
</mapper>
