search

goldami1 / IoTScenarioEngine

Scenario Engine Project is done in cooperation between academy students team and a software company. For further information please check out the ReadMe file.
0 stars 0 forks source link

Gil should get DBHandler class to be able to read/write from/to MYSQL DB. #6

Closed goldami1 closed 6 years ago

goldami1 commented 6 years ago

Writing methods (with writing queries) yet to be implemented (by @gil-ronen ) for the sake of Front-End - DB communication. (i.e. products insertion, users insertion, etc...)

goldami1 commented 6 years ago

I managed to solve the issue in following manner: 1.At first, switched local DBMS to ONLINE DBMS => onto a free online MySql server service provider. By doing that, I avoid collision between the Tomcat and MySql services, and we enjoy 24/7 accessible DB. 2.Secondly, I downloaded the most updated mysql-connector-java jar file (ver. 5.1.45) 2.5.There is a need of multiple jar import to Tomcat CLASSPATH and global sys ref because of collision between mentioned applications. 3.Last but not least, there was a need to import packages for working with DB and SQL.

IN ADDITION

Improved singleton DP in DBHandler Improved DBHandler class architecture Implemented user addition methods (customer, vendor) Fixed Implementation of method telling username availability (mainly for registration purposes) *Implemented PRODUCT adding method.

IMPORTANT TO NOTICE

All of this update is in separate branch because of @romadee 's recent 'sign-up page update'. It's in the "workingDB" branch. Thus, integration (merging) should be done in parallel manner with @romadee .