import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class baas extends HttpServlet{
  public void doGet(HttpServletRequest kysimus,
                    HttpServletResponse vastus)
              throws IOException, ServletException{
    vastus.setContentType("text/html");
    PrintWriter valja=vastus.getWriter();
    
   String a=kysimus.getParameter("submit");
   try{ 
    ////
  /*if(a!=null){ 
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection cn2=DriverManager.getConnection("jdbc:odbc:poebaas", "", "");
     Statement st2=cn2.createStatement();
     ResultSet rs2=st2.executeQuery("INSERT into isik (eesnimi, perenimi, isikukood, kursus) values("+kysimus.getParameter("eesnimi")+","+kysimus.getParameter("perenimi")+","+kysimus.getParameter("isikukood")+""+kysimus.getParameter("kursus")+");
     cn2.close();    
    }*/
    ////

    
       
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection cn=DriverManager.getConnection("jdbc:odbc:poebaas", "", "");
     Statement st=cn.createStatement();
     ResultSet rs=st.executeQuery("SELECT * FROM isik");
     valja.println("<table border='1' cellpadding='2' cellspacing='2'>");
     valja.println("<tr><td>Eesnimi</td><td>Perekonnanimi</td><td>kursus</td><td>Isikukood</td></tr>");
     while(rs.next()){
     valja.println("<tr><td>"+rs.getString("eesnimi")+"</td><td>"+rs.getString("perenimi")+"</td><td>"+rs.getString("kursus")+"</td><td>"+rs.getString("isikukood")+"</td></tr>");
  }
    valja.println("</table>");
     cn.close();
    
    valja.println("<br><br>Otsing<form><br>kursus<br><select name='nimi'>");
    
    
    ////
    
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection cn1=DriverManager.getConnection("jdbc:odbc:poebaas", "", "");
     Statement st1=cn1.createStatement();
     ResultSet rs1=st1.executeQuery("SELECT kursus FROM isik");
     valja.println("<option>--- ---</option>");
     while(rs1.next()){
     valja.println("<option>"+rs1.getString("kursus")+"</option>");
  }
    valja.println("</table>");
    // cn.close();    
    
      String kursus=kysimus.getParameter("nimi");
      String eesnimi=kysimus.getParameter("eesnimi1");
      String perenimi=kysimus.getParameter("perenimi1");
      String vastused="";
    valja.println("</select><br><br>"+
    "Eesnimi<br><input type='text' name='eesnimi1'><br><br>"+
    "Perenimi<br><input type='text' name='perenimi1'><br><br>"+
    "<input type='submit' name='submit' value='Otsi'></form>");
    String b=kysimus.getParameter("submit");
    if(b!=null){ 
     valja.println("<table border='1' cellpadding='2' cellspacing='2'>");
    ResultSet rs2=st1.executeQuery("SELECT * FROM isik WHERE kursus='"+kursus+"' OR perenimi='"+perenimi+"' OR eesnimi='"+eesnimi+"'");

     valja.println("<tr><td>Eesnimi</td><td>Perekonnanimi</td><td>kursus</td><td>Isikukood</td></tr>");
     
       while(rs2.next()){
        valja.println("<tr><td>"+rs2.getString("eesnimi")+"</td><td>"+rs2.getString("perenimi")+"</td><td>"+rs2.getString("kursus")+"</td><td>"+rs2.getString("isikukood")+"</td></tr>");
  }
    valja.println("</table>");
     cn.close();
     
}
  
    } catch(Exception e){
    	e.printStackTrace(valja);
    	}    
    
     
    
	}
}