发表于: 2017-09-06 23:27:43
3 876
今天完成的事情:
晚上回来写了前台职位查询和获取职位列表,后台新增职位有点问题
因为以前没有按照模块按照前后台写接口就没有涉及前台查询问题,
今天尝试了一下 感觉写起来还是很生涩看了一下之前公司learn项目
的动态查询代码,学习了一波
public static Map<String,Object> getProfession(long cid,String name,Integer provinces,Integer city,
Integer county,Integer recommend,Integer status,
Integer experience, Integer education, Integer salary,
Integer category,String label,String duty,
String industry,String condition,String companyWelfare,Long createAt,
Long createBy,
Long updateAt,Long updateBy,Long publishAt){
Map<String,Object> params = new HashMap<String,Object>();
Set<String> tables = new HashSet<>();
tables.add("company");
tables.add("profession");
if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.name &like","'%" + name + "%'");
}
if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.recommend &like","'("+recommend+")'");
}
if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.recommend &like","'("+recommend+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.experience &like","'("+experience+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.education &like","'("+education+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.salary &like","'("+salary+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.category &like","'("+category+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.label &like","'("+label+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.duty &like","'("+duty+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.condition &like","'("+condition+")'");
} if (DataUtils.isNotNullOrEmpty(name)){
params.put("profession.companyWelfare &like","'("+companyWelfare+")'");
} if (DataUtils.isNotNullOrEmpty(industry)){
params.put("in & in","(select c_id from industry where industry in("+industry+"))");
}
明天计划的事情:
明天可能还要出去一趟,可以的话尽量把职位接口写完
遇到的问题:
这个括号代表的意思有点不是很清楚,可能两点了人有点不清醒
。。。晚上两点断网了、、、、
收获:
对公司框架更为熟悉
评论