AppML .NET
如果您有 .NET 伺服器訪問許可權，請按照以下說明建立一個 AppML 伺服器應用程式。
建立測試頁面
建立一個測試頁面，並將其儲存在您的 PHP 伺服器上，檔名為 customers.htm（或任何您喜歡的名稱）。
customers.htm
<!DOCTYPE html>
<html lang="en">
<title>客戶</title>
<link rel="stylesheet" href="https://w3schools.tw/w3css/4/w3.css">
<script src="https://w3schools.tw/appml/2.0.3/appml.js"></script>
<body>
<div class="w3-container" appml-data="customers">
<h1>客戶</h1>
<table class="w3-table-all">
<tr>
<th>客戶</th>
<th>城市</th>
<th>國家</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":"México D.F.","Country":"Mexico"},
{"CustomerName":"Antonio Moreno Taquería","City":"México D.F.","Country":"Mexico"},
{"CustomerName":"Around the Horn","City":"London","Country":"UK"},
{"CustomerName":"B's Beverages","City":"London","Country":"UK"},
{"CustomerName":"Berglunds snabbköp","City":"Luleå","Country":"Sweden"},
{"CustomerName":"Blauer See Delikatessen","City":"Mannheim","Country":"Germany"},
{"CustomerName":"Blondel père et fils","City":"Strasbourg","Country":"France"},
{"CustomerName":"Bólido 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":"México D.F.","Country":"Mexico"},
{"CustomerName":"Chop-suey Chinese","City":"Bern","Country":"Switzerland"},
{"CustomerName":"Comércio Mineiro","City":"São Paulo","Country":"Brazil"}
]};
</script>
</body>
</html>
自己試試 »
在瀏覽器中測試網頁。
建立資料庫連線
如果您有 SQL Server 資料庫或任何其他 OLEDB 資料庫（如 MS Access）的訪問許可權，請定義資料庫連線，並將其儲存在伺服器上，檔名為 **appml_config.aspx**
appml_config.aspx (SQL Server 示例)
<%
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 示例)
<%
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 Access |
| provider | 資料庫軟體的驅動程式/提供程式 |
| host | 資料庫的 IP 地址或主機名 |
| dbname | 資料庫名稱 |
| username | 資料庫使用者名稱 |
| password | 資料庫密碼 |
複製 AppML
下載檔案：https://w3schools.tw/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\")"
]
}}
建立一個 **HTML 頁面** 來執行 create_customers.js 模型
create_customers.htm
<!DOCTYPE html>
<html>
<script src="https://w3schools.tw/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>客戶</title>
<link rel="stylesheet" href="https://w3schools.tw/w3css/4/w3.css">
<script src="https://w3schools.tw/appml/2.0.3/appml.js"></script>
<body>
<div class="w3-container" appml-data="appml.aspx?model=model_customers">
<h1>客戶</h1>
<table class="w3-table-all">
<tr>
<th>客戶</th>
<th>城市</th>
<th>國家</th>
</tr>
<tr appml-repeat="records">
<td>{{CustomerName}}</td>
<td>{{City}}</td>
<td>{{Country}}</td>
</tr>
</table>
</div>
</body>
</html>
自己試試 »
在瀏覽器中執行 HTML。
