Examples with Hotel br.senac.tads3.pi03b.gruposete.models.Hotel used on opensource projects

Example 6 with Hotel

use of br.senac.tads3.pi03b.gruposete.models.Hotel in project Loja_Agencia_De_Viagens by ArtCouSan.

the class ExcluiHotelServlet method doGet.

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String action = request.getParameter("action");
    String pesquisa = request.getParameter("pesquisa");
    HotelDAO query = new HotelDAO();
    if ("edit".equalsIgnoreCase(action)) {
        int id = Integer.parseInt(request.getParameter("id"));
        try {
            query.excluirHotel(id);
            List<Hotel> encontrados = query.procurarHotel(pesquisa);
            request.setAttribute("encontrados", encontrados);
        } catch (SQLException | ClassNotFoundException ex) {
            Logger.getLogger(ExcluiHotelServlet.class.getName()).log(Level.SEVERE, null, ex);
        }
        RequestDispatcher dispatcher = request.getRequestDispatcher("/jsp/Listar/ListaHotel.jsp");
        dispatcher.forward(request, response);
    }
}

Example 7 with Hotel

use of br.senac.tads3.pi03b.gruposete.models.Hotel in project Loja_Agencia_De_Viagens by ArtCouSan.

the class BuscaHotelServlet method doPost.

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    boolean erro = false;
    String pesquisa = request.getParameter("pesquisa");
    if (!erro) {
        try {
            HotelDAO dao = new HotelDAO();
            List<Hotel> encontrados = dao.procurarHotel(pesquisa);
            HttpSession sessao = request.getSession();
            sessao.setAttribute("encontrados", encontrados);
            sessao.setAttribute("pesquisa", pesquisa);
            RequestDispatcher dispatcher = request.getRequestDispatcher("/jsp/Listar/ListaHotel.jsp");
            dispatcher.forward(request, response);
        } catch (IOException | ServletException ex) {
            Logger.getLogger(CadastroHotelServlet.class.getName()).log(Level.SEVERE, null, ex);
        } catch (ClassNotFoundException | SQLException ex) {
            Logger.getLogger(BuscaHotelServlet.class.getName()).log(Level.SEVERE, null, ex);
        }
    } else {
        RequestDispatcher dispatcher = request.getRequestDispatcher("/jsp/Listar/ListaHotel.jsp");
        dispatcher.forward(request, response);
    }
}

Example 8 with Hotel

use of br.senac.tads3.pi03b.gruposete.models.Hotel in project Loja_Agencia_De_Viagens by ArtCouSan.

the class HotelDAO method ListaHotel.

public List<Hotel> ListaHotel() throws SQLException, ClassNotFoundException {
    List<Hotel> ListaHotel = new ArrayList<>();
    connection = DbUtil.getConnection();
    String query = "SELECT * FROM Hotel ORDER BY nome_hotel WHERE ativo=true";
    try {
        statement = connection.createStatement();
        resultSet = statement.executeQuery(query);
        while (resultSet.next()) {
            Hotel hotel = new Hotel();
            hotel.setId_hotel(resultSet.getInt("id_hotel"));
            hotel.setNome(resultSet.getString("nome_hotel"));
            hotel.setData_entrada(resultSet.getString("data_entrada"));
            hotel.setData_saida(resultSet.getString("data_saida"));
            hotel.setQuantidade_quartos(resultSet.getInt("quantidade_quartos"));
            hotel.setQuantidade_hospedes(resultSet.getInt("quantidade_hospedes"));
            hotel.setPreco(resultSet.getFloat("preco"));
            ListaHotel.add(hotel);
        }
    } catch (SQLException e) {
    }
    connection.close();
    return ListaHotel;
}

Example 9 with Hotel

use of br.senac.tads3.pi03b.gruposete.models.Hotel in project Loja_Agencia_De_Viagens by ArtCouSan.

the class HotelDAO method procurarHotel.

public List<Hotel> procurarHotel(String busca) throws ClassNotFoundException, SQLException {
    List<Hotel> listaResultado = new ArrayList<>();
    connection = DbUtil.getConnection();
    String sql = "SELECT * FROM hotel WHERE" + " (nome_hotel = ?" + " OR data_entrada = ?" + " OR data_saida = ?" + " OR preco = ?" + " OR quantidade_quartos = ?" + " OR quantidade_hospedes = ?)" + " AND ativo = ?";
    preparedStatement = connection.prepareStatement(sql);
    // Insercoes.
    preparedStatement.setString(1, busca);
    preparedStatement.setString(2, busca);
    preparedStatement.setString(3, busca);
    double n1 = 0;
    try {
        Double.parseDouble(busca);
    } catch (NumberFormatException e) {
        System.out.println("Erro");
    }
    int n2 = 0;
    try {
        n2 = Integer.parseInt(busca);
    } catch (NumberFormatException e) {
        System.out.println("Erro");
    }
    int n3 = 0;
    try {
        n3 = Integer.parseInt(busca);
    } catch (NumberFormatException e) {
        System.out.println("Erro");
    }
    preparedStatement.setDouble(4, n1);
    preparedStatement.setInt(5, n2);
    preparedStatement.setInt(6, n3);
    preparedStatement.setBoolean(7, true);
    // Recebe e executa pergunta.
    try (ResultSet result = preparedStatement.executeQuery()) {
        // Loop com resultados.
        while (result.next()) {
            Hotel hoteis = new Hotel();
            // Insere informacoes.
            hoteis.setId_hotel(result.getInt("id_hotel"));
            hoteis.setData_entrada(result.getString("data_entrada"));
            hoteis.setData_saida(result.getString("data_saida"));
            hoteis.setQuantidade_hospedes(result.getInt("quantidade_hospedes"));
            hoteis.setQuantidade_quartos(result.getInt("quantidade_quartos"));
            hoteis.setPreco(result.getFloat("preco"));
            hoteis.setNome(result.getString("nome_hotel"));
            // Insere na lista.
            listaResultado.add(hoteis);
        }
        // Retorna lista.
        return listaResultado;
    }
}

Example 10 with Hotel

use of br.senac.tads3.pi03b.gruposete.models.Hotel in project Loja_Agencia_De_Viagens by ArtCouSan.

the class BuscaHotelVendaServlet method doGet.

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    try {
        String busca = request.getParameter("busca");
        VendaDAO dao = new VendaDAO();
        ArrayList<Hotel> hotel = dao.procurarHotel(busca);
        response.setContentType("text/html;charset=UTF-8");
        JSONArray jsonArray = new JSONArray();
        for (Hotel object : hotel) {
            JSONObject json = new JSONObject();
            json.put("id_venda", object.getNome());
            json.put("id_cliente", object.getId_hotel());
            json.put("id_funcionario", object.getData_entrada());
            json.put("data_saida", object.getData_saida());
            json.put("preco", object.getPreco());
            json.put("quantidade_quartos", object.getQuantidade_quartos());
            json.put("quantidade_hospedes", object.getQuantidade_hospedes());
            jsonArray.add(json);
        }
        try (PrintWriter out = response.getWriter()) {
            out.println(jsonArray.toJSONString());
        }
    } catch (SQLException | ClassNotFoundException ex) {
    }
}