Cacher is the code snippet organizer for pro developers

public void callStoredProcedure () throws SQLException {
		
		String sql = "call addNewCity(?, ?, ?, ?)";
		
		try (
		
				Connection conn = DB_Util.getConn(DB_Types.MYSQLDB);
		
				CallableStatement callStat = conn.prepareCall(sql);
				)
		{
		
		System.out.print("Enter City Name: ");
		callStat.setString(1, scanner.nextLine());
		
		System.out.print("Enter City Country Code: ");
		callStat.setString(2, scanner.nextLine());
		
		System.out.print("Enter City District: ");
		callStat.setString(3, scanner.nextLine());
		
		System.out.print("Enter City Population: ");
		callStat.setInt(4, scanner.nextInt());
		
		callStat.executeQuery();
		
		System.out.println("New City was added successfully !");
		}
		catch (SQLException e) {
			
			System.out.println("Error; " + e);
		}
	}