Web | This Site

Java Basics Examples
Java Tutorial
Java Useful Resources
Selected Reading
© 2011 TutorialsPoint.COM

| Home |  | References |  | Discussion Forums |  | About TP

# Java Examples - Retrieve Table Contents

## Problem Description:

How to retrieve contents of a table using JDBC connection?

## Solution:

Following example uses getString,getInt & executeQuery methods to fetch & display the contents of the table.

    import java.sql.*;

    public class jdbcResultSet {
       public static void main(String[] args) {
          try {
             Class.forName("org.apache.derby.jdbc.ClientDriver");
          }
          catch(ClassNotFoundException e) {
             System.out.println("Class not found "+ e);
          }
          try {
             Connection con = DriverManager.getConnection
             ("jdbc:derby://localhost:1527/testDb","username",
             "password");
             Statement stmt = con.createStatement();
             ResultSet rs = stmt.executeQuery
             ("SELECT * FROM employee");
             System.out.println("id  name    job");
             while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                String job = rs.getString("job");
                System.out.println(id+"   "+name+"    "+job);
             }
          }
          catch(SQLException e){
             System.out.println("SQL exception occured" + e);
          }
       }
    }

## Result:

The above code sample will produce the following result.The result may vary.

    id  name   job
    1   alok   trainee
    2   ravi   trainee

Advertisement

Online Image Processing

Indian Baby Names