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

public class webiliides2 extends HttpServlet{

public void doGet(HttpServletRequest kysimus,
HttpServletResponse vastus)throws IOException, ServletException{

		String kinganr=kysimus.getParameter("kinganumber");
      String kingarv=kysimus.getParameter("kingaarv");
		vastus.setContentType("text/plain");
      PrintWriter valja=new PrintWriter(vastus.getWriter());


    
try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=
DriverManager.getConnection("jdbc:odbc:kingapoebaas", "", "");
Statement st=cn.createStatement();
String lause="SELECT kinganumber,kingaarv FROM kingatabel;";

ResultSet rs=st.executeQuery(lause);

while(rs.next()){

 int a=rs.getInt("kinganumber");
 int b=rs.getInt("kingaarv");

 valja.println ("Laos on "+a+" number kingi "+b+" paari");
}
cn.close();

}catch(Exception viga){
			  valja.println("Probleem andmebaasiga: "+viga);
			  }
}

}