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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
//---------------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop
#define __WIN__
#include "mysql.h"
#include "Unit1.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
: TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TForm1::testconnectionClick(TObject *Sender)
{
MYSQL *mySQL;
mySQL = mysql_init(NULL);
if (!mysql_real_connect(mySQL, "www.freesql.org", "cednieb", "123456", "cedtest",3306, NULL, 0))
{
Memo1->Clear();
Memo1->Lines->Add("echec");
// la connection a échoué
}
else
{
Memo1->Clear();
Memo1->Lines->Add("ok");
// la connection a réussi
}
mysql_close(mySQL);
}
//---------------------------------------------------------------------------
void __fastcall TForm1::listertableClick(TObject *Sender)
{
MYSQL *mySQL;
mySQL = mysql_init(NULL);
if (!mysql_real_connect(mySQL, "www.freesql.org", "cednieb", "123456", "cedtest",3306, NULL, 0))
{
Memo1->Clear();
Memo1->Lines->Add("echec");
// la connection a échoué
}
else
{
Memo1->Clear();
Memo1->Lines->Add("ok");
// la connection a réussi
}
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);
}
//---------------------------------------------------------------------------
void __fastcall TForm1::listerdonneesClick(TObject *Sender)
{
MYSQL *mySQL;
mySQL = mysql_init(NULL);
if (!mysql_real_connect(mySQL, "www.freesql.org", "cednieb", "123456", "cedtest",3306, NULL, 0))
{
Memo1->Clear();
Memo1->Lines->Add("echec");
// la connection a échoué
}
else
{
Memo1->Clear();
Memo1->Lines->Add("ok");
// la connection a réussi
}
MYSQL_ROW myROW;
MYSQL_RES *myRES;
AnsiString aStr;
if (!mysql_query(mySQL, "select * from test")) {
myRES = mysql_store_result(mySQL);
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 = myROW[j];
ListBox1->Items->Add(aStr);
}
}
mysql_free_result(myRES);
}
}
mysql_close(mySQL);
}
//--------------------------------------------------------------------------- |
