1.从数据库中取出数据,需要将数据封装成根据字段名能够取出所有字段值。
mapper文件
<select id="getUser" parameterType="java.lang.String" resultType="java.util.Map">
select fdId,docSubject,fd_sqr as fdSqr
from table_1 where doccode=#{docCode}
</select>
dao层
@Mapper
public interface UserDao{
/**
*查询所有同一年龄的人
* @param age 年龄
* @return 数据Map
*/
List<Map<String, Object>> getUser(String age);
}
service层
import cn.hutool.core.map.MapUtil;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.lang3.StringUtils;
import org.sun.common.api.vo.Result;
import org.sun.modules.user.mapper.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
@Slf4j
@Service
public class UserServiceImpl {
@Autowired
private UserDao userDao;
public Result getSupplier(String age) {
try {
List<Map<String, Object>> list = new ArrayList<>();
list = userDao.getUser(age);
if (CollectionUtils.isEmpty(list)) {
return Result.error();
}
Map<String, List<Object>> maps = MapUtil.toListMap(list);
return Result.ok();
} catch (Exception e) {
log.error("失败,失败原因:" + e.getMessage());
return Result.error("失败,失败原因:" + e.getMessage());
}
}
划重点:
https://hutool.cn/docs/index.html#/core/Map/Map%E5%B7%A5%E5%85%B7-MapUtil?id=%e6%96%b9%e6%b3%95