public MetropolisTableModel() {

		// construct column names
		colNames = new ArrayList<String>(
				Arrays.asList("Metropolis", "Continent", "Population"));
		
		// connection to database
		try {
			// make sure JDBC driver is loaded
			Class.forName("com.mysql.jdbc.Driver");
			
			// create connection between our account and the database
			con = DriverManager.getConnection
					("jdbc:mysql://" + server, account, password);
						
			Statement stmt = con.createStatement();
			stmt.executeQuery("USE " + database);
			rs = stmt.executeQuery("SELECT * FROM metropolises WHERE 1=2;");
					
		} catch (SQLException e){
			e.printStackTrace();
		} catch (ClassNotFoundException e){
			e.printStackTrace();
		}
	}