From 369454bcdbdd0c6fb0fa7ac6ec19112b9b6a179e Mon Sep 17 00:00:00 2001
From: fengxiang <110431245@qq.com>
Date: Mon, 26 Mar 2018 14:03:12 +0800
Subject: [PATCH] 数据查询 sql查询优化，一次带出 多项数据
---
src/main/java/com/moral/service/impl/AreaServiceImpl.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/AreaServiceImpl.java b/src/main/java/com/moral/service/impl/AreaServiceImpl.java
index 214f641..339ea54 100644
--- a/src/main/java/com/moral/service/impl/AreaServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/AreaServiceImpl.java
@@ -41,4 +41,35 @@
example.or().andEqualTo("cityCode",cityCode);
return areaMapper.selectByExample(example);
}
+
+ /**
+ * ������������������������ ��������������������� ��������� ��������� ���������
+ * @param code ������������ ��� ��� ���������������
+ * @return
+ */
+ @Override
+ public String selectFullNameByCode(Integer code){
+ String codeStr = code.toString();
+ String fullName = "";
+ // ���������������code
+ if(!codeStr.endsWith("00")){
+ String provinceCode = codeStr.substring(0,2)+"0000";
+ Province province = provinceMapper.selectByPrimaryKey(Integer.valueOf(provinceCode));
+ String cityCode = codeStr.substring(0,4)+"00";
+ City city = cityMapper.selectByPrimaryKey(Integer.valueOf(cityCode));
+ Area area = areaMapper.selectByPrimaryKey(code);
+ fullName = province.getProvinceName()+city.getCityName()+area.getAreaName();
+ } else if(!codeStr.endsWith("0000")){
+ // ��������� ���������code
+ String provinceCode = codeStr.substring(0,2)+"0000";
+ Province province = provinceMapper.selectByPrimaryKey(Integer.valueOf(provinceCode));
+ City city = cityMapper.selectByPrimaryKey(code);
+ fullName = province.getProvinceName()+city.getCityName();
+ } else {
+ // ��������� ���code
+ Province province = provinceMapper.selectByPrimaryKey(code);
+ fullName = province.getProvinceName();
+ }
+ return fullName;
+ }
}
--
Gitblit v1.8.0