The first version of this program was designed basically and it had security issues due to using a text file to store users information. I publish this version as 2.0 instead of 1.6 or 1.8 because it deserves. :-) . Version 2.0 fully supported by MySQL and i have worked on Eclipse Galileo environment which means by importing header files on your eclipse environment, any developer can start to enlarge the program. Of course this version still needs some upgrades ( but i call these upgrades as deficiencies ) and instead of loosing times on these upgrades, i wanted to publish a version. According to the scenario, this version executes as a dentist appointment program. On the other hand with some arrangements, it can support variety of purposes. In the first version, i had some troubles with connectors of Gnomes Gtkmm libraries and at the beginning, this version was a nightmare for MySQL connectors between mysql.h and Eclipse environment, but i make it work. I have googled these issues and i actually got confused. If anyone needs some help about connectors of Eclipse-MySQL connectors and Gnomes Gtkmm libraries, i can help you via info@ugurarpaci.com .
This version was compiled by gcc compiler and it is executable on any Linux environment. ( Personally i have executed on three different environments as Pardus, Ubuntu and Fedora. ) I have used a couple of different algorithm ( such as checking e-mail address ), and i gave some of their references, which i copied from technical books. As i succeeded, MySQL database supported 2.0 can be used on a network by settling database on a server. I used my home server two computers can send queries. ( This aspect can be used as a real world problem as having more than one dentist institute so that, doctors can reach any patiences information simultaneously ) In order to use database, database connection information need to be initialized with respect to proper database. This can be done by using sqlInformation.h header file. I organized this file as follows: static char* sqlPassword(){password="";return password;}; //MySQL Password static char* sqlUsername(){username="";return username;}; //MySQL Username static char* sqlServer(){server="";return server;}; //MySQL server address static char* sqldb_name(){db_name=""; return db_name;}; //MySQL database name You can change these information by writing your MySQL password,username,servername and databasename between " " . Let's make an initialization as follows; Let MySQL database password be "abcdef" Let MySQL database granted username be "doctorJohn" Let MySQL server ip address be "192.168.5.87" Let MySQL database database name be "dentistDatabase" ( database user must have query send and select query privileges otherwise execution could end or return by a database connection error ) static char* sqlPassword(){password="abcdef";return password;}; static char* sqlUsername(){username="doctorJohn";return username;}; static char* sqlServer(){server="192.168.5.87";return server;}; static char* sqldb_name(){db_name="dentistDatabase"; return db_name;}; Now that is a proper bunch of information to run database. MySQL column names: I used one table called 'member' and 8 columns named as: memberNumber memberName, memberSurname, memberAge, memberEmail, mumberMobile, memberDate, memberSymptoms When i send my query to database, columns look like as follows; query="SHOW COLUMNS FROM members;"  You can download either executable on linux environment ( it won't work anyway- it does not include database connection information ) or download source code files. |
