college-management-system-java icon indicating copy to clipboard operation
college-management-system-java copied to clipboard

Published 20 hours ago • verified publisher icon nixrajput

Database connection

Open Navneet-sharma01 opened this issue 3 years ago • 9 comments

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

Navneet-sharma01 avatar May 18 '21 05:05 Navneet-sharma01

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

nixrajput avatar May 18 '21 08:05 nixrajput

error

Navneet-sharma01 avatar May 18 '21 08:05 Navneet-sharma01

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...

nixrajput avatar May 18 '21 08:05 nixrajput

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

Navneet-sharma01 avatar May 18 '21 09:05 Navneet-sharma01

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 avatar May 18 '21 10:05 nixrajput

DB Table Structure Image 👇🏻

db_structure

nixrajput avatar May 18 '21 10:05 nixrajput

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

swaminath8358 avatar May 28 '21 13:05 swaminath8358

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

enchung27 avatar Dec 05 '22 10:12 enchung27

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

priyahiremath123 avatar Jul 14 '24 07:07 priyahiremath123