delphi学习SQL语句 - Insert、Update、Delete
来源:互联网 发布:qq农场魔法池守卫数据 编辑:程序博客网 时间:2024/04/29 23:12
unit Unit1;interfaceusesWindows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,Dialogs, StdCtrls, ExtCtrls, Grids, DBGrids, DB, ADODB;typeTForm1 = class(TForm)DBGrid1: TDBGrid;DataSource1: TDataSource;ADODataSet1: TADODataSet;ADOCommand1: TADOCommand;Panel1: TPanel;Button1: TButton;Button2: TButton;Button3: TButton;Button4: TButton;procedure FormCreate(Sender: TObject);procedure Button1Click(Sender: TObject);procedure Button4Click(Sender: TObject);procedure Button2Click(Sender: TObject);procedure Button3Click(Sender: TObject);end;varForm1: TForm1;implementation{$R *.dfm}//添加procedure TForm1.Button1Click(Sender: TObject);begintryADOCommand1.CommandText := 'INSERT INTO country VALUES("AAA", "BBB", "CCC", 111, 222)';ADOCommand1.Execute;ADOCommand1.CommandText :='INSERT INTO country(Name,Capital,Continent) VALUES("XXX", "YYY", "ZZZ")';ADOCommand1.Execute;except on E: Exception doShowMessage(E.Message);end;end;//更新procedure TForm1.Button2Click(Sender: TObject);beginADOCommand1.CommandText := 'UPDATE country SET Area=123,Population=456 WHERE Name="AAA"';ADOCommand1.Execute;ADOCommand1.CommandText := 'UPDATE country SET Capital="MMM" WHERE Capital="YYY"';ADOCommand1.Execute;end;//删除procedure TForm1.Button3Click(Sender: TObject);beginADOCommand1.CommandText := 'DELETE * From country WHERE Name="AAA"';ADOCommand1.Execute;ADOCommand1.CommandText := 'DELETE * From country WHERE Name="XXX"';ADOCommand1.Execute;end;//查看procedure TForm1.Button4Click(Sender: TObject);beginwith ADODataSet1 do beginClose;CommandText := 'SELECT * FROM country';Open;end;end;procedure TForm1.FormCreate(Sender: TObject);varmdbFile: string;begin{因要修改数据库, 特复制了一份}mdbFile := mdbFile + 'C:\Temp\dbdemos.mdb';ADODataSet1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' +mdbFile + ';Persist Security Info=False';ADOCommand1.ConnectionString := ADODataSet1.ConnectionString;DBGrid1.DataSource := DataSource1;DataSource1.DataSet := ADODataSet1;end;end.
0 0
- delphi学习SQL语句 - Insert、Update、Delete
- SQL学习—INSERT、UPDATE、DELETE语句
- SQL语句复习:insert,update,delete,select
- T-SQL Recipes------Insert, Update, Delete语句
- SQL语句复习:insert,update,delete,select
- LINQ to SQL语句之Insert/Update/Delete操作学习笔记
- MYSQL INSERT UPDATE DELETE 语句
- DML语句(delete,insert,update)
- SQL基本语句(Insert,Select,Update和Delete)
- LINQ to SQL 语句之Insert/Update/Delete 操作
- LINQ to SQL语句之Insert/Update/Delete操作
- SQL Server索引进阶第十三篇:Insert,Update,Delete语句
- LINQ to SQL语句之Insert/Update/Delete操作
- SQL Server索引进阶第十三篇:Insert,Update,Delete语句
- QtCreator Qt中执行SQL语句,select,update,delete,insert
- SQL SERVER insert/delete/update 中的 ouput语句
- mysql sql语句---增删改 insert、delete、update
- SQL基础查询语句(insert update delete)
- 蓝桥杯 结果填空 汉诺塔计数
- 正则表达式的学习二
- Aggressive cows
- 文件直接下载 (PHP代码函数)
- JAVA编程思想(第4版) toString()的用法小结
- delphi学习SQL语句 - Insert、Update、Delete
- python基础练习
- 修复MYSQL数据库 Monxin专用(PHP代码函数)
- 2014 蓝桥杯 预赛 c/c++ 本科B组 第三题:李白打酒【暴力】or【DFS】
- python遍历 truple list dictionary的几种方法
- C++ lambda表达式复习
- 优化MYSQL数据库 Monxin专用(PHP代码函数)
- 任务调度的 Java 实现方法
- 蓝桥杯 历届试题 城市建设 最小生成树