Java调用SQL Server存储过程同时返回参数和结果集

时间:2022-09-29 09:40:30
 

比如SQL Server的一个存储过程:

 

  1. create procedure proc_test 
  2. @q_type int,
  3. @value int,
  4. @count int output
  5. as
  6. begin
  7.      update mytable set value = @value where type = @q_type
  8.      set @count = @@rowcount
  9.      select * from mytable where type = @q_type
  10. end
  11. go

这个存储过程,既有输出参数,又有返回结果集,而用java调用他,两者都要取到,则代码如下:

 

  1. Connection conn = MyConnectionPool.getConnection();
  2. CallableStatement cstmt = conn.prepareCall("{call proc_test(?,?,?)}");
  3. cstmt.setInt(1, type);
  4. cstmt.setInt(2, value);
  5. cstmt.registerOutParameter(3, java.sql.Types.INTEGER);
  6. ResultSet rs = cstmt.executeQuery();
  7. while(rs.next()) {
  8.    doSomeThingToResultSet(rs);
  9. }
  10. doSomeThingToOutParameter(cstmt.getInt(3));
  11. rs.close();
  12. cstmt.close();
  13. conn.close();

其中的关键在于哪儿呢?

  1. 必须用cstmt.executeQuery()来取得结果集,用cstmt.execute()然后getResultSet()是取不到的,而executeQuery()能保证先执行update再select;
  2. 获得输出参数的cstmt.getInt(3)必须在处理完结果集的所有内容后再执行,如果把上述代码改成如下:

........
doSomeThingToOutParameter(cstmt.getInt(3));
while(rs.next()) {
   doSomeThingToResultSet(rs);
}
........

       后果就是,在rs.next()的时候,会抛出异常:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.

