Cezar Apulchro

Ranch Hand

+ Follow

108 Posts 23 Threads 1 Cows

since Feb 13, 2013

Cows and Likes

Cows

Total received

In last 30 days

Total given

Likes

Total received

Received in last 30 days

Total given

Given in last 30 days

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Cezar Apulchro

My servlet do not generate report created in jaspersoft studio

Paul thanks by help.
Sorry for not explain well. I have an jsp that call my servlet.

<%--
   Document   : Agenda_Eletro_W001
   Created on : 16/03/2019, 07:52:45
   Author     : Cezar Apulchro
--%>
<?xml version="1.0" encoding="UTF-8" ?>
<%@ page language="java" contentType="text/html; charset=UTF-8"
   pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
       <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
       <link rel="stylesheet" href="/resources/demos/style.css">
       <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
       <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
 
       <script type="text/javascript">
           $(function()
           {
           $("#calendario").datepicker({
               dateFormat: 'dd/mm/yy',
               changeMonth: true,
               changeYear: true,
               showOtherMonths: true,
               selectOtherMonths: true,
               dayNames: ['Domingo', 'Segunda', 'Terça', 'Quarta', 'Quinta', 'Sexta', 'Sábado'],
               dayNamesMin: ['D', 'S', 'T', 'Q', 'Q', 'S', 'S'],
               monthNames: ['Janeisro', 'Fevereiro', 'Março', 'Abril', 'Maio', 'Junho',
                            'Julho', 'Agosto', 'Setembro', 'Outubro', 'Novembro', 'Dezembro'],
               monthNamesShort: ['Jan', 'Fev', 'Mar', 'Abr', 'Mai', 'Jun', 'Jul', 'Ago',
                                   'Set', 'Out', 'Nov', 'Dez']
                             
           });
           });
       </script>
       <title>Agenda exame eletro.</title>
   </head>
   <style type="text/css">
       #farea
           {
               position: absolute;
               left: 50px;
               top: 50px;
               width: 230px;
               height: 100px;
               padding: 1em;
               border: 1px solid blue;
               border-radius: 0.5em;              
           }    
           *
               {
                   margin: 5;
                   padding: 0;
               }
           fieldset
               {
                   border: 0;
               }
           body, input, textarea, button
               {
                   font-family: sans-serif;
                   font-size: 12px;
               }
           fieldset.legenda .campo
               {
                   float: left;
                   /*margin-right: 50em;
                   margin-left: 12em;*/
                   font-size: 15px;
                   width: 20em;
                   color: blue;
                   text-decoration: underline;
               }
               #dtaagenda
               {
                   position: absolute;
                   top: 50px;
                   left: 70px;
               }
               #btnPesquisar
               {
                   position: absolute;
                   top: 80px;
                   left: 65px;
               }
               .botao
               {
                   font-size: 1em;
                   background: #F90;
                   border: 0;
                   margin-bottom: 1em;
                   color: #FFF;
                   padding: 0.2em 0.6em;
                   box-shadow: 2px 2px 2px rgba(0,0,0,0.2);
                   text-shadow: 1px 1px 1px rgba(0,0,0,0.5);
               }
           .botao:hover
               {
                   background: #FB0;
                   box-shadow: inset 2px 2px 2px rgba(0,0,0,0.2);
                   text-shadow: none;
               }
           .botao, select, label.checkbox, label.checkbox
               {
                   cursor: pointer;
               }
   </style>
   <body>
       <div id="farea">
           <form action="ListAgenda_Eletro_S001" method="POST" autocomplete="off">
               <fieldset class="legenda">
               <div class="campo" id="legenda">
                   <legend>
                       <b>Informe a data a ser pesquisada</b>
                   </legend>
               </div>
               </fieldset>
               <div class="campo" id="dtaagenda">
                   <label for="dtaagenda">Data:</label>
                   <input type="text" id="calendario" name="dtaexame" style="width: 5.2em"/>
                   
               </div>
               <div class="campo" id="btnPesquisar">
                   <button class="botao" type="submit" name="acaobotao" value="LstEletro">Ver agenda eletro.</button>
               </div>
           </form>
       </div>
   </body>
</html>

This jsp are calling the servlete ok, but my servlet do not execute my report.

9 hours ago

Other Open Source Projects

My servlet do not generate report created in jaspersoft studio

