AngularJS SQL · AngularJs教程

AngularJS SQL

在前面章节中的代码也可以用于读取数据库中的数据。

使用 PHP 从 MySQL 中获取数据

AngularJS 实例

  

  
  
  
    
{{ x.Name }}
  
    
{{ x.Country }}
  
  
  
  

  

ASP.NET 中执行 SQL 获取数据

AngularJS 实例

  

  
  
  
    
{{ x.Name }}
  
    
{{ x.Country }}
  
  
  
  

  

PHP 读取 MySQL 数据代码

query("SELECt CompanyName, City, Country FROM Customers");  

$outp "[";  
while($rs = $result->fetch_array(MYSQLI_ASSOC)) {  
    if ($outp != "[") {$outp .= ",";}  
    $outp .= '{"Name":"'  . $rs["CompanyName"] . '",';  
    $outp .= '"City":"'   . $rs["City"]        . '",';  
    $outp .= '"Country":"'. $rs["Country"]     . '"}';  
}  
$outp .="]";  

$conn->close();  

echo($outp);  
?>

PHP 读取 MS Access 代码

open("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb");  

$rs = $conn->execute("SELECt CompanyName, City, Country FROM Customers");  

$outp = "[";  
while (!$rs->EOF) {  
    if ($outp != "[") {$outp .= ",";}  
    $outp .= '{"Name":"'  . $rs["CompanyName"] . '",';  
    $outp .= '"City":"'   . $rs["City"]        . '",';  
    $outp .= '"Country":"'. $rs["Country"]     . '"}';  
    $rs->MoveNext();  
}  
$outp .= "]";  

$conn->close();  

echo ($outp);  
?>

服务端 ASP.NET, VB 和 MS Access 代码

<%@ import Namespace="System.IO"%>  
<%@ import Namespace="System.Data"%>  
<%@ import Namespace="System.Data.OleDb"%>  
<%  
Response.AppendHeader("Access-Control-Allow-Origin", "*")  
Dim conn As OleDbConnection  
Dim objAdapter As OleDbDataAdapter  
Dim objTable As DataTable  
Dim objRow As DataRow  
Dim objDataSet As New DataSet()  
Dim outp  
Dim c  
conn = New OledbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=Northwind.mdb")  
objAdapter = New OledbDataAdapter("SELECt CompanyName, City, Country FROM Customers", conn)  
objAdapter.Fill(objDataSet, "myTable")  
objTable=objDataSet.Tables("myTable")  

outp = "["  
c = chr(34)  
for each x in objTable.Rows  
if outp <> "[" then outp = outp & ","  
outp = outp & "{" & c & "Name"    & c & ":" & c & x("CompanyName") & c & ","  
outp = outp &       c & "City"    & c & ":" & c & x("City")        & c & ","  
outp = outp &       c & "Country" & c & ":" & c & x("Country")     & c & "}"  
next  

outp = outp & "]"  
response.write(outp)  
conn.close  
%>

服务端 ASP.NET, VB Razor 和 SQL Lite 代码

@{  
Response.AppendHeader("Access-Control-Allow-Origin", "*")  
var db = Database.Open("Northwind");  
var query = db.Query("SELECt CompanyName, City, Country FROM Customers");  
var outp ="["  
}  
@foreach(var row in query)  
{  
if outp <> "[" then outp = outp + ","  
outp = outp + "{" + c + "Name"    + c + ":" + c + @row.CompanyName + c + ","  
outp = outp +       c + "City"    + c + ":" + c + @row.City        + c + ","  
outp = outp +       c + "Country" + c + ":" + c + @row.Country     + c + "}"  
}  
outp = outp + "]"  
@outp