java examples
Home Java Examples Resources Java Interview Questions
Brainpower SEO

How to query records from table?

package com.javacoderanch.sample.java.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class ResultSetExample
{
    public static void main(String[] args) throws Exception
    {
        Connection connection = null;
        try
        {
            // Here we load the MySQL database Driver class
            Class.forName("com.mysql.jdbc.Driver");

            // Define properties for connecting to database such as
            // database jdbc url, username and password
            String url = "jdbc:mysql://localhost/sampledb";
            String username = "root";
            String password = "";

            // Get a connection to database.
            connection = DriverManager.getConnection(url, username, password);
            // Create a statment object.
            Statement statement = connection.createStatement();
            // Executes a query command to select isbn and the book title
            // from books table. The execute query returns a ResultSet object
            // which is the result of our query execution.
            ResultSet books = statement.executeQuery("SELECT isbn, title, published_date FROM books");

            // To get the value returned by the statement.executeQuery we need
            // to iterate the books object until the last items.
            while (books.next())
            {
                // To get the value from the ResultSet object we can call
                // a method that correspond to the data type of the column in
                // database table. In the example below we call
                // books.getString("isbn") to get the book's ISBN information.
                System.out.println(books.getString("isbn") + "; "
                        + books.getString("title") + "; "
                        + books.getDate("published_date"));
            }
        } finally {
            if (connection != null && !connection.isClosed())
            {
                // We've done the business with the connection object, so
                // let's close it.
                connection.close();
            }
        }
    }
}