如何用最容易的语句提交大量表单对象的值存储到数据库 - 明辉手游网

明辉手游网中心：是一个免费提供流行视频软件教程、在线学习分享的学习平台！

文章发布全站软件文章热门搜索：喜欢朋友 K歌手机酷狗电台搜索资讯首页腾讯视频爱奇艺暴风影音酷狗音乐酷我音乐影音大全软件下载软件教程电脑系统下载聊天工具办公软件杀毒教程系统工具图形图像电脑学习应用软件网络软件苹果应用注册码网站教程技术开发安卓教程其它教程您当前所在位置：网视手游站 -> 网站教程 -> 如何用最容易的语句提交大量表单对象的值存储到数据库
如何用最容易的语句提交大量表单对象的值存储到数据库发表时间：2024-05-30 来源：明辉站整理相关软件相关文章人气： [摘要]如何用最简单的语句提交大量表单对象的值存储到数据库？说道这个问题可能大家经常遇到，感到很头痛，但是又没办法，只能慢慢写，笔者以提交一张应聘表单的提交为例给大家介绍如何用最简短的语句来达到目的脚本运行通过环境环境： iis5.0+sqlserver2000（当然也可以access2000等）如有... 如何用最简单的语句提交大量表单对象的值存储到数据库？说道这个问题可能大家经常遇到，感到很头痛，但是又没办法，只能慢慢写，笔者以提交一张应聘表单的提交为例给大家介绍如何用最简短的语句来达到目的脚本运行通过环境环境： iis5.0+sqlserver2000（当然也可以access2000等）如有任何问题或建议请发email：chenxingbai@21cn.com 生成表结构的脚本 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[yingpin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[yingpin] GO CREATE TABLE [dbo].[yingpin] ( [id] [int] IDENTITY (1, 1) NOT NULL , [yp_ name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [sex] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL , [birthday] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL , [health] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [hunyin] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [zhengzhi] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [xueli] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [zhicheng] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [english] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [yp_ address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [zip] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [colledge] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [zhuanye] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [bumen] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [gangwei1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [gangwei2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [x_shijian] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [x_address] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [x_zhiwu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [g_shijian] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [g_address] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [g_zhiwu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [h_name] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [h_guanxi] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [h_danwei] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [h_zhiwu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [pingjia] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [shexiang] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [beizhu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [shijian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[yingpin] WITH NOCHECK ADD CONSTRAINT [DF_yingpin_shijian] DEFAULT (getdate()) FOR [shijian], CONSTRAINT [PK_yingpin] PRIMARY KEY CLUSTERED ( [id] ) ON [PRIMARY] GO Asp脚本addyp.asp <!--#include file="lib/config1.asp"--> <% if request("action")="add" then dim str,strvalue,strname,i,str1 str="yp_name,sex,birthday,health,hunyin,zhengzhi,xueli,zhicheng,english,email,phone,yp_address,zip,colledge,zhuanye,bumen,gangwei1,gangwei2,x_shijian,x_address,x_zhiwu,g_shijian,g_address,g_zhiwu,h_name,h_guanxi,h_danwei,h_zhiwu,pingjia,shexiang,beizhu" str1="x_shijian,x_address,x_zhiwu,g_shijian,g_address,g_zhiwu,h_name,h_guanxi,h_danwei,h_zhiwu" strname=split(str,",") for i=lbound(strname) to ubound(strname) if i<>ubound(strname) then if instr(str1,strname(i))=0 then if trim(request.Form(strname(i)))="" then response.write "<script>alert('发生错误，请将数据填写完整！');history.back(1);</script>" response.End() end if sql=sql&"'"&trim(request.Form(strname(i)))&"'," else j=1 much=trim(request.Form(cstr(strname(i)&j))) for j=2 to 5 much=much&" "&trim(request.Form(cstr(strname(i)&j))) next sql=sql&"'"&much&"'," end if else if trim(request.Form(strname(i)))="" then response.write "<script>alert('发生错误，请将数据填写完整！');history.back(1);</script>" response.End() end if sql=sql&"'"&trim(request.Form(strname(i)))&"'" end if next sql="insert into yingpin ("&str&") values ("&sql&")" conn.Execute(Sql) if Err <> 0 Then response.write "<script>alert('发生错误，请重新操作！');history.back(1);</script>" else response.write "<script>alert('已经成功提交应聘信息，\n我们会尽快和你联系！');window.location='addyp.asp';</script>" end If end if %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>gsjj</title> <link type="text/css" rel="stylesheet" href="main.css"> </head> <body bgcolor="#0066CC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" style="background-attachment:fixed;"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="center" valign="top" class="gray"> <p align="center"><font color="#66FF00">:::::::诚邀加盟:::::::</font></p> <form action="addyp.asp?action=add" method="post" name="ts"> <table width=100% border=1 align="center" cellpadding=0 cellspacing="0" bordercolorlight="#000000" bordercolordark="#ffffff"> <tbody> <tr> <td height="35" colspan="5"><font color="#FFFFFF"><span id=fps7>姓名 <input name="name" onFocus="this.select()" onMouseOver="this.focus()" size="12" > <font color="#FF0000"> </font> 性别 <input name="sex" onFocus="this.select()" onMouseOver="this.focus()" size="4" type=text> <font color="#FF0000"></font>出生年月 <input name="birthday" type=text id="birthday" onFocus="this.select()" onMouseOver="this.focus()" size="16" > <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td height="36" colspan="5"><font color="#FFFFFF"><span id=fps7>健康状况 <input name="health" onFocus="this.select()" onMouseOver="this.focus()" size="8" > <font color="#FF0000"></font> 婚姻状况 <input name="hunyin" onFocus="this.select()" onMouseOver="this.focus()" size="6" type=text> <font color="#FF0000"></font> 政治面貌 <input name="zhengzhi" onFocus="this.select()" onMouseOver="this.focus()" size="16" type=text> <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td height="34" colspan="5"><font color="#FFFFFF">最高学历<span id=fps7> <input name="xueli" onFocus="this.select()" onMouseOver="this.focus()" size="10" > <font color="#FF0000"></font>职称 <input name="zhicheng" onFocus="this.select()" onMouseOver="this.focus()" size="8" type=text> <font color="#FF0000"></font>外语水平 <input name="english" onFocus="this.select()" onMouseOver="this.focus()" size="16" type=text> <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td height="30" colspan="5"><font color="#FFFFFF">E - MAIL<span id=fps7> <input name="email" onFocus="this.select()" onMouseOver="this.focus()" size="30" > <font color="#FF0000"></font>电话 <input name="phone" onFocus="this.select()" onMouseOver="this.focus()" size=16 > <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td height="28" colspan="5" valign="middle"> <font color="#FFFFFF"><span id=fps7>联系地址</span><span id=fps7> <input name="address" onFocus="this.select()" onMouseOver="this.focus()" size="30" > <font color="#FF0000"></font>邮政编码 <input name="zip" onFocus="this.select()" onMouseOver="this.focus()" size="16" type=text> <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td height="29" colspan="5"><font color="#FFFFFF"> <span id=fps7>毕业院校 <input name="colledge" onFocus="this.select()" onMouseOver="this.focus()" size="30" > <font color="#FF0000"></font>专业 <input name="zhuanye" onFocus="this.select()" onMouseOver="this.focus()" size=16 > <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td height="27" colspan="5"><font color="#FFFFFF">应聘部门<span id=fps7> <input name="bumen" onFocus="this.select()" onMouseOver="this.focus()" size=10 > </span><span id=fps7><font color="#FF0000"></font></span>应聘岗位<span id=fps7> <input name="gangwei1" onFocus="this.select()" onMouseOver="this.focus()" size=12 > </span><span id=fps7><font color="#FF0000"></font></span>第二应聘岗位<span id=fps7> <input name="gangwei2" onFocus="this.select()" onMouseOver="this.focus()" size=12 > <font color="#FF0000"></font> </span></font></td> </tr> <tr> <td width="5%" height="203" rowspan="6" align="center" valign="middle"><font color="#FFFFFF">学<br> <br> 习<br> <br> 经<br> <br> 历 </font></td> <td height="25" colspan="4"><font color="#FFFFFF">起止时间学校职务</font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="x_shijian1" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="x_address1" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="x_zhiwu1" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="x_shijian2" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="x_address2" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="x_zhiwu2" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="x_shijian3" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="x_address3" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="x_zhiwu3" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="x_shijian4" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="x_address4" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="x_zhiwu4" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="x_shijian5" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="x_address5" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="x_zhiwu5" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr> <td colspan="5"> </tbody> <tr> <td height="203" rowspan="6" align="center" valign="middle"><font color="#FFFFFF">工</font><font color="#FFFFFF"><br> <br> 作<br> <br> 经<br> <br> 历 </font></td> <td height="24" colspan="4"><font color="#FFFFFF">起止时间供职单位职务</font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="g_shijian1" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="g_address1" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="g_zhiwu1" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="g_shijian2" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="g_address2" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="g_zhiwu2" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="g_shijian3" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="g_address3" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="g_zhiwu3" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="g_shijian4" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="g_address4" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="g_zhiwu4" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td colspan="4" align="left"><font color="#FFFFFF"><span id=fps7> <input name="g_shijian5" onFocus="this.select()" onMouseOver="this.focus()" size="18" > <input name="g_address5" onFocus="this.select()" onMouseOver="this.focus()" size="２０" > <input name="g_zhiwu5" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr> <td height="190" rowspan="6" align="center" valign="middle"><font color="#FFFFFF">家<br> 庭<br> 成<br> 员<br> 及<br> 主<br> 要<br> 社<br> 会<br> 关<br> 系 </font></td> <td height="23" colspan="4"><font color="#FFFFFF">姓名与本人关系工作单位职务</font></td> </tr> <tr align="center"> <td width="17%" height="20" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_name1" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="19%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_guanxi1" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="41%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_danwei1" onFocus="this.select()" onMouseOver="this.focus()" size="28" > </span></font></td> <td width="18%" align="center"><font color="#FFFFFF"><span id=fps7> <input name="h_zhiwu1" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td height="20" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_name2" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="19%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_guanxi2" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="41%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_danwei2" onFocus="this.select()" onMouseOver="this.focus()" size="28" > </span></font></td> <td width="18%" align="center"><font color="#FFFFFF"><span id=fps7> <input name="h_zhiwu2" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td height="20" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_name3" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="19%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_guanxi3" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="41%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_danwei3" onFocus="this.select()" onMouseOver="this.focus()" size="28" > </span></font></td> <td width="18%" align="center"><font color="#FFFFFF"><span id=fps7> <input name="h_zhiwu3" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td height="20" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_name4" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="19%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_guanxi4" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="41%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_danwei4" onFocus="this.select()" onMouseOver="this.focus()" size="28" > </span></font></td> <td width="18%" align="center"><font color="#FFFFFF"><span id=fps7> <input name="h_zhiwu4" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr align="center"> <td height="20" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_name5" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="19%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_guanxi5" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> <td width="41%" align="center" valign="middle"><font color="#FFFFFF"><span id=fps7> <input name="h_danwei5" onFocus="this.select()" onMouseOver="this.focus()" size="28" > </span></font></td> <td width="18%" align="center"><font color="#FFFFFF"><span id=fps7> <input name="h_zhiwu5" onFocus="this.select()" onMouseOver="this.focus()" size="10" > </span></font></td> </tr> <tr> <td align="center"><font color="#FFFFFF">自<br> <br> 我<br> <br> 评<br> <br> 价 </font> <td colspan="4" align="center"><textarea name="pingjia" cols="60" rows="5"></textarea> <font color="#FFFFFF"><span id=fps7><font color="#FF0000"></font></span></font> <tr> <td height="24" colspan="5"><font color="#FFFFFF">对未来工作的设想或其它需要补充的内容：</font> <tr align="center"> <td colspan="5"> <textarea name="shexiang" cols="60" rows="5"></textarea> <font color="#FFFFFF"><span id=fps7><font color="#FF0000"></font></span></font> <tr> <td height="28" colspan="5"><font color="#FFFFFF">备注（工作地点、薪金期望等）: </font> <tr align="center"> <td colspan="5"><textarea name="beizhu" cols="60" rows="5"></textarea> <font color="#FFFFFF"><span id=fps7><font color="#FF0000"></font></span></font> <tr> <td colspan="5"><font color="#FFFFFF"> </font> <tr align="center"> <td height="23" colspan="5"><font color="#FFFFFF"><span id=fps7> <input name="button" type="submit" value="提交"> <input name="reset" type="reset" value="重新填写"> </span></font> </table> <br> <br> </form> </td> </tr> </table> </body> </html> 标签：如何用最容易的语句提交大量表单对象的值存储到数据库* 上一篇：在Visual Baisc.NET 2005中使用泛型下一篇：用PHP编程开发“虚拟域名”系统	推荐资讯总人气榜 1PS提示：因为图层已锁定，无法编辑图层的处理方法 2Adobe Illustrator CS5 序列号大全 3picacg苹果版怎么找不到\|picacg ios版是不是下架了介绍 4ACDsee注册码免费分享（含ACDsee18、ACDsee10等版本） 5苹果iphone自动时间不准确的多种校正方法 6眼萌app怎么色弱测试眼萌app色弱测试图文说明教程 7百度安全卫士好用么_百度安全卫士技巧说明 8PDF浏览器能看3D文件吗？PDF浏览器看3D文件图文详细教程 9Potato(马铃薯聊天)怎么注册不了\|Potato不能注册处理方法介绍 10Potato(土豆聊天)怎么换头像\|Potato app更改头像方法介绍 11ipad版office如何激活? office365激活的图文说明教程 12最新的Adobe Illustrator CS4序列号大全 1css3里如何显示圆形图片 2支付宝怎么交学费，支付宝教育缴费图文说明教程 3京东微笑面单是什么，京东微笑快递单有什么用 4高铁儿童票网上怎么买，网上买高铁儿童票具体流程 5提高谷歌联盟Adsense收入4种方法 6百度减少收录是什么原因？ 7GG广告申请 8百度降权并不可怕 9稳定网站排名的隐秘：百度优先级算法 10新手误区：揭露seo反链工具的真实面目 11浅谈增加网站外部链接的方法 12被降权问题浅谈百度页面权重最新教程本月人气 1hr是什么意思？ 2新华保险如何？ 3固特异轮胎如何？ 4吉利汽车如何？ 5givenchy是什么牌子？ 6diesel是什么牌子？ 7铁观音是什么茶？ 8承兑汇票是什么意思？ 9抖音评论如何发竖排文字？ 10传销是什么？ 11moncler是什么牌子？ 12吕布如何死的？ 1豆瓣app下载地址豆瓣app官方版下载 2防范PPTV网络电视偷跑P2P流量的方法_pptv网络电视_下载之家 317app如何注册 17app注册方法流程 4Cool Edit提示：resample.xfm文件失去怎么办？ 5爱奇艺会员号共享（更新日期：2016年9月28日） 6ASP.NET编程10大技巧 7用XML与ASP完成购物车 8remoteview如何用？remoteview使用方法 9百度抢票宝验证码不显示如何办？百度抢票不显示验证码处理方法 10人生日历抢票如何用？人生日历抢票插件使用图文说明教程 11柚子相机如何用？柚子相机使用方法 12搜狗输入法如何设置快捷键？搜狗输入法设置快捷键图文说明教程
相关文章如何用最容易的语句提交大量表单对象的值存储到数据库