51Testing软件测试论坛

 找回密码
 (注-册)加入51Testing

QQ登录

只需一步,快速开始

微信登录,快人一步

手机号码,快捷登录

查看: 5215|回复: 7
打印 上一主题 下一主题

[原创] 请问将图片或是一些二进制类型的数据插入到oracle?

[复制链接]

该用户从未签到

跳转到指定楼层
#
发表于 2010-1-15 11:46:45 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
我用loadrunner录制了点击一个按钮就可以将图片以二进制流类型的数据插入到oracle.那么频繁上万用户执行该操作怎么办了?

先谢谢各位仁兄了!

[ 本帖最后由 HAOYUNXIANXIAN 于 2010-1-15 12:54 编辑 ]
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏
回复

使用道具 举报

该用户从未签到

7#
 楼主| 发表于 2010-1-28 11:17:26 | 只看该作者

回复 7# 的帖子

请问版主value值太长怎么做参数化?  佩带那么多奖彰,
回复 支持 反对

使用道具 举报

  • TA的每日心情
    开心
    2014-10-24 09:36
  • 签到天数: 1 天

    连续签到: 1 天

    [LV.1]测试小兵

    6#
    发表于 2010-1-20 14:51:44 | 只看该作者
    你这个比较厉害,还没用试过value设置成字节形式的,都是以文件方式上传的
    回复 支持 反对

    使用道具 举报

    该用户从未签到

    5#
     楼主| 发表于 2010-1-20 14:35:18 | 只看该作者

    用lr录制后, 请问value的图片值太大怎么办?

    web_submit_data("Handler_VideoModel.ashx_2",
                    "Action=http://192.168.0.101/Hospital.Client/AjaxData/Handler_VideoModel.ashx?type=1",
                    "Method=POST",
                    "RecContentType=text/html",
                    "Referer=http://192.168.0.101/Hospital.Client/VideoModel.aspx",
                    "Snapshot=t10.inf",
                    "Mode=HTML",
                    ITEMDATA,
                    "Name=hidFaceData", "Value=AF0AAIAARr4KAAAAAAAAKZlIZ3e6XPMJ5WmnvyHWkEbUsLTxRzY3P+Lrj9jaT57+Ivtt3OF83vrp4Q+iZb+x8gdzKx34ysOSmSEiWn2dQjkgubydG82u640kLiTBljtcdbuIL/uj7MhpyhpoUsS8XCspiYBNhy9ps1gL4cJruWSOOlr2Uc1IFiY1emnt2XL+kksLrUWqynLISjOM9DIIUBqg9KFPp70/hCh5A/EzgHFDqCziemjafeOaotdjjgScIRklYi6DV5Du9ETHkAcGx+fZ4kO/xtGYqN4ohzU3UE3bawnPGF+EqqFHcJ/DkK89J3KkraygcEXo6r7NbqXYkSvfRc0Dce8+/PrGc9GwdD6MPI7mfveuCz0U1bUhphl0XxARZqB277kHH8Du4EMwwOY2pnf2FljGIt4ThT+wqYKUYvRnbEUqDPv8ZjcpjzYwpHKM26ZPXwDcGrqrAu2/PaI8h/b+"
                    "8t++m1JK6gVPXWDAAd/Nr3SwfJq2H0nFXOcfIUmkDxry+iEwMgBndUM6RofrQ7X8Xi9cgMFMxpBo3TPq0brLneHmx/uRFoNdqKsgqmvgA+7IH3bCmmtCbteLVfCBe8ch6vgrd6MIr3sytDWSk5D0OTrodYeLcMz1k2vXbP0rYvf3isuSJiUqjdFd/Btq6Q39GVilwanBcBClx1F5teJESVq/kfVarwDuZnHtEZ5fr8GhUmzZlBvGWT3I3mmApCDwJCGCX+P0IYEOEyRdQkhm+GgqsHXPW5Dql/eEOvqGqXTwWOGf2FOTxdTiazHNLRQU9/WhyU8R/x6VAnxt8JtNsIKDf88/jEMQcRTidNJwDs5XRg5mBOyMVFchL610wzcR70kftMIjC2rB6qaya0Tk6UQMAojjE6mtQJ6OMhyX2ecNI0lH0aNi+F/"
                    "Azg2zamY0YTRWPHZE5qVRyrEolfKiTFiaV4oBeSh9THEbJM6jBMCogutIZ6wNqBNx/7OxiF4fZZ5miSrj1mLZKT5yO8k5pW0WZK3O8EmrmqwxcgeHdpLjVXGnnY3fia5dLj79qGj8Ky3YirIJNCcuTWsp4XvoGilArbQ8osDnZe4rANqhNI/K2y8fPrf52IuBGFFqEiP8+j4ZLqro4pCNNYokVsftx8zHQphmnAIsPwvE979V0hPqEI+vgJjpaLkG7HrZVhv4uYmAYCdivRoFcqw3mErTHbhS9J4aJwo+Xkz3NfGdJgu4zWNwXUzbX4pyU0DCzGLJl6Um52F4Q8ARQkUTgEBsOe0mMOAXxECi9eL+DtizV0TcgA5EMTIt//WV920ZfnxKScgSdOAerqVj6mtTwtjTyQ3Pwzz70D1Ws3nLJYotYkbtFzmalihGDD9OPtSY0D3k+FGlSYlDRviSLEX5CPtt+"
                    "UsBf8jmztmZvqe2M43YvWB7ACEOqXe8ymFSmespvncM52o9+0PBdZtNW4cp79l4HMtHA2gu/h104X/PQVCprVPnHBq1wWnlzZ4Kbg3Htc60e/zk8J6/2pD+g6Du2WqtlDrBABWnJImQm5zMZGih2rVaYe2Yr5EJn1TwV9Nr4u2Qvbmej35lEWiAznysaGDG43yc/TBo+jdLuJsbmjlVC53x4IUJ+136m5fYjUe7R05hbT8K531F8izz71QrdTbA5ZC9x2RGdx+j91fQFxykSQFvVGd0SS6rI6GKXcEko7spIBUBHUfcX0Y3aZOLMwzJd+I0OF4DeawwMwnwP41qHklJ1xm95DLZG8iXY6zSTowdI3AZ5Fq4PDFeuSFIkrua8vjjuSyYSxW/JLxuP445EQYXoExPfxXn/ArQrbymduRI3CuC62K35T3081iOcIDuKyMXx0uDWTWKltPxlyp16+"
                    "6nnIoXpxyyYkm7Viqy3pduG9RrRE9IFDynRIHfQowkPOQ8AewE5G3VH2BeagWNwOhMtbGn9J22cKFJWv99uYOIJoO5S0tCRHrpHvPHXbwQm2p4Eh0H5KrWEq9iUSg6GtvobtX6R2X1e8sRfMlFkE3D1olOueXfgj1sAuYM/Y8aQ89KV3EjlGuC/3Kc43PbvNebg3CNjtImvdBJU+DctZ2G6O0XvkEqjj686j1z2g6dLtYbSP/XFjq2usaZOc8NezTrUHV1nqgrZYR0BW4tsZ2VV4txYLrLcxAHYPMqZ1h7/REup5+PCy0F8Gxjv1bm4X3ba0xrE28/zPcz+o2NTpDg5MXt4qNqCzbtLegGRhZsjiqZDXUytLc5J+zYmAinv0hk9RGV+QN/TJCLp3Pd8L6gPqQMF1zn7uf8ydNqex80e/7OHBesl3aNH3s2zoxBDnrH/"
                    "LwG0r06ZzFC6iUYeqERzMx8JHHRbagKiTCzlYhP9uaXIQTw99oSa5n5CUm2ux7q8fwqfAsbsrYYzIFUORDBEYZcCv1Aw6JanIdhOPrrEWxh2p9ZFcgK3+g+xXFjuJvcneltZrtv07XglcYZSW7LYw9kAYqBN303mkr4/1TXx2T6NBL9rt65ztD/+MwoV2Q2v2XjE3+/ses0NTZEqC3JQcnJYZWRtr17369bsSySCUD4ah20393CEHS5LdyDOnCtUJzxD4pqMeIzpBV4z7ZxFhUwPgzmNkLWImT0FHuNde1LrOEwcfk3Oh/EM88Wo/E0HwVBqvuj2iPouZwAlHs0mPWgnvqqx5eI5+gE/rlC/Z4uj54LpL7Zkrt1r9gNjBSTvjpesZ8rmrPCgU2ieCqvw7DG8ujtWLoryYnyCwtV1rtzLQ1abKqaOXtMbe5ZLXSHRvzp+fdC1eVL805LhkocOHKJnwKq7MJg64/gOliEivHpqPDO/"
                    "qC0Grig2WuKS2RRjRdZoEDEfDWK40yWIvrSxLFIkn2w8pTz8aA1+Xin6pHaYCREFBThwPPVv1bpIWa8n72yvlzqmVEp+ASA3OnYfbq1HFTidiWiFvWGogwlOx2PQ037WZy9hgqhoP4o1SRabdegCsZYu82xWFuJ7PUb/uS2sEncuxtPiKt0UpfwaF6K+ub5ww87TZ/Cwz+9yRTPGjXNe4olQHn3JTKCCFeBQBAvyM6ywb/jsAQ1bLWbHvBfdKgk45WwxLX5cocV47TdEj1vmDi4NPnlHPzse/3S5dbuQOz8apk85PtEyTEt+2OCXbO6mm4mM32WN9tSoFB65+lpwNWKhXGygMvM2xgQTljdsXG7zfEZFnxqAaRH/SZLmunsju/KFRAyoRX9UDzMZktnVq3lSGDjIU6mlPUALH058/cmbMB/Hf5C2PbVdCqdAqWOOJD0syXXK4e+u/z+FzbL3kG8nesk6/jTDr86iw0Ec1EiHAJ3SXjEI/"
                    "Bo46Z43AvPbfZCk1Ig/pa0+ZcH6dD4rEJkviKJWLVeauvZChBxD7U1lJ/sAGvGmRZtN4ioD8/9S0IhkB3Ti+R/dSfogJKDQ9w+iSLumh5rc4QKw3zBVUhHPXpioX9vNtloMi33G5HFeJoskbhVR8HH1Vhz+otSvYzR2v8bPZAH0zRWgx0XSwyX9hZyRvgdvtGFkb0EBkIIExpCNofF/yj6xyAh+5WaUkW3lh05m479+XEK12C3K+DT6S9NKm5QDI57QaaCRJwlTLrn+JjCrT9okproshFj44yhW35q67khPHRcmL8kpGywIvnCI9bIQPTBMRpR1EA+QsgGazIrEIBABtyPlrwM3xr5By4VXWBJBESwRrXvBziuCq/yhittKVb3W2TNnJq1xn1G7r+0T3eSk+7ig0g4WRFur0pIHkI1lnrvSbXwNSZhltDYtfFPYM29peIGtgr1vGS6MyX+jihAsQSTt0OJA9+Tf7AhY/3KAwx+MLtBg/"
                    "4y6I4lQyQmAWLOFhmTU8gnrLOHy/Qk0tCSBe+44SXzsUqgVC1Qf/qdshGfnZFMulll1lWSkgUQJUGo9cDXoD1tVo8uk2d8pqGp3/9/RKpX6Dh/wgKxG/gyPNfHy25WLol+e5RX/+Nm7YYqQk+6BJL/2vINpamdHCxpn2cEev1L4uJ9oIxFNd4jDsYkyjmMutaYAEHZRqNLnvDjhAADsHpwQKb+ImtZ/RRRlkisLjnCXH8o1JvYA8Fa0BdnE6K9BV9Te39EK9JWOaNxh3yipOzEzE3/p3nZjtZZtEbswi21UT2hBTgnQCDz0Ia6q+MEg/fEoIZSziyoZAPaj8ZgLheb0heAckf5I0rDl0hnyxbkwGNaDXbMLecNY6w078zbZpXA2nlGlAaWqklSiNlBBLHNWILRPyX01PkQ9NpDbSA2M9K9zPCp+KaMVRG/tJ9oNGIFBojil/ADgWjecZUSAEAz15cUWXC0OqIlPGPPRAHQs0REkbjieiK/"
                    "X7qlugqd3B4+74STpuqjRuXk8vIYA0c6A2GIUEfrxLG5/MfGxeBAO6XyuznaZRqIxJbfxrGQQ2ciS4n7MUSdYiYLq25hTK0V/BgShVh4xDO+UcJ1FGAmX0gDNMbJhuPT4VOgGbHFV/gyjegUol+mK3kRYzxjVsIef+IYD56l7wRDE7eajsVjRSDtzgVTG3QS7kNOOONO4bWfLopnJ2y4ppB/Qqe/fLlkaP+XLpoHnfORRbz9wyWZ9SIv0QOFe5qZKZQN9afQlPWRzwC13comSqaf8NBXSKMjakdzKSa1jwifdElcVY52XomArVLgEE3KSpSdT25YS5K1LYexQ5HovP8YqctGhPb0E2gLfyE2LCDWi735ThI6BlSPD6UJJCMtBaIbh4f4Wc25Av0c8b648yfeJ4WYZgahFUR7EfXk/S8xn/wVzojUIEsY+yiRJ3KbKv6AH2NXK9wYtAUvAD/hhtVkTt++"
                    "xXPFOJjgp2DFqN77F6QAJTRTgQA+fT1EVyS6wdgHgBdtSIp1FOUrl1SZz9U/QVKPkE0KetQfPlcGmPvWCKXBSTYazy3N4P0pM1pDNMR4T3vpbCZV9EC9FxaIpbtm0YBBofD+CqtVwaBetI6TgbM48qtGfePyM/g2L7JVdp00yjwIqB0HerTpeLaVLY4eIO6nbUcPxLgUUhGz0UQev6lnj7gJoPN8xyqix/LjCDRPf78rVNhhQiFF/wMCvc74YBpNVTr9ihoUQaD7j+0tyYX8y6JyGDoA7xY6nPg2xdzWZM8ATT4IfniUbo/6UJyVLb4XG58uVFw/0IXqbhYYA66byoCaFbze3QWYS2FxKmeQRQBRyq6185tvMUQRZiEsProBJx3mDOGzV5WsA21CHVVdy2Q96q4u5ZOu2chjoL+V6WpnX8cReUwzbgftI1/"
                    "5kgFzaOWrd5m6gxzAX7ADlzWOrjMc4zOxu1QpcRUb6qtxoiqFM1tZZKzdCNioni+PSRtEV8UtuJf0NFARb3+nhoGOepGkRjQkexHhwnxjfto0+UoTNCzFV/NN8KCfC/YXZotPzfz8oeZ7IdBPG3NjJZM3l0mK8p3jY6y/oRy9Ox4ogng2a2+jCi/5OwTtm06I9xlfIsuYT0X/lYfyV9RrJIXlD99V1CoZGA1G/dKt/qWQRGa8lH1FMU69norrhuMO9kG5fMd3ttJy6hiXvfjyyZOUXxsK9fLBb01SACd+hlSbW1fHBWGSbql7juFopoNCnftcBKLRhrpAFNbuNtxL5unK+We11hn1Vq/XZ+EVZPghcefQodKUx5m1zSeEyxW3WO+diIO6PMzWgJZS8Tivx49xK2kBPkTAu+XdIfmFvXJyytY6VV4SS5V4nQ+dZCpA4wS9z5DZPEe3T9CHKbCEsH+"
                    "YoqfkrJKAewWqE05PHS8FoJSa1ehzZd9NiRAHMcrP2GemS8SsN2
    回复 支持 反对

    使用道具 举报

    该用户从未签到

    4#
     楼主| 发表于 2010-1-19 16:03:53 | 只看该作者

    问题是图象值太大,如下所示:377854个字节,我粘贴不下了.

    "Value=AF0AAIAARr4KAAAAAAAAKZlIZ3e6XPMHME4B4yzhsvVvChZwhoXXSGBr+/CS3r7iKvyhbjDtLKGjbq46JK3dKKZRyYPFVaFxKiMrzGHGJIP0xQ14AxdilVGITLcU/ZIsmaNTxo0XW+tRuOFQWTCPirR3kTdsGp6EDAH1r62mVeomRrlEHyUlglzrQ4gtTjY0N90U5CGfzro9UhquNuIglDkY+ngk+gRuiYGaNcNyeFcpioHUW2ZLrtR+78H+3rL9icG0c4rHxfhHEvvrkGS4TFjZbRmNp5D5z2L8zDHlzFB8URBG4mSB5eDl1MWDPgqmmNfXRf9m2bvEln7PmnCX6EN8veu4F2H5MlUbwVlJ0sIuk0BuxClq+HZyL60Te0K2QkT7z2a4wR/xqaaW69Ph8LQraMwzhzqIwEd4Y7P/hMZdZmUgAMLl4OcTQmRJPyOJ7zyDd0wqL1EJp+"
    回复 支持 反对

    使用道具 举报

    该用户从未签到

    3#
    发表于 2010-1-15 15:54:02 | 只看该作者
    参数化可以么?
    如果允许同样的照片,qtp也可以
    回复 支持 反对

    使用道具 举报

    该用户从未签到

    2#
     楼主| 发表于 2010-1-15 14:47:16 | 只看该作者

    这个测试怎么做? 帮我说说吧!

    回复 支持 反对

    使用道具 举报

    本版积分规则

    关闭

    站长推荐上一条 /1 下一条

    小黑屋|手机版|Archiver|51Testing软件测试网 ( 沪ICP备05003035号 关于我们

    GMT+8, 2024-11-15 14:48 , Processed in 0.074473 second(s), 27 queries .

    Powered by Discuz! X3.2

    © 2001-2024 Comsenz Inc.

    快速回复 返回顶部 返回列表