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 nrpytania;
    private int prodpowiedz;
    private int odpowiedz;

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
        nrpytania = 1;
        prodpowiedz = 1;
    }

    /**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("<P>Pytanie numer:" + nrpytania + "<P>");
            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=\"formularz\" 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>");
                prodpowiedz = Integer.parseInt(rset.getString("ODPOWIEDZ"));
            }
            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();
        odpowiedz = Integer.parseInt(request.getParameter("numer"));
        out.println("<html>");
        out.println("<head><title>s1</title></head>");
        out.println("<body>");


        if (odpowiedz == prodpowiedz) {
            nrpytania++;
            if (nrpytania == 4) {
                out.println("<p>Koniec Gry. Wygrales Milion!</p>");
            } else {
                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=" + 
                                          nrpytania);
                    out.println("<P>Pytanie numer:" + nrpytania + "<P>");
                    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=\"formularz\" 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>");
                        prodpowiedz = 
                                Integer.parseInt(rset.getString("ODPOWIEDZ"));
                    }
                    out.println("</table>");
                } catch (SQLException e) {
                    out.println("Wystapil blad: " + e);
                }
            }
        } else {
            out.println("<p>Z&#322;a odpowiedz</p>");
            out.println("<p>Prawidlowa odpowiedz to odpowiedz numer:" + 
                        prodpowiedz + "</p>");
            out.println("<p><a href=\"s1\">Zacznij od poczatku</a></p>");
            nrpytania = 1;
        }
        out.println("</body></html>");
        out.close();
    }
}