1.引入SqlMapper依赖
<!--sqlmapper-->
<dependency>
<groupId>com.github.abel533</groupId>
<artifactId>mapper</artifactId>
<version>2.3.0</version>
</dependency>
2.新建一个Bean为SqlSessionFactory
@Configuration
public class SqlSessionFactoryConfig {
@Autowired
DataSource dataSource;
@Bean
@Primary
public SqlMapper sqlMapper() throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);//更多参数请自行注入
SqlSession session = bean.getObject().openSession();
SqlMapper sqlMapper = new SqlMapper(session);
return sqlMapper;
}
}
测试一下
@Autowired
private SqlMapper sqlMapper;
@Override
public List<Map<String,Object>> getUserList() {
StringBuffer sql = new StringBuffer();
sql.append(" select * from user_test");
List<Map<String,Object>> userList = sqlMapper.selectList(sql.toString());
return userList;
}
}