這里講的是Spring與mybatis簡單使用。

配置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資源路徑下。當然這個路徑可以在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>