CodesJava

Easy learning with example program codes

JDBC Statement select records example


The JDBC statement is used to execute queries against the database. Let us study JDBC Statement by select records example.

Example:

JDBCTest.java

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import com.codesjava.util.JDBCUtil;
 
/**
 * This class is used to select a list of records from DB table.
 * @author codesjava
 */
public class JDBCTest {
	public static void main(String args[]){
		Connection conn = null;
		Statement statement = null;
 
		String query = "select EMPLOYEE_ID, NAME from EMPLOYEE";
 
		try{			
			//get connection
			conn = JDBCUtil.getConnection();
 
			//create statement
			statement = conn.createStatement();
 
			//execute query
			ResultSet rs = statement.executeQuery(query);
			while (rs.next()) {				 
			   String empId = rs.getString("EMPLOYEE_ID");
			   String empName = rs.getString("NAME");
 
			   System.out.println("EmpId : " + empId);
			   System.out.println("EmpName : " + empName); 
			}
 
			//close connection
			statement.close();
			conn.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}	
}

JDBCUtil.java

import java.sql.Connection;
import java.sql.DriverManager;
 
/**
 * This is a utility class for JDBC connection.
 * @author codesjava
 */
public class JDBCUtil {
	//JDBC and database properties.
	private static final String DB_DRIVER = 
		           "oracle.jdbc.driver.OracleDriver";
	private static final String DB_URL = 
		        "jdbc:oracle:thin:@localhost:1521:XE";
	private static final String DB_USERNAME = "system";
	private static final String DB_PASSWORD = "oracle";
 
	public static Connection getConnection(){
		Connection conn = null;
		try{
			//Register the JDBC driver
			Class.forName(DB_DRIVER);
 
			//Open the connection
			conn = DriverManager.
			getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
 
			if(conn != null){
			   System.out.println("Successfully connected.");
			}else{
			   System.out.println("Failed to connect.");
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}	
}

Output:

Successfully connected.
EmpId : 7
EmpName : Harish Yadav
EmpId : 2
EmpName : vivek
EmpId : 3
EmpName : Himanshu
EmpId : 1
EmpName : Bharat
EmpId : 4
EmpName : Bharti
EmpId : 8
EmpName : Abhishek Rathor
EmpId : 11
EmpName : Harish Kansal
EmpId : 12
EmpName : Vivek Solenki

Download this example.
 
Next Topic: JDBC Statement deletes a record example.
Previous Topic: JDBC Statement updates a record example.

Related Topics:

JDBC Statement creates a table example.
JDBC Statement inserts a record example.
JDBC Statement updates a record example.
JDBC Statement select records example.
JDBC Statement deletes a record example.
JDBC Statement batch update example.

 

Sign Up/ Sign In
Ask a Question


Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at hr@codesjava.com.

Development

We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on hr@codesjava.com.

Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki