Executing a select statement and save result set to Java object - Java JDBC

Java examples for JDBC:SQL Statement

  1. HOME
  2. Java
  3. JDBC
  4. SQL Statement

Description

Executing a select statement and save result set to Java object

Demo Code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.NumberFormat;

public class ListMovies {
  public static void main(String[] args) {
    NumberFormat cf = NumberFormat.getCurrencyInstance();

    ResultSet movies = getMovies();
    try {/*ww w .  j a va2s . c o  m*/
      while (movies.next()) {
        Movie m = getMovie(movies);
        String msg = Integer.toString(m.year);
        msg += ": " + m.title;
        msg += " (" + cf.format(m.price) + ")";
        System.out.println(msg);
      }
    } catch (SQLException e) {
      System.out.println(e.getMessage());
    }
  }

  private static ResultSet getMovies() {
    Connection con = getConnection();
    try {
      Statement s = con.createStatement();
      String select = "Select title, year, price " + "from movie order by year";
      ResultSet rows;
      rows = s.executeQuery(select);
      return rows;
    } catch (SQLException e) {
      System.out.println(e.getMessage());
    }
    return null;
  }

  private static Connection getConnection() {
    Connection con = null;
    try {
      Class.forName("com.mysql.jdbc.Driver");
      String url = "jdbc:mysql://localhost/Movies";
      String user = "root";
      String pw = "NuttMutt";
      con = DriverManager.getConnection(url, user, pw);
    } catch (ClassNotFoundException e) {
      System.out.println(e.getMessage());
      System.exit(0);
    } catch (SQLException e) {
      System.out.println(e.getMessage());
      System.exit(0);
    }
    return con;
  }

  private static Movie getMovie(ResultSet movies) {
    try {
      String title = movies.getString("Title");
      int year = movies.getInt("Year");
      double price = movies.getDouble("Price");
      return new Movie(title, year, price);
    } catch (SQLException e) {
      System.out.println(e.getMessage());
    }
    return null;
  }
}
class Movie {
  public String title;
  public int year;
  public double price;

  public Movie(String title, int year, double price) {
    this.title = title;
    this.year = year;
    this.price = price;
  }
}

Related Tutorials