以NewDEyes中的根據活動簡稱查詢第三方活動的相關內容為例進行學習:
2.定義介面IThirdActivityService.java
public interface IThirdActivityService {
/**
* 三方活動根據活動簡稱查詢活動部分 單位字典
* @param hashMap
*/
List<Map<String,Object>> getThirdUserUnitDict(HashMap<String, Object> hashMap);
}
3.定義介面的實現類ThirdActivityService.java
public class ThirdActivityService implements IThirdActivityService{
@Resource
private ThirdActivityMapper thirdActivityMapper;
public List<Map<String,Object>> getThirdUserUnitDict(HashMap<String, Object> hashMap) {
........
}
(1)定義類implements介面類
(2)宣告Mapper物件
(3)定義實現方法具體內容
4.定義Mapper介面類ThirdActivityMapper
public interface ThirdActivityMapper {
public List<Map<String,Object>> getThirdUserUnitDict(HashMap<String, Object> hashMap);
5.定義ThirdActivityController.java檔案中進行引數分配:
public class ThirdActivityController {
@Autowired
private IThirdActivityService thirdActivityService;
@RequestMapping(value = "/getThirdUserUnitDict")
@ResponseBody
public void getThirdUserUnitDict(HttpServletRequest request, HttpServletResponse response) {
Long userId = Long.parseLong(request.getParameter("userId"));
String actName = request.getParameter("actName");
String reString;
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
try {
HashMap<String, Object> hashMap = new HashMap<String, Object>();
hashMap.put("parentId", 0);
hashMap.put("actName", actName);
List<Map<String,Object>> list = thirdActivityService.getThirdUserUnitDict(hashMap);
JSONObject json = new JSONObject();
json.put("status",0);
json.put("unitList",JSONArray.fromObject(list));
reString = json.toString();
} catch (Exception e) {
logger.info("getThirdActUserInfoByName-----" + e.getMessage());
reString = "{\"status\":1}";
}
}
(1)生成實現類物件thirdActivityService
(2)初始化方法getThirdUserUnitDict()
(i)根據request的引數初始化變數
(ii)定義結果reString和response的編碼格式
(iii)try中定義HashMap物件並賦值,為reString賦值,呼叫實現類的介面方法
6.定義Mpper對應的XML檔案進行select語句對資料庫操作
<mapper namespace="com.neusoft.www.activity.mapper.ThirdActivityMapper">
<select id="getThirdUserUnitDict" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.Map">
SELECT tud.Id,tud.name,tud.level,tud.parentId
from third_unit_dict tud
where tud.actName = #{actName} and tud.parentId = #{parentId}
</select>