如何使用javascript或html5与sqlserve 2012连接 [英] How to Connect with sqlserve 2012 using javascript or html5
本文介绍了如何使用javascript或html5与sqlserve 2012连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Hiii朋友,
请提供我使用javascript将php连接到sqlserver 2012的脚本或指南。我试过一个代码
Hiii friends,
Pls Provide me script or guide for connecting php to sqlserver 2012 using javascript. i have tried a code
<pre lang="xml"><!DOCTYPE html "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
<title>Database Connect</title>
<script type="text/javascript">
function loadDB(){
var connection = new ActiveXObject("ADODB.Connection");
var connectionstring="Data Source=(LocalDB)\v11.0;Initial Catalog=C:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQLEXPRESS\\MSSQL\\DATA\\demo;User ID=GAURAV\GAMER's;Password=\"\";Provider=SQLOLEDB";
connection.open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT demo_name FROM tbl_demo", connection);
rs.MoveFirst();
while(!rs.eof)
{
document.write(rs.fields(1));
rs.MoveNext();
}
rs.close();
connection.close();
}
</script>
</head>
<body onload="loadDB()">
<div id="main"></div>
</body>
</html>
这不能正常工作
this is not working properly
推荐答案
哇!
那太棒了!!!您正在编写C#代码,只需在其周围添加< script>< / script>
块即可!很棒的想法,但不幸的是现在开始工作(永远)。
Javascript运行客户端,不允许你建立这样的连接。 HTML是一种专为演示目的而设计的语言。但是语言不能(也永远不能)连接到数据库。
WOW!
That would be great!!! You're writing C# code and just add a<script></script>
block around it and done! Excellent idea, but unfortunately now going to work (ever).
Javascript runs client side and will not allow you to make such connections. HTML is a language designed for presentation purpose. But languages are not (and will never) be able to connect to a database.
这篇关于如何使用javascript或html5与sqlserve 2012连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文