Software in Java to help maintain your data and notes and provide search option to manage your data in effective manner.
The Prgramming Language used is Java .
For handling data it uses MySQL database.
##MySQL database
Name of the database used is personalenc .
Data
Admin
####Data table - It stores your content.
| S.NO. | Column Name | Data Type | Size | Key | NULL |
|---|---|---|---|---|---|
| 1 | id | Integer | 7 | Primary Key | YES |
| 2 | title | Varchar | 60 | YES | |
| 3 | content | Varchar | 4000 | YES | |
| 4 | tag | Varchar | 200 | YES | |
| 5 | username | Varchar | 200 | YES |
####Admin table - It stores username and password of all users.
| S.NO. | Column Name | Data Type | Size | Key | NULL |
|---|---|---|---|---|---|
| 1 | username | Varchar | 200 | Primary Key | YES |
| 2 | password | Varchar | 200 | YES |
##Set up this project in your System
Open all the files in this repositry in your ide, i used Netbean IDE here.
Username and Password used by me are "root" and "netbean". So, edit this line of code according to your mysql username and password
String databasepass="netbean";
String databaseuser="root";