白蚁预警发短信7-19 12

ke

2024-07-19 f89ad8423f70af954da6f790ffa0163665ee1374

白蚁预警发短信7-19 12

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/skBaiYiTest/entity/BaiYiTestEntity.java

New file
@@ -0,0 +1,39 @@
package cn.gistack.sm.skBaiYiTest.entity;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springblade.core.mp.base.BaseEntity;

import java.sql.Date;

@Data
public class BaiYiTestEntity extends BaseEntity {

    /**
     * 水库
     */
    @ApiModelProperty(value = "水库名称")
    private String skName;

    @ApiModelProperty(value = "水库注册码")
    private String skZcCode;

    @ApiModelProperty(value = "rtu编码")
    private String rtu;

    @ApiModelProperty(value = "白蚁测点号")
    private String termitePointNum;

    @ApiModelProperty(value = "白蚁报警状态")
    private Integer status;

    @ApiModelProperty(value = "白")
    private Date obDate;

    @ApiModelProperty(value = "负责人姓名")
    private String     personInCharge;
    @ApiModelProperty(value = "负责人联系方式")
    private String     phone;


}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/skBaiYiTest/mapper/SkBaiYiMapper.java

New file
@@ -0,0 +1,16 @@
package cn.gistack.sm.skBaiYiTest.mapper;


import cn.gistack.sm.skBaiYiTest.entity.BaiYiTestEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springblade.core.mp.base.BaseEntity;

import java.util.List;

public interface SkBaiYiMapper extends BaseMapper<BaiYiTestEntity> {


    List<BaiYiTestEntity> selectList();


}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/skBaiYiTest/mapper/SkBaiYiMapper.xml

New file
@@ -0,0 +1,12 @@
<?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="cn.gistack.sm.skBaiYiTest.mapper.SkBaiYiMapper">


    <select id="selectList" resultType="cn.gistack.sm.skBaiYiTest.entity.BaiYiTestEntity">
        select * from SJZT_ODS."sk_test_termite_warn"

    </select>


</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/skBaiYiTest/service/ISkBaiYiService.java

New file
@@ -0,0 +1,13 @@
package cn.gistack.sm.skBaiYiTest.service;


import cn.gistack.sm.skBaiYiTest.entity.BaiYiTestEntity;
import com.baomidou.mybatisplus.extension.service.IService;
import org.springblade.core.mp.base.BaseEntity;

import java.util.List;

public interface ISkBaiYiService extends IService<BaiYiTestEntity> {

    List<BaiYiTestEntity> selectList();
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/skBaiYiTest/service/impl/SkBaiYiServiceImpl.java

New file
@@ -0,0 +1,20 @@
package cn.gistack.sm.skBaiYiTest.service.impl;


import cn.gistack.sm.skBaiYiTest.entity.BaiYiTestEntity;
import cn.gistack.sm.skBaiYiTest.mapper.SkBaiYiMapper;
import cn.gistack.sm.skBaiYiTest.service.ISkBaiYiService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.core.mp.base.BaseEntity;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class SkBaiYiServiceImpl extends ServiceImpl<SkBaiYiMapper, BaiYiTestEntity> implements ISkBaiYiService {

    @Override
    public List<BaiYiTestEntity> selectList() {
        return baseMapper.selectList();
    }
}