Copyright © tutorialspoint.com
How to retrieve contents of a table using JDBC connection?
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); } } } |
The above code sample will produce the following result.The result may vary.
id name job 1 alok trainee 2 ravi trainee |
Copyright © tutorialspoint.com