ConnectionFactory.java

package com.mydb.test;
import com.mysql.jdbc.Driver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;



public class ConnectionFactory {
	
    public static final String URL = "jdbc:mysql://localhost:3306/user_pref";
    public static final String USER = "root";
    public static final String PASS = "asdf";

    /**

     * Get a connection to database

     * @return Connection object

     */

    public static Connection getConnection()

    {

      try {

          DriverManager.registerDriver(new Driver());

          return DriverManager.getConnection(URL, USER, PASS);

      } catch (SQLException ex) {

          throw new RuntimeException("Error connecting to the database", ex);

      }

    }

    /**

    public static void main(String[] args) {

       Connection connection = ConnectionFactory.getConnection();
       System.out.println(connection.toString());
    }

     */

   
   

}