package wbs.jdbc;


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

public class ResultSetDemo {
	public static void main(String[] args) {
		String url = "jdbc:mysql://sql513.your-server.de/wbs_db1?useUnicode=yes&characterEncoding=UTF-8&useSSL=false";
		String user = "wbsdatenbank";
		String password = "Wbsdatenbank1";
		String sql = "SELECT * FROM buch";

		String isbn;
		String autor;
		String titel;
		double preis;

		try (Connection connection = DriverManager.getConnection(url, user, password);
				Statement statement = connection.createStatement();
				ResultSet rs = statement.executeQuery(sql)) {
			while (rs.next()) {
				isbn = rs.getString("isbn");
				autor = rs.getString("autor");
				titel = rs.getString("titel");
				preis = rs.getDouble("preis");

				//System.out.println(resultSet.getInt("id") + " -> " + resultSet.getString("data"));
				System.out.printf("%-20s%-30s%-40s%8.2f%n", isbn, autor, titel, preis);
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}
}