Last change
on this file since 36082e8 was 36082e8, checked in by dportnoy <dmp1488@…>, 12 years ago |
Moved the database code to a new class
|
-
Property mode
set to
100644
|
File size:
988 bytes
|
Line | |
---|
1 | #include "DataAccess.h"
|
---|
2 |
|
---|
3 | #include <iostream>
|
---|
4 |
|
---|
5 | #include <mysql/mysql.h>
|
---|
6 |
|
---|
7 | using namespace std;
|
---|
8 |
|
---|
9 | DataAccess::DataAccess()
|
---|
10 | {
|
---|
11 | }
|
---|
12 |
|
---|
13 | DataAccess::~DataAccess()
|
---|
14 | {
|
---|
15 | }
|
---|
16 |
|
---|
17 | int DataAccess::dbtest()
|
---|
18 | {
|
---|
19 | MYSQL *connection, mysql;
|
---|
20 | MYSQL_RES *result;
|
---|
21 | MYSQL_ROW row;
|
---|
22 | int query_state;
|
---|
23 |
|
---|
24 | mysql_init(&mysql);
|
---|
25 |
|
---|
26 | connection = mysql_real_connect(&mysql,"localhost","pythonAdmin","pyMaster09*","pythondb",0,0,0);
|
---|
27 |
|
---|
28 | if (connection == NULL) {
|
---|
29 | cout << mysql_error(&mysql) << endl;
|
---|
30 | return 1;
|
---|
31 | }else
|
---|
32 | cout << "Connection successful" << endl;
|
---|
33 |
|
---|
34 | query_state = mysql_query(connection, "SELECT * FROM users");
|
---|
35 |
|
---|
36 | if (query_state !=0) {
|
---|
37 | cout << mysql_error(connection) << endl;
|
---|
38 | return 1;
|
---|
39 | }
|
---|
40 |
|
---|
41 | result = mysql_store_result(connection);
|
---|
42 |
|
---|
43 | while ( ( row = mysql_fetch_row(result)) != NULL ) {
|
---|
44 | cout << row[0] << ", " << row[1] << ", " << row[2] << endl;
|
---|
45 | }
|
---|
46 |
|
---|
47 | mysql_free_result(result);
|
---|
48 | mysql_close(connection);
|
---|
49 |
|
---|
50 | cout << "Test finished" << endl;
|
---|
51 |
|
---|
52 | return 0;
|
---|
53 | }
|
---|
Note:
See
TracBrowser
for help on using the repository browser.