浏览器直接连接mysql_如何从浏览器中的JavaScript连接到SQL Server数据库？

jvaEnjoy coding提出了一个问题：How to connect to SQL Server database from JavaScript in the browser?，或许与您遇到的问题类似。

回答者fbinder给出了该问题的处理方式：

You shouldn´t use client javascript to access databases for several reasons (bad practice, security issues, etc) but if you really want to do this, here is an example:

var connection = new ActiveXObject("ADODB.Connection") ;

var connectionstring="Data Source=;Initial Catalog=;User ID=;Password=;Provider=SQLOLEDB";

connection.Open(connectionstring);

var rs = new ActiveXObject("ADODB.Recordset");

rs.Open("SELECT * FROM table", connection);

rs.MoveFirst

while(!rs.eof)

{

document.write(rs.fields(1));

rs.movenext;

}

rs.close;

connection.close;

A better way to connect to a sql server would be to use some server side language like PHP, Java, .NET, among others. Client javascript should be used only for the interfaces.

And there are rumors of an ancient legend about the existence of server javascript, but this is another story. ;)

希望本文对你有帮助，欢迎支持JavaScript中文网