Jeiman Jeiman - 1 month ago 7
Java Question

How to connect to database connection in Java

I would like to know how to connect to database in which is hosted in Xampp MySQL.

This is what I have so far in my java code to connect but I'm unsure what I'm doing.

public static void main(String[] args) {
try {
Connection con = DriverManager.getConnection( host, username, password );
String host = "jdbc:derby://localhost:1527/Employees";
String uName = "root";
String uPass= "password";
}
catch ( SQLException err ) {
System.out.println( err.getMessage( ) );
}

}



  1. What would the host URL be?

  2. Do i need a JDBC Jar file to connect to the DB?



I have setup a database and table via phpMyAdmin already. Just don't know how to proceed.

I am using Netbeans to write my Java code to connect to a local database which was created via Xampp PHPMyAdmin.

In the end, I want to create a database connection in Java and call out tables within the IDE. Would appreciate some help.

Answer

This is the project structure

Project Structure

Try with this

Update

    public static void main(String[] args) {
    // TODO Auto-generated method stub
    try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        System.out.println("Where is your MySQL JDBC Driver?");
        e.printStackTrace();
        return;
    }

    System.out.println("MySQL JDBC Driver Registered!");
    Connection connection = null;

    try {
        connection = DriverManager
        .getConnection("jdbc:mysql://localhost:3306/testspring","root", "password");

    } catch (SQLException e) {
        System.out.println("Connection Failed! Check output console");
        e.printStackTrace();
        return;
    }

    if (connection != null) {
        System.out.println("You made it, take control your database now!");
    } else {
        System.out.println("Failed to make connection!");
    }
}

It is working for me

I downloaded jar from Java2s.com

Refer

Comments