代码贴出来了,大家帮俺看看吧。
<html>
<body>
<h2>表格显示数据表记录</h2>
<hr>
<script language="JavaScript">
// 创建数据库对象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=INFORMFLAT;Data Source=BARCODE";
// 打开数据源
objdbConn.Open(strdsn);
// 执行SQL的数据库查询
var objrs = objdbConn.Execute("SELECT VPosition,Item_Sequence,Item_Code FROM D_Manufacture_Current where VPosition < 5");
// 获取字段数目
var fdCount = objrs.Fields.Count - 1;
// 检查是否有记录
if (!objrs.EOF){
document.write("<table border=1><tr>");
// 显示数据库的字段名称
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// 显示数据库内容
while (!objrs.EOF){
document.write("<tr>");
// 显示每笔记录的字段
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext(); // 移到下一笔记录
}
document.write("</table>");
}
else
document.write("数据库内没有记录!<br>");
objrs.Close(); // 关闭记录集合
objdbConn.Close(); // 关闭数据库链接
</script>
</body>
</html>
<html>
<body>
<h2>表格显示数据表记录</h2>
<hr>
<script language="JavaScript">
// 创建数据库对象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=INFORMFLAT;Data Source=BARCODE";
// 打开数据源
objdbConn.Open(strdsn);
// 执行SQL的数据库查询
var objrs = objdbConn.Execute("SELECT VPosition,Item_Sequence,Item_Code FROM D_Manufacture_Current where VPosition < 5");
// 获取字段数目
var fdCount = objrs.Fields.Count - 1;
// 检查是否有记录
if (!objrs.EOF){
document.write("<table border=1><tr>");
// 显示数据库的字段名称
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// 显示数据库内容
while (!objrs.EOF){
document.write("<tr>");
// 显示每笔记录的字段
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext(); // 移到下一笔记录
}
document.write("</table>");
}
else
document.write("数据库内没有记录!<br>");
objrs.Close(); // 关闭记录集合
objdbConn.Close(); // 关闭数据库链接
</script>
</body>
</html>
解决方案 »
- jquery ajax传值到action
- 关于input中自动添加内容后光标定位的问题!
- 找一段儿正则!
- 《javascript网页制作彻底研究》PDG格式电子书籍
- 求教:htm网页钳套ActiveX控件时,param的value值能否通过一个页面传递参数动态获得
- 中文字和数字的高度
- 一个正则匹配的问题
- 在javascript中如何创建对象??
- window.print("./anotherpage.jsp");打印问题?
- 怎么根据一个文本框的数字来动态的修改input的数目呢?
- 从jsp中得到“\\asd\123”,在js中“\”被当作转义符,变成了“\asd123”,怎么解决呢?
- javascript操作证书
需要权限。运行下面的js,然后重新启动IE(从桌面的图标上打开):
change.js:
----------
var WSHShell = WScript.CreateObject("WScript.Shell");
if(Number(WSHShell.RegRead("HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Internet Settings\\Zones\\0\\1201"))==1)
{
WSHShell.RegWrite("HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Internet Settings\\Zones\\0\\1201","0","REG_DWORD");
WScript.Echo("Warning:\n The My Computer Zone's Safe Setting have been changed a little.\n The item of initial and script running of the uned safty ActiveX component has been changed from notion to use.");
}
else
{
WSHShell.RegWrite("HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Internet Settings\\Zones\\0\\1201","1","REG_DWORD");
WScript.Echo("Warning:\n The My Computer Zone's Safe Setting have been changed a little.\n The item of initial and script running of the uned safty ActiveX component has been changed from use to notion.");
}