自己通过编程把文本文件中的字符读出,然后用SQL语句加入到数据库中.
解决方案 »
- 如何判断 字符串中 包含有 unicode 字符
- 如何把actionlist中action的shortcut设置成+?
- fastreport怎么实现masterband具有页首的属性
- (100分)问一个Delphi字符编码的转换的问题
- dspack怎么播放影片指定的区域?
- delphi中的时间怎么做加减呀?
- 如何模拟鼠标
- 征集围棋游戏(网络对攻,人对电脑)的方案,算法,策略(0.2)
- 请教,三层架构简单问题,谢谢
- 如何Install Shield Express做数据库程序客户端安装程序?
- 如何把数据库中的数据导入特定格式的Word文当中,特急,来者有分数。给100分!!!!!!!!!!!
- 关于在向固定格式的Word模版中导入数据的问题,急!!!!!!!!!!!!!!!
procedure TForm1.Button3Click(Sender: TObject);
var fstrm: TFileStream;
p: Pointer;
begin
fstrm := TFileStream.Create('h:\AA.txt',fmOpenRead);
GetMem(p,fstrm.Size);
fstrm.ReadBuffer(p^,fstrm.Size);
Table1.Edit;
Table1.FieldByName('Luo').SetData(p);
Table1.Post;
FreeMem(p);
end;
—————————————————————————————————
MaximStr := '宠辱不惊,看庭前花开花落,去留无意;
毁誉由人,望天上云卷云舒,聚散任风。';
if Not Assigned(I) then
I := TI.Create(Nil);
I.Maxim := MaximStr;
I.Explain := '假如上述代码中出现“OA”等字样,删除它们';
I.Desire := '加不加分随你';
—————————————————————————————————
FreeAndNil(fstrm);
—————————————————————————————————
MaximStr := '宠辱不惊,看庭前花开花落,去留无意;
毁誉由人,望天上云卷云舒,聚散任风。';
if Not Assigned(I) then
I := TI.Create(Nil);
I.Maxim := MaximStr;
I.Explain := '假如上述代码中出现“OA”等字样,删除它们';
I.Desire := '加不加分随你';
—————————————————————————————————
import java.awt.print.*;
import java.util.*;
import java.awt.geom.*;
import javax.swing.*;
public class drawOut implements Printable
{
Vector objects=new Vector();
String str;
public drawOut(Vector v,String strAction)
{
objects=v;
str=strAction;
}
public int print(Graphics g,PageFormat pf,int page)throws PrinterException
{
Graphics2D g2=(Graphics2D)g;
g2.setPaint(Color.black);
g2.translate(pf.getImageableX(),pf.getImageableY());
if (str.equals("Preview"))drawCropMarks(g2,pf);
g2.clip(new Rectangle2D.Double(0,0,pf.getImageableWidth(),pf.getImageableHeight()));
g2.translate(0,-page*pf.getImageableHeight());
int pages=getPageCount(g2,pf);
return (page>=pages)?Printable.NO_SUCH_PAGE:Printable.PAGE_EXISTS;
}
public int getPageCount(Graphics2D g2,PageFormat pf)
{
if (objects.size()==0)return 0;
printerObject p;
Point pt=new Point(0,0);
for(int i=0;i<objects.size();i++)
{
p=(printerObject)objects.elementAt(i);
p.draw(g2,pt);
}
int height=pt.y;
return (int)Math.ceil(height/pf.getImageableHeight());
}
public void drawCropMarks(Graphics2D g2,PageFormat pf)
{
final double c=36;
double w=pf.getImageableWidth(),
h=pf.getImageableHeight();
g2.draw(new Line2D.Double (0,0,0,c));
g2.draw(new Line2D.Double (0,0,c,0));
g2.draw(new Line2D.Double (w,0,w,c));
g2.draw(new Line2D.Double (w,0,w-c,0));
g2.draw(new Line2D.Double (0,h,0,h-c));
g2.draw(new Line2D.Double (0,h,c,h));
g2.draw(new Line2D.Double (w,h,w,h-c));
g2.draw(new Line2D.Double (w,h,w-c,h));
}
}//
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;public class PrintTest extends JFrame implements ActionListener
{
JButton bttPrint=new JButton("Print"),
bttExit=new JButton("Exit");
JDesktopPane desk=new JDesktopPane();
public PrintTest()
{
setSize(720,540);
desk.setLayout(null);
Container contentPane=getContentPane();
contentPane.add(desk);
bttPrint.setBounds(300,200,100,25);
bttExit.setBounds(300,250,100,25);
desk.add(bttPrint);
desk.add(bttExit);
bttPrint.addActionListener(this);
bttExit.addActionListener(this);
setResizable(false);
}
public void actionPerformed(ActionEvent e)
{
Object obj=e.getSource();
if (obj==bttPrint){
PrintExample1 p=new PrintExample1();
desk.add(p);
p.show();
}else System.exit(0);
}
public static void main(String []argv)
{
(new PrintTest()).show();
}
}
procedure GenerateSQLFile;
var
fText:TextFile;
fSQL:TextFile;
strLine:String;
iCount:Integer;
begin
AssignFile(fSQL,'E:\Test\Import.sql');
Rewrite(fSQL);
AssignFile(fText,'E:\Test\Test.txt');
Reset(fText);
while not Eof(fText) do
begin
readln(fText,strLine);
strLine:=Trim(strLine);
for iCount:=1 to Length(strLine) do
begin
if (' '=strLine[iCount])or(#9=strLine[iCount]) then
begin
break;
end;
end;
writeln(fSQL,'insert into test values("'+Copy(strLine,1,iCount-1)+'","'+Trim(Copy(strLine,iCount,Length(strLine)))+'");');
end;
CloseFile(fText);
CloseFile(fSQL);
end;