摘要: 之前有个需求,需要动态查询某一个表的某些字段,看了下MyBatis的文档,它可以支持的,具体做法如下:
一:Controller层
1 package boss.portal.web.controller; 2 3 import boss.base.web.controller.BaseController; 4 import boss.base.web.support.ResponseModel; 5 import boss.portal.web.service.CommonService; 6 import io.swagger.annotations.Api; 7 import io.swagger.annotations.ApiOperation; 8 import org.springframework.beans.factory.annotation.Autowired; 9 import org.springframework.web.bind.annotation.RequestMapping; 10 import org.springframework.web.bind.annotation.RequestMethod; 11 import org.springframework.web.bind.annotation.RequestParam; 12 import org.springframework.web.bind.annotation.RestController; 13 14 import java.util.List; 15 import java.util.Map; 16 17 /** 18 * 描述: 19 * <p> 20 * Author: 赵新国 21 * Date: 2018/1/31 17:48 22 */ 23 @RestController 24 @Api(value = "公共接口管理", description = "公共接口管理") 25 @RequestMapping(value = "/common") 26 public class CommonController extends BaseController { 27 28 @Autowired 29 private CommonService commonService; 30 31 @ApiOperation(value = "根据ID获取指定实体,字段对应的返回值", notes = "根据ID获取指定实体,字段对应的返回值") 32 @RequestMapping(value = "/get", method = RequestMethod.GET) 33 public ResponseModel get(@RequestParam(required = false) String ids, 34 @RequestParam(required = false) String tableName, 35 @RequestParam(required = false) String fields) { 36 List<Map<String, Object>> maps = commonService.get(ids, tableName, fields); 37 return renderSuccess(maps); 38 } 39 40 }
二:Service层
1 package boss.portal.web.service; 2 3 import boss.auth.user.provider.IUserProvider; 4 import com.alibaba.boot.dubbo.annotation.DubboConsumer; 5 import org.springframework.stereotype.Component; 6 7 import java.util.List; 8 import java.util.Map; 9 10 /** 11 * 描述: 12 * <p> 13 * Author: 赵新国 14 * Date: 2018/1/31 17:48 15 */ 16 @Component 17 public class CommonService { 18 19 @DubboConsumer(lazy = true) 20 private IUserProvider userProvider; 21 22 public List<Map<String,Object>> get(String ids, String tableName, String fields) { 23 List<Map<String, Object>> maps = userProvider.get(ids, tableName, fields); 24 return maps; 25 } 26 }
三:Provider层
@Override public List<Map<String, Object>> get(String ids, String tableName, String fields) { List<Map<String, Object>> maps = userMapper.get(ids, tableName, fields); if (maps != null && !maps.isEmpty()) { return maps; } return null; }
四:Mapper层
List<Map<String,Object>> get(@Param("ids") String ids, @Param("tableName") String tableName, @Param("fields") String fields);
五:Mapper.xml
<!-- 根据指定ID获取指定数据表的指定字段的数据集 --> <select id="get" resultType="java.util.Map" statementType="STATEMENT" > select ${fields} from ${tableName} where id in ( ${ids} ) </select>
附录: 最后说明一下,fields代表你要查询的字段,tableName代表你要查询的表名称,ids代表你要查询的id集合, 这样你就可以随意查询任何你想要的表和字段了,再也不用担心其他人让你加接口了!
————————————————
版权声明:本文为CSDN博主「迷彩的博客」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/sxdtzhaoxinguo/java/article/details/79235998