Project issue

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class TableReader {

	static Connection getConnection() {
		Connection connection = null;

		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			connection = DriverManager.getConnection(
					"jdbc:mysql://184.154.73.113/davidlno_StockHistory?" + "user=davidlno_student&password=ez24get!");

		} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			System.out.println("SQLException: " + e.getMessage());
			System.out.println("SQLState: " + e.getSQLState());
			System.out.println("VendorError: " + e.getErrorCode());
			e.printStackTrace();
		}

		return connection;
	}

	static void getAllTickers() {
		Connection connection = getConnection();
		String query = "select ticker from TickerHistory group by ticker order by ticker";

		try {
			Statement statement = connection.createStatement();
			ResultSet rs = statement.executeQuery(query);

			while (rs.next()) {

				String ticker = rs.getString("Ticker");
				System.out.print(ticker + ", ");
			}

			rs.close();
			statement.close();
			connection.close();

			rs = null;
			statement = null;
			connection = null;

		} catch (SQLException e) {
			System.out.println("SQLException: " + e.getMessage());
			System.out.println("SQLState: " + e.getSQLState());
			System.out.println("VendorError: " + e.getErrorCode());

		}
	}

	static void recentData() {

		String line;
		Scanner scann = new Scanner(System.in);
		System.out.println("Enter a valid ticker: ");
		line = scann.nextLine();

		Connection connection = getConnection();
		String query = "select * from TickerHistory where Ticker = 'line'";

		try {
			Statement statement = connection.createStatement();
			ResultSet rs = statement.executeQuery(query);

			int counter = 0;
			while (rs.next()) {
				String ticker = rs.getString("Ticker");
				String companyName = rs.getString("CompanyName");
				int volume = rs.getInt("Volume");
				double openPrice = rs.getDouble("OpenPrice");
				double highPrice = rs.getDouble("HighPrice");
				double lowPrice = rs.getDouble("LowPrice");
				double closePrice = rs.getDouble("ClosePrice");

				counter++;
				System.out.println(counter + "  " + ticker + "  " + companyName + "  Volume: " + volume);
				System.out.println("Open:   " + openPrice);
				System.out.println("High:   " + highPrice);
				System.out.println("Low:    " + lowPrice);
				System.out.println("Close:  " + closePrice);
			}
			scann.close();
			rs.close();
			statement.close();
			connection.close();

			rs = null;
			statement = null;
			connection = null;

		} catch (SQLException e) {
			System.out.println("SQLException: " + e.getMessage());
			System.out.println("SQLState: " + e.getSQLState());
			System.out.println("VendorError: " + e.getErrorCode());

		}
	}

	static void closePrice() {
		String line;
		Scanner scann = new Scanner(System.in);
		System.out.println("Enter a valid ticker: ");
		line = scann.nextLine();

		Connection connection = getConnection();
		String query = "select HistoryDate and Ticker and HighPrice and ClosePrice from TickerHistory order by HighPrice where Ticker = 'line'";

		try {
			Statement statement = connection.createStatement();
			ResultSet rs = statement.executeQuery(query);

			while (rs.next()) {
				for (int i = 1; i > 1; i++) {
					double high = rs.getDouble("HighPrice");
					double close = rs.getDouble("ClosePrice");
					String date = rs.getString("HistoryDate");
					System.out.println("High Price: " + high);
					System.out.println("2017 03 10  " + close);
				}
			}

			rs.close();
			statement.close();
			connection.close();

			rs = null;
			statement = null;
			connection = null;

		} catch (SQLException e) {
			System.out.println("SQLException: " + e.getMessage());
			System.out.println("SQLState: " + e.getSQLState());
			System.out.println("VendorError: " + e.getErrorCode());

		}
	}

	static void currentDate() {
		String date;
		Scanner scan = new Scanner(System.in);
		System.out.println("Enter a valid Date (yyyy-mm-dd): ");
		date = scan.nextLine();

		Connection connection = getConnection();
		String query = "select Ticker and Volume from TickerHistory where HistoryDate = 'date' order by Volume desc limit 5";

		try {
			Statement statement = connection.createStatement();
			ResultSet rs = statement.executeQuery(query);

			while (rs.next()) {

				String ticker = rs.getString("Ticker");
				int volume = rs.getInt("Volume");
				System.out.print(ticker + "     " + volume);
			}

			rs.close();
			statement.close();
			connection.close();

			rs = null;
			statement = null;
			connection = null;

		} catch (SQLException e) {
			System.out.println("SQLException: " + e.getMessage());
			System.out.println("SQLState: " + e.getSQLState());
			System.out.println("VendorError: " + e.getErrorCode());

		}
	}

	public static void main(String[] args) {

		String line = "";
		Scanner scan = new Scanner(System.in);
		Scanner scanin = new Scanner(System.in);
		do {
			System.out.println("");
			System.out.println("");
			System.out.println("----------Stock Reporting Menu--------------");
			System.out.println(" ");
			System.out.println("");
			System.out.println("");
			System.out.println("MENU OPTIONS:");
			System.out.println("1. List all tickers");
			System.out.println("2. Display most recent data for ticker");
			System.out.println("3. Display high and current close price for ticker");
			System.out.println("4. Display top five active tickers for date");
			System.out.println("");
			System.out.print("Select number or type quit:");

			line = scanin.nextLine();

			if (line.equals("1")) {
				getAllTickers();
			} else if (line.equals("2")) {
				recentData();
			} else if (line.equals("3")) {
				closePrice();
			} else if (line.equals("4")) {
				currentDate();
			}

		} while (!line.equalsIgnoreCase("quit"));
		scanin.close();
	}

}