注册 登录
编程论坛 VFP论坛

这个网站页面如何批量查询?

sostemp 发布于 2022-07-02 20:12, 1686 次点击
这个网站页面如何批量查询?
http://zwfw.hubei.
谢谢。

[此贴子已经被作者于2022-7-3 08:44编辑过]

9 回复
#2
吹水佬2022-07-02 21:31
xm = "朱勇"
zk = "294010015317"
bm = "2242940141240338"
xm = STRCONV(STRCONV(xm,9),15)
xm = TRANSFORM(xm, "@R "+REPLICATE("%##",LEN(xm)/2))
url = "http://hbzw-gateway-prod.ehbapp.hubei. + xm + "&zkzh=" + zk + "&bmp=" + bm

{
  "data": {
    "dataList": [
      {
        "id": 1,
        "dataUpUuid": null,
        "isDeleted": null,
        "dataUpStatus": null,
        "bj": "07",
        "bmp": "2242940141240338",
        "dl": "47",
        "hx": "47",
        "ls": "57",
        "lz": "",
        "sp": "47",
        "sw": "45",
        "sx": "89",
        "sycj": "20",
        "tycj": "48.5",
        "wl": "49",
        "wz": "",
        "xb": "",
        "xjcj": "",
        "xm": "朱勇",
        "yj": "0",
        "yw": "102",
        "yy": "112.5",
        "zf": "664",
        "zkzh": "294010015317",
        "dataUpTime": null
      }
    ],
    "totalRow": 1,
    "totalPage": 1,
    "pageNum": 1,
    "pageSize": 1
  },
  "status": 0,
  "msg": "success"
}
#3
sdta2022-07-02 23:30
程序代码:
CREATE CURSOR zkcj (姓名 c(10), 准考证号 c(12), 报名号 c(16), 语文 n(5,1), 数学 n(5,1), 英语 n(5,1))
xm0 = "朱勇"
zk = "294010015317"
bm = "2242940141240338"
xm = STRCONV(STRCONV(xm0, 9), 15)
xm = TRANSFORM(xm, "@R " + REPLICATE("%##", LEN(xm)/2))
lcUrl = "http://hbzw-gateway-prod.ehbapp.hubei.8060/ba05285d27974fceb00dd06503832f776cc78d8485fb47e282fac2d8ae0e9d43?xm=" + xm + "&zkzh=" + zk + "&bmp=" + bm
lcText = GETURL(lcUrl)
IF EMPTY(lcText)
    RETURN ""
ENDIF
lcText = STREXTRACT(lcText, "[{", "}]")
ALINES(laText, lcText, 5, ",", ':"', ':')
INSERT INTO zkcj VALUES (xm0, zk, bm, VAL(latext[44]), VAL(laText[26]), VAL(laText[46]))
BROWSE
FUNCTION GETURL(UrlName)
    lcStr = ""
    oHTTP = CREATEOBJECT("MSXML2.XMLHTTP")
    oHTTP.Open("GET", UrlName, .F.)
    oHTTP.Send()
    IF oHTTP.Status = 200
        lcStr = oHTTP.ResponseText
    ENDIF
    RELEASE oHTTP
    RETURN lcStr
ENDFUNC
#4
sostemp2022-07-03 00:25
回复 2楼 吹水佬
谢谢两位版主,主要是想知道怎么获取到网址URL。
#5
jinanshui2022-07-03 06:35
我也想知道,如何获取网址URL。
#6
nbwww2022-07-03 06:56
F12

只有本站会员才能查看附件,请 登录
#7
sostemp2022-07-03 08:45
回复 6楼 nbwww
谢谢,网页类都这么操作吗?
#8
吹水佬2022-07-03 09:25
以下是引用sostemp在2022-7-3 08:45:45的发言:

谢谢,网页类都这么操作吗?

这类问题好象都没“通式”
这个网页也可以从页面源码分析,对HTML、JS了解就可以
如其中就有:
程序代码:


//获取数据
function getDataList() {
   
    var d = $.Deferred();
    hbzwfwJssdk.notice.showPreloader({
        text: "使劲加载中.."
    });
    var data = {
        "xm":$("#xm").val(),
        "zkzh":  $("#zkzh").val(),
        "bmp":$("#bmp").val()
    };

    $.ajax({
        // url:'http://ehb.',
        url:encodeURI('http://hbzw-gateway-prod.ehbapp.hubei.'),
        type: 'get',
        contentType: "application/json",
        dataType: "json",
        data: data,
        success: function(resp) {
#9
sdta2022-07-03 12:36
只有本站会员才能查看附件,请 登录
#10
a575985872022-07-03 16:20
批量查询抛砖引玉:  
将以下三个要素构成dbf  然后循环查询将结果写入到新的dbf中 可视作 循环查询
xm = "朱勇"
zk = "294010015317"
bm = "2242940141240338"
1