import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class hinnang 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:teated_uus", "", "");
  Statement st=cn.createStatement();
  String lause="INSERT INTO teated (Nimi,Kommentaar,Hinne) values ('"+kysimus.getParameter("nimi1")+
                                    "', '"+kysimus.getParameter("kommentaar1")+ "', '"+kysimus.getParameter("hinne1")+"');";   
  st.executeUpdate(lause);

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

PrintWriter valja=vastus.getWriter();
valja.println("<center><h2>Hinnangud</h2><table border=1><tr><td bgcolor=#999999><center><b>Nimi</b></center><td bgcolor=#999999><center><b>Kommentaar</b></center><td bgcolor=#999999><center><b>Hinne</b></center></td><td bgcolor=#999999><center><b>Lisamise aeg</b></center></td></tr>");

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

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