How to connect MySQL database in NetBeans

Поделиться
HTML-код
  • Опубликовано: 21 июл 2024
  • Hello Everyone! Today in this video I am going to step by step guide you How To connect to MySQL8.0.28 database in NetBeans12.6 IDE using Database Services tool , so you can work with and manage MySQL databases right inside NetBeans without having to use an external program like MySQL Workbench or MySQL Command Line Client .
    In details , you will learn :-
    Download MySQL JDBC driver -
    Make connection to a MySQL database
    Create a new table -
    Update data in a table -
    Execute SQL statements Line Client
    And I suppose that you're using these software programs : -
    Java Development Kit ( JDK ) -
    Apache NetBeans IDE -
    MySQL Community server
    How to connect Java application with MySQL using NetBeans steps:-
    1. Downloading MySQL JDBC driver
    2.Extract and open the downloaded file. There will be a file named mysql-connector-java-8.0.28.jar (version number may be different).
    3.Create a MySQL database.
    4. Configuring the NetBeans project
    Open NetBeans and create a new project by
    Clicking File -New Project
    From the Choose Project window, select Java-Java Application and click next.
    Choose a project name and click Finish.
    Expand the project folder and Right-click on Libraries.
    Select Add JAR/Folder.
    Select mysql-connector-java-8.0.28jar and click open. Now you will see the jar file listed under Libraries.
    Go to Window-Services.
    Right-click on Databases and select New Connection.
    Click Add and select mysql-connector-java-8.0.28 connectivi.jar file. From Driver drop-down, select MySQL (Connector/J driver). Click Next.
    In the Customize Connection window, replace the Database name with the one you have created for the application. If you have not created a database, leave it as it is.
    Click Test Connection.
    If you get a Connection Succeeded message, you have connected your application with the MySQL database.
    ►Top Online Courses Tutorial for Beginners by Sudhir Sir :
    How to download mysql 8.0.28
    • How to install MYSQL S...
    how to download netbeans 12.6
    • How to install java Ne...
    about mysql workbench
    • How to create database...
    about mysql client server
    • Create Database and Ta...
    -------------------------------------------------------------------------------
    Timestamp
    00:00 Introduction
    01:22 Mysql Conector/J Driver Downloading
    02:14 Unzip driver
    03:12 Create database
    03:56 Create table
    05:08 Connecting Mysql and Netbeans
    05:55 Create new project
    07:07 Load Driver
    09:00 Code writing✍️
    11:14 run project
    -------------------------------------------------------------------------------
    ►Like And Subscribe
    -------------------------------------------------------------------------------
    ►Video tag
    #DatabaseConnectivity
    #connectnetbeansAndMysql
    #databaseConnection
    #netbeans
    #mysql8
    #mysqlserver
    #mysqlworkbench
    #javaprogramming
    #javatutorial
    #mysqldatabase
    #connectMysqlNetbens
    #netbenas12.6
    Connect mysql and java NetBeans
    Connect mysql and java NetBeans
    Database connectivity in java
    Database connectivity in netbeans12.6
    How to connect MySQL8.0.28 and NetBeans12.6
    How to connect mysql database in java using NetBeans
    Mysql8.0.28
    java database connectivity
    java database connectivity tutorial
    java jdbc complete tutorial
    java jdbc connection mysql
    java jdbc mysql
    java jdbc project
    jdbc connection in java mysql
    jdbc in java
    jdbc tutorial
    what is jdbc connection in java
    what is database connectivity
    How to create MySQL database in NetBeans
  • НаукаНаука

Комментарии • 36

  • @subhadeeproy1983
    @subhadeeproy1983 Год назад +1

    thank u very much for the help. Keep it up 👍

  • @inessbenachenhou6795
    @inessbenachenhou6795 Год назад +1

    Thank you very much !!

  • @poojajoijode7301
    @poojajoijode7301 Год назад +2

    thankyou ! everything explained properly in detailed

  • @m.m3806
    @m.m3806 2 года назад +4

    thank you so much

  • @gayatrigopireddi7456
    @gayatrigopireddi7456 Год назад +1

    Thank you 😊

  • @ManishKumar-gx9no
    @ManishKumar-gx9no Год назад +2

    Thanks buddy

  • @ozonewagle
    @ozonewagle 2 года назад +4

    Hey bro. It says cannot find jdbc symbol.

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +1

      ruclips.net/video/HLOLUDHRtDQ/видео.html
      Watch this video,I have explained.
      and if you are happy then subscribe the channel.

  • @justsmile5168
    @justsmile5168 2 года назад +4

    It is showing
    Cannot find symbol DriverManager

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +1

      ruclips.net/video/HLOLUDHRtDQ/видео.html
      Watch this video

  • @ambikaraut5413
    @ambikaraut5413 2 года назад +3

    while adding the jdc,on what basis i should keep the password.It not connecting. it says" connection failed:communications link failure......please help me

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +1

      Watch this video. If after this the problem is not solved then message us on telegram link us on the home page:
      ruclips.net/video/HLOLUDHRtDQ/видео.html

  • @ladudu4444
    @ladudu4444 2 года назад +5

    In step: Right-click on Databases and select New Connection.
    Click Add and select mysql-connector-java-8.0.12.jar file. From Driver drop-down, select MySQL (Connector/J driver). Click Next.
    - I dont have MySQL (Connector/J driver) from Driver drop-down, only Oracle OCI, Oracle Thin and PostgreSQL, how to add this ?

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +3

      Select the driver you downloaded: Automatic will take it

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +3

      If still problem is coming then comment

    • @ladudu4444
      @ladudu4444 2 года назад +3

      @@CodingWithSudhir i selected New Driver and added url to jar file, it works, thanks

  • @computertrends4825
    @computertrends4825 2 года назад +4

    Connection c me connection kaha se import kiya hai

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +2

      You can do it by pressing the Alt+Enter key or you can do it manually.

  • @Rahul-ju4vh
    @Rahul-ju4vh Год назад +1

    It's showing an error
    Cannot find symbol : variable DriverManager
    Please help..

    • @CodingWithSudhir
      @CodingWithSudhir  Год назад +1

      Watch this
      ruclips.net/video/d_R77D9pA3s/видео.html

  • @md.juwelmallick7716
    @md.juwelmallick7716 2 года назад +4

    please help! I successfully connect the database new connection with the driver file link but in project section doesn't show any library option where I will add a MySQL connector.

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +2

      You don't take tension... send me by clicking the 🖼️pictures

    • @md.juwelmallick7716
      @md.juwelmallick7716 2 года назад +1

      @@CodingWithSudhir how can i send you picture? drive reply link deleted automatically from reply

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +1

      do you use telegram?
      Then send message
      t.me/SudhirKushwah

    • @terd3011
      @terd3011 2 года назад +1

      i have the same problem as him and its been a week and i still havent solved it please help

    • @CodingWithSudhir
      @CodingWithSudhir  2 года назад +1

      Watch this video and message on telegram if the problem is not getting solved. htap:://yotu.bay/haloludharatdak

  • @lajarinalawade2807
    @lajarinalawade2807 2 года назад +5

    While connecting it gives error : Unable to find suitable driver.

  • @amalpfranglin
    @amalpfranglin 2 года назад +3

    Thank you so much.... :)