//修改自Example11_3.java

import javax.naming.Name;
import java.sql.*;
public class MiddleEastSum{
    public static void main(String args[]) {
        Connection con;
        Statement sql;
        ResultSet rs;
        con = GetDBConnection.connectDB("world","root","");
        if(con == null ) return;
        String sqlStr =
                "select * from country where Region Like 'Middle East'";
        long sum = 0;
        try {
            sql=con.createStatement();
            rs = sql.executeQuery(sqlStr);
            while(rs.next()) {
                int Population=rs.getInt(7);
                sum=sum+Population;
            }
            System.out.printf("世界上的所有中东国家的总人口为："+sum);
            con.close();
        }
        catch(SQLException e) {
            System.out.println(e);
        }
    }
}