祭祀我的一卡通,用SQL查詢一卡通記錄
陪我兩年的一卡通兄弟,被我不小心丟了,SFZ號碼:10007510104887822。看著被搞的記錄很是不爽,只能寫一小博,以做紀念。
create table Html.YKT url
''http://www.bJSuperpass.com/pagecontrol.do?object=ecard&action=query&card_id=10007510104887822'' charset ''gb2312'' row_xpath ''/Html/body/table/tr'' (
P1
VARCHAR element ''td[1]'',
P2
VARCHAR element ''td[2]'',
P3
VARCHAR element ''td[3]'',
P4
VARCHAR element ''td[4]'',
P5
VARCHAR element ''td[5]'',
P6
VARCHAR element
pan style="FONT-SIZE: 8pt; COLOR: #0000f0">''td[6]''
);
create or replace procedure ykt(id) return rowset as
begin
execute(''alter table Html.ykt set
url ''''http://www.bJSuperpass.com/pagecontrol.do?object=ecard&action=query&card_id='' + id + '''''''');
select * from Html.ykt;
end;
select * from ykt(''10007510104887822'');