如果你有機會到.NET服務器，請按照下面的說明創建AppML服務器應用程序。
如果您沒有訪問到服務器，按照WebMatrix的說明 。
創建測試頁
創建測試頁，並保存你的PHP服務器customers.htm（或任何你喜歡）上：
customers.htm
<!DOCTYPE html>
<html lang="en">
<title>Customers</title>
<link rel="stylesheet" href=
"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="http://www.w3ii.com/appml/2.0.3/appml.js"></script>
<body>
<div class="container" appml-data="customers">
<h1>Customers</h1>
<table class="table table-striped table-bordered">
<tr>
<th>Customer</th>
<th>City</th>
<th>Country</th>
</tr>
<tr appml-repeat="records">
<td>{{CustomerName}}</td>
<td>{{City}} </td>
<td>{{Country}} </td>
</tr>
</table>
</div>
<script>
var customers = {
"records":[
{"CustomerName":"Alfreds Futterkiste","City":"Berlin","Country":"Germany"},
{"CustomerName":"Ana Trujillo Emparedados y helados","City":"Mexico D.F.","Country":"Mexico"},
{"CustomerName":"Antonio Moreno Taqueria","City":"Mexico D.F.","Country":"Mexico"},
{"CustomerName":"Around the Horn","City":"London","Country":"UK"},
{"CustomerName":"B's
Beverages","City":"London","Country":"UK"},
{"CustomerName":"Berglunds
snabbkop","City":"Lulea","Country":"Sweden"},
{"CustomerName":"Blauer See
Delikatessen","City":"Mannheim","Country":"Germany"},
{"CustomerName":"Blondel
pere et fils","City":"Strasbourg","Country":"France"},
{"CustomerName":"Bolido
Comidas preparadas","City":"Madrid","Country":"Spain"},
{"CustomerName":"Bon
app'","City":"Marseille","Country":"France"},
{"CustomerName":"Bottom-Dollar
Marketse","City":"Tsawassen","Country":"Canada"},
{"CustomerName":"Cactus
Comidas para llevar","City":"Buenos Aires","Country":"Argentina"},
{"CustomerName":"Centro
comercial Moctezuma","City":"Mexico D.F.","Country":"Mexico"},
{"CustomerName":"Chop-suey Chinese","City":"Bern","Country":"Switzerland"},
{"CustomerName":"Comercio Mineiro","City":"Sao Paulo","Country":"Brazil"}
]};
</script>
</body>
</html>
試一試» 在瀏覽器中測試網頁了。
創建數據庫連接
如果你有機會到一個SQL Server數據庫，或任何其他OLEDB數據庫(like MS Acess)定義的數據庫連接，並保存在服務器上appml_config.aspx：
appml_config.aspx (SQL Server Example)
<%
Response.write("Access Forbidden")
Response.end
%>
{
"dateformat"
: "yyyy-mm-dd",
"databases" : [{
"connection" : "mydatabase",
"provider" : "SQLOLEDB",
"host" : "myserver",
"dbname"
: "DemoDB",
"username" : "DemoDBUkbn5",
"password"
: " l6|U6=V(*T+P "
}]
}appml_config.aspx (MS Access Example)
<%
Response.write("Access Forbidden")
Response.end
%>
{
"dateformat"
: "yyyy-mm-dd",
"databases" : [
{
"connection" : "mydatabase",
"connectionstring"
:
"Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\database\\Northwind.mdb"
}
}上面的連接是不是真實的。 名和密碼的例子。
配置文件說明：
| 屬性 | 描述 |
|---|---|
| dateformat | 你會在你的模型使用的日期格式 |
| connection | 連接名稱，你會在你的模型使用 |
| connectionstring | 通常用於在OLEDB驅動器，如MS訪問 |
| provider | DB軟件的驅動程序/提供 |
| host | 數據庫的IP或主機名 |
| dbname | 數據庫名稱 |
| username | 數據庫用戶名 |
| password | 數據庫密碼 |
複製AppML
下載文件： http://www.w3ii.com/appml/2.0.3/appml.aspx.txt 。
將文件複製到你的網站。 它重命名為appml.aspx。
創建數據庫表
在數據庫中創建Customers表創建一個模型 。
create_customers.js
{
"database" : {
"connection" : "mydatabase",
"execute" : [
"DROP
TABLE IF EXISTS Customers",
"CREATE TABLE IF NOT EXISTS Customers (CustomerID
INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,(CustomerID),CustomerName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City
NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255))",
"INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\"Alfreds Futterkiste\",\"Maria Anders\",\"Obere Str.
57\",\"Berlin\",\"12209\",\"Germany\")",
"INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\"Around the Horn\",\"Thomas Hardy\",\"120 Hanover
Sq.\",\"London\",\"WA1 1DP\",\"UK\")",
"INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\"Blauer See Delikatessen\",\"Hanna Moos\",\"Forsterstr.
57\",\"Mannheim\",\"68306\",\"Germany\")"
]
}}用於運行create_customers.js模型創建HTML頁面 ：
create_customers.htm
<!DOCTYPE html>
<html>
<script src="http://www.w3ii.com/appml/2.0.3/appml.js"></script>
<body>
<div appml-data="appml.aspx?model=create_customers"></div>
</body>
</html>在瀏覽器中運行的HTML頁面。
創建應用程序
為客戶創造應用的典範 。 它保存為customers.js：
customers.js
{
"rowsperpage" : 10,
"database" : {
"connection" : "mydatabase",
"sql" : "SELECT * FROM Customers",
"orderby" : "CustomerName"
}
}用於運行應用程序的客戶創建一個HTML頁面 ：
customers.htm
<!DOCTYPE html>
<html lang="en">
<title>Customers</title>
<link rel="stylesheet" href=
"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="http://www.w3ii.com/appml/2.0.3/appml.js"></script>
<body>
<div class="container" appml-data="appml.aspx?model=customers">
<h1>Customers</h1>
<table class="table table-striped table-bordered">
<tr>
<th>Customer</th>
<th>City</th>
<th>Country</th>
</tr>
<tr appml-repeat="records">
<td>{{CustomerName}}</td>
<td>{{City}}</td>
<td>{{Country}}</td>
</tr>
</table>
</div>
</body>
</html>
試一試» 運行在瀏覽器的HTML。