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

public class Sample {

    public static void main(String[] args) {
	try {
	    // load the DB2 Driver
	    Class.forName("com.ibm.db2.jcc.DB2Driver");
            
	    // establish a connection to DB2
 String dbserver = "salz.is.informatik.uni-duisburg.de";
	    String dbport   = "50015";
	    String database = "almanach";

	    // Verbindung zur DB aufbauen
	    // Passwort wird in der Praktikumssitzung ausgegeben
            Connection db2Conn = DriverManager.getConnection
		("jdbc:db2://"+dbserver+":"+dbport+"/"+database,
		 "dbps0515","********");

            // use a statement to gather data from the database
            Statement st = db2Conn.createStatement();
            String myQuery = "SELECT * FROM LAND"; 

	    // execute the query
            ResultSet resultSet = st.executeQuery(myQuery); 

            // cycle through the resulSet and display what was grabbed
            while (resultSet.next()) {
		String name = resultSet.getString("name");
		String code = resultSet.getString("code");
		System.out.println("Land: " + name);
		System.out.println("Landescode: " + code);
		System.out.println("-------------------------------");
	    }
	    
	    // clean up resources
	    resultSet.close();
	    st.close();
	    db2Conn.close();
	}
	catch (ClassNotFoundException e) {
	    e.printStackTrace();
	}
	catch (SQLException e) {
	    e.printStackTrace();
	}
    }
}