W3.JS W3Data
什么是 W3Data?
W3Data 是一个将服务器数据引入 HTML 应用程序的工具。
W3Data 的目的是为 w3.js 提供来自 Web 服务器的数据。
应用程序模型
W3Data 使用 应用程序模型(以 JSON 格式编写)来描述服务器应用程序。
这个简单的模型描述了一个从 数据库 获取数据的完整应用程序
model_customers.js
{
"database" : {
"connection" : "localmysql",
"sql" : "SELECT * FROM Customers"}
}
模型存储在服务器上,Web 用户无法编辑。
您必须是服务器管理员或被授予编辑服务器上文件的权限的用户。
使用应用程序模型很简单,只需在调用 w3Http() 时将模型名称添加到 w3data.php 中。
示例
<script>
w3.getHttpObject("w3data.php?model=model_customers", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
亲自尝试 »
从文本文件显示
示例
<script>
w3.getHttpObject("w3data.php?model=model_cd_from_txt", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
亲自尝试 »
这是应用程序中使用的模型
model_cd_from_txt
{
"data" : {
"type" : "csvfile",
"filename" : "cd_catalog.txt",
"items" : [
{"name" : "title", "index" : 1},
{"name" : "artist", "index" : 2},
{"name" : "price", "index" : 5}
]
}
}
这是逗号分隔的文本文件
cd_catalog.txt
Empire Burlesque,Bob Dylan,USA,Columbia,10.90,1985
Hide your heart,Bonnie Tyler,UK,CBS Records,9.90,1988
Greatest Hits,Dolly Parton,USA,RCA,9.90,1982
Still got the blues,Gary Moore,UK,Virgin records,10.20,1990
Eros,Eros Ramazzotti,EU,BMG,9.90,1997
One night only,Bee Gees,UK,Polydor,10.90,1998
Sylvias Mother,Dr.Hook,UK,CBS,8.10,1973
Maggie May,Rod Stewart,UK,Pickwick,8.50,1990
从 JSON 文件显示
示例
<script>
w3.getHttpObject("w3data.php?model=model_cd_from_json", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
亲自尝试 »
这是应用程序中使用的模型
model_cd_from_json.js
{
"data" : {
"type" : "jsonfile",
"filename" : "cd_catalog.js",
"record" : "cd"
"items" : [
{"name" : "title", "nodename" : "title"},
{"name" : "artist", "nodename" : "artist"},
{"name" : "price", "nodename" : "price"}
]
}
}
这是 JSON 文件
cd_catalog.js
{
"cd" : [
{ "title" : "Empire Burlesque", "artist" : "Bob Dylan", "price" : "10.90" },
{ "title" : "Hide your heart", "artist" : "Bonnie Tyler", "price" : "9.90" },
{ "title" : "Greatest Hits", "artist" : "Dolly Parton", "price" : "9.90" },
{ "title" : "Still got the blues", "artist" : "Gary Moore", "price" : "10.20" },
{ "title" : "Eros", "artist" : "Eros Ramazzotti", "price" : "9.90" },
{ "title" : "One night only", "artist" : "Bee Gees", "price" : "10.90" },
{ "title" : "Sylvias Mother", "artist" : "Dr.Hook", "price" : "8.10" }
]
}
从 XML 文件显示
示例
<script>
w3.getHttpObject("w3data.php?model=model_cd_from_xml", myFunction);
function myFunction(myObject) {
w3.displayObject("id01", myObject);
}
</script>
亲自尝试 »
这是应用程序中使用的模型
model_cd_from_xml
{
"data" : {
"type" : "xmlfile",
"filename" : "cd_catalog.xml",
"record" : "CD",
"items" : [
{"name" : "artist", "nodename" : "ARTIST"},
{"name" : "title", "nodename" : "TITLE"},
{"name" : "country", "nodename" : "COUNTRY"}
]
}
}
这是 XML 文件
cd_catalog.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<PUBLISHED>1985</PUBLISHED>
</CD>
<CD>
<TITLE>Hide your heart</TITLE>
<ARTIST>Bonnie Tyler</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS Records</COMPANY>
<PRICE>9.90</PRICE>
<PUBLISHED>1988</PUBLISHED>
</CD>
<CD>
<TITLE>Greatest Hits</TITLE>
<ARTIST>Dolly Parton</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>RCA</COMPANY>
<PRICE>9.90</PRICE>
<PUBLISHED>1982</PUBLISHED>
</CD>
<CD>
<TITLE>Still got the blues</TITLE>
<ARTIST>Gary Moore</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>Virgin records</COMPANY>
<PRICE>10.20</PRICE>
<PUBLISHED>1990</PUBLISHED>
</CD>
<CD>
<TITLE>Eros</TITLE>
<ARTIST>Eros Ramazzotti</ARTIST>
<COUNTRY>EU</COUNTRY>
<COMPANY>BMG</COMPANY>
<PRICE>9.90</PRICE>
<PUBLISHED>1997</PUBLISHED>
</CD>
<CD>
<TITLE>One night only</TITLE>
<ARTIST>Bee Gees</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>Polydor</COMPANY>
<PRICE>10.90</PRICE>
<PUBLISHED>1998</PUBLISHED>
</CD>
<CD>
<TITLE>Sylvias Mother</TITLE>
<ARTIST>Dr.Hook</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS</COMPANY>
<PRICE>8.10</PRICE>
<PUBLISHED>1973</PUBLISHED>
</CD>
</CATALOG>
下载
下载文件: https://w3schools.org.cn/w3js/w3data.php.txt.
将文件复制到您的网站并将其重命名为 w3data.php。