c++builder 做程序,真是太好用了。高版本的装起来看看。还是6.0的版本,简单好用。以后就用c++builder 做界面了。
真是方便 啊。
这里写个sqlite3的操作方法
//---------------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop
#include "sqlite3.h"
#pragma comment(lib,"sqlite3.lib")
#include "Unit1.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
: TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TForm1::btn1Click(TObject *Sender)
{
//
int ret = 0 ;
String sql = "select * From book where id > 0 ";
sqlite3* db ;
String strName;
ret = sqlite3_open("d:\\user.db",&db) ;
sqlite3_stmt* stmt = 0;
int ncolumn = 0;
ret = sqlite3_prepare(db, sql.c_str(), -1, &stmt, 0);
ncolumn = sqlite3_column_count(stmt);
while (sqlite3_step(stmt) == SQLITE_ROW)
{
strName = Utf8ToAnsi((char*)sqlite3_column_text(stmt,4));
// strName = Utf8ToAnsi(strName) ;
ListBox1->Items->Add(strName.c_str());
}
ret = sqlite3_finalize(stmt) ;
sqlite3_close(db);
}
//---------------------------------------------------------------------------