Untitled

import java.io.*;
import java.util.Arrays;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.*;
import javax.servlet.http.*;


public class Lotto extends HttpServlet {

    private Connection connection;

    public void doGet(HttpServletRequest req, HttpServletResponse res)
            throws ServletException, IOException {
        PrintWriter out = res.getWriter();
res.setContentType("text/html");

String num1 = req.getParameter("num_1");
String num2 = req.getParameter("num_2");
String num3 = req.getParameter("num_3");
String num4 = req.getParameter("num_4");
String num5 = req.getParameter("num_5");
String num6 = req.getParameter("num_6");

int number1 = Integer.parseInt(num1);
int number2 = Integer.parseInt(num2);
int number3 = Integer.parseInt(num3);
int number4 = Integer.parseInt(num4);
int number5 = Integer.parseInt(num5);
int number6 = Integer.parseInt(num6);

int[] numbers = {number1, number2, number3, number4, number5, number6};

Arrays.sort(numbers);

boolean duplicates=false;
for (int j=0;j<numbers.length;j++){
for (int k=j+1;k<numbers.length;k++){
if (numbers[k] == numbers[j]){
duplicates=true;
}else{
duplicates=false;
}
}
}


for (int i : numbers){
if (i <= 0 && i >= 43){

out.println("<HTML>");
out.println("<HEAD><TITLE>You have " + "MISTAKE" + "</TITLE></HEAD>");
out.println("<BODY>");
out.println("Your numbers should from 1 to 42");
out.println("</BODY></HTML>");
System.out.println("Your numbers should from 1 to 42");
}
}

if(duplicates == true){

out.println("<HTML>");
out.println("<HEAD><TITLE>You have " + "MISTAKE" + "</TITLE></HEAD>");
out.println("<BODY>");
out.println("Your numbers should be unique!");
out.println("</BODY></HTML>");
System.out.println("Your numbers should be unique!");
}
else{
//вот здесь надо начать чтобы база данных отобразилась

  }

//INSERT DATA INTO DATABASE
try (PreparedStatement createNum = connection.prepareStatement("INSERT into dt354jdbc (num1, num2, num3, num4, num5, num6)" +
        " VALUES (?, ?, ?, ?, ?, ?)")) {
     createNum.setInt(1, 2);
     createNum.setInt(2, 22);
     createNum.setInt(3, 24);
     createNum.setInt(4, 5);
     createNum.setInt(5, 6);
     createNum.setInt(6, 18);
    int rowsUpdated = createNum.executeUpdate();
    createNum.close();

} catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}

}


    public Lotto() throws Exception
    //Exception thrown here to unclutter code below. Try Catches should be used in full solution.
        {

        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Class Loaded....");
            try {
                System.out.println("IN THE TRY BLOCK");
                connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/dt354jdbc?"+"user=root&password=root");
                System.out.println("Connected to the database....");
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();

        }
        //SELECT DATA FROM DATABASE
        Statement select = connection.createStatement();
        ResultSet rs = select.executeQuery("SELECT * FROM numbers");
        while (rs.next()) {
            System.out.println("Column 1 values :"+ rs.getInt(1));
            System.out.println("Column 2 values :" +rs.getInt(2));
            System.out.println("Column 2 values :" +rs.getInt(3));
            System.out.println("Column 2 values :" +rs.getInt(4));
            System.out.println("Column 2 values :" +rs.getInt(5));
            System.out.println("Column 2 values :" +rs.getInt(6));

            HttpServletRequest res = null;
            PrintWriter out = ((ServletResponse) res).getWriter();
            out.println("<HTML>");
            out.println("<HEAD><TITLE>Data:" + "</TITLE></HEAD>");
            out.println("<BODY>");
            out.println("Value 1: " + rs.getInt(1));
            out.println("Value 2: " + rs.getInt(2));
            out.println("Value 3: " + rs.getInt(3));
            out.println("Value 4: " + rs.getInt(4));
            out.println("Value 5: " + rs.getInt(5));
            out.println("Value 6: " + rs.getInt(6));


        }


         connection.close();


    }


    public static void main(String[] args){
        try {
            new Lotto();

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}