Olá eu mudei o comando agora acho que tá falhando e dá a seguinte mensagem:
java.sql.SQLException: Falha ao criar o banco de dados ‘eletronica’, consulte a próxima exceção para obter detalhes.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at persistencia.PersistenciaConexao.<clinit>(PersistenciaConexao.java:15)
at persistencia.PersistenciaCliente.gravar(PersistenciaCliente.java:27)
at layout.CadastroCliente$1.actionPerformed(CadastroCliente.java:105)
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.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)
Caused by: java.sql.SQLException: Falha ao criar o banco de dados 'eletronica', consulte a próxima exceção para obter detalhes.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 42 more
java.lang.NullPointerException
at persistencia.PersistenciaCliente.gravar(PersistenciaCliente.java:28)
at layout.CadastroCliente$1.actionPerformed(CadastroCliente.java:105)
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.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)
olhe o codio de onde tá dando o erro.
package persistencia;
import interfaces.Percistencia;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import beans.Cliente;
import excecoes.ContatoNaoExisteException;
public class PersistenciaCliente implements Percistencia{
static PreparedStatement stmt;
public PersistenciaCliente() {
}
//==============================================
public void gravar(Object obj)
{
Cliente cliente = (Cliente) obj;
try {
stmt = PersistenciaConexao.conexao
.prepareStatement("insert into tbcliente(nome, endereco, rg, cpf, sexo, datanascimento, fone) values(?,?,?,?,?,?,?)");
System.out.println("Chegou no banco");
stmt.setString (1, cliente.getNome());
stmt.setString (2, cliente.getEndereço());
stmt.setString (3, cliente.getRG());
stmt.setString (4, cliente.getCPF());
stmt.setString (5, cliente.getSexo());
stmt.setString (6, cliente.getDataNascimento());
stmt.setString (7, cliente.getFone());
System.out.println("Passou pelo banco");
stmt.execute();
System.out.println("Banco Executado");
} catch (Exception e) {
e.printStackTrace();
}
}
// ==========================================================================
public Object buscar(Object obj) throws ContatoNaoExisteException
{
Cliente cliente = (Cliente) obj;
java.sql.ResultSet rs;
try {
stmt = PersistenciaConexao.conexao.prepareStatement
("select * from tbcliente where codigo=?");
stmt.setInt(1, cliente.getCodigo());
rs = stmt.executeQuery();
if (rs.first())
{
cliente.setCodigo (rs.getInt("codigo"));
cliente.setNome (rs.getString("nome"));
cliente.setEndereço (rs.getString("endereco"));
cliente.setRG (rs.getString("rg"));
cliente.setCPF (rs.getString("cpf"));
cliente.setSexo (rs.getString("sexo"));
cliente.setDataNascimento (rs.getString("datanascimento"));
cliente.setFone (rs.getString("fone"));
return cliente;
}
else
throw new ContatoNaoExisteException("O cliente " + cliente.getCodigo() + " não está cadastrado");
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
//==============================================
public void alterar(Object obj) {
try {
Cliente cliente = (Cliente) obj;
stmt = PersistenciaConexao.conexao
.prepareStatement("update tbcliente set nome=?, endereco=?, rg=?, cpf=?,sexo=?, datanascimento=?, fone=? where codigo=?");
stmt.setString (1, cliente.getNome());
stmt.setString (2, cliente.getEndereço());
stmt.setString (3, cliente.getRG());
stmt.setString (4, cliente.getCPF());
stmt.setString (5, cliente.getSexo());
stmt.setString (6, cliente.getDataNascimento());
stmt.setString (7, cliente.getFone());
stmt.setInt (8, cliente.getCodigo());
stmt.execute();
} catch (Exception e) {
e.printStackTrace();
}
}
//================================================
public void excluir(Object obj)
{
Cliente cliente = (Cliente) obj;
try {
stmt = PersistenciaConexao.conexao
.prepareStatement("delete from tb_cliente where codigo=?");
stmt.setInt(1, cliente.getCodigo());
stmt.execute();
} catch (Exception e) {
e.printStackTrace();
}
}
//==========================================================================
public Vector buscarTudo(){
ResultSet rs;
Vector<Cliente> cliente = new Vector<Cliente>();
try {
stmt = PersistenciaConexao.conexao.prepareStatement
("select * from tb_cliente");
rs = stmt.executeQuery();
while (rs.next())
{
Cliente cli = new Cliente();
cli.setCodigo (rs.getInt("codigo"));
cli.setNome (rs.getString("nome"));
cli.setEndereço (rs.getString("endereco"));
cli.setRG (rs.getString("rg"));
cli.setCPF (rs.getString("cpf"));
cli.setSexo (rs.getString("sexo"));
cli.setDataNascimento(rs.getString("datanascimento"));
cli.setFone (rs.getString("fone"));
cliente.add(cli);
}
return cliente;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
}