How to connect MySQL database in NetBeans

SdĂ­let
VloĆŸit
  • čas pƙidĂĄn 9. 07. 2024
  • Hello Everyone! Today in this video I am going to step by step guide you How To connect to MySQL8.0.30 database with NetBeans 15 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 .
    👉Disclaimer --- Video is for educational purpose only . Copyright Disclaimer Under Section 107 of the Copyright Act 1976 , allowance is made for " fair use " for purposes such as criticism , comment , news reporting , teaching , scholarship , and research . Fair use is a use permitted by copyright statute that might otherwise be infringing . Non - profit , educational or personal use tips the balance in favor of fair use .
    ----------------------------------------------------------------------------
    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
    â–șRecord Navigation Using Java Mysql Step by Step Check More Projects
    And I suppose that you're using these software programs : -
    Java Development Kit ( JDK ) -
    Apache NetBeans IDE -
    MySQL Community server
    â–șWhat is Java? Java is an object-oriented, class-based, high-level programming language used for software development, mobile application development, website development, desktop application development, and much more. Java is one of the leading and in-demand programming languages in the current IT industry.
    â–șWhat is Java JDBC? Java JDBC stands as an abbreviation for Java Database Connection. Basically, Java JDBC is used as an interface or a plugin to connect the relational databases and other sources of real-time data with the Java software application.
    â–șHow to connect Java application with MySQL using NetBeans steps:-
    â–șDownloading MySQL JDBC driver
    â–șExtract and open the downloaded file. There will be a file named mysql-connector-java-8.0.30.jar
    â–șCreate a MySQL database.
    â–ș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.30.jar 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.30 connectivity.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 From Code Leaning Tutorial for Beginners :
    â–șHow to download mysql 8.0.30
    ‱ How to install MYSQL 8...
    â–șHow to download netbeans 15
    ‱ Video
    â–șAbout mysql workbench
    ‱ How to create database...
    â–șAbout mysql client server
    ‱ Create Database and Ta...
    â–șHotel management project in java netbeans
    ‱ Hotel Management Syste...
    â–șLoading Form designing in java netbeans
    ‱ #02 Loading Screen for...
    ----------------------------------------------------------------------------
    Timestamp
    00:00 Tutorial Introduction
    00:30 Download Mysql Connector/J drivers
    01:30 Unzip Downloaded files
    03:12 Open NetBeans IDE And set Database Connectivity Configuration
    05:17 Create a new Project in NetBeans IDE
    7:30 Add mysql driver in project library
    8:00 Writing Code for connecting Mysql and NetBeans
    10:00 Finely Run project
    ----------------------------------------------------------------------------
    â–șLike And Subscribe
    ----------------------------------------------------------------------------
    â–șVideo tag
    #JavaJDBCTutorial #JDBCInJava #JavaDatabaseConnectivity #WhatlsJDBCInJava #JavaTutorialForBeginners #JavaProgramming
    -------------------------------------------------------------------------------
    Topic Covered
    Connect mysql and java NetBeans
    database connectivity in java
    Database connectivity in netbeans 15
    How to connect MySQL8.0.30 and NetBeans 14
    How to connect mysql database in java using
    what is database connectivity
    record navigation in java
    How to Connection mysql in netbeans
    How to connect mysql 8.0.30 and netbeans 14
    Java database connection jdbc and mysql
    Java database connectivity theory
    Java database connectivity with mysql in
    How to connect mysql 8.0.30 and NetBeans 14
    How to connect mysql database in java NetBeans
    How to connect mysql database in java using eclipse in hindi
    How to connect mysql database in java in hindi
  • Věda a technologie

Komentáƙe • 11

  • @muhammadagung2934
    @muhammadagung2934 Pƙed rokem +1

    Dude can you helped me? I was makin jframe that can connect to mysql (xampp) and it work fine when i run it on ide, but here's the problem when i clean and build, then i run the jar file it can't work. Any solution?

    • @CodingWithSudhir
      @CodingWithSudhir  Pƙed rokem +1

      Watch my another tutorial

    • @muhammadagung2934
      @muhammadagung2934 Pƙed rokem +1

      @@CodingWithSudhir wich one?

    • @CodingWithSudhir
      @CodingWithSudhir  Pƙed rokem +2

      Go to Database Connectivity Playlist section where I have uploaded many videos. You can watch the video in which we describe JFrame with database connection.

    • @muhammadagung2934
      @muhammadagung2934 Pƙed rokem +1

      @@CodingWithSudhir BRO I FOUND THE PROBLEMS, when i saw one of your video i realize ur using java application not class library, and it worked when i follow ur tutorial, thank you so much dudeee u save my day a lott. About to be ur new subscriber hahaha

  • @sakshamrajput482
    @sakshamrajput482 Pƙed rokem +3

    From last 12 hours I was stuck with connection problem but this video help me to overcome problem in no time.... He is best.... Thankyou from heart❀

  • @ktwithsakshi9960
    @ktwithsakshi9960 Pƙed rokem +2

    Thank you so much...
    Finally connection successful.....🙏😊

    • @CodingWithSudhir
      @CodingWithSudhir  Pƙed rokem +3

      If you really like this video please subscribe my channel

  • @sakshamrajput482
    @sakshamrajput482 Pƙed rokem +3

    His video is very detailed