import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Vk {

	public static void main(String[] args) {
		readPers("jdbc:db2://DEINEVERBINDUNGVONDEINERBEHINDERTENDB/wdb:user=;password=;");

	}
	public static void readPers(String url) {
		try {
			Connection con = DriverManager.getConnection(url);
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT persnr, name, vorname, gebdat FROM vkbeisp.person");

			while(rs.next()) {
				long persnr = rs.getLong("PERSNR");
				String name = rs.getString("NAME");
				String vorname = rs.getString("VORNAME");
				java.util.Date gebdat = rs.getDate("GEBDAT");
				System.out.printf("%10d %-10s %-10s %1s %10s", persnr,name,vorname,gebdat);
			}
			rs.close();
			con.commit();
			con.close();
			stmt.close();

		} catch (SQLException e) {
			e.getStackTrace();
		}
	}

}