Hi guys,
I have created a report in jaspersoft studio, in this reports I have four fields and one parameter, the parameter is to be receive the date to select records in mysql db sent by hashmap in my servlet. The problem is that, when I click in the preview button of jaspersoft studio screen and I inform the date desired, the preview show me the records of my mysql db without problem. But, when I execute my servlet to generate the report I not generate the report and I do not receive any type of error.

This is jrxml of the report:

<?xml version="1.0" encoding="UTF-8"?>

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="LstAgendaEletro" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5676a452-be9f-48f1-a46d-31876895dcc9">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="ITC Systems P63 DA "/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<parameter name="paramDtaEletro" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT Nome, Data_Nascimento, Sexo, Telefone_Residencial
                       FROM Tabela_Pacientes_Eletro WHERE Data_Exame = $P{paramDtaEletro}]]>
</queryString>
<field name="Nome" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Nome"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<field name="Data_Nascimento" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Data_Nascimento"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<field name="Sexo" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Sexo"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<field name="Telefone_Residencial" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Telefone_Residencial"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="30" splitType="Stretch">
<staticText>
<reportElement x="143" y="6" width="210" height="18" uuid="4208c3ce-a5f6-4de0-847e-630b04443cc9">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>
<font size="14" isBold="true"/>
</textElement>
<text><![CDATA[Agenda Pacientes Eletro - Dia:]]></text>
</staticText>
<textField>
<reportElement x="351" y="7" width="80" height="18" uuid="5c98465d-6519-4fe1-ac30-d7d30a2d0485">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
</reportElement>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$P{paramDtaEletro}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="20" splitType="Stretch">
<staticText>
<reportElement x="80" y="2" width="34" height="16" uuid="e37d77f9-3d59-400b-bf01-ef99c30e2afd">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Nome]]></text>
</staticText>
<staticText>
<reportElement x="240" y="2" width="28" height="16" uuid="f669244d-b327-4958-a2af-ab04410eb8cd">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
</reportElement>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Sexo]]></text>
</staticText>
<staticText>
<reportElement x="320" y="2" width="80" height="16" uuid="933b83f3-1c17-422d-8b45-04766b73263c">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
</reportElement>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[D. Nascimento]]></text>
</staticText>
<staticText>
<reportElement x="450" y="2" width="50" height="16" uuid="b2af4af5-bdb0-4228-8cf1-c825eb1c3e41">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Telefone]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement x="3" y="1" width="200" height="14" uuid="8b6c5281-1eaa-4087-9fed-133117a24511">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="083dcb10-7d57-4384-a1b0-d4aaccb94d2a"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Nome}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="250" y="1" width="10" height="14" uuid="69da0b65-9350-45d7-bf87-f3d99ee8c5c5">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5ddb6e73-805c-4c4f-9361-db02eacf5f13"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Sexo}]]></textFieldExpression>
</textField>
                       <textField pattern="dd/mm/yyyy" isBlankWhenNull="true">
<reportElement x="330" y="1" width="60" height="14" uuid="40416ea4-21ef-440b-945c-095c44ead21e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="210e800f-09df-4d07-99eb-df1ca6d61d43"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Data_Nascimento}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="450" y="1" width="80" height="14" uuid="ae8c2ea3-514d-4acb-bdd8-9de6f05ec279">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e1ca290f-5449-4d46-9b1f-7bf2e0f79139"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Telefone_Residencial}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="24" splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField>
<reportElement x="272" y="5" width="10" height="15" uuid="16d38ac8-1ee0-4efc-b4ba-702193f3e169">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
</jasperReport>

And this is my servlet class:

/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.itcsystems.itc_systems_web_mv00;
import com.itcsystems.beans.Conectar_Banco_W00;
import com.itcsystems.beans.DadosPaciente;
import com.itcsystems.beans.PacientesDAO_W01;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.util.JRLoader;
import java.util.HashMap;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import net.sf.jasperreports.engine.util.JRLoader;
import java.util.logging.Level;
import java.util.logging.Logger;
import net.sf.jasperreports.engine.JREmptyDataSource;
/**
*
* @author Cezar Apulchro
*/
public class ListAgenda_Eletro_S001 extends HttpServlet
{
       private String      nome = null,
                           dataexame = null,
                           diaexame = null,
                           mesexame = null,
                           anoexame = null,
                           sexo = null,
                           telefone = null;
    public Connection conectar;
           