很有趣,不是么?dl.vmall.com/c0ycof3tnl
dl.vmall.com/c0n1u2afnv
dl.vmall.com/c0zmnxdp1v
dl.vmall.com/c0ajyw9aam
dl.vmall.com/c0qk2a24l0
dl.vmall.com/c02t2wlux0
dl.vmall.com/c06unkrur9
dl.vmall.com/c0xb83l1mc
dl.vmall.com/c0nve9azix
dl.vmall.com/c02r9qpnxt
dl.vmall.com/c0om14hl5a
dl.vmall.com/c0fnzqwmly
dl.vmall.com/c05ioph5i6
dl.vmall.com/c09llqelll
dl.vmall.com/c0w4by2fk7
dl.vmall.com/c03fyzcje8
dl.vmall.com/c00gon8np3
dl.vmall.com/c0siuuhjrd
dl.vmall.com/c0ex1d7fyn
dl.vmall.com/c05dng7tjo
dl.vmall.com/c0twhsi15y
dl.vmall.com/c0d2vwmi9r
dl.vmall.com/c0puah8vk2
dl.vmall.com/c0tocw93hb
dl.vmall.com/c0ti6w0bcr
dl.vmall.com/c02oprxnl2
dl.vmall.com/c08ndsol32
dl.vmall.com/c0vd199a22
dl.vmall.com/c0ad6bwtft
dl.vmall.com/c0jp2kz6t4
dl.vmall.com/c0awmm1i6w
dl.vmall.com/c0qs8mbauf
dl.vmall.com/c08jddg8op
dl.vmall.com/c0cjlkjuv8
dl.vmall.com/c06zcmbulp
dl.vmall.com/c0iqjq18ev
dl.vmall.com/c0v2y5hetf
dl.vmall.com/c01lb0d2fx
dl.vmall.com/c0dya9lxsz
dl.vmall.com/c08g0tw62j
dl.vmall.com/c0j7jx94v1
dl.vmall.com/c03utwa6to
dl.vmall.com/c0ei561lg9
dl.vmall.com/c0c2skrb73
dl.vmall.com/c0cllzw866
dl.vmall.com/c0fkbybpzc
dl.vmall.com/c081skz2ya
dl.vmall.com/c0n3w3srcv
dl.vmall.com/c0ersifip7
dl.vmall.com/c0tuk6dj3m
dl.vmall.com/c0howi0nnx
dl.vmall.com/c0vutg0ir5
dl.vmall.com/c0uqdwgeii
dl.vmall.com/c0yao4dfu1
dl.vmall.com/c0oapem144
dl.vmall.com/c09hy3ihy0
dl.vmall.com/c0pfbpzxzg
dl.vmall.com/c068s6ttau
dl.vmall.com/c0ybbno4bn
dl.vmall.com/c04b3lrkvj
dl.vmall.com/c0ly7dizuz
dl.vmall.com/c0wxcx5u5b
dl.vmall.com/c06iumbcij
dl.vmall.com/c05k3o0v0a
dl.vmall.com/c0qnj65pcm
dl.vmall.com/c0pj3be6zi
dl.vmall.com/c04peh0o57
dl.vmall.com/c0ihn1c41o
dl.vmall.com/c08d0out03
dl.vmall.com/c0yq7rqoav
dl.vmall.com/c00io7z2ns
dl.vmall.com/c0iucp50wv
dl.vmall.com/c07f6lq3o3
dl.vmall.com/c0iul5ggvg
dl.vmall.com/c0taacomar
dl.vmall.com/c0gayrfz5g
dl.vmall.com/c082k786xc
dl.vmall.com/c0lu8sdymi
dl.vmall.com/c0o603jkzo
dl.vmall.com/c0313revad
dl.vmall.com/c0uvir2vb3
dl.vmall.com/c056dhujd5
dl.vmall.com/c0y0vgnos9
dl.vmall.com/c0bmoxnzf3
dl.vmall.com/c0wb4ms7dl
dl.vmall.com/c0dojx2kiv
dl.vmall.com/c0a3nrfw78
dl.vmall.com/c0spw6ppmx
dl.vmall.com/c08k6adtbz
dl.vmall.com/c0cktg6md1
dl.vmall.com/c0w1fafp2u
dl.vmall.com/c05e45pntj
dl.vmall.com/c07f4vzeje
dl.vmall.com/c0d0q9v8vg
dl.vmall.com/c0jem33g2l
dl.vmall.com/c07tsq5ay5
dl.vmall.com/c0aboza8au
dl.vmall.com/c0nnahdpyh
dl.vmall.com/c0lh700tpm
dl.vmall.com/c0oaqxq98q
dl.vmall.com/c0dkhpafuc
dl.vmall.com/c0fsf5sy01
dl.vmall.com/c0giop5wa7
dl.vmall.com/c0o8fh7y9t
dl.vmall.com/c0d151ia6m
dl.vmall.com/c0g7mnh6ta
dl.vmall.com/c055uttihp
dl.vmall.com/c01k1xw8e5
dl.vmall.com/c0vxswjp9g
dl.vmall.com/c0jyddb96f
dl.vmall.com/c0fzog151b
dl.vmall.com/c072rkja22
dl.vmall.com/c0o1gzsgfw
dl.vmall.com/c0h5xw4qvg
dl.vmall.com/c0bxtnyfrd
dl.vmall.com/c0og916e4x
dl.vmall.com/c0055aa1t7
dl.vmall.com/c0adqu5fls
dl.vmall.com/c015fa1m07
dl.vmall.com/c08ovjkpwv
dl.vmall.com/c0gr3qz8jv
dl.vmall.com/c09vzam5p9
dl.vmall.com/c0ji1uof33
dl.vmall.com/c0zhqbba1y
dl.vmall.com/c0o7pyts56
dl.vmall.com/c0gds2g3em
dl.vmall.com/c0pn7kzirk
dl.vmall.com/c0y2atkjir
dl.vmall.com/c0aanmjqe8
dl.vmall.com/c0zk7ode8a
dl.vmall.com/c0w5jv2pxr
dl.vmall.com/c01yjr0aeq
dl.vmall.com/c0sogzktpp
dl.vmall.com/c06da8upnx
dl.vmall.com/c054tjaaas
dl.vmall.com/c0kema8lui
dl.vmall.com/c04ty0aeg8
dl.vmall.com/c09bq0afh2
dl.vmall.com/c0j26za5lo
dl.vmall.com/c0aa1uck72
dl.vmall.com/c06mlrg53r
dl.vmall.com/c0v53m35hq
dl.vmall.com/c0uztnq7hp
dl.vmall.com/c0e0qa2b9p
dl.vmall.com/c0w5tqr76v
dl.vmall.com/c0rdvdm8fd
dl.vmall.com/c0eg3c9pml
dl.vmall.com/c0a2oh5avd
dl.vmall.com/c0xv1jb2y8
dl.vmall.com/c0nb27r0l0
dl.vmall.com/c0jbj0vy1c
dl.vmall.com/c0opbkyyue
dl.vmall.com/c0ej9nfelk
dl.vmall.com/c0e7po0kbb
dl.vmall.com/c0c8b2r52b
dl.vmall.com/c0cptoasoe
dl.vmall.com/c0pcw9v8iw
dl.vmall.com/c0qkp2nr1c
dl.vmall.com/c0hixkokaz
dl.vmall.com/c0dgfw9dtf
dl.vmall.com/c0f24l7o8m
dl.vmall.com/c0gacbt41p
dl.vmall.com/c0dnef7kck
dl.vmall.com/c0vmsyttax
dl.vmall.com/c0k88vjmp1
dl.vmall.com/c0deaa54dm
dl.vmall.com/c092iatm53
dl.vmall.com/c0000444gj
dl.vmall.com/c08jaxqtsi
dl.vmall.com/c0h9y41i8i
dl.vmall.com/c06ahygfq1
dl.vmall.com/c0wovlgub2
dl.vmall.com/c086jsxqx8
dl.vmall.com/c0za68htal
dl.vmall.com/c0zi1u7dwf
dl.vmall.com/c0gvgofjvq
dl.vmall.com/c0d4gh00zt
dl.vmall.com/c07ipbrev5
dl.vmall.com/c0u3p4928e
dl.vmall.com/c0f0h3xhr4
dl.vmall.com/c0m5z8o2qv
dl.vmall.com/c03r8kuobw
dl.vmall.com/c0wtmntvkm
dl.vmall.com/c05trrvnhi
dl.vmall.com/c00potdhvh
dl.vmall.com/c0t7aerl93
dl.vmall.com/c0f57xxtfh
dl.vmall.com/c0srb9mwxt
dl.vmall.com/c07roo3yc2
dl.vmall.com/c0dlpdlniu
dl.vmall.com/c00pznf5l2
dl.vmall.com/c0h1500lm0
dl.vmall.com/c027yvc9b5
dl.vmall.com/c0klfibl08
dl.vmall.com/c0qa4abvhh
dl.vmall.com/c06udaqma2
dl.vmall.com/c05ks2nzwq
dl.vmall.com/c03ly06qa7
dl.vmall.com/c0162omuxl
dl.vmall.com/c0gniu1hx7
dl.vmall.com/c0b68kpiqt
dl.vmall.com/c0p52m5ctx
dl.vmall.com/c0qs50wd04
dl.vmall.com/c0zj8iy15n
dl.vmall.com/c0l80g2aed
dl.vmall.com/c0yuefvagy
dl.vmall.com/c0l2skqt49
dl.vmall.com/c0mfwcr7j8
dl.vmall.com/c0a1uht71x
dl.vmall.com/c0u6ds5hlj
dl.vmall.com/c0xcdkq2x6
dl.vmall.com/c097fdjkii
dl.vmall.com/c0aqew0hl7
dl.vmall.com/c0omd2m6cc
dl.vmall.com/c0zq8iue83
dl.vmall.com/c0yt8l53it
dl.vmall.com/c0qp6dlzv4
dl.vmall.com/c0g6e7900s
dl.vmall.com/c03vuv1t1w
dl.vmall.com/c0cw9wv3bv
dl.vmall.com/c0zz2r2hq9
dl.vmall.com/c0p03an8ap
dl.vmall.com/c09qyb8b0y
dl.vmall.com/c0cbxrr7c9
dl.vmall.com/c0hpufmg42
dl.vmall.com/c0u6z3rvhk
dl.vmall.com/c0ofpr6db1
dl.vmall.com/c0fa300xh5
dl.vmall.com/c0m8ilrr2n
dl.vmall.com/c0m3fzr5ky
dl.vmall.com/c0uuhafanq
dl.vmall.com/c010w4dga4
dl.vmall.com/c0lfy44u68
dl.vmall.com/c0ubqgoi7p
dl.vmall.com/c0zpkcmwa5
dl.vmall.com/c0k2nerrh6
dl.vmall.com/c0k0h3rbtb
dl.vmall.com/c0klyk683v
dl.vmall.com/c0jvll91wp
dl.vmall.com/c0y4j9da9n
dl.vmall.com/c07k3rwt3r
dl.vmall.com/c0qiwt441h
dl.vmall.com/c081fnua7s
dl.vmall.com/c0vctd3ghy
dl.vmall.com/c0kjna9789
dl.vmall.com/c0o2x3hxe7
dl.vmall.com/c0flghfr7u
dl.vmall.com/c0n2tnape3
dl.vmall.com/c07v8ctbi9
dl.vmall.com/c030yqmr76
dl.vmall.com/c0q0yldvvv
dl.vmall.com/c0b1oszhym
dl.vmall.com/c065aka48o
dl.vmall.com/c0sh5bdobk
dl.vmall.com/c0xzm3aku2
dl.vmall.com/c07zola4hl
dl.vmall.com/c0wopfhpti
dl.vmall.com/c0nzmcqg5m
dl.vmall.com/c05h8xzzml
dl.vmall.com/c0dat4q6fw
dl.vmall.com/c0ppxkovdh
dl.vmall.com/c0vuz6skjc
dl.vmall.com/c0i7vaar4p
dl.vmall.com/c0gpm9r054
dl.vmall.com/c0s46g8lic
dl.vmall.com/c0nrk5aer7
dl.vmall.com/c0sp37cf69
dl.vmall.com/c0kk9eez07
dl.vmall.com/c03acjgv0y
dl.vmall.com/c03108xzos
dl.vmall.com/c0xjdwyfdt
dl.vmall.com/c0rgdbkg55
dl.vmall.com/c0dtqh4621
dl.vmall.com/c0vkz94v1v
dl.vmall.com/c003cthhle
dl.vmall.com/c0w9tvag0a
dl.vmall.com/c0o3p95qux
dl.vmall.com/c0rmif2lqg
dl.vmall.com/c09za5g41l
dl.vmall.com/c0mzb6v7t3
dl.vmall.com/c0km0oe0n5
dl.vmall.com/c09ud9fcbt
dl.vmall.com/c0u5lv893v
dl.vmall.com/c0zrv0i3jb
dl.vmall.com/c0zavx3b3y
dl.vmall.com/c0e5dafy0o
dl.vmall.com/c0y8u1yect
dl.vmall.com/c0l71qs2eb
dl.vmall.com/c0j1s3miqw
dl.vmall.com/c0ax1rpbnl
dl.vmall.com/c0m0m0wcbp
dl.vmall.com/c0ca8388na
dl.vmall.com/c0h0rihz3b
dl.vmall.com/c0cs9crt1a
dl.vmall.com/c0arb2ajmk
dl.vmall.com/c0l4ajfx6r
dl.vmall.com/c0n4lumzpo
dl.vmall.com/c0aue6mg9c
dl.vmall.com/c0g4vy8nsd
dl.vmall.com/c0adgwu89a
dl.vmall.com/c0awqdalpa
dl.vmall.com/c04v5u3a6e
dl.vmall.com/c0oxt8y7s7
dl.vmall.com/c0ozqdedse
dl.vmall.com/c0j477tk67
dl.vmall.com/c0akveswk4
dl.vmall.com/c042if8h4w
dl.vmall.com/c01bqs1ztx
dl.vmall.com/c02diwdlqs
dl.vmall.com/c0s8fxtpo4
dl.vmall.com/c0cdlqkddh
dl.vmall.com/c0uwsqasrd
dl.vmall.com/c0aajq9yes
dl.vmall.com/c02l32gwpn
dl.vmall.com/c0waq75pt5
dl.vmall.com/c0udvgs1wq
dl.vmall.com/c0phdhgsn4
dl.vmall.com/c066m7wuol
dl.vmall.com/c0z05utz6j
dl.vmall.com/c0arq4d7j6
dl.vmall.com/c05nhabajj
dl.vmall.com/c0fg6sfi4l
dl.vmall.com/c01gxouvyw
dl.vmall.com/c0ofxvpkyw
dl.vmall.com/c0l3hr9zkt
dl.vmall.com/c0kek8x0la
dl.vmall.com/c015nkifyl
dl.vmall.com/c0xy0yekom
dl.vmall.com/c0w4bcgf3o
dl.vmall.com/c0fptfii9n
dl.vmall.com/c099crfst3
dl.vmall.com/c0nf3644lz
dl.vmall.com/c00ohqvaet
dl.vmall.com/c0pmydgrk5
dl.vmall.com/c0k9vgjkcf
dl.vmall.com/c0gn2lp5ot
dl.vmall.com/c0ytalnxf6
dl.vmall.com/c036hvsm6a
dl.vmall.com/c03xcatygl
dl.vmall.com/c0385aenbf
dl.vmall.com/c0zxx2i0ay
dl.vmall.com/c0lfjrxnds
dl.vmall.com/c0uxmsa4mz
dl.vmall.com/c09pyc1dhi
dl.vmall.com/c076aw7y4y
dl.vmall.com/c081ik3eir
dl.vmall.com/c0hxmcvtvg
dl.vmall.com/c0hrlspl7w
dl.vmall.com/c0ccdzfnam
dl.vmall.com/c0a51dwref
dl.vmall.com/c0ldka2naq
dl.vmall.com/c04j2vmn7p
dl.vmall.com/c0ax27m2vo
dl.vmall.com/c01ea813mu
dl.vmall.com/c0ml5cgifz
dl.vmall.com/c0c26k3x7y
dl.vmall.com/c06zeut7m2
dl.vmall.com/c0iteofaij
dl.vmall.com/c0sp7mdyda
dl.vmall.com/c0brh1tpmg
dl.vmall.com/c0zfodsapx
dl.vmall.com/c0n3udljo8
dl.vmall.com/c0t2c90lua
dl.vmall.com/c0jd57h0ot
dl.vmall.com/c0bcuyhoma
dl.vmall.com/c036o3q6ga
dl.vmall.com/c0bkaa0jpa
dl.vmall.com/c0q1qtri6l
dl.vmall.com/c0z2bv79cp
dl.vmall.com/c0wkr1xmz7
dl.vmall.com/c0iftse8ot
dl.vmall.com/c0lk4ayrar
dl.vmall.com/c0oidh9704
dl.vmall.com/c00vjrkjap
dl.vmall.com/c0w85i3nva
dl.vmall.com/c01jhiix8y
dl.vmall.com/c00n7vn0ox
dl.vmall.com/c06ys38tjq
dl.vmall.com/c0z5xanbbz
dl.vmall.com/c0kpdd0nxa
dl.vmall.com/c0iwv0bdgu
dl.vmall.com/c09amt34cl
dl.vmall.com/c0zv0p8uvm
dl.vmall.com/c02zabsfaq
dl.vmall.com/c0wq0lriok
dl.vmall.com/c0fe9ha0ac
dl.vmall.com/c06na73jw1
dl.vmall.com/c0mmeo39hl
dl.vmall.com/c0af1qtbvn
dl.vmall.com/c03u97ghf3
dl.vmall.com/c0q2gdn2gc
dl.vmall.com/c0snjg3day
dl.vmall.com/c0eziqy1o7
dl.vmall.com/c0drnsmeeu
dl.vmall.com/c0e5uzkma6
dl.vmall.com/c0j9q51fv8
dl.vmall.com/c0ha1mhgc8
dl.vmall.com/c0fd8atqyc
dl.vmall.com/c0ppurqa8p
dl.vmall.com/c06ru92rzv
dl.vmall.com/c0fk8f22xc
dl.vmall.com/c06rebaavh
dl.vmall.com/c0382a684o
dl.vmall.com/c05dkdton7
dl.vmall.com/c02gezbqmv
dl.vmall.com/c0inzoc4la
dl.vmall.com/c0i8cqpg85
dl.vmall.com/c0o4tatwja
dl.vmall.com/c0is3dytpk
dl.vmall.com/c0y6trbxy4
dl.vmall.com/c0wvh2ujcl
dl.vmall.com/c0trvkcm7b
dl.vmall.com/c0atbdotis
dl.vmall.com/c0if53p0jj
dl.vmall.com/c0ghy6975h
dl.vmall.com/c00z47f1fr
dl.vmall.com/c0ckx7cb8g
dl.vmall.com/c0vcqxvgc1
dl.vmall.com/c07w3ucmvt
dl.vmall.com/c0t0572b6d
dl.vmall.com/c0fu8sxsdx
dl.vmall.com/c0zi3z9ycn
dl.vmall.com/c0k75ofjgm
dl.vmall.com/c09r05o4b6
dl.vmall.com/c0kb9a1zbb
dl.vmall.com/c072y2bpv4
dl.vmall.com/c0wkdi6doa
dl.vmall.com/c0lknubeo4
dl.vmall.com/c02q3509fe
dl.vmall.com/c0x75mv8bp
dl.vmall.com/c08ey4dwsg
dl.vmall.com/c00ykdg02l
dl.vmall.com/c0mtenrif6
dl.vmall.com/c0ex6p9ahm
dl.vmall.com/c0rklue2qz
dl.vmall.com/c0qcol2t7j
dl.vmall.com/c00tznwjrg
dl.vmall.com/c0ymlawo2y
dl.vmall.com/c0v7zrsc3a
dl.vmall.com/c0dqjsyaar
dl.vmall.com/c03ayv8ana
dl.vmall.com/c0gctoirg0
dl.vmall.com/c0aop91pw4
dl.vmall.com/c0g2mfxcft
dl.vmall.com/c03jkfb1ul
dl.vmall.com/c00l3a8jbo
dl.vmall.com/c0rz1e4i97
dl.vmall.com/c0afv9wx6h
dl.vmall.com/c0f5cdij6l
dl.vmall.com/c0a47m4qjq
dl.vmall.com/c01harovfw
dl.vmall.com/c0xnlr7gz4
dl.vmall.com/c0jpza32sl
dl.vmall.com/c0tf4jp1cy
dl.vmall.com/c091djt1dn
dl.vmall.com/c0v5tke13f
dl.vmall.com/c0u5bb5tz2
dl.vmall.com/c06ma29xy5
dl.vmall.com/c0xrh0rbxi
dl.vmall.com/c0gwv6apdx
dl.vmall.com/c0gtp0piiu
dl.vmall.com/c0fd3un38g
dl.vmall.com/c0v1mhtjaa
dl.vmall.com/c006l3e5wc
dl.vmall.com/c0flc0pikb
dl.vmall.com/c0xduesne6
dl.vmall.com/c00pltf9fe
dl.vmall.com/c0rq85phnp
dl.vmall.com/c0wvxiaklq
dl.vmall.com/c0wnges51i
dl.vmall.com/c0tnvaw9k0
dl.vmall.com/c04gghzuub
dl.vmall.com/c0a2gulrvs
dl.vmall.com/c0f1tunuut
dl.vmall.com/c0fia277n0
dl.vmall.com/c0xt721s20
dl.vmall.com/c01nazlg48
dl.vmall.com/c0sg0yxd0d
dl.vmall.com/c08qi3e53d
dl.vmall.com/c06y5ampdf
dl.vmall.com/c0opivzfpk
dl.vmall.com/c02i77qita
dl.vmall.com/c0mktjael2
dl.vmall.com/c0qbfbhuet
dl.vmall.com/c0ntjp0ee9
dl.vmall.com/c0bj61ti2n
dl.vmall.com/c0d0024346
dl.vmall.com/c04nzy3pg4
dl.vmall.com/c06kl8rd4x
dl.vmall.com/c0aojqoayv
dl.vmall.com/c0q1xnihyl
dl.vmall.com/c0e3pyn36l
dl.vmall.com/c0xodg750z
dl.vmall.com/c0chkik4co
dl.vmall.com/c0akiymsmb
dl.vmall.com/c0d0qgrpwa
dl.vmall.com/c086e63d1m
dl.vmall.com/c0hbzivru1
dl.vmall.com/c0vfpjdpoo
dl.vmall.com/c09p827ym4
dl.vmall.com/c0ogcbl1lc
dl.vmall.com/c0qdn52zqa
dl.vmall.com/c0bcrel2sr
dl.vmall.com/c05wyoxlao
dl.vmall.com/c0bqp9691j
dl.vmall.com/c0qjvkuctl
dl.vmall.com/c0hbluxvrm
dl.vmall.com/c0d65gzb37
dl.vmall.com/c0pr126g9r
dl.vmall.com/c0vlwm0vuk
dl.vmall.com/c0xw5fapsw
dl.vmall.com/c0ys8lkj3g
dl.vmall.com/c0r6p34w9k
dl.vmall.com/c0d8nkchzm
dl.vmall.com/c0izoprnfe
dl.vmall.com/c0emhdvsq5
dl.vmall.com/c0vzm3p6gp
dl.vmall.com/c09fafq1xf
dl.vmall.com/c0u073jg8k
dl.vmall.com/c0wi60vtr5
dl.vmall.com/c04i06tkl8
dl.vmall.com/c0f1dgkp5h
dl.vmall.com/c0aifr024n
dl.vmall.com/c02230nnzm
dl.vmall.com/c0og6lz6vy
dl.vmall.com/c0jlyydw5m
dl.vmall.com/c0d57qkl7c
dl.vmall.com/c0szol2cuu
dl.vmall.com/c09tzejvpu
dl.vmall.com/c0hu5ti4k8
dl.vmall.com/c065aaydgd
dl.vmall.com/c0j5ffepis
dl.vmall.com/c04ylvj5kk
dl.vmall.com/c03faphzso
dl.vmall.com/c0gvercod2
dl.vmall.com/c0693uju26
dl.vmall.com/c02gmku0cc
dl.vmall.com/c0yy62bwrt
dl.vmall.com/c0av4cwl0y
dl.vmall.com/c0f8fway8p
dl.vmall.com/c05xbfhonu
dl.vmall.com/c0kq4sag9m
dl.vmall.com/c0zcxgg5xl
dl.vmall.com/c0zz07hcty
dl.vmall.com/c0xfmeu8t9
dl.vmall.com/c07sonzlf5
dl.vmall.com/c06xl8s0vf
dl.vmall.com/c0d43xqsnm
dl.vmall.com/c04pv5038m
dl.vmall.com/c01sen9nz1
dl.vmall.com/c0504gsyb1
dl.vmall.com/c03hmee175
dl.vmall.com/c0dwnmu3r9
dl.vmall.com/c0v2zb59jn
dl.vmall.com/c057fibifj
dl.vmall.com/c0odnw80o4
dl.vmall.com/c0bdto90sj
dl.vmall.com/c0zbvzcha1
dl.vmall.com/c05po4egaa
dl.vmall.com/c0tah5rmzs
dl.vmall.com/c0vkao6hsg
dl.vmall.com/c0xaimey7q
dl.vmall.com/c09oo9ctvc
dl.vmall.com/c00icyxtqt
dl.vmall.com/c0adkflenh
dl.vmall.com/c04fotraag
dl.vmall.com/c05xre3uzt
dl.vmall.com/c0jqhk7rtp
dl.vmall.com/c06suo2dzr
dl.vmall.com/c0mae6szyf
dl.vmall.com/c0lvmtu6sl
dl.vmall.com/c0ye7a0c5n
dl.vmall.com/c0zakp3sxu
dl.vmall.com/c0z0ra3jad
dl.vmall.com/c0ud9jnexa
dl.vmall.com/c038sygoz0
dl.vmall.com/c0qqa3wfsx
dl.vmall.com/c0jwp4tczj
dl.vmall.com/c0osew0ssw
dl.vmall.com/c07fjai18t
dl.vmall.com/c0oqd74uaa
dl.vmall.com/c0d9kimzka
dl.vmall.com/c01lrrilxc
dl.vmall.com/c06hoe4ldf
dl.vmall.com/c0ht36kbgt
dl.vmall.com/c0mlredjij
dl.vmall.com/c0abyolktm
dl.vmall.com/c05aolpaql
dl.vmall.com/c0nuaa91xt
dl.vmall.com/c0t4vu04w0
dl.vmall.com/c0ht3f07v2
dl.vmall.com/c0o1ykbdv6
dl.vmall.com/c0xahhpor8
dl.vmall.com/c0ma1150z5
dl.vmall.com/c0uenbv7ua
dl.vmall.com/c0xg31u549
dl.vmall.com/c0efj8a4jc
dl.vmall.com/c0g9ptuud3
dl.vmall.com/c0z4aonxj9
dl.vmall.com/c0j9b6qar5
dl.vmall.com/c0ydbw6ybw
dl.vmall.com/c04r6i0k49
dl.vmall.com/c0djackgaa
dl.vmall.com/c0c3m8flzd
dl.vmall.com/c0kramkmua
dl.vmall.com/c02y1kgqy8
dl.vmall.com/c0szkbkt5a
dl.vmall.com/c01czf48ai
dl.vmall.com/c0h2ypd6ha
dl.vmall.com/c0uoo2j8im
dl.vmall.com/c0pqo0a9cu
dl.vmall.com/c0xunnvlkn
dl.vmall.com/c0ofyo1ywg
dl.vmall.com/c0zbw8co1t
dl.vmall.com/c0gn2ceita
dl.vmall.com/c0qknlamyh
dl.vmall.com/c0gapksdjw
dl.vmall.com/c0dfmidwn0
dl.vmall.com/c0mwqyolmh
dl.vmall.com/c0m23fifbg
dl.vmall.com/c0lvzfjsot
dl.vmall.com/c0rleddafn
dl.vmall.com/c0mj4aoiuz
dl.vmall.com/c0g6n0aght
dl.vmall.com/c0yy4phmwx
dl.vmall.com/c0malsc6k4
dl.vmall.com/c0wzz0so1n
dl.vmall.com/c0ayn9hfdk
dl.vmall.com/c002kyfpwr
dl.vmall.com/c04pgooewg
dl.vmall.com/c0u211jyd9
dl.vmall.com/c03zn7r5bi
dl.vmall.com/c0kaidw8x5
dl.vmall.com/c01ab6fw8z
dl.vmall.com/c09ui54xf3
dl.vmall.com/c0twade8lb
dl.vmall.com/c08heycg2v
dl.vmall.com/c0o2197dlh
dl.vmall.com/c0qeoq2c03
dl.vmall.com/c0kgo61m6a
dl.vmall.com/c02cb3avms
dl.vmall.com/c0e0r9grw5
dl.vmall.com/c0tiv5rahg
dl.vmall.com/c0a30h02j2
dl.vmall.com/c02skrih24
dl.vmall.com/c0uf4adg9h
dl.vmall.com/c02dlu8t0w
dl.vmall.com/c0tn4wd3jf
dl.vmall.com/c0fzavlltg
dl.vmall.com/c03e26k14a
dl.vmall.com/c0kwuvfklg
dl.vmall.com/c0uv82zjna
dl.vmall.com/c0pblys65d
dl.vmall.com/c0ka9h52m9
dl.vmall.com/c0ylcq3kyz
dl.vmall.com/c0a7kwuzq3
dl.vmall.com/c06n0rhzfi
dl.vmall.com/c0dyl37b0s
dl.vmall.com/c0msqkk71i
dl.vmall.com/c0rmz5fbuz
dl.vmall.com/c0bbbv236v
dl.vmall.com/c082qbjfgl
dl.vmall.com/c0jlfr9imo
dl.vmall.com/c0qc4diuu0
dl.vmall.com/c0ua8hgejd
dl.vmall.com/c0lpvycbq7
dl.vmall.com/c0akfe92kp
dl.vmall.com/c06z9n1pcn
dl.vmall.com/c0ur11m17g
dl.vmall.com/c0ixff4v1m
dl.vmall.com/c090i7a40v
dl.vmall.com/c0vmnaj7dv
dl.vmall.com/c0ftxh5934
dl.vmall.com/c0qmev67pu
dl.vmall.com/c04qtpasvf
dl.vmall.com/c04ubjs768
dl.vmall.com/c04mjplawe
dl.vmall.com/c0q1xwo1r0
dl.vmall.com/c0al1cvk4d
dl.vmall.com/c03quhuzd3
dl.vmall.com/c0udcr19x0
dl.vmall.com/c05kq4jaho
dl.vmall.com/c00ahmol0y
dl.vmall.com/c00iawehif
dl.vmall.com/c01yxuw6dm
dl.vmall.com/c0q20usemn
dl.vmall.com/c0663ea8na
dl.vmall.com/c0kqsqo5qc
dl.vmall.com/c07cd7pocb
dl.vmall.com/c0yasdcz1s
dl.vmall.com/c0hod9ec7g
dl.vmall.com/c0r46du56v
dl.vmall.com/c0ux6zrvbn
dl.vmall.com/c0i5hfngqo
dl.vmall.com/c0p79msf1o
dl.vmall.com/c0sz7iyfpk
dl.vmall.com/c0ay1un7w7
dl.vmall.com/c0dmx2ejf2
dl.vmall.com/c0jzqivk9z
dl.vmall.com/c0ttcmll99
dl.vmall.com/c0v4gdaxxp
dl.vmall.com/c0cdscoe1c
dl.vmall.com/c0egy57p7m
dl.vmall.com/c007qda0a3
dl.vmall.com/c0ge772isu
dl.vmall.com/c0ye9duazh
dl.vmall.com/c0ngx1lqmy
dl.vmall.com/c0sjloke4b
dl.vmall.com/c01tot4m4a
dl.vmall.com/c0g1txfm2j
dl.vmall.com/c02thq52lh
dl.vmall.com/c0t0p56c7l
dl.vmall.com/c0jnj3q21j
dl.vmall.com/c0gciv296i
dl.vmall.com/c0206v2527
dl.vmall.com/c0l15m5llq
dl.vmall.com/c0c9ngxgla
dl.vmall.com/c052xdrg2a
dl.vmall.com/c0qv3bx1cd
dl.vmall.com/c09kput8hj
dl.vmall.com/c08vt44bx6
dl.vmall.com/c0umkckj96
dl.vmall.com/c0q2rnbpmf
dl.vmall.com/c0x42cjr0e
dl.vmall.com/c0upqe7b8d
dl.vmall.com/c09w39f26n
dl.vmall.com/c0ai9iz9vf
dl.vmall.com/c0r2uyf6y5
dl.vmall.com/c02no1s9n9
dl.vmall.com/c0stl5q1x2
dl.vmall.com/c0arzawdjl
dl.vmall.com/c0jrs3he6d
dl.vmall.com/c03wsy3sge
dl.vmall.com/c0gbk48mwt
dl.vmall.com/c0ph3bter5
dl.vmall.com/c09uycrlas
dl.vmall.com/c0r9l5yi7n
dl.vmall.com/c0tzfrwmgx
dl.vmall.com/c033la1iq0
dl.vmall.com/c03vg7mi2u
dl.vmall.com/c069elw9rm
dl.vmall.com/c0idewkqag
dl.vmall.com/c0pfrop87u
dl.vmall.com/c0zoqn0v2v
dl.vmall.com/c09ilw56pk
dl.vmall.com/c0rpq4qaai
dl.vmall.com/c001efqytq
dl.vmall.com/c0pfeoyw9c
dl.vmall.com/c0yetl4cn9
dl.vmall.com/c0kqilxb21
dl.vmall.com/c0soe4h9mf
dl.vmall.com/c0524ifntz
dl.vmall.com/c0ds6st7kw
dl.vmall.com/c0hnyt7ksj
dl.vmall.com/c004cat7ss
dl.vmall.com/c0tv06ouzh
dl.vmall.com/c0r5lo8uko
dl.vmall.com/c0yarq4ury
dl.vmall.com/c0tuuf1j8e
dl.vmall.com/c0l23m0bfj
dl.vmall.com/c0bawuvvd6
dl.vmall.com/c0ef1tae2d
dl.vmall.com/c0qoa3e3q0
dl.vmall.com/c0sg8n96wt
dl.vmall.com/c0xwzgef7h
dl.vmall.com/c0pquvs4hv
dl.vmall.com/c0t267zaj9
dl.vmall.com/c0a7tuduob
dl.vmall.com/c03bdll45g
dl.vmall.com/c0vcdya6wc
dl.vmall.com/c0zutab6tr
dl.vmall.com/c089h28hyw
dl.vmall.com/c07o0b9mv7
dl.vmall.com/c0b2jrjg7i
dl.vmall.com/c0tv62fqj3
dl.vmall.com/c0okh629lf
dl.vmall.com/c0fypkic6r
dl.vmall.com/c0j9jdzhes
dl.vmall.com/c0ig9b5gy5
dl.vmall.com/c0xa4mhn8t
dl.vmall.com/c0b5b20xqv
dl.vmall.com/c05gmfemzh
dl.vmall.com/c0ipam4162
dl.vmall.com/c0ucyl6d25
dl.vmall.com/c0ybdom5d6
dl.vmall.com/c0mxqzli8s
dl.vmall.com/c0p7qsnxjh
dl.vmall.com/c0slia91ry
dl.vmall.com/c0hydr32vi
dl.vmall.com/c0i58ebp00
dl.vmall.com/c0xfkbiz64
dl.vmall.com/c0w5g0fgof
dl.vmall.com/c0nhi4555i
dl.vmall.com/c04wyedabp
dl.vmall.com/c0vit3suym
dl.vmall.com/c08j3dm9zj
dl.vmall.com/c00ra94c6a
dl.vmall.com/c0vhmfm6qn
dl.vmall.com/c0nncnmv5h
dl.vmall.com/c0n0iorcit
dl.vmall.com/c0xybgkujw
dl.vmall.com/c0or1axowo
dl.vmall.com/c0e8ni1yo7
dl.vmall.com/c07wle3q0u
dl.vmall.com/c0kkconl76
dl.vmall.com/c0lo24k9ph
dl.vmall.com/c0mkgv56r9
dl.vmall.com/c0ix5shjzc
dl.vmall.com/c0ak718utw
dl.vmall.com/c0np0a1m0m
dl.vmall.com/c0wozi0013
dl.vmall.com/c0vti1cgx2
dl.vmall.com/c005uvccj3
dl.vmall.com/c0pn2b53sk
dl.vmall.com/c0bt5bvf29
dl.vmall.com/c0xxxl2tfv
dl.vmall.com/c05xjzgdgm
dl.vmall.com/c0gvx7dexo
dl.vmall.com/c09fktkv6g
dl.vmall.com/c0f4tevnke
dl.vmall.com/c0y7z8yxsr
dl.vmall.com/c0lregs4ny
dl.vmall.com/c0xe75layl
dl.vmall.com/c0elmqmiek
dl.vmall.com/c0bzeu4lhc
dl.vmall.com/c0nvnw8dbn