Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(SELECT COF_NAME, PRICE FROM COFFEES");
while (rs .next() )
{
//Iam assuming there are 3 columns in the table.
System.out.println ( rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}

//don't forget to close the resultset, statement & connection

rs.close(); //First
stmt.close(); //Second
con.close(); //Last
System.out.println("You are done");

Connection con=null;
ResultSet rs=null;
//write your own code for Making connection to ur database
String Query="Select * from emp";
try
{
Statement stmt=con.CreateStatement(
rs=stmt.executeQury(Query);
while(rs.next()
{
System.out.println(rs.getString(1)+" "+rs.getString(2));
stmt.close();
rs.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question