   /**
    * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
    * methods.
    *
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   protected void processRequest(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
   
   }
   // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
   /**
    * Handles the HTTP <code>GET</code> method.
    *
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   @Override
   protected void doGet(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       processRequest(request, response);
   }
   /**
    * Handles the HTTP <code>POST</code> method.
    *
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   @Override
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       conectar = new Conectar_Banco_W00().getConnection();
       
       DadosPaciente dpaciente = new DadosPaciente();
       PacientesDAO_W01 pcdao = new PacientesDAO_W01();
       List<DadosPaciente> pacientes = new ArrayList<DadosPaciente>();
           try {
               dpaciente = pcdao.lstEletroDia();
           } catch (Exception ex) {
               Logger.getLogger(ListAgenda_Eletro_S001.class.getName()).log(Level.SEVERE, null, ex);
           }
       dataexame = request.getParameter("dtaexame");
       
       diaexame = dataexame.substring(0, 2);
       mesexame = dataexame.substring(3, 5);
       anoexame = dataexame.substring(6, 10);
       dataexame = anoexame + "-" + mesexame + "-" + diaexame;
       
       HashMap<String, Object> parameters = new HashMap<String, Object>();
       
       parameters.put("paramData", dataexame);
       System.out.println("DataExame: " + dataexame);
               
       String pathJasper =  getServletContext().getRealPath("/WEB-INF/LstAgendaEletro.jrxml");
       
       InputStream inputStr = new FileInputStream( new File(pathJasper));
       
       try
       {
           JasperReport jReport = JasperCompileManager.compileReport(inputStr);
           JasperPrint  jPrint  = JasperFillManager.fillReport(jReport, parameters, conectar);
           JasperExportManager.exportReportToPdfStream(jPrint,
                   response.getOutputStream());
           
           response.getOutputStream().flush();
           response.getOutputStream().close();
           
       } catch (JRException ex) {
           Logger.getLogger(ListAgenda_Eletro_S001.class.getName()).log(Level.SEVERE, null, ex);
       }
   }
   /**
    * Returns a short description of the servlet.
    *
    * @return a String containing servlet description
    */
   @Override
   public String getServletInfo() {
       return "Short description";
   }// </editor-fold>
}

Thanks in advance for help.

1 day ago

Java in General

Netbeans do not execute JSP.

Hi Tim,
my problem was of deploy. I deleted in domain1 folder the /generated and /osgi-cache folders and I have executed my jsp in my server again.

Problem solved.

Thanks.

1 week ago

Java in General

Netbeans do not execute JSP.

Hi,
after fail the light of my office, my netbeans don't execute my jsp.
Thanks.

1 week ago

Java in General

Problem in installation of Netbeans 8.2

Hi, sorry by long time.
I don't know how but after many attempts the netbeans are instaled.

Thanks.

1 month ago

NetBeans

Problem in installation of Netbeans 8.2

Hi,
the instalation of Netbeans 8.2 are stoping in:
Instaling IDE Base...
Extracting: C:\Program Files\NetBeans\platform\modules\locale\org-netbeans-core-output2_PT_BR.jar.pack.gz
this problem occur after 4% of extracting.

Thanks for help.

1 month ago

NetBeans

How to show PDF file in href tag

Hi, good news, problem is solved. i have transferred my file from WEB-INF to Web Pages and changed the href to:

Thanks a lot.

2 months ago

JSP

How to show PDF file in href tag

Sorry,
In my case I have changed "Docs" by "WEB-INF". I can't see where are my error.

2 months ago

JSP

How to show PDF file in href tag

Hi, thank you by assistance.
My reference to do this is:

In my I have changed "Docs" by "WEB-INF". I can't see where are my error.
Thanks.

2 months ago

JSP

How to show PDF file in href tag

Hi,
I'm needing to put in my jsp an option to print pdf file. I saw in internet forums the tag:

I have puting to test target="pdf-frame" or target="_blank" in my jsp, but in both case I'm receiving HTTP status 404 not found when call the page.

Thanks in advance.

2 months ago

Beginning Java

Control and return of error whien accessing MySQL db from a servlet

Sorry I know how to get error code.

Thank you to all.

2 months ago

Servlets

Control and return of error whien accessing MySQL db from a servlet

