JDBC Fetch

In this Tutorial we want to describe you an example from Jdbc Fetch.

JDBC Fetch

JDBC Fetch

     

The Tutorial describe you a code that fetch the elements from a database. In this Tutorial we want to describe you an example from Jdbc Fetch. In this program code, the System.println print the fetch data from database. The code illustrates a class Jdbc Fetch, Inside the main method we have the list of steps to be followed - 

The first step is to import a java.sql.* ,this provides you a network interface helps you in communicating between the front end Java application and the backend Loading a driver  follows the next step, by calling a class.forName ( ) with driver class passed as argument.

   DriverManger.getConnection( ) :This method return you a connection object, This method is used to built a connection between the url and database. The createStatement ( ) return you a statement object, this statement is used to execute and send SQL query in the database.

The Statement object call execute Query ( ),The method is used to fetch  the record set from employee table, that accept sql passed as an argument.

   Finally on execution the println print the element from database using getString ( )  from the record set.
  getString( ):The method return and retrieves the value of the specified column name in the current row of this  object as a String in the Java programming language.

  JdbcFetch.java

import java.sql.*;



public class JdbcFetch {



  public static void main(String args[]) {

  Connection con = null;

  Statement st = null;

  ResultSet rs = null;



  String url = "jdbc:mysql://localhost:3306/";

  String db = "komal";

  String driver = "com.mysql.jdbc.Driver";

  String user = "root";

  String pass = "root";



  try {

  Class.forName(driver);

  con = DriverManager.getConnection(url + db, user, pass);

  con.setAutoCommit(false);

  st = con.createStatement();



  String sql = "select * from employees";

  rs = st.executeQuery(sql);



  while (rs.next()) {

  System.out.print(rs.getString(1) + " \t");

  System.out.print(rs.getString(2) + "  \t");

  System.out.print(rs.getString(3)+ " \t");

  System.out.println(rs.getString(4) );

  }

  } catch (Exception e) {

  System.out.println(e);

  }

  }

}

Output

Girish     	Tewari      	Rohini       	Indian
Komal     	Singh      	Rohini       	Indian
Sandeep     	kumar      	Rohini       	Indian
Amit     	Singh      	Rohini       	Indian
Girish     	Tewari      	Rohini       	Indian
Darshan     	Tewari      	Rohini       	Indian

Download code

Tutorials

  1. First Step towards JDBC
  2. Accessing the Database from Servlet
  3. Accessing Databases Using Java and JDBC
  4. First Step towards JDBC!
  5. First Step towards JDBC!
  6. Accessing Database from servlets through JDBC!
  7. JDBC, JDBC Tutorial, JDBC Tutorials
  8. What is JDBC?
  9. Product Components of JDBC
  10. Understanding the JDBC Architecture
  11. JDBC Driver and Its Types
  12. JDBC Versions
  13. Features of JDBC 3.0 API
  14. Features of JDBC 4.0
  15. Difference between JDBC 3.0 & JDBC 4.0
  16. Relational Database Concepts
  17. Understanding Common SQL statements
  18. Important JDBC Concepts
  19. Introduction to java.sql package
  20. Driver Manager Class
  21. Understanding Data Source
  22. Understanding Connection Object
  23. Mapping MySQL Data Types in Java
  24. Connecting to a MySQL Database in Java
  25. Creating a Database in MySQL
  26. Creating a Database Table
  27. Creating a MySQL Database Table to store Java Types
  28. Description of Database Table
  29. Deleting a Table from Database
  30. Retrieving Tables from a Database
  31. Inserting values in MySQL database table
  32. Retrieving All Rows from a Database Table
  33. Adding a New Column Name in Database Table
  34. Change Column Name of a Table
  35. Make Unique Column in Database Table
  36. Remove Unique Column in Database Table
  37. Arrange a Column of Database Table
  38. Arrange a Column of Database Table
  39. Sum of Column in a Database Table
  40. Deleting All Rows from a Database Table