The <form> element is used to define your own layout of the input form. If this element is omitted, a default layout is used.
<form>元素是用于定义输入表单的布局的。如果忽略该元素,那么将使用一个默认的布局。
All legal HTML elements can be put inside the <form> element.
所有合法的HTML元素都可以写进<form>元素中。
To display the data stored in the database, add id attributes to the form fields that corresponds with the name of the data fields in the recordset (SQL).
为了显示存储在数据库中的数据,可以将id属性添加到与记录集中数据字段名称相一致的表但字段中。
Create form layout with HTML elements:
使用HTML元素创建表单布局:
Note: <table>, <tr>, <td>, <fieldset>, and <legend> (and their attributes) are all standard HTML elements.
注意:<table>、<tr>、<td>、<fieldset>和<legend>(以及它们包含的属性)都是标准的HTML元素。
<?xml version="1.0" ?> <appml> <title>Suppliers</title> <database> <connection>northwind</connection> <keyfield>supplierid</keyfield> <maintable>suppliers</maintable> <sql>SELECT CompanyName,ContactName,City FROM Suppliers</sql> </database> <htmllist /> <htmlform> <form> <table width="50%"> <tr> <td> <fieldset> <legend style="color:darkblue;">Supplier information</legend> <br/> <table> <tr> <td>Company</td> <td><input size='50' maxlength='40' id='companyname' /></td> </tr> <tr> <td>Contactname</td> <td><input size='50' maxlength='30' id='contactname' /></td> </tr> <tr> <td>City</td> <td><input size='50' maxlength='15' id='city' /></td> </tr> </table> </fieldset> </td> </tr> </table> </form> </htmlform> </appml> |
View the output produced by the AppML HTML List Service
查看由AppML HTML 报告服务输出的结果
View the XML source file
查看XML 源文件
Extract data from the record and add it to the legend:
从记录中释放数据并将其添加到Legend中:
<?xml version="1.0" ?> <appml> <title>Suppliers</title> <database> <connection>northwind</connection> <keyfield>supplierid</keyfield> <maintable>suppliers</maintable> <sql>SELECT CompanyName,ContactName,City FROM Suppliers</sql> </database> <htmllist /> <htmlform> <form> <table width="50%"> <tr> <td> <fieldset> <legend style="color:darkblue;"> Supplier information for <span id="span_companyname"></span> </legend> <br/> <table> <tr> <td>Company</td> <td><input size='50' maxlength='40' id='companyname' /></td> </tr> <tr> <td>Contactname</td> <td><input size='50' maxlength='30' id='contactname' /></td> </tr> <tr> <td>City</td> <td><input size='50' maxlength='15' id='city' /></td> </tr> </table> </fieldset> </td> </tr> </table> </form> </htmlform> </appml> |
View the output produced by the AppML HTML List Service
查看由AppML HTML 报告服务输出的结果
View the XML source file
查看XML 源文件
Create drop-down boxes from the data:
创建下拉框:
<?xml version="1.0" ?> <appml> <title>Products</title> <database> <connection>northwind</connection> <keyfield>productid</keyfield> <maintable>products</maintable> </database> <filters> <orderby>productname</orderby> </filters> <htmllist> <sql> SELECT products.productname AS Product, suppliers.companyname AS Supplier, categories.categoryname AS Category FROM ((Products LEFT JOIN suppliers ON products.supplierid=suppliers.supplierid) LEFT JOIN categories ON products.categoryid=categories.categoryid) </sql> </htmllist> <htmlform> <sql> SELECT productname,supplierid,categoryid, quantityperunit,unitprice FROM products </sql> <form> <table> <tr> <td>Product</td> <td><input size="40" maxlength="40" id="productname" /></td> </tr> <tr> <td>Category</td> <td> <field name="categoryid"> <function name="dbselect"> <sql>SELECT categoryid,categoryname FROM categories ORDER BY categoryname</sql> <value>categoryid</value> <options>categoryname</options> </function> </field> </td> </tr> <tr> <td>Supplier</td> <td> <field name="supplierid"> <function name="dbselect"> <sql>SELECT supplierid,companyname FROM suppliers ORDER BY companyname</sql> <value>supplierid</value> <options>companyname</options> </function> </field> </td> </tr> <tr> <td>Quantity per unit</td> <td><input size="40" maxlength="20" id="quantityperunit" /></td> </tr> <tr> <td>Unitprice</td> <td><input size="40" maxlength="8" id="unitprice" /></td> </tr> </table> </form> </htmlform> </appml> |
View the output produced by the AppML HTML List Service
查看由AppML HTML 报告服务输出的结果
View the XML source file
查看XML 源文件