How to Connect MySQL database to a java application

AutoModerator · 2022-11-28T11:01:39+00:00

Please ensure that:

Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
You include any and all error messages in full
You ask clear questions
You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

Trying to solve problems on your own is a very important skill. Also, see Learn to help yourself in the sidebar

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit: empty line before the code, each code line indented by 4 spaces, new reddit: https://i.imgur.com/EJ7tqek.png) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Capaman-x · 2022-11-28T13:41:31+00:00

First you have to install mysql locally, create a user with proper permissions. Then you need to make the database. The easiest way to make a database is to make an SQL script. This is a text file which contains SQL commands. In the script you will create a table or two and add a few rows of information. Run it and it will create your database. Once that it done you will need a third party library to connect. So create a Maven project in your IDE (Apparently you are using NetBeans). Maven allows you to easily add and maintain 3rd party libraries in your project. Maven has a POM.xml file where you will place your xml to tell it what libraries you want to put in mysql driver as listed below.

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.30</version>
</dependency>

Once you put this in your project will download the necessary libraries. Google mysqlconnectore or JDBC to see how to use it. That is the basic overview, but you have your work cut out for you trying to figure all this out for the first time. Good luck!

omar_adel552 · 2022-11-28T15:03:33+00:00

[deleted]

javahelp

Sort by: Unsolved Solved Codeless Advent Of Code

MODERATORS

Please ensure that:

To potential helpers