Pages Navigation Menu

Coding is much easier than you think

JDBC PreparedStatement example to Select list of the records

JDBC PreparedStatement example to Select list of the records

 
In this example let us learn how to select records from table via JDBC PreparedStatement, and display the records via a ResultSet object.
 
To issue a select query, call the PreparedStatement.executeQuery() method like this :
 

String selectQuery = "SELECT USER_ID, USERNAME FROM EMPLOYEE WHERE USER_ID = ?";
PreparedStatement preparedStatement = connection.prepareStatement(selectSQL);
preparedStatement.setInt(1, 1000);
ResultSet rs = preparedStatement.executeQuery(selectQuery);
while (rs.next()) 
{
	String userid = rs.getString("USER_ID");
	String username = rs.getString("USERNAME");
	String createdBy = rs.getString("CREATED_BY");	
}

 
Full example…
 

package com.simplecode.jdbc;

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

public class JDBCPreparedStmtSelectExample 
{
private static final String dbDriver = "oracle.jdbc.driver.OracleDriver";
private static String serverName = "127.0.0.1";
private static String portNumber = "1521";
private static String sid = "XE";
private static final String dbUrl = "jdbc:oracle:thin:@" + serverName + ":"
		+ portNumber + ":" + sid;
private static final String dbUser = "system";
private static final String dbPassword = "admin";

public static void main(String[] argc) 
{
	try 
	{
		selectRecordsFromTable();
	}
	catch (SQLException e) 
	{
		System.out.println(e.getMessage());
	}
}

private static void selectRecordsFromTable() throws SQLException 
{
	Connection connection = null;
	PreparedStatement prepareStmt = null;

	String selectQuery = "SELECT USER_ID, USERNAME FROM EMPLOYEE WHERE USER_ID = ?";

try 
{
	connection = getDBConnection();
	prepareStmt = connection.prepareStatement(selectQuery);
	prepareStmt.setInt(1, 1001);
	// execute select SQL stetement
	ResultSet rs = prepareStmt.executeQuery();

	while (rs.next()) 
	{ 
		String userid = rs.getString("USER_ID");
		String username = rs.getString("USERNAME");
		System.out.println("userid : " + userid);
		System.out.println("username : " + username);
       } 
}
catch (SQLException e) 
{
	System.err.println(e.getMessage());
} 
	
finally 
{
	if (prepareStmt != null) 
	{
		prepareStmt.close();
	}
	if (connection != null) 
	{
		connection.close();
	}
	}
}

private static Connection getDBConnection() 
{
	Connection dbConnection = null;
	try 
	{
		Class.forName(dbDriver);
	}
	
	catch (ClassNotFoundException e) 
	{
		System.err.println(e.getMessage());
	}

	try 
	{
	dbConnection = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
	return dbConnection;

	}
	catch (SQLException e) 
	{
		System.err.println("Db "+e.getMessage());
	}

	return dbConnection;
}
}

 

About Mohaideen Jamil


Am currently working as a Struts 2 Developer in a reputed IT Organisations. I can help you with teaching Core java and Struts 2. Follow me on Facebook or Google Plus. If you like my tutorials, consider making a donation to this charity, thanks.