package dbinoutstate;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.ArrayList;

public class Db {

	private static final String DRIVER = "com.mysql.jdbc.Driver";
	private static final String URL = "jdbc:mysql://localhost/mysql";
	private static final String USERID = "root";

	ArrayList<String> al1 = new ArrayList<String>();
	ArrayList<String> al2 = new ArrayList<String>();

	public Db() {

		Input i = new Input();
		String query = i.setQuery();
		Connection verbindung = null;
		Statement abfrage = null;
		try {
			Class.forName(DRIVER);
			verbindung = DriverManager.getConnection(URL, USERID, "");
			abfrage = verbindung.createStatement();
			ResultSet daten = abfrage.executeQuery(query);
			ResultSetMetaData metaDaten = daten.getMetaData();
			System.out.printf("%-25s %-30s \n", metaDaten.getColumnName(1),
					metaDaten.getColumnName(2));
			while (daten.next())
				 System.out.printf("%-25s %-30s \n", daten.getString(1), daten.getString(2));
				al1.add(daten.getString(1));
				al2.add(daten.getString(2));

			} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {

				abfrage.close();
				verbindung.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

	}
}