delphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²é

ÇódelphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó

---

ÓÃASqlite3Query,ÉèÖÃËûµÄconnectionΪASqlite3DB
ASqlite3Query.Sql.text := 'insert into ....';
ASqlite3Query.Execsql;

---

sqlstr:='insert into student_test(id,username,telephone,address,state) values(:id,:username,:telephone,:address,:state)';                                            dm.ASQLite3Query1id.Value:=Trim(id_edit.Text);
  dm.ASQLite3Query1username.Value:=Trim(username_edit.Text);
  dm.ASQLite3Query1telephone.Value:=Trim(phone_edit.Text);
  dm.ASQLite3Query1address.Value:=Trim(address_edit.Text);
  dm.ASQLite3Query1state.Value:=Trim(state_edit.Text);
  dm.ASQLite3Query1.ExecSQL;
  dm.ASQLite3Query1.Close;
  dm.ASQLite3Query1.SQL.Clear;
  dm.ASQLite3Query1.SQL.Text:='select * from student_test';   
  dm.ASQLite3Query1.Open;
end;


ÎÒÕâÑùдΪʲô²»ÐÐÄØ

---

Â¥Ö÷¿ÉÒÔÊÔÊÔÕâ¸ö£º
http://www.itwriting.com/blog/a-simple-delphi-wrapper-for-sqlite-3

¼òµ¥·½±ã

{{