我这儿有一段我自己写的程序,希望对你有点用:function QueryImg()
{
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn = "Driver={SQL Server};SERVER=localhost;UID=sa;PWD=;DATABASE=gmis_rdstandard";
objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("SELECT * FROM advertisement"); ImgCount = 0;
var Html = "<table bordercolor =\"#d5d5d5\" border = \"1\" cellpadding=\"0\" cellspacing=\"0\">";
while (!objrs.EOF)
{
Html += "<tr>";
Html += "<td bgcolor=\"#ffffff\" width=\"160\" align=\"center\" height=\"1\"><img width = 128 height = 96 src=\"";
Html += objrs.Fields(3).Value + "\" id = Img" + objrs.Fields(0).Value + " title = \"链接网址:" + objrs.Fields(1).value + "\n开放:" + objrs.Fields(2).value + "\">";
Html += "<input type = \"hidden\" id = \"CurrImgURl" + objrs.Fields(0).value + "\" value = \"" + objrs.Fields(3).value + "\">" + "</td>";
Html += "<td width=\"160\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><input type=\"text\" id=\"URL" + objrs.Fields(0).Value + "\" value = \"" + objrs.Fields(1).Value + "\"></td>";
Html += "<td width=\"120\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><input id=\"Open" + objrs.Fields(0).Value + "\" type=\"checkbox\" CHECKED name=\"a" + objrs.Fields(0).Value + "\">开放 ";
Html += "</td>";
Html += "<td width=\"60\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><a style=\"CURSOR: hand;\" class = \"MouseOut\" onmouseover = \"SetStyle(this, 'in');\" onmouseout = \"SetStyle(this, 'out');\" onclick=\"OpenSelect('";
Html += objrs.Fields(0).Value + "');\">[换图]</a></td>";
Html += "<td width=\"60\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><a style=\"CURSOR: hand;\" class = \"MouseOut\" onmouseover = \"SetStyle(this, 'in');\" onmouseout = \"SetStyle(this, 'out');\" onclick=\"Delete('";
Html += objrs.Fields(0).Value + "');\">[删除]</a></td>";
Html += "<td width=\"60\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><a style=\"CURSOR: hand;\" class = \"MouseOut\" onmouseover = \"SetStyle(this, 'in');\" onmouseout = \"SetStyle(this, 'out');\" onclick=\"Apply('";
Html += objrs.Fields(0).Value + "');QueryImg();\">[应用]</a></td>";
Html += "</tr>";
ImgIDArr[ImgCount] = objrs.Fields(0).value;
Hab[ImgCount++] = objrs.Fields(2).value;
objrs.moveNext();
}
Html += "</table>";
ImageList.innerHTML = Html;
var i = 0;
for(; i < ImgCount; i++)
{
document.all("Open" + ImgIDArr[i]).checked = Hab[i];
}
objrs.Close();
objdbConn.Close();
}
{
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn = "Driver={SQL Server};SERVER=localhost;UID=sa;PWD=;DATABASE=gmis_rdstandard";
objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("SELECT * FROM advertisement"); ImgCount = 0;
var Html = "<table bordercolor =\"#d5d5d5\" border = \"1\" cellpadding=\"0\" cellspacing=\"0\">";
while (!objrs.EOF)
{
Html += "<tr>";
Html += "<td bgcolor=\"#ffffff\" width=\"160\" align=\"center\" height=\"1\"><img width = 128 height = 96 src=\"";
Html += objrs.Fields(3).Value + "\" id = Img" + objrs.Fields(0).Value + " title = \"链接网址:" + objrs.Fields(1).value + "\n开放:" + objrs.Fields(2).value + "\">";
Html += "<input type = \"hidden\" id = \"CurrImgURl" + objrs.Fields(0).value + "\" value = \"" + objrs.Fields(3).value + "\">" + "</td>";
Html += "<td width=\"160\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><input type=\"text\" id=\"URL" + objrs.Fields(0).Value + "\" value = \"" + objrs.Fields(1).Value + "\"></td>";
Html += "<td width=\"120\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><input id=\"Open" + objrs.Fields(0).Value + "\" type=\"checkbox\" CHECKED name=\"a" + objrs.Fields(0).Value + "\">开放 ";
Html += "</td>";
Html += "<td width=\"60\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><a style=\"CURSOR: hand;\" class = \"MouseOut\" onmouseover = \"SetStyle(this, 'in');\" onmouseout = \"SetStyle(this, 'out');\" onclick=\"OpenSelect('";
Html += objrs.Fields(0).Value + "');\">[换图]</a></td>";
Html += "<td width=\"60\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><a style=\"CURSOR: hand;\" class = \"MouseOut\" onmouseover = \"SetStyle(this, 'in');\" onmouseout = \"SetStyle(this, 'out');\" onclick=\"Delete('";
Html += objrs.Fields(0).Value + "');\">[删除]</a></td>";
Html += "<td width=\"60\" bgcolor=\"#ffffff\" align=\"center\" height=\"1\"><a style=\"CURSOR: hand;\" class = \"MouseOut\" onmouseover = \"SetStyle(this, 'in');\" onmouseout = \"SetStyle(this, 'out');\" onclick=\"Apply('";
Html += objrs.Fields(0).Value + "');QueryImg();\">[应用]</a></td>";
Html += "</tr>";
ImgIDArr[ImgCount] = objrs.Fields(0).value;
Hab[ImgCount++] = objrs.Fields(2).value;
objrs.moveNext();
}
Html += "</table>";
ImageList.innerHTML = Html;
var i = 0;
for(; i < ImgCount; i++)
{
document.all("Open" + ImgIDArr[i]).checked = Hab[i];
}
objrs.Close();
objdbConn.Close();
}
解决方案 »
- JavaScript怎么获得listview编辑模式下的一个label服务器控件的ID
- js 无法读取输入后的值
- javascript处理网页连接的问题.
- 求助JS四舍五入的方法
- javascript高手进来帮帮忙!!!
- 怎么用javascri语言t登陆窗口输入账号密码后怎么调到主界面去
- 关于正则表达式
- 不使用window.open打开一个无menubar,toolbar窗口的问题,敬请各位英雄指教
- 如何在父页面中用javascript刷新iframe页面啊?
- 关于删除一条记录的问题!
- 我想在一个页面中如果URL是有’?‘的,我下面的连接也带上?test可以这样吗?
- 在客户端如何读取注册表中的信息,和运行某个程序并加上参数?
的确有来自ADO的警告说不安全。请问,该如何克服如此情况!!