谢谢!!我写的脚本是如下:function Update(){ alert("qweqrwer"); var xDOM = new ActiveXObject("MSXML.DOMDocument"); var sConn = new ActiveXObject("ADODB.Connection"); var updateCnt = "";
// var sqlUpdCnt = "Update worker SET pos = '"; // var choice = document.all.srcList.options[document.all.srcList.selectedIndex].text; // var myArray = new myArray("资产编号", "资产名称", "使用单位","使用职员", "使用状态"); // sSQL = "update worker set pos='111'"; // sSQL = "Select * FROM worker"; var sqlSelCnt = "Select pos FROM worker"; sConn = "Provider=SQLOLEDB;Server=(local);Database=pubs;UID=sa;PWD=1234"; sConn.open(); var rs = new ActiveXObject("ADODB.Recordset"); rs.open(sqlSelCnt, sConn); rs.Save(xDOM, 1); while (!rs.eof) { var cnt = rs.Fields("pos"); //document.write(cnt); //将取得结果加1后更新数据库。 updateCnt = cnt + "ok!!"; rs.moveNext; } rs.close(); rs = null; //var sqlUpdCnt = "Update worker SET pos ='"+updateCnt+"'";
alert("qweqrwer");
var xDOM = new ActiveXObject("MSXML.DOMDocument");
var sConn = new ActiveXObject("ADODB.Connection");
var updateCnt = "";
// var sqlUpdCnt = "Update worker SET pos = '";
// var choice = document.all.srcList.options[document.all.srcList.selectedIndex].text;
// var myArray = new myArray("资产编号", "资产名称", "使用单位","使用职员", "使用状态");
// sSQL = "update worker set pos='111'";
// sSQL = "Select * FROM worker";
var sqlSelCnt = "Select pos FROM worker";
sConn = "Provider=SQLOLEDB;Server=(local);Database=pubs;UID=sa;PWD=1234";
sConn.open();
var rs = new ActiveXObject("ADODB.Recordset");
rs.open(sqlSelCnt, sConn);
rs.Save(xDOM, 1);
while (!rs.eof) {
var cnt = rs.Fields("pos");
//document.write(cnt);
//将取得结果加1后更新数据库。
updateCnt = cnt + "ok!!";
rs.moveNext;
}
rs.close();
rs = null;
//var sqlUpdCnt = "Update worker SET pos ='"+updateCnt+"'";
var sqlUpdCnt = "Update worker SET pos ='123'";
sConn.execute(sqlUpdCnt);
sConn.close();
} document.write("<input type='button' width='500' align='center' value='更新数据' onClick='parent.Update();'>");但是使用document.write调用时重新打开了一个窗口根本找不到更新函数了,请高手帮忙看看
如果是服务器端js 可以直接操作数据库
function Update(){
var inValue = form1.inputValue.value;
var inPos = form1.inputPos.value;
var rsXML = new ActiveXObject("ADODB.Recordset");
var xDOM = new ActiveXObject("MSXML.DOMDocument");
var sConn = new ActiveXObject("ADODB.Connection");
if(inValue == ""){
alert("请根据编号先查询结果然后再修改更新位置的数值!!");
form1.inputValue.focus();
return false;
}
var updateCnt;
var sqlUpdCnt = "Update ZC_ASSET_CARD SET CUSTOM_TEXT1 ='"+inPos+"' where ASSET_CARD_NO = '"+inValue+"'";
sConn = "Provider=OraOLEDB.Oracle;data source=ora;user id=gaczdata0004;password=gold;"
//sConn = "Provider=SQLOLEDB;Server=(local);Database=pubs;UID=sa;PWD=1234";
rsXML.Open(sqlUpdCnt, sConn);
alert("修改成功,编号是:" + form1.inputValue.value + ",修改后更新位置的数值是:" + form1.inputPos.value);
Query();
}
</script>
<input type="button" name="bt222" value="更新数据" onclick="Update();"/>