Test Mysql
Dependencies: mbed MySQLClient EthernetNetIf
Diff: MySQLClientExample.cpp
- Revision:
- 0:82effba6633e
- Child:
- 3:ab8a9d84da07
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/MySQLClientExample.cpp Tue Jun 15 16:24:56 2010 +0000 @@ -0,0 +1,71 @@ +#include "mbed.h" +#include "EthernetNetIf.h" +#include "MySQLClient.h" + +#define SQL_SERVER "" +#define SQL_USER "" +#define SQL_PASSWORD "" +#define SQL_DB "" + +EthernetNetIf eth; +MySQLClient sql; + +MySQLResult sqlLastResult; +void onMySQLResult(MySQLResult r) +{ + sqlLastResult = r; +} + +int main() +{ + printf("Start\n"); + + printf("Setting up...\n"); + EthernetErr ethErr = eth.setup(); + if(ethErr) + { + printf("Error %d in setup.\n", ethErr); + return -1; + } + printf("Setup OK\n"); + + Host host(IpAddr(), 3306, SQL_SERVER); + + //Connect + sqlLastResult = sql.open(host, SQL_USER, SQL_PASSWORD, SQL_DB, onMySQLResult); + while(sqlLastResult == MYSQL_PROCESSING) + { + Net::poll(); + } + if(sqlLastResult != MYSQL_OK) + { + printf("Error %d during connection\n", sqlLastResult); + } + + //SQL Command + //Make command + char cmd[128] = {0}; + const char* msg="Hello World!"; + sprintf(cmd, "INSERT INTO Test (Test) VALUES('%s')", msg); + + //INSERT INTO DB + string cmdStr = string(cmd); + sqlLastResult = sql.sql(cmdStr); + while(sqlLastResult == MYSQL_PROCESSING) + { + Net::poll(); + } + if(sqlLastResult != MYSQL_OK) + { + printf("Error %d during SQL Command\n", sqlLastResult); + } + + sql.exit(); + + while(1) + { + + } + + return 0; +} \ No newline at end of file