风场接口

chen_xi

2022-11-17 dc76e8f73c7ff963d7cf47b6f533314a58db36ac

风场接口

 screen-api/src/main/java/com/moral/api/entity/WindModel.java

New file
@@ -0,0 +1,37 @@
package com.moral.api.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.extension.activerecord.Model;
import com.baomidou.mybatisplus.annotation.TableId;
import java.io.Serializable;
import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * <p>
 * 
 * </p>
 *
 * @author moral
 * @since 2022-08-04
 */
@Data
@EqualsAndHashCode(callSuper = false)
public class WindModel extends Model<WindModel> {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    private String json;

    private String value;


    @Override
    protected Serializable pkVal() {
        return this.id;
    }

}

 screen-api/src/main/java/com/moral/api/mapper/WindModelMapper.java

New file
@@ -0,0 +1,22 @@
package com.moral.api.mapper;

import com.moral.api.entity.WindModel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author moral
 * @since 2022-08-04
 */
public interface WindModelMapper extends BaseMapper<WindModel> {

    List<Map<String,Object>> selectWindModel(@Param("map") Map map);

}

 screen-api/src/main/java/com/moral/api/service/WindModelService.java

New file
@@ -0,0 +1,21 @@
package com.moral.api.service;

import com.moral.api.entity.WindModel;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  服务类
 * </p>
 *
 * @author moral
 * @since 2022-08-04
 */
public interface WindModelService extends IService<WindModel> {

    List<Map<String,Object>> selectWindModel();

}

 screen-api/src/main/java/com/moral/api/service/impl/WindModelServiceImpl.java

New file
@@ -0,0 +1,37 @@
package com.moral.api.service.impl;

import com.moral.api.entity.WindModel;
import com.moral.api.mapper.WindModelMapper;
import com.moral.api.service.WindModelService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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

/**
 * <p>
 *  服务实现类
 * </p>
 *
 * @author moral
 * @since 2022-08-04
 */
@Service
public class WindModelServiceImpl extends ServiceImpl<WindModelMapper, WindModel> implements WindModelService {

    @Autowired
    private WindModelMapper windModelMapper;

    @Override
    public List<Map<String, Object>> selectWindModel() {
        Map<String,Object> map = new HashMap<>();
        map.put("p5dna7a0390001",146);
        map.put("p5dna7a0390002",140);
        List<Map<String, Object>> maps = windModelMapper.selectWindModel(map);
        System.out.println(maps);
        return null;
    }
}

 screen-api/src/main/resources/mapper/WindModelMapper.xml

New file
@@ -0,0 +1,20 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.moral.api.mapper.WindModelMapper">

        <!-- 通用查询映射结果 -->
        <resultMap id="BaseResultMap" type="com.moral.api.entity.WindModel">
                    <id column="id" property="id" />
                    <result column="json" property="json" />
                    <result column="value" property="value" />
        </resultMap>

    <select id="selectWindModel" resultType="java.util.Map">
        select * from wind_model
        <where>
            <foreach collection="map.entrySet()" item="value" index="key">
                AND ABS((select JSON_EXTRACT(json, '$.${key}') FROM wind_model)-#{value})<![CDATA[<]]>10
            </foreach>
        </where>
    </select>
</mapper>