Select records using Statement in Java

To select records using Statement in java we use

ResultSet executeQuery(String sql) throws SQLException

1	ResultSet executeQuery(String sql) throws SQLException

“A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.”

Example : Select records using Statement in Java

package com.kscodes.sampleproject.jdbc;

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

public class StatementSelectExample {

	public static String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";
	public static String CONNECTION_URL = "jdbc:mysql://localhost:3306/mysql";
	public static String CONNECTION_USER = "kscodes";
	public static String CONNECTION_PASSWORD = "kscodes";

	public static void main(String[] args) {

		String selectSql = "SELECT * FROM employee_details";

		try (Connection connection = getConnection();
				Statement statement = connection.createStatement()) {
			ResultSet rs = statement.executeQuery(selectSql);
			while (rs.next()) {
				int id = rs.getInt("id");
				String firstName = rs.getString("first_name");
				String lastName = rs.getString("last_name");

				System.out.println("Employee Id :: " + id);
				System.out.println("Employee Name :: " + firstName + " " + lastName);
			}

		} catch (SQLException e) {
			System.out.println("An exception occured while Selecting records from Table. Exception is :: "+ e);
		}
	}

	public static Connection getConnection() {

		try {
			Class.forName(DRIVER_CLASS_NAME);
		} catch (ClassNotFoundException e) {
			System.out.println("Error while registering JDBC driver");
			return null;
		}

		Connection connection = null;
		try {
			connection = DriverManager.getConnection(CONNECTION_URL,
					CONNECTION_USER, CONNECTION_PASSWORD);

		} catch (SQLException e) {
			System.out.println("Failed to create Connection");
			return null;
		}
		System.out.println("Connection created Successfully.");
		return connection;
	}
}

package com.kscodes.sampleproject.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class StatementSelectExample {

public static String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";

public static String CONNECTION_URL = "jdbc:mysql://localhost:3306/mysql";

public static String CONNECTION_USER = "kscodes";

public static String CONNECTION_PASSWORD = "kscodes";

public static void main(String[] args) {

String selectSql = "SELECT * FROM employee_details";

try (Connection connection = getConnection();

Statement statement = connection.createStatement()) {

ResultSet rs = statement.executeQuery(selectSql);

while (rs.next()) {

int id = rs.getInt("id");

String firstName = rs.getString("first_name");

String lastName = rs.getString("last_name");

System.out.println("Employee Id :: " + id);

System.out.println("Employee Name :: " + firstName + " " + lastName);

}

} catch (SQLException e) {

System.out.println("An exception occured while Selecting records from Table. Exception is :: "+ e);

}

public static Connection getConnection() {

try {

Class.forName(DRIVER_CLASS_NAME);

} catch (ClassNotFoundException e) {

System.out.println("Error while registering JDBC driver");

return null;

}

Connection connection = null;

try {

connection = DriverManager.getConnection(CONNECTION_URL,

CONNECTION_USER, CONNECTION_PASSWORD);

} catch (SQLException e) {

System.out.println("Failed to create Connection");

return null;

}

System.out.println("Connection created Successfully.");

return connection;

}

Output

Connection created Successfully.
Employee Id :: 1
Employee Name :: John Doe
Employee Id :: 2
Employee Name :: Smith Yo

Connection created Successfully.

Employee Id :: 1

Employee Name :: John Doe

Employee Id :: 2

Employee Name :: Smith Yo

Reference

1. Statement executeQuery()
2. ResultSet