Examples with Requisito model.bean.Requisito used on opensource projects

Search in sources :

Example 1 with Requisito

use of model.bean.Requisito in project specify by rhebecaabreu.

the class CartaoEstoria method criaPDF.

public void criaPDF(JTable table_1, java.util.List<Integer> codigosReq) throws FileNotFoundException, DocumentException {
    Document document = new Document();
    try {
        document.setPageSize(PageSize.A4);
        document.setMargins(50, 50, 50, 50);
        nomepdf = MeusProjetos.getNome_pdf() + ".pdf";
        PdfWriter writer = PdfWriter.getInstance(document, new FileOutputStream(nomepdf));
        ModelPDFRodape mf = new ModelPDFRodape();
        mf.setTopo("Specify");
        writer.setPageEvent(mf);
        document.open();
        DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
        Date date = new Date();
        String data = dateFormat.format(date);
        RequisitoDAO rdao = new RequisitoDAO();
        Font f = FontFactory.getFont(FontFactory.HELVETICA, 13, Font.NORMAL);
        Font ff = FontFactory.getFont(FontFactory.HELVETICA, 13, Font.BOLD);
        Paragraph title2 = new Paragraph("Cartões de Estória", FontFactory.getFont(FontFactory.HELVETICA, 18, Font.BOLD));
        title2.setAlignment(Element.ALIGN_CENTER);
        Chapter chapter2 = new Chapter(title2, 2);
        chapter2.setNumberDepth(0);
        ProjetoDAO pread = new ProjetoDAO();
        for (Requisito r : rdao.readOrderBy()) {
            for (Projeto p : pread.read()) {
                for (int i = 0; i < codigosReq.size(); i++) {
                    if (r.getProjcodigo() == p.getCodigo() && r.getCodigo() == codigosReq.get(0)) {
                        Paragraph title_project2 = new Paragraph("Projeto: " + p.getNome(), FontFactory.getFont(FontFactory.HELVETICA, 16, Font.BOLD));
                        title_project2.setAlignment(Element.ALIGN_CENTER);
                        chapter2.add(title_project2);
                        break;
                    }
                }
            }
        }
        Paragraph data_hora2 = new Paragraph("Gerado em " + data, FontFactory.getFont(FontFactory.HELVETICA, 14, Font.NORMAL));
        data_hora2.setAlignment(Element.ALIGN_CENTER);
        chapter2.add(data_hora2);
        Paragraph listUserStories = new Paragraph("Lista de Cartões de Estória", FontFactory.getFont(FontFactory.HELVETICA, 14, Font.NORMAL));
        Section section2 = chapter2.addSection(listUserStories);
        for (Requisito r : rdao.readOrderBy()) {
            if (table_1.getSelectedRow() != -1) {
                for (int j = 0; j < (codigosReq.size()); j++) {
                    if (r.getCodigo() == codigosReq.get(j)) {
                        Paragraph p = new Paragraph();
                        Paragraph q = new Paragraph();
                        Paragraph rr = new Paragraph();
                        Paragraph s = new Paragraph();
                        Paragraph t = new Paragraph();
                        p.setFont(ff);
                        p.add("Identificador: ");
                        p.setFont(f);
                        p.add(r.getId());
                        p.setFont(ff);
                        p.add(" Código: ");
                        p.setFont(f);
                        p.add(String.valueOf(r.getCodigo()));
                        q.setFont(ff);
                        q.add("Como um " + r.getSujeito() + " eu quero " + r.getAcaoRestricao() + " a fim de " + r.getValorRazao());
                        Paragraph qq = new Paragraph();
                        qq.setFont(ff);
                        qq.add("Estimativa: ");
                        qq.setFont(f);
                        qq.add(r.getEstimativa() + " hora(s)");
                        rr.setFont(ff);
                        rr.add("Grau Prioridade: ");
                        rr.setFont(f);
                        rr.add(r.getGrauPrioridade().toString());
                        s.setFont(ff);
                        s.add("Grau Dificuldade: ");
                        s.setFont(f);
                        s.add(r.getGrauDificuldade().toString());
                        t = new Paragraph(" ");
                        section2.add(p);
                        section2.add(q);
                        section2.add(rr);
                        section2.add(s);
                        section2.add(t);
                    }
                }
            }
        }
        document.add(chapter2);
        document.add(Chunk.NEXTPAGE);
    } catch (DocumentException ex) {
        System.out.println("Error:" + ex);
    } catch (FileNotFoundException ex) {
        System.out.println("Error:" + ex);
    } finally {
        document.close();
    }
    try {
        Desktop.getDesktop().open(new File(nomepdf));
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}
Also used : PdfWriter(com.itextpdf.text.pdf.PdfWriter) Requisito(model.bean.Requisito) ModelPDFRodape(model.bean.ModelPDFRodape) Chapter(com.itextpdf.text.Chapter) FileNotFoundException(java.io.FileNotFoundException) Projeto(model.bean.Projeto) IOException(java.io.IOException) Document(com.itextpdf.text.Document) Section(com.itextpdf.text.Section) Date(java.util.Date) Font(com.itextpdf.text.Font) Paragraph(com.itextpdf.text.Paragraph) RequisitoDAO(model.dao.RequisitoDAO) FileOutputStream(java.io.FileOutputStream) SimpleDateFormat(java.text.SimpleDateFormat) DateFormat(java.text.DateFormat) DocumentException(com.itextpdf.text.DocumentException) ProjetoDAO(model.dao.ProjetoDAO) SimpleDateFormat(java.text.SimpleDateFormat) File(java.io.File)

Example 2 with Requisito

use of model.bean.Requisito in project specify by rhebecaabreu.

the class DocumentoReqCartaoEstoria method criaPDF.

/**
 * @param args
 * @throws FileNotFoundException
 * @throws DocumentException
 * @throws IOException
 * @throws MalformedURLException
 */
public void criaPDF(JTable table_1, java.util.List<Integer> codigosReq) throws FileNotFoundException, DocumentException {
    // Listing 1. Instantiation of document object
    Document document = new Document();
    try {
        document.setPageSize(PageSize.A4);
        document.setMargins(50, 50, 50, 50);
        nomepdf = MeusProjetos.getNome_pdf() + ".pdf";
        // Listing 2. Creation of PdfWriter object
        PdfWriter writer = PdfWriter.getInstance(document, new FileOutputStream(nomepdf));
        ModelPDFRodape mf = new ModelPDFRodape();
        mf.setTopo("Specify");
        writer.setPageEvent(mf);
        document.open();
        // Listing 3. Creation of chapter object
        Paragraph title1 = new Paragraph("Documento de Requisitos", FontFactory.getFont(FontFactory.HELVETICA, 18, Font.BOLD));
        title1.setAlignment(Element.ALIGN_CENTER);
        Chapter chapter1 = new Chapter(title1, 1);
        chapter1.setNumberDepth(0);
        // Listing 4. Creation of section object
        RequisitoDAO rrdao = new RequisitoDAO();
        // Listing 4. Creation of section object
        ProjetoDAO pread = new ProjetoDAO();
        for (Requisito r : rrdao.readOrderBy()) {
            for (Projeto p : pread.read()) {
                for (int i = 0; i < codigosReq.size(); i++) {
                    if (r.getProjcodigo() == p.getCodigo() && r.getCodigo() == codigosReq.get(0)) {
                        Paragraph title_project2 = new Paragraph("Projeto: " + p.getNome(), FontFactory.getFont(FontFactory.HELVETICA, 16, Font.BOLD));
                        title_project2.setAlignment(Element.ALIGN_CENTER);
                        chapter1.add(title_project2);
                        break;
                    }
                }
            }
        }
        DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
        Date date = new Date();
        String data = dateFormat.format(date);
        Paragraph data_hora = new Paragraph("Gerado em " + data, FontFactory.getFont(FontFactory.HELVETICA, 14, Font.NORMAL));
        data_hora.setAlignment(Element.ALIGN_CENTER);
        chapter1.add(data_hora);
        Paragraph listRequirement = new Paragraph("Lista de Requisitos", FontFactory.getFont(FontFactory.HELVETICA, 14, Font.NORMAL));
        Section section1 = chapter1.addSection(listRequirement);
        RequisitoDAO rdao = new RequisitoDAO();
        Font f = FontFactory.getFont(FontFactory.HELVETICA, 13, Font.NORMAL);
        Font ff = FontFactory.getFont(FontFactory.HELVETICA, 13, Font.BOLD);
        for (Requisito r : rdao.readOrderBy()) {
            if (table_1.getSelectedRow() != -1) {
                for (int j = 0; j < (codigosReq.size()); j++) {
                    if (r.getCodigo() == codigosReq.get(j)) {
                        if (r.getTipoReq().toString().equals("FUNCIONAL")) {
                            Paragraph o = new Paragraph();
                            o.setFont(ff);
                            o.add("Tipo de Requisito: ");
                            o.setFont(f);
                            o.add("Funcional" + "       ");
                            o.setFont(ff);
                            o.add(" Código: ");
                            o.setFont(f);
                            o.add(String.valueOf(r.getCodigo()));
                            section1.add(o);
                        }
                        if (r.getTipoReq().toString().equals("NAOFUNCIONAL")) {
                            Paragraph o = new Paragraph();
                            o.setFont(ff);
                            o.add("Tipo de Requisito: ");
                            o.setFont(f);
                            o.add("Não-funcional" + "       ");
                            o.setFont(ff);
                            o.add(" Código: ");
                            o.setFont(f);
                            o.add(String.valueOf(r.getCodigo()));
                            section1.add(o);
                        }
                        if (r.getTipoReq().toString().equals("USUARIO")) {
                            Paragraph o = new Paragraph();
                            o.setFont(ff);
                            o.add("Tipo de Requisito: ");
                            o.setFont(f);
                            o.add("       Usuário" + "       ");
                            o.setFont(ff);
                            o.add(" Código: ");
                            o.setFont(f);
                            o.add(String.valueOf(r.getCodigo()));
                            section1.add(o);
                        }
                        if (r.getTipoReq().toString().equals("NEGOCIO")) {
                            Paragraph o = new Paragraph();
                            o.setFont(ff);
                            o.add("Tipo de Requisito: ");
                            o.setFont(f);
                            o.add("       Negócio" + "       ");
                            o.setFont(ff);
                            o.add(" Código: ");
                            o.setFont(f);
                            o.add(String.valueOf(r.getCodigo()));
                            section1.add(o);
                        }
                        Paragraph p = new Paragraph();
                        Paragraph q = new Paragraph();
                        Paragraph rr = new Paragraph();
                        Paragraph s = new Paragraph();
                        Paragraph t = new Paragraph();
                        p.setFont(ff);
                        p.add("Identificador: ");
                        p.setFont(f);
                        p.add(r.getId());
                        q.setFont(ff);
                        q.add("O(a) " + r.getSujeito() + " deve ser capaz de " + r.getAcaoRestricao() + " para " + r.getValorRazao());
                        rr.setFont(ff);
                        rr.add("Grau Prioridade: ");
                        rr.setFont(f);
                        rr.add(r.getGrauPrioridade().toString());
                        s.setFont(ff);
                        s.add("Grau Dificuldade: ");
                        s.setFont(f);
                        s.add(r.getGrauDificuldade().toString());
                        t = new Paragraph(" ");
                        section1.add(p);
                        section1.add(q);
                        section1.add(rr);
                        section1.add(s);
                        section1.add(t);
                    }
                }
            }
        }
        // Listing 3. Creation of chapter object
        Paragraph title2 = new Paragraph("Cartões de Estória", FontFactory.getFont(FontFactory.HELVETICA, 18, Font.BOLD));
        title2.setAlignment(Element.ALIGN_CENTER);
        Chapter chapter2 = new Chapter(title2, 2);
        chapter2.setNumberDepth(0);
        for (Requisito r : rrdao.readOrderBy()) {
            for (Projeto p : pread.read()) {
                for (int i = 0; i < codigosReq.size(); i++) {
                    if (r.getProjcodigo() == p.getCodigo() && r.getCodigo() == codigosReq.get(0)) {
                        Paragraph title_project2 = new Paragraph("Projeto: " + p.getNome(), FontFactory.getFont(FontFactory.HELVETICA, 16, Font.BOLD));
                        title_project2.setAlignment(Element.ALIGN_CENTER);
                        chapter2.add(title_project2);
                        break;
                    }
                }
            }
        }
        Paragraph data_hora2 = new Paragraph("Gerado em " + data, FontFactory.getFont(FontFactory.HELVETICA, 14, Font.NORMAL));
        data_hora2.setAlignment(Element.ALIGN_CENTER);
        chapter2.add(data_hora2);
        Paragraph listUserStories = new Paragraph("Lista de Cartões de Estória", FontFactory.getFont(FontFactory.HELVETICA, 14, Font.NORMAL));
        Section section2 = chapter2.addSection(listUserStories);
        for (Requisito r : rdao.readOrderBy()) {
            if (table_1.getSelectedRow() != -1) {
                for (int j = 0; j < (codigosReq.size()); j++) {
                    if (r.getCodigo() == codigosReq.get(j)) {
                        Paragraph p = new Paragraph();
                        Paragraph q = new Paragraph();
                        Paragraph rr = new Paragraph();
                        Paragraph s = new Paragraph();
                        Paragraph t = new Paragraph();
                        p.setFont(ff);
                        p.add("Identificador: ");
                        p.setFont(f);
                        p.add(r.getId());
                        p.setFont(ff);
                        p.add("       Código: ");
                        p.setFont(f);
                        p.add(String.valueOf(r.getCodigo()));
                        q.setFont(ff);
                        q.add("Como um " + r.getSujeito() + " eu quero " + r.getAcaoRestricao() + " a fim de " + r.getValorRazao());
                        Paragraph qq = new Paragraph();
                        qq.setFont(ff);
                        qq.add("Estimativa: ");
                        qq.setFont(f);
                        qq.add(r.getEstimativa() + " hora(s)");
                        rr.setFont(ff);
                        rr.add("Grau Prioridade: ");
                        rr.setFont(f);
                        rr.add(r.getGrauPrioridade().toString());
                        s.setFont(ff);
                        s.add("Grau Dificuldade: ");
                        s.setFont(f);
                        s.add(r.getGrauDificuldade().toString());
                        t = new Paragraph(" ");
                        // Paragraph p = new Paragraph();
                        section2.add(p);
                        section2.add(q);
                        section2.add(qq);
                        section2.add(rr);
                        section2.add(s);
                        section2.add(t);
                    }
                }
            }
        }
        // Listing 5. Addition of a chapter to the main document
        document.add(chapter1);
        document.add(chapter2);
        document.add(Chunk.NEXTPAGE);
    } catch (DocumentException ex) {
        System.out.println("Error:" + ex);
    } catch (FileNotFoundException ex) {
        System.out.println("Error:" + ex);
    } finally {
        document.close();
    }
    try {
        Desktop.getDesktop().open(new File(nomepdf));
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}
Also used : PdfWriter(com.itextpdf.text.pdf.PdfWriter) Requisito(model.bean.Requisito) ModelPDFRodape(model.bean.ModelPDFRodape) Chapter(com.itextpdf.text.Chapter) FileNotFoundException(java.io.FileNotFoundException) Projeto(model.bean.Projeto) IOException(java.io.IOException) Document(com.itextpdf.text.Document) Section(com.itextpdf.text.Section) Date(java.util.Date) Font(com.itextpdf.text.Font) Paragraph(com.itextpdf.text.Paragraph) RequisitoDAO(model.dao.RequisitoDAO) FileOutputStream(java.io.FileOutputStream) SimpleDateFormat(java.text.SimpleDateFormat) DateFormat(java.text.DateFormat) DocumentException(com.itextpdf.text.DocumentException) ProjetoDAO(model.dao.ProjetoDAO) SimpleDateFormat(java.text.SimpleDateFormat) File(java.io.File)

Example 3 with Requisito

use of model.bean.Requisito in project specify by rhebecaabreu.

the class PopupHandler method deletarProjeto.

private void deletarProjeto(String recebenode) {
    // TreePath path = ((JTree) nodeInfo).getPathForLocation ( getX (), getY () );
    ProjetoDAO dao = new ProjetoDAO();
    RequisitoDAO rdao = new RequisitoDAO();
    MeusProjetos mp = new MeusProjetos();
    InteressadoProjetoDAO ipdao = new InteressadoProjetoDAO();
    for (Projeto p : dao.readName()) {
        if (recebenode.equals(p.getNome())) {
            int resposta = JOptionPane.showConfirmDialog(null, "Ao deletar um projeto todos os requisitos e interessados associados a ele serão removidos. \nDeseja realmente deletar o projeto " + p.getNome() + "?", "Atenção", JOptionPane.YES_NO_OPTION, JOptionPane.WARNING_MESSAGE);
            if (resposta == JOptionPane.YES_OPTION) {
                // deletar primeiro os requisitos ligados ao projeto
                for (Requisito r : rdao.readID()) {
                    if (p.getCodigo() == r.getProjcodigo()) {
                        rdao.delete(r.getId());
                    }
                }
                // deletar os interessados
                for (InteressadoProjeto ip : ipdao.buscaInteressados()) {
                    if (p.getCodigo() == (ip.getCodProj())) {
                        ipdao.delete(ip.getCodProj());
                    }
                }
                // deletar o projeto
                dao.delete(p.getCodigo());
                mp.atualizaArvore(tree);
                mp.atualizaProjeto(tableproj);
            }
        }
    }
}
Also used : RequisitoDAO(model.dao.RequisitoDAO) Requisito(model.bean.Requisito) InteressadoProjetoDAO(model.dao.InteressadoProjetoDAO) InteressadoProjeto(model.bean.InteressadoProjeto) Projeto(model.bean.Projeto) InteressadoProjeto(model.bean.InteressadoProjeto) InteressadoProjetoDAO(model.dao.InteressadoProjetoDAO) ProjetoDAO(model.dao.ProjetoDAO) Point(java.awt.Point)

Example 4 with Requisito

use of model.bean.Requisito in project specify by rhebecaabreu.

the class RequisitoDAO method readALL.

public List<Requisito> readALL() {
    // para JTable
    PreparedStatement stmt = null;
    ResultSet rs = null;
    List<Requisito> req = new ArrayList<>();
    try {
        stmt = con.prepareStatement("SELECT * FROM requisito ");
        rs = stmt.executeQuery();
        while (rs.next()) {
            Requisito requisito = new Requisito();
            requisito.setId(rs.getString("id"));
            requisito.setCodigo(rs.getInt("codigo"));
            requisito.setSujeito(rs.getString("sujeito"));
            requisito.setAcaoRestricao(rs.getString("acaoRestricao"));
            requisito.setValorRazao(rs.getString("valorRazao"));
            requisito.setProjcodigo(rs.getInt("pcodigo"));
            requisito.setEstimativa(rs.getInt("estimativa"));
            requisito.setHoraCriacao(rs.getString("diaHoraCriacao"));
            requisito.setUltimaMod(rs.getString("ultimaAtualizacao"));
            requisito.setId_usuario(rs.getInt("id_usuario"));
            requisito.setTipoReq(Enum.valueOf(TipoReq.class, rs.getString("tipoRequisito")));
            requisito.setGrauPrioridade(Enum.valueOf(GrauP.class, rs.getString("grauPrioridade")));
            requisito.setGrauDificuldade(Enum.valueOf(GrauD.class, rs.getString("grauDificuldade")));
            req.add(requisito);
        }
    } catch (SQLException ex) {
        Logger.getLogger(ProjetoDAO.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        ConnectionFactory.closeConnection(con, stmt, rs);
    }
    return req;
}
Also used : Requisito(model.bean.Requisito) SQLException(java.sql.SQLException) ResultSet(java.sql.ResultSet) ArrayList(java.util.ArrayList) GrauD(model.bean.Requisito.GrauD) PreparedStatement(java.sql.PreparedStatement) TipoReq(model.bean.Requisito.TipoReq) GrauP(model.bean.Requisito.GrauP)

Example 5 with Requisito

use of model.bean.Requisito in project specify by rhebecaabreu.

the class RequisitoDAO method readID.

public List<Requisito> readID() {
    PreparedStatement stmt = null;
    ResultSet rs = null;
    List<Requisito> reqID = new ArrayList<>();
    try {
        stmt = con.prepareStatement("SELECT id, pcodigo FROM requisito");
        rs = stmt.executeQuery();
        while (rs.next()) {
            Requisito requisito = new Requisito();
            requisito.setId(rs.getString("id"));
            requisito.setProjcodigo(rs.getInt("pcodigo"));
            reqID.add(requisito);
        }
    } catch (SQLException ex) {
        Logger.getLogger(ProjetoDAO.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        ConnectionFactory.closeConnection(con, stmt, rs);
    }
    return reqID;
}
Also used : Requisito(model.bean.Requisito) SQLException(java.sql.SQLException) ResultSet(java.sql.ResultSet) ArrayList(java.util.ArrayList) PreparedStatement(java.sql.PreparedStatement)

Aggregations

Requisito (model.bean.Requisito)8 PreparedStatement (java.sql.PreparedStatement)4 ResultSet (java.sql.ResultSet)4 SQLException (java.sql.SQLException)4 ArrayList (java.util.ArrayList)4 Projeto (model.bean.Projeto)4 ProjetoDAO (model.dao.ProjetoDAO)4 RequisitoDAO (model.dao.RequisitoDAO)4 Chapter (com.itextpdf.text.Chapter)3 Document (com.itextpdf.text.Document)3 DocumentException (com.itextpdf.text.DocumentException)3 Font (com.itextpdf.text.Font)3 Paragraph (com.itextpdf.text.Paragraph)3 Section (com.itextpdf.text.Section)3 PdfWriter (com.itextpdf.text.pdf.PdfWriter)3 File (java.io.File)3 FileNotFoundException (java.io.FileNotFoundException)3 FileOutputStream (java.io.FileOutputStream)3 IOException (java.io.IOException)3 DateFormat (java.text.DateFormat)3
About Me
UseOf

Java Tutorials :

Simple Java RabbitMQ Example with Spring
Simple Springboot JPA Eclipeslink Example
Simple SpringBoot JPA Hibernate Example
Jackson JSON @JsonIgnore and @JsonIgnoreProperties Examples
Java Infinite recursion (StackOverflowError) Jackson solutions
Simple Java Jackson Serialize Objects to JSON and convert them back To Object
ElasticSearch 5 - Upload files using Java API in binary field Example
Java JAXB marshall unmarshall Examples from String and Stream
Java 8 forEach List and Map examples
ElasticSearch 5 Java API SearchRequestBuilder examples
Java ElasticSearch 5 examples with node index and mapping - running local
Convert String to int or Integer Java 8
Java 9 in action - JShell - Ubuntu
Java - removing invalid characters from a file name
Hello world!? or Hello Tutorial