package servl;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import oracle.jdbc.*;
import oracle.sql.*;

public class s1 extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=windows-1250";
    private int numer;

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
        int numer=0;
    }

    /**Process the HTTP doGet request.
     */
    public void doGet(HttpServletRequest request, 
                      HttpServletResponse response) throws ServletException, 
                                                           IOException {
        
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<head><title>s1</title></head>");
        out.println("<body>");
        try {
                    DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
                    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@dblab.cs.put.poznan.pl:1521:dblab10g", "sum52383", "tomek");
                    Statement stmt = conn.createStatement();
                    ResultSet rset = stmt.executeQuery ("SELECT * FROM pytania WHERE numer=1");
                    out.println("<table width=\"200\" border=\"0\" bgcolor=\"#CCCC00\"\">");
                    while (rset.next()) {
                        out.println("<tr>");
                        out.println("<td colspan=2>"+rset.getString("TRESC")+"</td>");
                        out.println("</tr>");
                        out.println("<tr>");
                        out.println("<td>1.</td>");
                        out.println("<td>"+rset.getString("WYBOR1")+"</td>");
                        out.println("</tr>");
                        out.println("<tr>");
                        out.println("<td>2.</td>");
                        out.println("<td>"+rset.getString("WYBOR2")+"</td>");
                        out.println("</tr>");
                        out.println("<tr>");
                        out.println("<td>3.</td>");
                        out.println("<td>"+rset.getString("WYBOR3")+"</td>");
                        out.println("</tr>");
                        out.println("<tr>");
                        out.println("<td>4.</td>");
                        out.println("<td>"+rset.getString("WYBOR4")+"</td>");
                        out.println("</tr>");
                        out.println("<tr>");
                        out.println("<td colspan=2>Podaj numer odpowiedzi </td>");
                        out.println("</tr>");
                        out.println("<tr>");
                        out.println("<td colspan=2>");
                        out.println("<form name=\"login_form\" action=\"s1\" method=\"post\">");
                        out.println("      <p>");
                        out.println("        numer:<input type=\"text\" name=\"numer\" maxlength=\"20\" size=\"20\"/>");
                        out.println("      </p>");
                        out.println("      <p>");
                        out.println("        <input type=\"submit\" name=\"Wyslij\" value=\"wyslij\"/>");
                        out.println("      </p>");
                        out.println("    </form>");
                        out.println("</td>");
                        out.println("</tr>");
                    }
                    out.println("</table>");
                } catch (SQLException e) {
                    out.println("Wystapil blad: "+e);
                }
        out.println("</body></html>");
        out.close();
    }

    /**Process the HTTP doPost request.
     */
    public void doPost(HttpServletRequest request, 
                       HttpServletResponse response) throws ServletException, 
                                                            IOException {
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<head><title>s1</title></head>");
        out.println("<body>");
        out.println(numer);
        out.println("<p>The servlet has received a POST. This is the reply.</p>");
        out.println("</body></html>");
        out.close();
    }
}