Question: 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](https://i.stack.imgur.com/VjjiD.png)

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](http://www.java2s.com/Code/Jar/m/Downloadmysqlconnectorjavajar.htm)

[Refer](http://www.mkyong.com/jdbc/how-to-connect-to-mysql-with-jdbc-driver-java/)
Maybe you should define your strings before use them.

The host URL seems good. 

You have to install the driver in your server, or to put it in the `/lib` folder of your project. You fill find it in `%DERBY_HOME%/lib` folder, named `derby.jar`, assuming `%DERBY_HOME%` is the directory installation of Derby.