Advertisement
Guest User

Untitled

a guest
Feb 26th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. #include <iostream>
  2. #include <string>
  3. #include <mysql.h>
  4.  
  5. using namespace std;
  6.  
  7. class Proc
  8. {
  9. const char* MY_HOSTNAME;
  10. const char* MY_DATABASE;
  11. const char* MY_USERNAME;
  12. const char* MY_PASSWORD;
  13. const char* MY_SOCKET;
  14. enum {
  15. MY_PORT_NO = 3306,
  16. MY_OPT = 0
  17. };
  18. MYSQL *conn;
  19. MYSQL_RES *res;
  20. MYSQL_ROW row;
  21.  
  22. public:
  23. Proc();
  24. bool execMain();
  25. };
  26.  
  27. Proc::Proc()
  28. {
  29. // Initialize constants
  30. MY_HOSTNAME = "localhost";
  31. MY_DATABASE = "mysql";
  32. MY_USERNAME = "root";
  33. MY_PASSWORD = "root";
  34. MY_SOCKET = NULL;
  35.  
  36. }
  37.  
  38. bool Proc::execMain()
  39. {
  40. try {
  41. // Format a MySQL object
  42. conn = mysql_init(NULL);
  43.  
  44. // Establish a MySQL connection
  45. if (!mysql_real_connect(
  46. conn,
  47. MY_HOSTNAME, MY_USERNAME,
  48. MY_PASSWORD, MY_DATABASE,
  49. MY_PORT_NO, MY_SOCKET, MY_OPT)) {
  50. cerr << mysql_error(conn) << endl;
  51. return false;
  52. }
  53.  
  54. // Execute a sql statement
  55. if (mysql_query(conn, "SHOW TABLES")) {
  56. cerr << mysql_error(conn) << endl;
  57. return false;
  58. }
  59.  
  60. // Get a result set
  61. res = mysql_use_result(conn);
  62.  
  63. // Fetch a result set
  64. cout << "* MySQL - SHOW TABLES in `"
  65. << MY_DATABASE << "`" << endl;
  66. while ((row = mysql_fetch_row(res)) != NULL)
  67. cout << row[0] << endl;
  68.  
  69. // Release memories
  70. mysql_free_result(res);
  71.  
  72. // Close a MySQL connection
  73. mysql_close(conn);
  74. } catch (char *e) {
  75. cerr << "[EXCEPTION] " << e << endl;
  76. return false;
  77. }
  78. return true;
  79. }
  80.  
  81. int main(){
  82. try {
  83. Proc objMain;
  84. bool bRet = objMain.execMain();
  85. if (!bRet) cout << "ERROR!" << endl;
  86. getchar();
  87. } catch (char *e) {
  88. cerr << "[EXCEPTION] " << e << endl;
  89. return 1;
  90. }
  91. return 0;
  92. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement