Jeiman Jeiman - 8 months ago 52
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.


This is the project structure

Project Structure

Try with this


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

    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");

    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