Select Query

package jdbc;

import java.sql.*;

public class SelectQuery
{
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
String driverClassName="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="hr";
String password="hr";
String query ="select * from COUNTRIES";
int count=0;
Class.forName(driverClassName);
Connection con = DriverManager.getConnection(url, user, password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
System.out.println(rs.getString(1)+"..."+rs.getString(2)+"..."+rs.getInt(3));
count++;
}
System.out.println("No. of Rows = "+count);
con.close();
}

}