Zoho-comments
It is a Basic Comment App for different users.
Technology Used : JAVA Swing, Mysql. Tools Used : Eclipse , WampServer.
Mysql Table : signup,login,comment
How to Run : Download the project in your eclipse and run , but for database connection you have to install Wampserver and in that you have to make mentioned tables by yourself. -> Also user has to add mysql driver in project for executing queries/ making connection with database. ->Email should be in "@gmail.com" format. -> Password should be greater than 8 size and also contains a upper case Alphabet & character.
Process: -> First in Login class ,if User is using first time , user has to create account by using signup option and there he has to add Email,Password & secret code.After creating it will redirect user to login class ->In the login class user has to pass valid credentials otherwise it will show Error .After logging in user can filter comments for there username and also can post the comment and it will show there email and comment that user did.
Checking for valid credentials
Database Tables:-
mysql> mysql> use online Database changed mysql> ; ERROR: No query specified
mysql> select *from signup; +------------------------+----------+-------------+ | Email | Password | Secret_Code | +------------------------+----------+-------------+ | [email protected] | 1234 | jai | | [email protected] | 12345 | tanish | | [email protected] | asdsa | dsdsd | | [email protected] | k | k | | [email protected] | Jai123@@ | sdsds | | [email protected] | Jai123@@ | jai | | [email protected] | Jai123@@ | 12345 | +------------------------+----------+-------------+ 7 rows in set (0.00 sec)
mysql> select *from signup; +------------------------+----------+-------------+ | Email | Password | Secret_Code | +------------------------+----------+-------------+ | [email protected] | 1234 | jai | | [email protected] | 12345 | tanish | | [email protected] | asdsa | dsdsd | | [email protected] | k | k | | [email protected] | Jai123@@ | sdsds | | [email protected] | Jai123@@ | jai | | [email protected] | Jai123@@ | 12345 | +------------------------+----------+-------------+ 7 rows in set (0.00 sec)
mysql> select *from signup; +------------------------+----------+-------------+ | Email | Password | Secret_Code | +------------------------+----------+-------------+ | [email protected] | 1234 | jai | | [email protected] | 12345 | tanish | | [email protected] | asdsa | dsdsd | | [email protected] | k | k | | [email protected] | Jai123@@ | sdsds | | [email protected] | Jai123@@ | jai | | [email protected] | Jai123@@ | 12345 | | [email protected] | | 12345 | +------------------------+----------+-------------+ 8 rows in set (0.00 sec)
mysql> show tables; +------------------+ | Tables_in_online | +------------------+ | comment | | login | | signup | +------------------+ 3 rows in set (1.25 sec)
mysql> select *from signup; +------------------------+---------------------+-------------+ | Email | Password | Secret_Code | +------------------------+---------------------+-------------+ | [email protected] | 1234 | jai | | [email protected] | Jai123@@ | tanish | | [email protected] | asdsa | dsdsd | | [email protected] | k | k | | [email protected] | Jai123@@ | sdsds | | [email protected] | Jai123@@ | jai | | [email protected] | Jai123@@ | 12345 | | [email protected] | dsadsaksdsdsadssdsa | 12345 | | [email protected] | Jai123@@ | jai | +------------------------+---------------------+-------------+ 9 rows in set (0.02 sec)
mysql> select *from login; Empty set (0.05 sec)
mysql> select *from comment; +------------------------+--------------------------+ | Email | Comment | +------------------------+--------------------------+ | [email protected] | First project | | [email protected] | Second project | | [email protected] | jai | | [email protected] | dafsfd | | [email protected] | jjjj | | [email protected] | | | [email protected] | sdass aadfdsf dsfd sd df | | [email protected] | jja | | [email protected] | is it working? | | [email protected] | how are you? | | [email protected] | dekh | | [email protected] | dsadsads | | [email protected] | xcxcxczczx | | [email protected] | cdsddddddddddddd | | [email protected] | dwaqqqqqqqqqqq | | [email protected] | wqqqqqqqqqqqqqqqqqqq | | [email protected] | wqqqqqqqqqqqqqqqq | | [email protected] | wqqqqqqqqqqq | | [email protected] | kkk | | [email protected] | kk | | [email protected] | kk | | [email protected] | kk | | [email protected] | k | | [email protected] | dd | | [email protected] | jjjj | | [email protected] | it is testing . | | [email protected] | testing | | [email protected] | testing | | [email protected] | testing | | [email protected] | testing | | [email protected] | testing | +------------------------+--------------------------+ 31 rows in set (0.02 sec)
mysql>