以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>