asp循环插入多条数据
asp循环插入多条数据的典型案例 '循环添加到数据库 For i=0 To UBound(pg_fltNo) objStrSTime = pg_sTime(i)&" "&pg_sHour(i)&":"&pg_sMin(i)&":"&pg_sSend(i) objStrETime = pg_eTime(i)&" "&pg_eHour(i)&":"&pg_eMin(i)&":"&pg_eSecd(i) strSql= " insert into ba_flightMileage "&_ " ( flightId, dayNum, flightNo, airlineCn, airlineEn, airfares, planeTypes, "&_ " startPoint, departureAirport, departureCode, departureTerminal, startTime, "&_ " [endPoint], arriveAirport, arriveCode, arriveTerminal, endTime, isNight ) "&_ " values "&_ " ("& objItem.item("fltId") &", '"& pg_dayNum(i) &"', '"& pg_fltNo(i) &"', '"& pg_airlineCn(i) &"', '"& pg_airlineEn(i) &"', '"& pg_airfares(i) &"', '"& pg_planeTypes(i) &"',"&_ " '"& pg_sPoint(i) &"', '"& pg_departAirport(i) &"', '"& pg_departCode(i) &"', '"& pg_departTerminal(i) &"', '"& objStrSTime &"', "&_ " '"& pg_ePoint(i) &"', '"& pg_arriveAirport(i) &"', '"& pg_arriveCode(i) &"', '"& pg_arriveTerminal(i) &"', '"& objStrETime &"', '"& pg_isNight(i) &"')" conn.execute(strSql) Next
其中有一些方法是我们自己在后台封装好的比如SplitPlus
-----------------action
Select Case GetSafeStr(Request.QueryString("action"))
'增加机票航段
Case "createFlgMlgAdd"
Dim strFltNo, strDayNum, strSPoint, strSTime, strSHour, strSMin, strSSecd, strEPoint, strETime, strEHour, strEMin, strESecd, strIsNight, strAirlineEn
Dim strAirlineCn, strDepartAirport, strDepartCode, strArriveAirport, strArriveCode, strAirfares, strPlaneTypes, strDepartTerminal, strArriveTerminal
Dim addNum : addNum = GetSafeStr(Request("addNum"))
fltId = GetSafeStr(Request("flightId"))
strFltNo = GetSafeStr(Request("flightNo"))
strDayNum = GetSafeStr(Request("dayNum"))
strSPoint = GetSafeStr(Request("startPoint"))
strSTime = GetSafeStr(Request("startTime"))
strSHour = GetSafeStr(Request("leaveOnHour"))
strSMin = GetSafeStr(Request("leaveOnMinute"))
strSSecd = GetSafeStr(Request("leaveOnSecond"))
strEPoint = GetSafeStr(Request("endPoint"))
strETime = GetSafeStr(Request("leaveTime"))
strEHour = GetSafeStr(Request("returnOnHour"))
strEMin = GetSafeStr(Request("returnOnMinute"))
strESecd = GetSafeStr(Request("returnOnSecond"))
strIsNight = GetSafeStr(Request("sltNight"))
strAirlineEn = GetSafeStr(Request("airlineEn"))
- majormaster2015-05-05好用,参考后解决了问题
- 戬2015-10-19还好吧, 但是用不上
- 粉丝: 3
- 资源: 19
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- torchvision resnet18 计算相似度
- mnist手写数据集本地下载链接
- 52193906181644561181711717834527.jpg
- 图片缓冲技术(android)源码
- 花数据集+数据集汇总+标签txt+数据集汇总代码+迁移学习最佳模型+全部迭代最佳模型
- 20240329224412.zip
- switch.docx `switch`语句是C++中的一种流程控制语句,通常用于根据表达式的值选择执行不同的代码块 下面是`
- python绘制直方图-02-进程之间不共享全局变量.ev4.rar
- python绘制直方图-01-第三天知识点回顾.ev4.rar
- 01背包问题动态规划.docx