Pessoal tenho a seguinte classe para conexao:
[code]public class Conexao{
private Connection conexao;
public Conexao(){
try{
Class.forName(“org.firebirdsql.jdbc.FBDriver”);
conexao = DriverManager.getConnection(“jdbc:firebirdsql:localhost/3050:D:\Sistemas\Gestor\bd\GESTORBD”, “GESTOR”, “msolutec0702”);
}catch ( Exception e ) {
String erro = e.getMessage();
}
}
public Connection getConexao(){
return conexao;
}
}[/code]
e o seguinte DAO:
1 /*
2 * EmpresaDao.java
3 *
4 * Created on 22 de Abril de 2005, 13:33
5 */
6
7 package br.com.solutec.gestor.dao.empresa;
8
9 import br.com.solutec.gestor.dao.comum.Conexao;
10 import br.com.solutec.gestor.dao.comum.Id;
11 import br.com.solutec.gestor.model.empresa.Empresa;
12 import java.sql.Connection;
13 import java.sql.PreparedStatement;
14 import java.sql.ResultSet;
15 import java.sql.Statement;
16 import java.util.ArrayList;
17 import java.util.List;
18
19 /**
20 *
21 * @author Rodrigo Rocha
22 */
23 public class EmpresaDao {
24 private static Conexao cx = new Conexao();
25 private static Connection conexao = cx.getConexao();
26 /** Creates a new instance of EmpresaDao */
27 public EmpresaDao() {
28 }
29
30 public Integer gerarId() throws Exception {
31 Id id = new Id();
32 return id.gerarId("tbEmpresa", "idEmpresa");
33 }
34
35 public void cadastrar(Empresa em) throws Exception {
36
37 if( em == null ) return;
38 //Statement st = conexao.createStatement();
39 PreparedStatement ps = null;
40 try {
41 String sql = "INSERT INTO tbEmpresa ( idEmpresa, rzsocial, apelido, dtVencimento) VALUES (?,?,?,?)";
42 ps = conexao.prepareStatement(sql);
43 ps.setInt(1, em.getIdEmpresa().intValue());
44 ps.setString(2, em.getRzSocial());
45 ps.setString(3, em.getApelido());
46 ps.setString(4, em.getDtVencimento());
47 ps.execute();
48 } finally {
49 if(ps!=null) try {ps.close(); } catch( Exception e ) {}
50 if(ps!=null) try {conexao.close(); } catch( Exception e ) {}
51 }
52 }
53
54 }
Qdo tento executar me apresenta uma exceção:
java.lang.NullPointerException
testeEventos
at br.com.solutec.gestor.dao.empresa.EmpresaDao.cadastrar(EmpresaDao.java:42)
at br.com.solutec.gestor.negocio.empresa.NegocioEmpresa.Salvar(NegocioEmpresa.java:26)
at br.com.solutec.gestor.gui.controle.empresa.EventosEmpresaButtons.salvar(EventosEmpresaButtons.java:35)
at br.com.solutec.gestor.gui.components.StoolBar.btSalvarClick(StoolBar.java:126)
at br.com.solutec.gestor.gui.components.StoolBar.access$100(StoolBar.java:13)
at br.com.solutec.gestor.gui.components.StoolBar$2.actionPerformed(StoolBar.java:56)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
Falha Negocio!!!
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)