import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class teade2 extends HttpServlet{
public void doGet(HttpServletRequest kysimus,
HttpServletResponse vastus)
throws IOException, ServletException{
String muuda=kysimus.getParameter("textmuut1");
String muuda2=kysimus.getParameter("textmuut2");
vastus.setContentType("text/plain");

PrintWriter valja=new PrintWriter(vastus.getWriter());
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=
DriverManager.getConnection("jdbc:odbc:board", "", "");
Statement st=cn.createStatement();

//String lause="UPDATE kingad set kogus=muudakogus+1;";
String lause="INSERT INTO foorum (text1,text2,ip) values('"+muuda+"', '"+muuda2+"', '"+kysimus.getRemoteHost()+"')";
st.executeUpdate(lause);
		

		
String lause1="SELECT text1, text2, aeg, ip FROM foorum;";
ResultSet rs=st.executeQuery(lause1);
rs.next();

//valja.println(+rs.getvarchar(
//"<table border=1><tr><td>Nimi<td>Teade<td>Aeg</td></tr>
//<tr><td>"textmuut1"<td>"textmuut2"<td>"kell"</td></tr></table>");

valja.println("<center><h2>Foorum</h2><table border=1><center><tr><td>Nimi<td>Teade<td>Aeg<td>IP</td></tr>");

while (rs.next()){
valja.println("<tr><td>"+rs.getString("text1")+" <td>"+rs.getString("text2")
+" <td>"+rs.getString("aeg")+" <td>"+rs.getString("ip")+"</td></tr>");

}
//valja.println("Teateid on kokku lisatud"+rs.getInt("text1")+" tükki.");
valja.println("</table></center>");
cn.close();
}catch(Exception viga){
valja.println("Viga andmebaasis!! " +viga);
}
}
}