朋友,你应该直接找孟老师呀!他就告诉了我一个javascript连接到mssql数据库的方法,不过我也不敢给你传载,因为侵权!不过你可以去:
http://www.csdn.net/expert/topic/1025/1025439.xml?temp=.5482752
http://www.csdn.net/expert/topic/1025/1025439.xml?temp=.5482752
解决方案 »
- 一个数据检测的问题。
- 关于onMouseOver、onMouseOut、onClick 实现一个效果
- 关于javascript追加的一个问题
- 如何实现多张图片切换时每张图片都不变形?
- ymPrompt消息提示组件
- 导入JS文件问题,郁闷
- 根据下拉框让不同table显示
- 关于焦点的问题
- 一个有点难度的问题;怎样用javascript实现象windows的帮助文档内的索引查询功能(输入某字符后自动显示关于该字的项目
- 请问按如下方式作单选钮的选择情况控制为什么无论是否选择选择哪个选项都alert啊?3x
- 请问如何分隔同窗口同名js函数?
- 这绝对是个拿分的问题,但我估计会的人还真不会太多.InterDev的使用问题.
<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>
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\\TopTen\\TopTen.mdb";
strSQL = "SELECT TopTenName, TopTenCount FROM TopTen ORDER BY TopTenCount DESC";
rsTopTen.Open(strSQL, ConnectionString, 3,1,1);// Set variable
var nCounter
nCounter = 0;// Loop through the Recordset
while(!rsTopTen.EOF)
{ var nCount, strCount, strFormated // Iterate the counter
nCounter++;
// Load variables from the Recordset
strName = rsTopTen.Fields.Item(0).Value;
nCount = rsTopTen.Fields.Item(1).Value; // Go to the next Record
rsTopTen.MoveNext();};
// Close the Recordset
rsTopTen.Close();
//ConnectionString = "DRIVER=SQL Server;SERVER=MySQLServer;CATALOG=MyDatabase;UID=USERID;PWD=Password";
//
// for SQL 7.0:
ConnectionString = "DRIVER=SQL Server;SERVER=TopTen;CATALOG=TopTen;UID=TopTen;PWD=TopTen";
//
// Build a SQL statement
strSQL = "SELECT TopTenName, TopTenCount FROM TopTen ORDER BY TopTenCount DESC";// Open the recordset
rsTopTen.Open(strSQL, ConnectionString, 3,1,1);
// Create the Recordset Object
rsTopTen = new ActiveXObject("ADODB.Recordset");// Build the connection string
//
// ConnectionString Format below:
//ConnectionString = "DRIVER=SQL Server;SERVER=MySQLServer;CATALOG=MyDatabase;UID=USERID;PWD=Password";
//
// for SQL 7.0:
//ConnectionString = "DRIVER=SQL Server;SERVER=TopTen;CATALOG=TopTen;UID=TopTen;PWD=TopTen";
//
// for Access Database (on Server):
//ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=\\\\demwwwdev01\\develop\\im\\security\\TopTen.mdb";
//
// for Access Database (on local drive):
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\\TopTen\\TopTen.mdb";// Build a SQL statement
strSQL = "SELECT TopTenName, TopTenCount FROM TopTen ORDER BY TopTenCount DESC";// Open the recordset
rsTopTen.Open(strSQL, ConnectionString, 3,1,1);// Set variable
var nCounter
nCounter = 0;// Loop through the Recordset
while(!rsTopTen.EOF)
{
....
}