Hi,
very very good.
This is my DAO now:

public class ProcessDAO_W01 extends HttpServlet
{
   public Connection conectar;
   private Connection conectaDB;
   public String remoteIP;
   public String stringFormatData1 = null;
   public String stringFormatData2 = null;
   public String prontuario = null;
   public String paramerro = null;
   
   @SuppressWarnings("empty-statement")
   public void cadastrarUsuarios (Usuarios_DAO Tabela_Profissional_Medico) throws SQLException
   {
       conectar = new Conectar_Banco_W00().getConnection();
       
       String sqlInsertUsuarios = "INSERT INTO Tabela_Profissional_Medico" +
               "(Nome, Apelido, Cremerj, Coren, Senha, Tipo, Celular)" +
               "values(?,?,?,?,?,?,?)";
       
       PreparedStatement pstmInput = conectar.prepareStatement(sqlInsertUsuarios);
                       
       pstmInput.setString(1, Tabela_Profissional_Medico.getNome());
       pstmInput.setString(2, Tabela_Profissional_Medico.getApelido());
       pstmInput.setString(3, Tabela_Profissional_Medico.getCremerj());
       pstmInput.setString(4, Tabela_Profissional_Medico.getCoren());
       pstmInput.setString(5, Tabela_Profissional_Medico.getSenha());
       pstmInput.setString(6, Tabela_Profissional_Medico.getTipo());
       pstmInput.setString(7, Tabela_Profissional_Medico.getCelular());
         
           pstmInput.executeUpdate();
   }

My servlet now:

public class Cadastrar extends HttpServlet
{
   private String      nome = null,
                       apelido = null,
                       senha = null,
                       celular = null,
                       cremerj = null,
                       coren = null,
                       tipo = null,
                       botaoacao;
   
   
   
   @Override
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       try {
           processoCadastrar(request, response);
           response.setContentType("text/html");
                   PrintWriter out = response.getWriter();
                   out.println("<!DOCTYPE html>");
                   out.println("<html>");
                   out.println("<head>");
                   out.println("<title>Servlet NewServlet</title>");            
                   out.println("</head>");
                   out.println("<body>");
                   out.println("<br>");
                   out.println("<h1>Processo executado com sucesso!</h1>");
                   out.println("</body>");
                   out.println("</html>");
                   out.close();
       }
       catch (SQLException ex)
       {
           response.setContentType("text/html");
                   PrintWriter out = response.getWriter();
                   out.println("<!DOCTYPE html>");
                   out.println("<html>");
                   out.println("<head>");
                   out.println("<title>Servlet NewServlet</title>");            
                   out.println("</head>");
                   out.println("<body>");
                   out.println("<br>");
                   out.println("<h1>Processo não executado!</h1>");
                   out.println("</body>");
                   out.println("</html>");
                   out.close();
           
           Logger.getLogger(Cadastrar.class.getName()).log(Level.SEVERE, null, ex);
       }
   }
   
   private void processoCadastrar(HttpServletRequest request,
HttpServletResponse response) throws SQLException, IOException
   {
       nome = request.getParameter("nome");
       apelido = request.getParameter("apelido");
       senha = request.getParameter("psw");
       celular = request.getParameter("celular");
       cremerj = request.getParameter("cremerj");
       coren = request.getParameter("coren");
       tipo = request.getParameter("tipo");
       
       ProcessDAO_W01 pcdao = new ProcessDAO_W01();
       Usuarios_DAO usuario = new Usuarios_DAO();
           
       usuario.setNome(nome);
       usuario.setApelido(apelido);
       usuario.setSenha_Usuario(senha);
       usuario.setCelular(celular);
       if(cremerj.trim() != null)
       {usuario.setCremerj(cremerj);}
       if(coren.trim() != null)
       {usuario.setCoren(coren);}
       if(tipo.trim() != null)
       {usuario.setTipo(tipo);}
       
       pcdao.cadastrarUsuarios(usuario);            
   }
}

To test this, I trying to insert an record that already exist, the error code of MySQL is 1022, can I get this error in the catch??

2 months ago

Servlets

Control and return of error whien accessing MySQL db from a servlet

How control exceptions in caller side?

2 months ago

Servlets

Control and return of error whien accessing MySQL db from a servlet

Hi Bear,
how I do that? Simply exclude the catch?

2 months ago

Servlets