db.dws

来自「script language」· DWS 代码 · 共 43 行

DWS
43
字号
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<LINK REL="stylesheet" HREF="/styles/web.css" TYPE="text/css">
<title>Database Demonstration</title>
</head>

<body>
<h1>Database Demonstration</h1>
<%

var
  Query: TQuery;
var i: Integer;  

Query := TQuery.Create('DbDemos', 'select * from Customer');

Query.First;


Send('<table>');
Send('<tr>');
  for i := 0 to Query.FieldCount -1 do
    Send('<td>' + Query.DisplayName(i) + '</td>');
Send('<tr>');
while not Query.Eof do
begin
  Send('<tr>');
  for i := 0 to Query.FieldCount -1 do
    Send('<td>'+Query.FieldValue(i)+'</td>');
  SendLn('</tr>');
  Query.Next;
end;
Send('</table>');

//TQuery.Execute('DbDemos', 'insert into Customer (CustNo, Company) values (2000, ''IBM'')');

%>
</body
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?