74 lines
2.6 KiB
Plaintext
74 lines
2.6 KiB
Plaintext
<%@ page import="com.alibaba.fastjson.JSONObject" %>
|
||
<%@ page import="weaver.conn.RecordSet" %>
|
||
<%@ page import="weaver.general.Util" %>
|
||
|
||
|
||
<%--
|
||
User: wangj
|
||
Design Ideas：
|
||
数智-数据中心--通过手机号获取简历信息（姓名，性别，年龄，身份证号，民族，应聘企业，意向岗位）
|
||
表名：edc_uf_table160
|
||
需要：通过手机号获取简历信息（姓名，性别，年龄，身份证号，民族，应聘企业，意向岗位）
|
||
--%>
|
||
<%@ page contentType="text/html;charset=UTF-8" %>
|
||
<%
|
||
|
||
JSONObject data = new JSONObject();
|
||
JSONObject res = new JSONObject();
|
||
RecordSet rs = new RecordSet();
|
||
String mobile = Util.null2String(request.getParameter("mobile"));
|
||
boolean flag = false;
|
||
String xm = "";
|
||
String xb = "";
|
||
String age = "";
|
||
String cardno = "";
|
||
String mz = "";
|
||
String ypqy = "";
|
||
String gw = "";
|
||
|
||
String sql = "select field001 as xm,field002 as xb,field008 as age,field004 as cardno,field013 as mz,field011 as ypqy,field007 as gw " +
|
||
" from edc_uf_table160 where field005 = '"+mobile+"'";
|
||
|
||
rs.execute(sql);
|
||
while (rs.next()){
|
||
flag = true;
|
||
xm = Util.null2String(rs.getString("xm"));
|
||
xb = getFildName("edc_uf_table160","field002",Util.null2String(rs.getString("xb")));
|
||
age = Util.null2String(rs.getString("age"));
|
||
cardno = Util.null2String(rs.getString("cardno"));
|
||
mz = getFildName("edc_uf_table160","field013",Util.null2String(rs.getString("mz")));
|
||
ypqy = getFildName("edc_uf_table160","field011",Util.null2String(rs.getString("ypqy")));
|
||
gw = Util.null2String(rs.getString("gw"));
|
||
|
||
res.put("xm",xm);
|
||
res.put("xb",xb);
|
||
res.put("age",age);
|
||
res.put("cardno",cardno);
|
||
res.put("mz",mz);
|
||
res.put("ypqy",ypqy);
|
||
res.put("gw",gw);
|
||
}
|
||
|
||
|
||
data.put("flag",flag);
|
||
data.put("data",res);
|
||
out.print(data.toJSONString());
|
||
%>
|
||
|
||
<%!
|
||
private String getFildName(String tablename,String fieldname,String value){
|
||
String selectname = "";
|
||
if("".equals(value)){
|
||
return selectname;
|
||
}
|
||
String sql = " select c.selectname from workflow_billfield a, workflow_bill b,workflow_selectitem c where a.billid=b.id and c.fieldid=a.id and b.tablename='"+tablename+"' and a.fieldname='"+fieldname+"' and c.selectvalue='" + value + "'";
|
||
RecordSet rs = new RecordSet();
|
||
rs.execute(sql);
|
||
while (rs.next()){
|
||
selectname = Util.null2String(rs.getString("selectname"));
|
||
}
|
||
return selectname;
|
||
}
|
||
%>
|
||
|