Boa tarde Amigos.
Estou tendo dificuldade em implementar e preciso de ajuda de voces. Estou implementando um formulario de Atualizar Preços. Neste formulario tem: 4 campos (Grupo, SubGrupo, Aumentar e Baixar) e um Botao (Atualizar). Idéia do form.: Quando o usuario digitar um grupo ou subgrupo e digitar se quer aumentar ou baixar … o sistema devera procurar todos produtos com os grupos ou subgrupos iguais, alterando o preço do produto (conforme digitado no aumentar ou baixar). Segue abaixo um pedaço do fonte que estou fazendo.
private void btnAlterarActionPerformed(java.awt.event.ActionEvent evt) {
aumentarValor = Integer.parseInt(txtFieldAumentar.getText());
baixarValor = Integer.parseInt(txtFieldBaixar.getText());
try {
List<Produto> result = new ProdutoDao().carregarPorDescricao(txtFieldGrupo.getText());
for (Produto produto : result) {
recebeValor = produto.getPrecoVenda();
calcularValor = (recebeValor * aumentarValor) / 100;
retornarValor = recebeValor + calcularValor;
produto.setPrecoVenda(retornarValor);
produtoDao.atualizar(produto);
}
} catch (Exception ex) {
Logger.getLogger(alterarPreco.class.getName()).log(Level.SEVERE, null, ex);
}
}
Este aqui é os erros que esta dando:
[color=red]
run:
11/09/2009 17:07:04 org.hibernate.cfg.annotations.Version
INFO: Hibernate Annotations 3.3.1.GA
11/09/2009 17:07:04 org.hibernate.cfg.Environment
INFO: Hibernate 3.2.5
11/09/2009 17:07:04 org.hibernate.cfg.Environment
INFO: hibernate.properties not found
11/09/2009 17:07:04 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
11/09/2009 17:07:04 org.hibernate.cfg.Environment
INFO: using JDK 1.4 java.sql.Timestamp handling
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Cliente
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Cliente on table cliente
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Empresa
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Empresa on table empresa
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Fornecedor
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Fornecedor on table fornecedor
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Grupo
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Grupo on table grupo
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.SubGrupo
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.SubGrupo on table subgrupo
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Produto
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Produto on table produto
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.CondicaoPagamento
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.CondicaoPagamento on table condicaopagamento
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Usuario
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Usuario on table usuario
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Transportadora
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Transportadora on table transportadora
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.TipoServico
11/09/2009 17:07:04 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.TipoServico on table tiposervico
11/09/2009 17:07:04 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
11/09/2009 17:07:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
11/09/2009 17:07:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
11/09/2009 17:07:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
11/09/2009 17:07:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3309/bancodados
11/09/2009 17:07:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****, autocommit=false}
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 6.0.2-alpha-community-nt-debug
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
11/09/2009 17:07:05 org.hibernate.dialect.Dialect
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
11/09/2009 17:07:05 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
11/09/2009 17:07:05 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
11/09/2009 17:07:05 org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO: Using ASTQueryTranslatorFactory
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
11/09/2009 17:07:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
11/09/2009 17:07:05 org.hibernate.impl.SessionFactoryImpl
INFO: building session factory
11/09/2009 17:07:05 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Hibernate: select this_.codigo as codigo3_0_, this_.descricao as descricao3_0_ from grupo this_ where this_.descricao like ?
Hibernate: select this_.codigo as codigo3_0_, this_.descricao as descricao3_0_ from grupo this_ where this_.codigo=?
Exception in thread “AWT-EventQueue-0” java.lang.NumberFormatException: For input string: “”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:470)
at java.lang.Integer.parseInt(Integer.java:499)
at forms.alterarPreco.btnAlterarActionPerformed(alterarPreco.java:264)
at forms.alterarPreco.access$400(alterarPreco.java:23)
at forms.alterarPreco$5.actionPerformed(alterarPreco.java:147)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.java:6263)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6028)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
CONSTRUÇÃO PARADA (tempo total: 25 segundos)
[/color]
Não se estou fazendo certo, mas espero que voces entenderam a ideia, é selecionar todos os produtos cadastrados , e os que forem igual ao campo grupo ou subgrupo, alterar os preços (aumentando ou baixando). Por favor me ajudem, Obrigado !