ola amigos tudo bem estou com um problema ao listar vendas por data uso calendar
no campo onde o usuario faz a busca tem um calendario ele seleciona la a data ai lista todas as vendas daquele dia porem
em na query do relatorio esta dando erro pois fala que esta passando string alguem poderia ajudar?
esta parte aqui abaixo é todo o botao que faz a consulta
consulta.addActionListener (new ActionListener()
{
public void actionPerformed(ActionEvent arg0) {
List <VendaProduto> lista = null;
List resultList;
if (f.getText().trim().equalsIgnoreCase(""))
resultList= em.createQuery("from VendaProduto").getResultList();
else // Senão ele digitou alguma coisa na procura
{
Query consulta =
em.createQuery("SELECT i FROM VendaProduto i WHERE UPPER(i.data) LIKE :argumento");
consulta.setParameter("argumento", "%" + f.getText().toUpperCase() + "%");
resultList= consulta.getResultList();
}
lista = resultList;
StringBuilder sb = new StringBuilder();
if (lista.isEmpty())
{
sb.append("Não há vendas cadastradas!");
}
else
{
double soma = 0;
for (VendaProduto med : lista) {
sb.append("Código: " + med.getCodigo() + "\n");
sb.append("Data: " + converteData(med.getData()) + "\n");
sb.append("Nome do Vendedor: " + med.getNomevendedor() +"\n");
sb.append("Descrição: " + med.getDescricao()+ "\n");
sb.append("Quantidade:" + med.getQtde()+ "\n");
sb.append("Valor: " + med.getValor()+ "\n");
sb.append("Total: " + med.getTotal()+ "\n");
// Adiciona uma linha)
modelo.addRow(new Object[]{med.getCodigo(),converteData(med.getData()), med.getNomevendedor(), med.getDescricao(),med.getQtde(),med.getValor(),med.getTotal()});
soma += med.getValor();
}
sb.append("Total de Vendas Efetuadas = " + lista.size()+"\n\n");
//sb.append("Média dos Anos dos Carros = " + soma/lista.size());
sb.append("Total do Valor de Vendas = " +soma+lista.size()+"\n\n");
totalmedidas.setText("Total de Vendas Efetuadas = " + lista.size());
totalvalor.setText("Total do valor de vendas =" +soma);
//mediaano.setText("Média dos Clientes Cadastrados = " + soma/lista.size());
}
//area.setText(sb.toString());
}
private String converteData(Calendar data) {
// TODO Auto-generated method stub
return new SimpleDateFormat("dd/MM/yyyy").format(new Date().getTime());
}
});
erro que ocorre
Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Calendar
at org.hibernate.type.CalendarDateType.toString(CalendarDateType.java:49)
at org.hibernate.type.NullableType.nullSafeToString(NullableType.java:93)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:140)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:116)
at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:38)
at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:491)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1563)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:66)
at ListarVendas$2.actionPerformed(ListarVendas.java:129)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
