How to connect with mysql in java

How to Connect MySQL Database in Java Using Eclipse Step by Step

Hello guys, Welcome to another tutorial, and in this tutorial, we will learn how to connect MySQL database in Java using Eclipse with simple and easy steps. Most of the time, whenever we try to connect our program to the database, we face a lot of problems, and even then, we cannot connect successfully. But if you follow this tutorial properly, you will be able to connect your Java program to the MySQL database using Eclipse quite easily.

So Let’s start our tutorial on how to connect MySQL database in Java using Eclipse.

How to Connect MySQL Database in Java Using Eclipse

• 1 How to Connect MySQL Database in Java Using Eclipse
  • 1.1 Downloading and Installing Eclipse
  • 1.2 Creating a Database and Table in MySQL
  • 1.3 Creating a Java Project in Eclipse
  • 1.4 Adding MySQL connector jar file in Eclipse
  • 1.5 Connecting Java Program with MySQL Database
  • 1.6 Inserting Data into The MySQL Database using Java
  • 1.7 Updating Data in The MySQL Database using Java
  • 1.8 How to Retrieve Data from MySQL Database in Java Using Eclipse
  • 1.9 Deleting Data from the MySQL Database using Java
  • 1.10 Conclusion

  Downloading and Installing Eclipse

  • The very First thing you need to do is to Download and Install Eclipse IDE on your system.
  • Open your favorite browser and go to the official website of Eclipse www.eclipse.org.
  • When you enter the official website of the eclipse, you will see a download button in the top right corner. Click on that.

  

  • After clicking on the Download Button, you will be redirected to another Web page. Click on the download button, as shown in the figure below.

  

  • Now again, click on the Download button to download the executable eclipse file.

  

  • After downloading the file, you need to install it in your system in the same way you install any application.

  Creating a Database and Table in MySQL

  • To create a database and table, you can either choose MySQL command-line client or MySQL workbench, which is nothing but a GUI version of the MySQL console where we can visually design, model, and generates databases.
  • If you don’t know how to install MySQL workbench in your system, then you can follow this guide, How to install MySQL Workbench.
  • To get to know how to download and Install MySQL in your system so that you can Use MySQL command-line client, you can follow this guide.

  

  • I will use MySQL command-line client in this tutorial, open MySQL command-line client, and enter your password so that you can connect the MySQL database.
  • This is the same password you provided while installing the MySQL database in your system.
  • Now create a database named “demodb” and a table named “student” inside it with columns
    • ROLLNO
    • USERNAME
    • DEPT

  create table student ( ROLLNO varchar ( 10 ) not null , USERNAME varchar ( 30 ) , DEPT VARCHAR ( 30 ) ) ;

  Creating a Java Project in Eclipse

  • Open Eclipse IDE and click on the Java Project under the new section of File Menu ( File>>New>>Java Project ).

  

  • Now give a name to your project (DbConnect in this example) and click on “Finish”.

  

  • Now right click on the project and create a new Java class (New>>Class).

  

  • Now give a name to your class(MyDbconnect in this Example), tick mark on the public static void main(String[] args), and then click on the Finish button as shown in the figure below.

  

  Adding MySQL connector jar file in Eclipse

  • In order to connect your java program with MySQL database, you need to include MySQL JDBC driver which is a JAR file, namely mysql-connector-java-8.0.28.jar. The version number in the Jar file can be different.
  • You can download the latest version of MySQL connector from this link (MySQL Connector Java download) .
  • After visiting the link, select platform independent from the drop-down menu as shown in the figure below.

  

  • Then download the Platform Independent (Architecture Independent), ZIP Archive as shown below.

  

  • Extract the zip archive and you will get the jar file.
  • Next, you have to include this jar file into your program so that you will be able to connect your java program with MySQL database.
  • Right-click on the project, go to the properties section then select Java Build Path and click on the Add External JARs button.

  

  • After clicking on the button a pop-up window will appear where you have to select and open the jar file.

  

  • You can see the added Jar file as shown in the figure below. Now click on the Apply and Close button.

  

  Connecting Java Program with MySQL Database

  Since you have already finished adding jar file, now you are ready to connect your Java program with MySQL Database. Let’s quickly take a look at the steps.

  • Establish a connection using DriverManager.getConnection(String URL) and it returns a Connection reference.
  • In String URL parameter you have to write like this jdbc:mysql://localhost:3306/demodb”, “root”, “root” where,

    Источник

    How to connect with mysql in java

    Example to Connect Java Application with mysql database

    In this example, sonoo is the database name, root is the username and password both.

    The above example will fetch all the records of emp table.

    To connect java application with the mysql database, mysqlconnector.jar file is required to be loaded.

    Two ways to load the jar file:

    1) Paste the mysqlconnector.jar file in JRE/lib/ext folder:

    2) Set classpath:

    How to set the temporary classpath

    How to set the permanent classpath

    Go to environment variable then click on new tab. In variable name write classpath and in variable value paste the path to the mysqlconnector.jar file by appending mysqlconnector.jar;.; as C:\folder\mysql-connector-java-5.0.8-bin.jar;.;

    

    For Videos Join Our Youtube Channel: Join Now

    Feedback

    Help Others, Please Share

    

    Learn Latest Tutorials

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    Preparation

    

    

    

    

    Trending Technologies

    

    

    

    

    

    

    

    

    

    

    

    

    B.Tech / MCA

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    

    Javatpoint Services

    JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.

    • Website Designing
    • Website Development
    • Java Development
    • PHP Development
    • WordPress
    • Graphic Designing
    • Logo
    • Digital Marketing
    • On Page and Off Page SEO
    • PPC
    • Content Development
    • Corporate Training
    • Classroom and Online Training
    • Data Entry

    Training For College Campus

    JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
    Duration: 1 week to 2 week

    Like/Subscribe us for latest updates or newsletter

    Источник

    Java connect to MySQL database with JDBC

    This article explains how to write Java code to connect to a MySQL database server, step by step. If you just want to see the code example, click on Code example: a simple program connects to MySQL. If you have never written Java code to connect MySQL before, it’s worth reading this tutorial from the beginning.

    1. Download JDBC driver for MySQL

    First, in order to have Java program working with MySQL, we need a JDBC driver for MySQL. Browse this URL:

    to download the latest version of the JDBC driver for MySQL called Connector/J. MySQL Connector/J comes into 2 major versions: 5.1 and 8.0. The latest version 8.0 supports JDBC 4.2 and JDK 8 or higher.

    

    Click the Download button next to Platform Independent (Architecture Independent), ZIP Archive to download a zip archive. Extract the ZIP file to a desired location on your computer.

    

    The distribution includes a binary JAR file, source code, documentation and license files. But only one file we need is the JAR file mysql-connector-java-VERSION.jar . Copy this file into your project and make it available in your program’s classpath. You can use newer version of JDBC driver for MySQL.

    If your Java project based on Maven, you just need to declare the following dependency in the pom.xml file:

     mysql mysql-connector-java 8.0.19 

    2. No need to load MySQL driver class explicitly

    The Connector/J version 8.0 library comes with a JDBC driver class: com.mysql.cj.jdbc.Driver . Before Java 6, we have to load the driver explicitly by this statement:

    Class.forName(«com.mysql.cj.jdbc.Driver»);

    However that statement is no longer needed, thanks to new update in JDBC 4.0 comes from Java 6. As long as you put the MySQL JDBC driver JAR file file into your program’s classpath, the driver manager can find and load the driver.

    3. Understand the getConnection() method of DriverManager class

    It’s quite easy to make a connection to a database server in general, as well as to a MySQL server in particular. Just using the method getConnection() of the class DriverManager which is available in the package java.sql .

    There are three different signatures of the method getConnection() which we can use:

    • • static Connection getConnection(String url)
      • static Connection getConnection(String url, Properties info)
      • static Connection getConnection(String url, String user, String password)

      jdbc:mysql:// [host][:port]/[database] [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2].

      • • host: host name or IP address of the MySQL server.
        • port: port number of the server, default is 3306.
        • database: name of the database on the server.
        • propertyName1=propertyValue1 : a key=value pair for an additional property which will be sent to the server. For example, to send a username and password, write: ?user=root&password=secret

        4. Java code example connect to MySQL database

        The following example program makes three connections to three MySQL database in three different ways:

        import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Properties; public class MySQLConnectExample < public static void main(String[] args) < // creates three different Connection objects Connection conn1 = null; Connection conn2 = null; Connection conn3 = null; try < // connect way #1 String url1 = "jdbc:mysql://localhost:3306/test1"; String user = "root"; String password = "secret"; conn1 = DriverManager.getConnection(url1, user, password); if (conn1 != null) < System.out.println("Connected to the database test1"); >// connect way #2 String url2 = "jdbc:mysql://localhost:3306/test2?user=root&password=secret"; conn2 = DriverManager.getConnection(url2); if (conn2 != null) < System.out.println("Connected to the database test2"); >// connect way #3 String url3 = "jdbc:mysql://localhost:3306/test3"; Properties info = new Properties(); info.put("user", "root"); info.put("password", "secret"); conn3 = DriverManager.getConnection(url3, info); if (conn3 != null) < System.out.println("Connected to the database test3"); >> catch (SQLException ex) < System.out.println("An error occurred. Maybe user/password is invalid"); ex.printStackTrace(); >> >

        NOTES: You should close the database connection in the finally clause like this:

        finally < if (conn != null) < try < conn.close(); >catch (SQLException ex) < ex.printStackTrace(); >> >

        And since Java 1.7, you can use the try-with-resource syntax that closes the connection automatically, for example:

        try (Connection conn = DriverManager.getConnection(url, user, password)) < if (conn != null) < System.out.println("Connected to the database"); >> catch (SQLException ex) < System.out.println("An error occurred. Maybe user/password is invalid"); ex.printStackTrace(); >

        Type the following command to compile the example program:

        javac MySQLConnectExample.java

        Suppose the Connect/J library is placed in the same directory as the MySQLConnectExample.java file. Type the following command to run:

        java -cp mysql-connector-java-5.1.21-bin.jar;. MySQLConnectExample

        And here is the result when running the example program:

        

        That means the program has successfully connected to the MySQL database server.

        For visual howto, watch this video:

        JDBC API References:

        Related JDBC Tutorials:

        About the Author:

        

        Nam Ha Minh is certified Java programmer (SCJP and SCWCD). He started programming with Java in the time of Java 1.4 and has been falling in love with Java since then. Make friend with him on Facebook and watch his Java videos you YouTube.

        Источник

        Читайте также:  Css селектор по содержимому