import java.sql.*;
public class AutodeNimekiri{
  public static void main(String[] argumendid) throws Exception{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection cn=DriverManager.getConnection("jdbc:odbc:yhendus1");
    Statement st=cn.createStatement();
    ResultSet rs=st.executeQuery("select * from autod");
    while(rs.next()){
      System.out.println(rs.getString("mark")+":"+rs.getInt("aasta"));
    }
    cn.close();
  }
}