roma-api/src/main/java/com/roma/romaapi/dao/PageDao.java

package com.roma.romaapi.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.HashMap;
import java.util.Map;

@Repository
public class PageDao {
    @Autowired
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    // 获取页面json
    public Map dbQueryForMap(String pageCode) {
        try {
            Map<String, Object> paramMap = new HashMap<>();
            paramMap.put("page_code", pageCode);
            Map<String, Object> resMap2 = namedParameterJdbcTemplate.queryForMap(
                    "SELECT `page_json` FROM `page_details` where `page_code` = :page_code", paramMap);

            return resMap2;
        } catch (EmptyResultDataAccessException e) {
            Map<String, Object> resultMap = new HashMap<>();
            resultMap.put("sysErrorCode", "500");
            resultMap.put("sysErrorMessage", "operation failed");

            return resultMap;
        }
    }
}