procedure TWebModule1.WebModule1ActionItem1(Sender: TObject;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
var usernm,mail,url,city,previence,country:string;
memo:Tstringlist;
tst:string;
link:string;
hh:Tstringlist;
begin try
with ADOQ do
begin
usernm:=Request.QueryFields.Values['username'];
mail:=Request.QueryFields.Values['email'];
url:= Request.QueryFields.Values['url'];
city:=Request.QueryFields.Values['city'];
previence:=Request.QueryFields.Values['provience'];
country:=Request.QueryFields.Values['country'];
memo:=TStringlist.Create;
hh:= TStringlist.Create;
memo.Add(Request.QueryFields.Values['comments']);
ADOq.SQL.Clear;
tst:= 'insert into lyb values("'+usernm+'","'+mail+'","'+url+'","'+city+'","'+previence+'","'+country+'","'+memo.Strings[0]+'")';
ADOQ.SQL.Add(tst);
ADoq.ExecSQL;
pageproducer1.HTMLDoc.Clear;
hh.Clear;
hh.LoadFromFile('upper.txt');
pageproducer1.HTMLDoc.AddStrings(hh);
if url<>'http://' then link:=' <a href='+url+'>'+url+'</a>';
pageproducer1.HTMLDoc.Add(usernm+' '+previence+city+'.'+country+' <a href=mailto:"'+mail+'">'+mail+'</a>'+link+'<hr> <p>'+memo.Strings[0]+'</p><hr> ');
hh.Clear;
hh.LoadFromFile('down.txt');
pageproducer1.HTMLDoc.AddStrings(hh);
response.Content:=pageproducer1.Content;
ADOQ.Active:=false; end;
except
on E:Exception do
Response.Content:='<p>保存记录失败,错误是:'+E.Message;
end;
end;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
var usernm,mail,url,city,previence,country:string;
memo:Tstringlist;
tst:string;
link:string;
hh:Tstringlist;
begin try
with ADOQ do
begin
usernm:=Request.QueryFields.Values['username'];
mail:=Request.QueryFields.Values['email'];
url:= Request.QueryFields.Values['url'];
city:=Request.QueryFields.Values['city'];
previence:=Request.QueryFields.Values['provience'];
country:=Request.QueryFields.Values['country'];
memo:=TStringlist.Create;
hh:= TStringlist.Create;
memo.Add(Request.QueryFields.Values['comments']);
ADOq.SQL.Clear;
tst:= 'insert into lyb values("'+usernm+'","'+mail+'","'+url+'","'+city+'","'+previence+'","'+country+'","'+memo.Strings[0]+'")';
ADOQ.SQL.Add(tst);
ADoq.ExecSQL;
pageproducer1.HTMLDoc.Clear;
hh.Clear;
hh.LoadFromFile('upper.txt');
pageproducer1.HTMLDoc.AddStrings(hh);
if url<>'http://' then link:=' <a href='+url+'>'+url+'</a>';
pageproducer1.HTMLDoc.Add(usernm+' '+previence+city+'.'+country+' <a href=mailto:"'+mail+'">'+mail+'</a>'+link+'<hr> <p>'+memo.Strings[0]+'</p><hr> ');
hh.Clear;
hh.LoadFromFile('down.txt');
pageproducer1.HTMLDoc.AddStrings(hh);
response.Content:=pageproducer1.Content;
ADOQ.Active:=false; end;
except
on E:Exception do
Response.Content:='<p>保存记录失败,错误是:'+E.Message;
end;
end;
JPeg:TJPegImage;
begin
JPeg := TJPegImage.Create;
With Table1 do
Begin
Try
If JPegOpenPictureDialog.Execute Then
Begin Jpeg.LoadFromFile(JPegOpenPictureDialog.FileName);
Edit;
FieldByName('FieldForPhoto').Assign(JPeg);
Post;
End;
Except
ShowMessage('无法打开该图像文件!');
End;
End;
Jpeg.Free;
miShowJPeg.Click;
inherited;
end;图片读取:
Var
Jpeg: TJPegImage;
BlobStream:TStream;
begin
JPeg := TJPegImage.Create;
Try
Begin
BlobStream := MusterDm.MusterTable.
CreateBlobStream(Table1.FieldByName('FieldForPhoto'),bmRead);
Image1.Picture.Assign(nil);
If BlobStream.Size <= 0 Then Exit;
JPeg.LoadFromStream(BlobStream);
Image1.Picture.Assign(JPeg);
End;
Except End;
inherited;
JPeg.Free;
end;