Scribd Logo
Upload

Welcome to Scribd!

  • 23 views

    Problem Description:: How To Retrieve Contents of A Table Using JDBC Connection?

    Uploaded by

    dasre
    This document provides a Java code sample to retrieve and display the contents of a database table using JDBC. The code imports necessary classes, connects to a Derby database, executes a query to select all records from an employee table, and uses ResultSet methods to retrieve and print the id, name, and job fields of each record.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Problem Description:: How To Retrieve Contents of A Table Using JDBC Connection?

    Uploaded by

    dasre
    23 views1 page
    This document provides a Java code sample to retrieve and display the contents of a database table using JDBC. The code imports necessary classes, connects to a Derby database, executes a query to select all records from an employee table, and uses ResultSet methods to retrieve and print the id, name, and job fields of each record.

    Original Description:

    free

    Original Title

    205

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a Java code sample to retrieve and display the contents of a database table using JDBC. The code imports necessary classes, connects to a Derby database, executes a query to select all records from an employee table, and uses ResultSet methods to retrieve and print the id, name, and job fields of each record.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    23 views1 page

    Problem Description:: How To Retrieve Contents of A Table Using JDBC Connection?

    Uploaded by

    dasre
    This document provides a Java code sample to retrieve and display the contents of a database table using JDBC. The code imports necessary classes, connects to a Derby database, executes a query to select all records from an employee table, and uses ResultSet methods to retrieve and print the id, name, and job fields of each record.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    Java Examples - Retrieve Table Contents

    1 of 1

    http://www.tutorialspoint.com/cgi-bin/printpage.cgi

    http://www.tutorialspoint.com/javaexamples/jdbc_resultset.htm

    Copyright tutorialspoint.com

    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
    1
    2

    name
    alok
    ravi

    job
    trainee
    trainee

    21-Jun-16 4:31 PM

    You might also like