import java.sql.*;
import java.io.FileInputStream;
import java.util.Properties;
class jdbcCountryPop {
  public static void main (String args [])
   throws Exception {
 DriverManager.registerDriver(new
         oracle.jdbc.driver.OracleDriver());
 Properties props = new Properties();
 props.load(new FileInputStream("conn.props"));
 Connection conn = DriverManager
     .getConnection(props.getProperty("url"), props);
 PreparedStatement giveCountryPop =
   conn.prepareStatement(
      "SELECT Population FROM Country WHERE Code = ?");
 giveCountryPop.setString(1,args[0]);
 ResultSet rset = giveCountryPop.executeQuery();
 if(rset.next()) {
  int pop = rset.getInt(1);
  if (rset.wasNull()) System.out.println("null");
  else System.out.println(pop);  }
 else System.out.println("No existing country code");
 conn.close();
}}