1. Database link
int cppdatebase::D atabaseconnect (sBit8 *uname,sbit8 *pword,sbit8 *dbname)
{
Dbhandle = Mysql_init (NULL);
if (NULL = = Dbhandle)
{
cout<< "MySQL init error!" <<endl;
Return (-1);
}
if (NULL = = Mysql_real_connect (dbhandle, "localhost", uname,pword,dbname,0,null,0))
{
cout<< "Connect error!" <<endl;
Return (-1);
}
Mysql_set_character_set (Dbhandle, "UTF8");
return 0;
}
2, database insertion--increase
int cppdatebase::D atabaseinsert (const char *cmd)
{
if (NULL = = cmd)
{
cout<< "[insert] cmd error" <<endl;
Return (-1);
}
int ret = mysql_query (dbhandle,cmd);
if (ret!=0)
{
cout << "Database Insert info:exist, I am updata." <<endl<<endl;
Return (-1);
}
return 0;
}
3, database deletion--delete
int cppdatebase::D atabasedelete (const char *cmd)
{
if (NULL = = cmd)
{
cout<< "[Delete] cmd error" <<endl;
Return (-1);
}
int ret = mysql_query (dbhandle,cmd);
if (ret!=0)
{
cout << "Database Delete info:not exist." <<endl<<endl;
Return (-1);
}
return 0;
}
4, database update--Change
int cppdatebase::D atabaseupdate (const char *cmd)
{
if (NULL = = cmd)
{
cout<< "[UPDATE] cmd error" <<endl;
Return (-1);
}
int ret = mysql_query (dbhandle,cmd);
if (ret!=0)
{
cout << "Database Update info:not exist, I am insert." <<endl<<endl;
Return (-1);
}
return 0;
}
5, database query-check
int cppdatebase::D atabasequery (char *cmd, char **row)
{
if (NULL = = cmd | | NULL = = row)
{
cout<< "[query] cmd error" <<endl;
Return (-1);
}
Mysql_real_query (Dbhandle,cmd,strlen (cmd));
Mysql_res *result = Mysql_store_result (Dbhandle);
if (Result! = NULL)
{
int numline = mysql_num_rows (result);
int numlist = Mysql_num_fields (result);
}
Else
{
cout<< "[query] Mysql_store_result Error!" <<endl;
Return (-1);
}
while (row = mysql_fetch_row (result)))
{
printf ("%s,%s%s%s\n", row[0],row[1],row[2],row[3]);
}
Mysql_free_result (result);
return 0;
}
6. Database Disconnect
int cppdatebase::D atabaseclose ()
{
Mysql_close (Dbhandle);
return 0;
}