Retrieve Table Contents
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);
}
}
}
No comments:
Post a Comment