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.
Show Password:
Comment Class
Testing by clicking on submit
After Submit
Filter Button
After Filter
Reset Password
Poor Password
Sign Up class
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 | +------------------------+----------+-------------+ | jaikumar8503@gmail.com | 1234 | jai | | tanish@gmail.com | 12345 | tanish | | fsdfa@g.com | asdsa | dsdsd | | jai1213@gmail.com | k | k | | jai@gmail.com | Jai123@@ | sdsds | | tanish@gmail.com | Jai123@@ | jai | | tanish@gmail.com | Jai123@@ | 12345 | +------------------------+----------+-------------+ 7 rows in set (0.00 sec)
mysql> select *from signup; +------------------------+----------+-------------+ | Email | Password | Secret_Code | +------------------------+----------+-------------+ | jaikumar8503@gmail.com | 1234 | jai | | tanish@gmail.com | 12345 | tanish | | fsdfa@g.com | asdsa | dsdsd | | jai1213@gmail.com | k | k | | jai@gmail.com | Jai123@@ | sdsds | | tanish@gmail.com | Jai123@@ | jai | | tanish@gmail.com | Jai123@@ | 12345 | +------------------------+----------+-------------+ 7 rows in set (0.00 sec)
mysql> select *from signup; +------------------------+----------+-------------+ | Email | Password | Secret_Code | +------------------------+----------+-------------+ | jaikumar8503@gmail.com | 1234 | jai | | tanish@gmail.com | 12345 | tanish | | fsdfa@g.com | asdsa | dsdsd | | jai1213@gmail.com | k | k | | jai@gmail.com | Jai123@@ | sdsds | | tanish@gmail.com | Jai123@@ | jai | | tanish@gmail.com | Jai123@@ | 12345 | | jai8503@gmail.com | | 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 | +------------------------+---------------------+-------------+ | jaikumar8503@gmail.com | 1234 | jai | | tanish@gmail.com | Jai123@@ | tanish | | fsdfa@g.com | asdsa | dsdsd | | jai1213@gmail.com | k | k | | jai@gmail.com | Jai123@@ | sdsds | | tanish@gmail.com | Jai123@@ | jai | | tanish@gmail.com | Jai123@@ | 12345 | | jai8503@gmail.com | dsadsaksdsdsadssdsa | 12345 | | test@gmail.com | Jai123@@ | jai | +------------------------+---------------------+-------------+ 9 rows in set (0.02 sec)
mysql> select *from login; Empty set (0.05 sec)
mysql> select *from comment; +------------------------+--------------------------+ | Email | Comment | +------------------------+--------------------------+ | jaikumar8503@gmail.com | First project | | jaikumar8503@gmail.com | Second project | | jaikumar8503@gmail.com | jai | | tanish@gmail.com | dafsfd | | tanish@gmail.com | jjjj | | tanish@gmail.com | | | tanish@gmail.com | sdass aadfdsf dsfd sd df | | tanish@gmail.com | jja | | tanish@gmail.com | is it working? | | tanish@gmail.com | how are you? | | tanish@gmail.com | dekh | | tanish@gmail.com | dsadsads | | tanish@gmail.com | xcxcxczczx | | tanish@gmail.com | cdsddddddddddddd | | tanish@gmail.com | dwaqqqqqqqqqqq | | tanish@gmail.com | wqqqqqqqqqqqqqqqqqqq | | tanish@gmail.com | wqqqqqqqqqqqqqqqq | | tanish@gmail.com | wqqqqqqqqqqq | | tanish@gmail.com | kkk | | tanish@gmail.com | kk | | tanish@gmail.com | kk | | tanish@gmail.com | kk | | tanish@gmail.com | k | | tanish@gmail.com | dd | | jai8503@gmail.com | jjjj | | test@gmail.com | it is testing . | | test@gmail.com | testing | | test@gmail.com | testing | | test@gmail.com | testing | | test@gmail.com | testing | | test@gmail.com | testing | +------------------------+--------------------------+ 31 rows in set (0.02 sec)
mysql>