search

nixrajput / college-management-system-java

A Desktop Application for managing a college data. It's developed using Java programming language & MySQL database.
BSD 3-Clause "New" or "Revised" License
18 stars 14 forks source link

Database connection #1

Open Navneet-sharma01 opened 3 years ago

Navneet-sharma01 commented 3 years ago

It shows the database connection failed..... Can you help me out?

nixrajput commented 3 years ago

Hi @Navneet-sharma01 , Can you share the image of your error that you are getting??

Navneet-sharma01 commented 3 years ago

error

nixrajput commented 3 years ago

Hi @Navneet-sharma01 , Did you created database as database structure shown in image?? If you have done the above process correctly then show me your DBConnection file...

Navneet-sharma01 commented 3 years ago

no,i didn't understand what actually needs to be done.

nixrajput commented 3 years ago

Hi @Navneet-sharma01 , Steps need to be taken 👎🏻

  1. Create a database in MySQL.
  2. DB table structure should be according to table structure as shown in image.
  3. Go to DBConnection.java file in the project.
  4. Write your database name, username and password in the place of YOUR_DB_NAME, YOUR_DB_USERNAME and YOUR_DB_PASSWORD respectively.
  5. Try to run the app again.

Hope u will be helped. 👍🏻

nixrajput commented 3 years ago

DB Table Structure Image 👇🏻

db_structure

swaminath8358 commented 3 years ago

can you tell me the connections of ER diagram for MySQL in windows. because the connection lines in windows are different

enchung27 commented 1 year ago

How to solve java.sql.SQLException: Field 'UID' doesn't have a default value?

Insertion failed everytime I tried to save on Student Application Page

priyahiremath123 commented 1 month ago

please explain in detail all the steps needed to run this project. And where to run this code