try(Connection connection = DriverManager.getConnection(URL,USERNAME,PASSWORD);) {

                                    PreparedStatement stmt=connection.prepareStatement("select * from Users where username = ? and password = ?");
                                    stmt.setString(1, avtForm.getLogin() );
                                    stmt.setString(2, avtForm.getPsw());

                                    ResultSet rs=stmt.executeQuery();
                                    if(!rs.isBeforeFirst()) {

                                        System.out.println("no match");
                                        exchange.getResponseHeaders().put(Headers.CONTENT_TYPE, "text/html");

                                        templateData.put("name", avtForm.getLogin());
                                        badTemplate.process(templateData, stringWriter);

                                        exchange.getResponseSender().send(stringWriter.toString());
                                        stringWriter.flush();
                                        stringWriter.close();
                                    }

                                    else {
                                        stmt=connection.prepareStatement("select * from Users where username = ? and isAdmin = ?");
                                        stmt.setString(1, avtForm.getLogin() );
                                        stmt.setInt(2, 1 );

                                        rs=stmt.executeQuery();

                                        if(rs.isBeforeFirst()){


                                            while(rs.next()){
                                                System.out.println("Info: "+rs.getString(2)+" "+rs.getString(3));
                                                exchange.getResponseHeaders().put(Headers.CONTENT_TYPE, "text/html");

                                             //   templateData.put("name", "Admin");
                                              //  templateData.put("status", "logged in");
                                                adminTemplate.process(templateData, stringWriter);

                                                exchange.getResponseSender().send(stringWriter.toString());
                                                stringWriter.flush();
                                                stringWriter.close();
                                            }


                                        }
                                        else {
                                            while (rs.next()) {
                                                System.out.println("Info: " + rs.getString(2) + " " + rs.getString(3));
                                                exchange.getResponseHeaders().put(Headers.CONTENT_TYPE, "text/html");

                                                templateData.put("name", avtForm.getLogin());
                                                templateData.put("status", "logged in");
                                                goodTemplate.process(templateData, stringWriter);

                                                exchange.getResponseSender().send(stringWriter.toString());
                                                stringWriter.flush();
                                                stringWriter.close();

                                            }
                                        }
                                    }



                                }
                                catch (SQLException e){
                                    System.out.println(e);

                                }