<CFQUERY NAME= "abc" DATASOURCE= "employee">
SELECT * FROM employee_info
</CFQUERY>
<html>
<head>
<title>职员工资表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="50%" border="1" bordercolor="#000000">
<tr>
<td>编号</td>
<td>职员姓名</td>
<td>工资</td>
</tr>
<CFOUTPUT QUERY= "abc">
<tr>
<td>#employee_id#</td>
<td>#employee_name#</td>
<td>#employee_salary#</td>
</tr>
</cfoutput>
</table>
</body>
</html>
显示为以下情况
编号 | 职员姓名 | 工资 |
1 | 王老虎 | 2000 |
2 | 周星驰 | 2500 |
3 | 张三丰 |