1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
//---------------------------------------------------------------------------
#define __WIN__
#include <vcl.h>
#pragma hdrstop
#include "Unit1.h"
#include "include/mysql.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
MYSQL *mySQL;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
: TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TForm1::Button1Click(TObject *Sender)
{
mySQL = mysql_init(NULL);
if (!mysql_real_connect(mySQL, "127.0.0.1", "tonlogin", "tonpassword", "tabasededonne", 0, NULL, 0))
{
Application->MessageBox("Tu peux te brosser","Ca arrive pas a se connecter",MB_OK);
// la connection a échoué
}
else
{
// la connection a réussi
Application->MessageBox("Ouvre la bouteille ca marche","T'es connecte ",MB_OK);
MYSQL_ROW myROW;
MYSQL_RES *myRES;
AnsiString aStr;
myRES = mysql_list_tables(mySQL, NULL);
if (myRES)
{
for(unsigned int i = 0; i < myRES->row_count; i++)
{
myROW = mysql_fetch_row(myRES);
for(unsigned int j = 0; j < mysql_num_fields(myRES); j++)
{
aStr.sprintf("%s", myROW[j]);
ListBox1->Items->Add(aStr);
}
}
mysql_free_result(myRES);
}
mysql_close(mySQL);
}
}
//--------------------------------------------------------------------------- |
Partager