mysql.zip_builder mysql_easy _mysql builder

//--------------------------------------------------------------------------- #include <vcl.h> #pragma hdrstop #include "Unit1.h" #include <vcl.h> #pragma hdrstop #include <winsock2.h> #include <mysql/mysql.h> //--------------------------------------------------------------------------- #pragma package(smart_init) #pragma resource "*.dfm" TForm1 *Form1; //--------------------------------------------------------------------------- __fastcall TForm1::TForm1(TComponent* Owner) : TForm(Owner) { } //--------------------------------------------------------------------------- void TForm1::showContents(MYSQL *handle,const char *tbl) { MYSQL_RES *res=NULL; // result of sql query MYSQL_ROW row; // row char sql[1024], // sql query commastr[2]; // commas separate to view corectly text int i,numf=0; // number of columns String tempo_tbl;/*table temp*/ String tempo_resultado; char tabla[60];for(int i=0;i<60;i++){tabla[i]=0x00;} tempo_tbl=tbl; /*create sql query*/ strcpy(tabla,"select * from "); strcpy(tabla+14,Edit6->Text.c_str()); strcpy(sql,tabla); if (!mysql_query(handle,sql))/*execute query*/ { res = mysql_use_result(handle);/*retrieve results*/ if (res) { numf = mysql_num_fields(res);/*number of collumns*/ row = mysql_fetch_row(res);/*number of rows*/ while (row) { commastr[0]=commastr[1]=(char)NULL;/*init comma, separate values by comma*/ for (i=0;i<numf;i++) { if (row[i] == NULL) { tempo_resultado=tempo_resultado+commastr; } else { tempo_resultado=tempo_resultado+commastr+row[i]; } commastr[0]=','; } this->lbxResultados->Items->Add(tempo_resultado);/*add formatted values String */ row = mysql_fetch_row(res); } mysql_free_result(res);/*free */ } else { ShowMessage("No se ha podido mostrar el resultado"); } } else { ShowMessage("No se ha podido ejecutar la sentencia"); } return; } void __fastcall TForm1::Button1Click(TObject *Sender) { MYSQL *hnd=NULL; // connection MySQL const char *sinf=NULL; // server info MySQL String tempo_sinf; char SERVER_NAME[60]; char DB_USER[60]; char DB_USERPASS[60]; char DB_NAME[60]; char TABLE_OF_INTEREST[60]; char PORT[60]; for(int i=0;i<60;i++){ SERVER_NAME[i]=0x00; DB_USER[i] =0x00; DB_USERPASS[i]=0x00; DB_NAME[i]=0x00; TABLE_OF_INTEREST[i] =0x00; PORT[i]=0x00; } /*copy from form values*/ strcpy(SERVER_NAME,Edit1->Text.c_str()); strcpy(DB_USER,Edit2->Text.c_str()); strcpy(PORT,Edit3->Text.c_str()); strcpy(DB_USERPASS,Edit4->Text.c_str()); strcpy(DB_NAME,Edit5->Text.c_str()); strcpy(TABLE_OF_INTEREST,Edit6->Text.c_str()); hnd = mysql_init(NULL);/*init conection manager */ /*create connection*/ if (NULL == mysql_real_connect(hnd,SERVER_NAME,DB_USER,DB_USERPASS,DB_NAME,0,NULL,0)) { ShowMessage( mysql_error(hnd) );/*on error*/ } else { ShowMessage("Conection is OK"); sinf = mysql_get_server_info(hnd);/*get server info*/ if (sinf != NULL) { showContents(hnd,TABLE_OF_INTEREST);/*shown content of table*/ } else { ShowMessage("Error getting server info"); ShowMessage( mysql_error(hnd) ); } mysql_close(hnd);/*close connection manager and free*/ } } //---------------------------------------------------------------------------