【mybitis执行sql】mybatis直接执行传入的sql语句

【转自】https://blog.youkuaiyun.com/xingqibaing/article/details/95632363

（一）通过配置文件的方式实现

1、dao.java

 public List<Map<String, Object>> selectPublicItemList(@Param(value="sqlStr") String sqlStr);

2、mapper.xml

1. <select id="selectPublicItemList" parameterType="String" resultType="java.util.Map">

2. ${sqlStr}

3. </select>

3、测试类

1. package com.yukong.chapter5.repository;

2. import org.junit.Test;

3. import org.junit.runner.RunWith;

4. import org.springframework.beans.factory.annotation.Autowired;

5. import org.springframework.boot.test.context.SpringBootTest;

6. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

7. import java.util.List;

8. import java.util.Map;

9. @SpringBootTest

10. @RunWith(SpringJUnit4ClassRunner.class)

11. public class UserMapperTest {

12. @Autowired

13. private PublicMapper publicMapper;

14. @Test

15. public void getPublicData(){

16. String sql = "select id,age,password,sex,username from user where id = 1";

17. List<Map<String, Object>> list = publicMapper.selectPublicItemList(sql);

18. }

19. }

（二）通过注解的方式实现

1、dao.java

1. import org.apache.ibatis.annotations.Mapper;

2. import org.apache.ibatis.annotations.Param;

3. import org.apache.ibatis.annotations.Select;

4. import java.util.LinkedHashMap;

5. import java.util.List;

6. /**

7. * @description:

8. * @author: zhengkeyang

9. * @date: 2019/7/12

10. */

11. @Mapper

12. public interface PublicMapper {

13. @Select("${sqlStr}")

14. List<LinkedHashMap<String,Object>> getPublicItems(@Param(value = "sqlStr") String sqlStr);

15. }

2、测试类

1. @Autowired

2. private PublicMapper publicMapper;

3. @GetMapping("/user")

4. public Object getUser(){

5. List<LinkedHashMap<String,Object>> mapList = publicMapper.getPublicItems("select id,age,password,sex,username from user where id = 1");

6. return mapList;

7. }

注意事项：

Dao中getPublicItems返回值的Map集合要指定为LinkedHashMap，不然查询的数据和sql中字段顺序会不一致。