import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Autodeloetelu extends HttpServlet{
   public void doGet(HttpServletRequest kysimus, HttpServletResponse vastus)
                       throws IOException, ServletException{
        PrintWriter valjund=vastus.getWriter();
        try{
           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()){
              valjund.println(rs.getString("mark"));
           }
           cn.close();
        } catch(Exception ex){
           ex.printStackTrace(valjund);
        }
        valjund.close();                    
   }
}