From a093b470d5f9ce57c05ad610312d4af69688a18b Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 07 十月 2023 15:01:32 +0800 Subject: [PATCH] 添加地块实体类、Mapper映射类 --- /dev/null | 56 ---- src/main/resources/application.properties | 2 src/main/java/com/smartearth/poiexcel/entity/DkEntity.java | 586 +++++++++++++++++++++++++++++++++++++++++++++ src/main/java/com/smartearth/poiexcel/mapper/EntMapper.java | 42 +++ src/main/java/com/smartearth/poiexcel/controller/EntController.java | 16 src/main/java/com/smartearth/poiexcel/mapper/DkMapper.java | 15 + src/main/resources/mapper/EntMapper.xml | 2 src/main/java/com/smartearth/poiexcel/config/InitConfig.java | 24 + 8 files changed, 666 insertions(+), 77 deletions(-) diff --git a/src/main/java/com/smartearth/poiexcel/config/InitConfig.java b/src/main/java/com/smartearth/poiexcel/config/InitConfig.java index 3fbbfd8..5f5626c 100644 --- a/src/main/java/com/smartearth/poiexcel/config/InitConfig.java +++ b/src/main/java/com/smartearth/poiexcel/config/InitConfig.java @@ -4,8 +4,8 @@ import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.smartearth.poiexcel.entity.*; +import com.smartearth.poiexcel.mapper.DkMapper; import com.smartearth.poiexcel.mapper.EntMapper; -import com.smartearth.poiexcel.mapper.QiYeMapper; import com.smartearth.poiexcel.service.EntService; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; @@ -21,6 +21,7 @@ * @author WWW */ @Component +@SuppressWarnings("ALL") public class InitConfig implements ApplicationRunner { @Resource EntService entService; @@ -29,7 +30,7 @@ EntMapper entMapper; @Resource - QiYeMapper qiYeMapper; + DkMapper dkMapper; private final static Log log = LogFactory.getLog(InitConfig.class); @@ -39,7 +40,7 @@ try { log.info("***************** 绯荤粺鍚姩瀹屾瘯 *****************" + "\n"); - //test(); + test(); } catch (Exception ex) { log.error(ex.getMessage(), ex); } @@ -49,16 +50,19 @@ * 娴嬭瘯 */ private void test() { - int count = qiYeMapper.selectCount(); + /*int count = entMapper.selectCount(); int pages = (count - 1) / StaticData.I100 + 1; int pageSize = 2, pageIndex = 1; - List<EntEntity> list = qiYeMapper.selectByPage(pageSize, pageSize * (pageIndex - 1)); - list.get(0).setX(119.0); - list.get(0).setY(39.0); - //qiYeMapper.update(list.get(0)); - int cc = qiYeMapper.updates(list); + List<EntEntity> list = entMapper.selectByPage(pageSize, pageSize * (pageIndex - 1)); - // List<EntEntity> list = entMapper.selectList(new QueryWrapper<>()) + int c1 = entMapper.update(list.get(0)); + int c2 = entMapper.updates(list);*/ + + /*QueryWrapper dkWrapper = new QueryWrapper(); + dkWrapper.eq("dikuaibianhao", "N86G1"); + List<DkEntity> dkList = dkMapper.selectList(dkWrapper); + dkList.get(0).setPoint_area(""); + int c3 = dkMapper.updateBatch(dkList);*/ String tokenJson = "{\"success\":true,\"code\":200,\"message\":\"鎴愬姛\",\"data\":{\"ctoken\":\"ZmYxZTgyN2QxZTYyNDMxMDhjZjgzNDNiNDZiN2RjMDVAYTc3ZmFlOGE5ZGM0OGQ1Y2ZmODY4ZTFmNWYwZTEzM2E=\",\"userInfo\":{\"loginLogId\":\"1ab1675c3632428a84dc0ebe579cd66f\",\"phoneNumber\":\"\",\"displayName\":\"鏃剁┖涓�寮犲浘\",\"userMail\":\"\",\"departLevel\":\"5-1\",\"id\":\"ff1e827d1e6243108cf8343b46b7dc05\",\"userID\":\"shikong001\",\"uniqueID\":\"\",\"departName\":\"姹借溅鍜屾櫤鑳藉埗閫犱骇涓氫笓鐝璡"},\"expires\":3600,\"roles\":[]}}"; Result rsToken = JSON.parseObject(tokenJson, Result.class); diff --git a/src/main/java/com/smartearth/poiexcel/controller/EntController.java b/src/main/java/com/smartearth/poiexcel/controller/EntController.java index cd1bd57..3d71423 100644 --- a/src/main/java/com/smartearth/poiexcel/controller/EntController.java +++ b/src/main/java/com/smartearth/poiexcel/controller/EntController.java @@ -6,7 +6,6 @@ import com.smartearth.poiexcel.entity.ResponseMsg; import com.smartearth.poiexcel.entity.StaticData; import com.smartearth.poiexcel.mapper.EntMapper; -import com.smartearth.poiexcel.mapper.QiYeMapper; import com.smartearth.poiexcel.service.EntService; import com.smartearth.poiexcel.utils.HttpUtils; import com.smartearth.poiexcel.utils.StringHelper; @@ -41,9 +40,6 @@ @Resource EntMapper entMapper; - @Resource - QiYeMapper qiYeMapper; - @Value("${address.code.url}") private String addressCodeUrl; @@ -54,7 +50,7 @@ @GetMapping({"/selectByName"}) public ResponseMsg<Object> selectByName(String name) { try { - List<EntEntity> list = qiYeMapper.selectByName(StringHelper.getLikeStr(name)); + List<EntEntity> list = entMapper.selectByName(StringHelper.getLikeStr(name)); return success(null == list ? 0 : list.size(), list); } catch (Exception ex) { @@ -159,8 +155,8 @@ if (null == pageIndex || pageIndex < 1) { pageIndex = 1; } - int count = qiYeMapper.selectCount(); - List<EntEntity> list = qiYeMapper.selectByPage(pageSize, StaticData.I100 * (pageIndex - 1)); + int count = entMapper.selectCount(); + List<EntEntity> list = entMapper.selectByPage(pageSize, StaticData.I100 * (pageIndex - 1)); return success(count, list); } catch (Exception ex) { @@ -173,14 +169,14 @@ public ResponseMsg<Object> updateCoords() { try { int rows = 0; - int count = qiYeMapper.selectCount(); + int count = entMapper.selectCount(); if (0 == count) { return success("娌℃湁鏁版嵁闇�瑕佹洿鏂�", count); } int pages = (count - 1) / StaticData.I100 + 1; for (int i = 1; i <= pages; i++) { - List<EntEntity> list = qiYeMapper.selectByPage(StaticData.I100, StaticData.I100 * (i - 1)); + List<EntEntity> list = entMapper.selectByPage(StaticData.I100, StaticData.I100 * (i - 1)); if (null == list || list.isEmpty()) { continue; } @@ -191,7 +187,7 @@ } } - rows += qiYeMapper.updates(list); + rows += entMapper.updates(list); } return success(rows); diff --git a/src/main/java/com/smartearth/poiexcel/entity/DkEntity.java b/src/main/java/com/smartearth/poiexcel/entity/DkEntity.java new file mode 100644 index 0000000..848c6cd --- /dev/null +++ b/src/main/java/com/smartearth/poiexcel/entity/DkEntity.java @@ -0,0 +1,586 @@ +package com.smartearth.poiexcel.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import lombok.AllArgsConstructor; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; + +/** + * 鍦板潡瀹炰綋绫� + * @author WWW + * @date 2023-10-07 + */ +@Data +@AllArgsConstructor +@TableName("smart_earth.yz_dikuaixinxi") +@EqualsAndHashCode(callSuper = false) +public class DkEntity implements Serializable { + private static final long serialVersionUID = -8624235184539814989L; + + /** + * 涓婚敭 + */ + @TableId(type = IdType.AUTO) + private Long id; + + /** + * 鍦板潡缂栧彿 + */ + private String dikuaibianhao; + + /** + * 鏃ц鍖� + */ + private String jiujiequ; + + /** + * 鏂拌鍖� + */ + private String xinjiequ; + + /** + * 椤圭洰鍚嶇О + */ + private String xiangmuming; + + /** + * 鐢ㄥ湴鎬ц川 + */ + private String yongdixingzhi; + + /** + * 鐢ㄥ湴闈㈢Н + */ + private Double yongdimianji; + + /** + * 瑙勫垝瀹圭Н + */ + private Double guihuarongji; + + /** + * 瑙勫垝寤虹瓚闈㈢Н + */ + private Double guihuajian; + + /** + * 宸ョ▼璇� + */ + private Double gongchengzheng; + + /** + * 椤圭洰杩涘害 + */ + private Double xmjd; + + /** + * 鍑鸿鏃堕棿 + */ + private String churangshi; + + /** + * 鎰忚 + */ + private String yijian; + + /** + * 宸ョ▼ + */ + private String gongcheng; + + /** + * PT2 + */ + private String PT2; + + /** + * 鍖哄煙 + */ + private String qiye; + + /** + * 鍖哄煙鍚嶇О + */ + private String quyumingcheng; + + /** + * 闈㈢Н + */ + private Double mianji; + + /** + * 鐢ㄥ湴绫诲瀷 + */ + private String yijilei; + + /** + * 缁忓害 + */ + private Double lng; + + /** + * 绾害 + */ + private Double lat; + + /** + * 鍦板潡鑼冨洿 + */ + private String point_area; + + /** + * 鐢ㄥ湴缂栧彿 + */ + private String ydbh; + + /** + * 椤圭洰鍚嶇О + */ + private String xmmc; + + /** + * 鐢ㄥ湴绫诲瀷 + */ + private String ydlx; + + /** + * 鐢ㄥ湴闈㈢Н + */ + private Double ydmj; + + /** + * 椤圭洰鍦板潃 + */ + private String xmdz; + + /** + * 鍑鸿骞撮檺 + */ + private Integer crnx; + + /** + * 鐢ㄥ湴鍒嗗瀷 + */ + private String cyfx; + + /** + * 鍑鸿骞翠唤 + */ + private Integer crnf; + + /** + * 瀹圭Н鐜� + */ + private Double rjl; + + /** + * 鐢ㄥ湴绫诲瀷鍚嶇О + */ + private String ydlxmc; + + /** + * 寤虹瓚闄愰珮 + */ + private Double jzxg; + + /** + * 寤虹瓚楂樺害 + */ + private Double jzgd; + + /** + * 瑙勫垝瀹圭Н鐜� + */ + private Double ghrjl; + + /** + * 浼佷笟鍚嶇О + */ + private String qymc; + + /** + * 鐘舵�� + */ + private Integer zt; + + /** + * 鐢ㄥ湴鎬ц川 + */ + private String ydxz; + + /** + * 鐢ㄥ湴绫诲瀷 + */ + private String type; + + /** + * 瑙勫垝寤虹瓚瑙� + */ + private Double jzgh; + + /** + * 鐢ㄥ湴绫诲瀷 + */ + private String ltype; + + /** + * 缂栧彿 + */ + private String no; + + /** + * 闈㈢Н + */ + private Double area; + + public DkEntity() { + } + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getDikuaibianhao() { + return dikuaibianhao; + } + + public void setDikuaibianhao(String dikuaibianhao) { + this.dikuaibianhao = dikuaibianhao; + } + + public String getJiujiequ() { + return jiujiequ; + } + + public void setJiujiequ(String jiujiequ) { + this.jiujiequ = jiujiequ; + } + + public String getXinjiequ() { + return xinjiequ; + } + + public void setXinjiequ(String xinjiequ) { + this.xinjiequ = xinjiequ; + } + + public String getXiangmuming() { + return xiangmuming; + } + + public void setXiangmuming(String xiangmuming) { + this.xiangmuming = xiangmuming; + } + + public String getYongdixingzhi() { + return yongdixingzhi; + } + + public void setYongdixingzhi(String yongdixingzhi) { + this.yongdixingzhi = yongdixingzhi; + } + + public Double getYongdimianji() { + return yongdimianji; + } + + public void setYongdimianji(Double yongdimianji) { + this.yongdimianji = yongdimianji; + } + + public Double getGuihuarongji() { + return guihuarongji; + } + + public void setGuihuarongji(Double guihuarongji) { + this.guihuarongji = guihuarongji; + } + + public Double getGuihuajian() { + return guihuajian; + } + + public void setGuihuajian(Double guihuajian) { + this.guihuajian = guihuajian; + } + + public Double getGongchengzheng() { + return gongchengzheng; + } + + public void setGongchengzheng(Double gongchengzheng) { + this.gongchengzheng = gongchengzheng; + } + + public Double getXmjd() { + return xmjd; + } + + public void setXmjd(Double xmjd) { + this.xmjd = xmjd; + } + + public String getChurangshi() { + return churangshi; + } + + public void setChurangshi(String churangshi) { + this.churangshi = churangshi; + } + + public String getYijian() { + return yijian; + } + + public void setYijian(String yijian) { + this.yijian = yijian; + } + + public String getGongcheng() { + return gongcheng; + } + + public void setGongcheng(String gongcheng) { + this.gongcheng = gongcheng; + } + + public String getPT2() { + return PT2; + } + + public void setPT2(String PT2) { + this.PT2 = PT2; + } + + public String getQiye() { + return qiye; + } + + public void setQiye(String qiye) { + this.qiye = qiye; + } + + public String getQuyumingcheng() { + return quyumingcheng; + } + + public void setQuyumingcheng(String quyumingcheng) { + this.quyumingcheng = quyumingcheng; + } + + public Double getMianji() { + return mianji; + } + + public void setMianji(Double mianji) { + this.mianji = mianji; + } + + public String getYijilei() { + return yijilei; + } + + public void setYijilei(String yijilei) { + this.yijilei = yijilei; + } + + public Double getLng() { + return lng; + } + + public void setLng(Double lng) { + this.lng = lng; + } + + public Double getLat() { + return lat; + } + + public void setLat(Double lat) { + this.lat = lat; + } + + public String getPoint_area() { + return point_area; + } + + public void setPoint_area(String point_area) { + this.point_area = point_area; + } + + public String getYdbh() { + return ydbh; + } + + public void setYdbh(String ydbh) { + this.ydbh = ydbh; + } + + public String getXmmc() { + return xmmc; + } + + public void setXmmc(String xmmc) { + this.xmmc = xmmc; + } + + public String getYdlx() { + return ydlx; + } + + public void setYdlx(String ydlx) { + this.ydlx = ydlx; + } + + public Double getYdmj() { + return ydmj; + } + + public void setYdmj(Double ydmj) { + this.ydmj = ydmj; + } + + public String getXmdz() { + return xmdz; + } + + public void setXmdz(String xmdz) { + this.xmdz = xmdz; + } + + public Integer getCrnx() { + return crnx; + } + + public void setCrnx(Integer crnx) { + this.crnx = crnx; + } + + public String getCyfx() { + return cyfx; + } + + public void setCyfx(String cyfx) { + this.cyfx = cyfx; + } + + public Integer getCrnf() { + return crnf; + } + + public void setCrnf(Integer crnf) { + this.crnf = crnf; + } + + public Double getRjl() { + return rjl; + } + + public void setRjl(Double rjl) { + this.rjl = rjl; + } + + public String getYdlxmc() { + return ydlxmc; + } + + public void setYdlxmc(String ydlxmc) { + this.ydlxmc = ydlxmc; + } + + public Double getJzxg() { + return jzxg; + } + + public void setJzxg(Double jzxg) { + this.jzxg = jzxg; + } + + public Double getJzgd() { + return jzgd; + } + + public void setJzgd(Double jzgd) { + this.jzgd = jzgd; + } + + public Double getGhrjl() { + return ghrjl; + } + + public void setGhrjl(Double ghrjl) { + this.ghrjl = ghrjl; + } + + public String getQymc() { + return qymc; + } + + public void setQymc(String qymc) { + this.qymc = qymc; + } + + public Integer getZt() { + return zt; + } + + public void setZt(Integer zt) { + this.zt = zt; + } + + public String getYdxz() { + return ydxz; + } + + public void setYdxz(String ydxz) { + this.ydxz = ydxz; + } + + public String getType() { + return type; + } + + public void setType(String type) { + this.type = type; + } + + public Double getJzgh() { + return jzgh; + } + + public void setJzgh(Double jzgh) { + this.jzgh = jzgh; + } + + public String getLtype() { + return ltype; + } + + public void setLtype(String ltype) { + this.ltype = ltype; + } + + public String getNo() { + return no; + } + + public void setNo(String no) { + this.no = no; + } + + public Double getArea() { + return area; + } + + public void setArea(Double area) { + this.area = area; + } +} diff --git a/src/main/java/com/smartearth/poiexcel/mapper/DkMapper.java b/src/main/java/com/smartearth/poiexcel/mapper/DkMapper.java new file mode 100644 index 0000000..6bbf1cd --- /dev/null +++ b/src/main/java/com/smartearth/poiexcel/mapper/DkMapper.java @@ -0,0 +1,15 @@ +package com.smartearth.poiexcel.mapper; + +import com.smartearth.poiexcel.entity.DkEntity; +import org.apache.ibatis.annotations.Mapper; +import org.springframework.stereotype.Repository; + +/** + * 鍦板潡鎺ュ彛鏄犲皠绫� + * @author WWW + * @date 2023-10-07 + */ +@Mapper +@Repository +public interface DkMapper extends BasicMapper<DkEntity> { +} diff --git a/src/main/java/com/smartearth/poiexcel/mapper/EntMapper.java b/src/main/java/com/smartearth/poiexcel/mapper/EntMapper.java index 1c162ef..5bf1f00 100644 --- a/src/main/java/com/smartearth/poiexcel/mapper/EntMapper.java +++ b/src/main/java/com/smartearth/poiexcel/mapper/EntMapper.java @@ -2,7 +2,10 @@ import com.smartearth.poiexcel.entity.EntEntity; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; + +import java.util.List; /** * 浼佷笟鎺ュ彛鏄犲皠绫� @@ -12,4 +15,43 @@ @Mapper @Repository public interface EntMapper extends BasicMapper<EntEntity> { + /** + * 鏍规嵁鍚嶇О妯$硦鏌ヨ + * + * @param name + * @return + */ + public List<EntEntity> selectByName(@Param("name") String name); + + /** + * 鏌ヨ琛屾暟 + * + * @return + */ + public Integer selectCount(); + + /** + * 鍒嗛〉鏌ヨ + * + * @param limit + * @param offset + * @return + */ + public List<EntEntity> selectByPage(@Param("limit") Integer limit, @Param("offset") Integer offset); + + /** + * 鏇存柊涓�鏉� + * + * @param entity + * @return + */ + public Integer update(EntEntity entity); + + /** + * 鏇存柊澶氭潯 + * + * @param list + * @return + */ + public Integer updates(List<EntEntity> list); } diff --git a/src/main/java/com/smartearth/poiexcel/mapper/QiYeMapper.java b/src/main/java/com/smartearth/poiexcel/mapper/QiYeMapper.java deleted file mode 100644 index c22b1c1..0000000 --- a/src/main/java/com/smartearth/poiexcel/mapper/QiYeMapper.java +++ /dev/null @@ -1,56 +0,0 @@ -package com.smartearth.poiexcel.mapper; - -import com.smartearth.poiexcel.entity.EntEntity; -import org.apache.ibatis.annotations.Mapper; -import org.apache.ibatis.annotations.Param; -import org.springframework.stereotype.Repository; - -import java.util.List; - -/** - * 浼佷笟Mapper - * @author WWW - */ -@Mapper -@Repository -public interface QiYeMapper { - /** - * 鏍规嵁鍚嶇О妯$硦鏌ヨ - * - * @param name - * @return - */ - public List<EntEntity> selectByName(@Param("name") String name); - - /** - * 鏌ヨ琛屾暟 - * - * @return - */ - public Integer selectCount(); - - /** - * 鍒嗛〉鏌ヨ - * - * @param limit - * @param offset - * @return - */ - public List<EntEntity> selectByPage(@Param("limit") Integer limit, @Param("offset") Integer offset); - - /** - * 鏇存柊涓�鏉� - * - * @param entity - * @return - */ - public Integer update(EntEntity entity); - - /** - * 鏇存柊澶氭潯 - * - * @param list - * @return - */ - public Integer updates(List<EntEntity> list); -} diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties index 04d418f..472ced0 100644 --- a/src/main/resources/application.properties +++ b/src/main/resources/application.properties @@ -23,3 +23,5 @@ qylweb.host=https://qylweb.bda.gov.cn qylweb.user=shikong001 qylweb.pwd=123!@#qwe + +yd.host=http://10.10.4.115:8022/ diff --git a/src/main/resources/mapper/QiYeMapper.xml b/src/main/resources/mapper/EntMapper.xml similarity index 95% rename from src/main/resources/mapper/QiYeMapper.xml rename to src/main/resources/mapper/EntMapper.xml index b7c5388..3c6c2a8 100644 --- a/src/main/resources/mapper/QiYeMapper.xml +++ b/src/main/resources/mapper/EntMapper.xml @@ -1,6 +1,6 @@ <?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.smartearth.poiexcel.mapper.QiYeMapper"> +<mapper namespace="com.smartearth.poiexcel.mapper.EntMapper"> <select id="selectByName" resultType="com.smartearth.poiexcel.entity.EntEntity"> select * from smart_earth.yz_qiyexinxi -- Gitblit v1.9.3