title: Using database mysql in Java
body: <p>I have started trying out some stuff so that I can use mysql database together with Java. First of all I have some questions about it.</p>
  
  <p>I have used mysql a lot with PHP development but never with Java. Can I use the MySQL that MAMP brings or do I have to install it stand alone or something? </p>
  
  <p>and second.. I have created this code with the help of a tutorial but the only output I get is </p>
  
  <blockquote>
    <p>com.mysql.jdbc.Driver</p>
  </blockquote>
  
  <p>The code that I have used for this you can find below:</p>
  
  <pre><code>package Databases;
  
  import java.sql.*;
  
  public class MysqlConnect{
  
  /* These variable values are used to setup
  the Connection object */
  
   static final String URL = "jdbc:mysql://localhost:3306/test";
   static final String USER = "root";
   static final String PASSWORD = "root";
   static final String DRIVER = "com.mysql.jdbc.Driver";
  
   public Connection getConnection() throws SQLException {
      Connection con = null;
      try {
         Class.forName(DRIVER); 
         con = DriverManager.getConnection(URL, USER, PASSWORD);
      }
      catch(ClassNotFoundException e) {
         System.out.println(e.getMessage());
         System.exit(-1);
      }
      return con;
   }
  
   public void getEmployees() {
      ResultSet rs = null;
      try {
         Statement s = getConnection().createStatement();
         rs = s.executeQuery("SELECT id, name, job_id, location FROM person");
         System.out.format("%3s %-15s %-7s %-7s%n", 
            "ID", "NAME", "JOB ID", 
              "LOCATION");
         System.out.format("%3s %15s %7s %7s%n", 
            "---", "---------------", 
              "-------", "--------");
  
         while(rs.next()) {
            long id = rs.getLong("id");
            String name = rs.getString("name");
            long job = rs.getLong("job_id");
            String location = rs.getString("location");
            System.out.format("%-3d %-15s %7d %5s%n", 
               id, name, job, location);
         }
      }
      catch(SQLException e) {
         System.out.println(e.getMessage());
         System.exit(-1);
      }
   }
  }
  </code></pre>