20165305 Suzhenrong "Java program Design" in the eighth week of the test complement

1. Download the world.sql.zip in the attachment, reference Http://www.cnblogs.com/rocedu/p/6371315.html#SECDB, import World.sql, submit the import successfully

2. Write a program that lists all cities in the world that exceed the "seven digits of your study number and bring the last home to the highest level, with a maximum of 0 o'clock 1" (for example, study number 20165201, more than 3016520, number 20165208, more than 1016520), and submit the results of the Operation 3. Write a program that queries the total population of all Middle Eastern countries in the world

4. Writing procedures to inquire the world's longest and shortest countries

20165305 Suzhenrong "Java program Design" in the eighth week of the test complement