导入到数据库 Function RegulateStr(aString:String;Sepchar:String):String; var i,Num:Integer; Flag:Boolean; MyStr,TempStr:String; begin Flag:=False; Num:=Length(aString); for i:=1 to Num do begin TempStr:=Copy(aString,i,1); if TempStr<>SepChar then begin MyStr:=MyStr+TempStr; Flag:=True; end else if Flag=True then begin MyStr:=MyStr+TempStr; Flag:=False; end; end; if Mystr[Length(MyStr)]<>SepChar then begin MyStr:=MyStr+SepChar; RegulateStr:=MyStr; end; end;
procedure Tdaoru.Button1Click(Sender:TObject); const space=' '; var i,j,Num:integer; myline,szValue:string; begin if opendialog1.Execute=true then begin begin richedit1.clear; richedit1.Lines.LoadFromFile(opendialog1.FileName); end; begin table1.Open; for i:=0 to richedit1.lines.count-1 do begin table1.Append; Num:=0; myline:=regulatestr(richedit1.lines[i],space); j:=pos(space,myline); while j>0 do begin szValue:=copy(myline,1,j-1); table1.Fields[Num].asstring:=szValue; inc(Num); delete(myline,1,j); j:=pos(space,myline); end; end; end; table1.Post; showmessage('导入成功!') end else showmessage('您还没有选择导入的文档!'); end;
导出到文本 procedure TForm2.Button5Click(Sender: TObject); var st:TStrings; myline:string; i:Integer; begin if savedialog1.Execute=true then begin st:=TStringList.Create; datamodule9.Query1.First; while not datamodule9.Query1.Eof do begin myline:=datamodule9.Query1.Fields[0].AsString; for i:=1 to datamodule9.Query1.FieldCount-1 do myline:=myline+' '+datamodule9.Query1.Fields[i].AsString; st.add(myline); datamodule9.Query1.Next; end; st.SaveToFile(savedialog1.FileName); st.Free; showmessage('导出成功!'); end else showmessage('请选择要导出的文档名!'); end;