String sql = "SELECT * FROM Country where cid = \'"+cid+ "\'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next())
{
String Name = rs.getString(2);
int Population = rs.getInt(3);
int  Area = rs.getInt(4);
String Government = rs.getString(5);
String Capital = rs.getString(6);
float  CapLatitude = rs.getFloat(7);
float  CapLongitude = rs.getFloat(8);
ret = "CID" + "\t\t\t" + ":" +cid+"\n"
       +"Name" + "\t\t\t" + ":" +Name+"\n"
       +"Population" + "\t\t\t" + ":" + Population+"\n"
       +"Area" + "\t\t\t" + ":" + Area+"\n"
       +"Government" + "\t\t" + ":" + Government+"\n"
       +"Capital" + "\t\t\t" + ":" + Capital+"\n"
       +"CapLatitude" + "\t\t" + ":" + CapLatitude+"\n"
       +"CapLongitude" + "\t\t" + ":" + CapLongitude;

rs.close();