有位朋友提出了一个简单的方法,基本可用,只是Request.Form("Price" & mm)取不出用户填写的价格,我把修改过的代码贴出来看看有什么问题:HTML<input type=checkbox name="mm" value=<%=rsgrid("id")%>>
<input type=input name="price" value=<%=rsgrid("price")%>>
=========================================================================ASParrProdID = Split(Request.Form("mm"), ",")
mm=Request.Form("mm")For Each mm in arrProdID strSQL = "Update production set price = '" & Request.Form("Price" & mm) & "' Where id = '" & mm & "'"conn.execute strSQLNext
<input type=input name="price" value=<%=rsgrid("price")%>>
=========================================================================ASParrProdID = Split(Request.Form("mm"), ",")
mm=Request.Form("mm")For Each mm in arrProdID strSQL = "Update production set price = '" & Request.Form("Price" & mm) & "' Where id = '" & mm & "'"conn.execute strSQLNext
addbatch()就是用于写批量SQL语句的、
好象还要记得autocommit设为否、
问题继续请教中……
String sql = "update production set price = '***' Where " ;
for( int i = 0; i < idList.length; i++ ){
if(i == idList.length-1){
sql = sql + "id = '" + idList[i] + "'";
}else{
sql = sql + "id = '" + idList[i] + "' or ";
}
}
大概就是这个样子了,没测试过,自己拿去玩玩吧^_^