javascript 实现无刷新修改数据库
<javascript language="javascript">
function replace()
{
//定义SQL语句
var sql = update ping set yyong = yyong+1 where pid = 100370;
//新建数据库连接对象和数据集存取对象
var ConnDB = new ActiveXObject(adodb.connection);
var rs = new ActiveXObject(ADODB.Recordset);
//这里填入要连接的DSN
ConnDB.ConnectionString="DSN=ccjsj001;uid=glc;pwd=521098";
ConnDB.open
rs.open(sql,ConnDB,1,1);
if (rs.RecordCount>0){
var sql=null;
rs.close
ConnDB.close
return;
} else
{
var sql=null;
alert(没有此代号!);
rs.close
ConnDB.close
}
</script>
<a href="javascript://" onclick="javascript:replace()">有用</a>