import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class kursused extends HttpServlet{
public void doGet(HttpServletRequest kysimus,
    HttpServletResponse vastus)throws IOException, ServletException{

 try{   
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection cn=
  DriverManager.getConnection("jdbc:odbc:kursused", "", "");
  Statement st=cn.createStatement();
  String lause="INSERT INTO teated (Nimi,Perekonnanimi,Kursus) values ('"+kysimus.getParameter("nimi1")+
                                    "', '"+kysimus.getParameter("nimi2")+ "', '"+kysimus.getParameter("kursus1")+"');";   
  st.executeUpdate(lause);

String lause1="SELECT Nimi, Perekonnanimi, Kursus, Aeg FROM teated;";
ResultSet rs=st.executeQuery(lause1);
rs.next();

PrintWriter valja=vastus.getWriter();
valja.println("Registreerimine ơnnestus. Tudeng <b>"+kysimus.getParameter("nimi1")+"</b> <b>"+kysimus.getParameter("nimi2")+"</b> registreeriti <b>"+kysimus.getParameter("kursus1")+"</b> kursusele.");
valja.println("<center><h2>Loetelu</h2><table border=1><tr><td bgcolor=#999999><center><b>Nimi</b></center>");
valja.println("<td bgcolor=#999999><center><b>Perekonnanimi</b></center>");
valja.println("<td bgcolor=#999999><center><b>Kursus</b></center></td>");
valja.println("<td bgcolor=#999999><center><b>Registreerimise aeg</b></center></td></tr>");

while (rs.next()){
valja.println("<tr><td bgcolor=#CCCCCC>"+rs.getString("Nimi")+"<td bgcolor=#CCCCCC>"+rs.getString("Perekonnanimi")+"<td bgcolor=#CCCCCC>"+rs.getString("Kursus")+"<td bgcolor=#CCCCCC>"+rs.getString("Aeg")+"</td></tr>");
                 }
valja.println("</table></center>");

  
  
  cn.close(); 
}catch(Exception viga){
   vastus.getWriter().println(viga);
}
}
}