segue as classes
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package projetobd.bancodedados;
import com.mysql.jdbc.Connection;
import com.sun.org.apache.xpath.internal.functions.FuncBoolean;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import projetobd.conexao.ConexaoMySql;
import projetobd.empresa.Funcionario;
import projetobd.empresa.Orelha;
/**
*
* @author Rafael
*/
public class EmpresaDAO {
Connection cn;
public EmpresaDAO() throws SQLException, ClassNotFoundException {
this.cn = (Connection) ConexaoMySql.getConexao();
}
public void insertReg(Funcionario f1) throws SQLException {
String sql = "insert into funcionario (nome,salario,empresa)"
+ "values (?,?,?)";
PreparedStatement stm = cn.prepareStatement(sql);
stm.setString(1, f1.getNome());
stm.setInt(2, (int) f1.getSalario());
stm.setString(3, f1.getEmpresa());
stm.execute();
stm.close();
System.out.println("ADICIONADO COM SUCESSO");
}
public List<Funcionario> selectReg() throws SQLException {
String sql = "select * from funcionario";
PreparedStatement stm = this.cn.prepareStatement(sql);
ResultSet rSet = stm.executeQuery();
List<Funcionario> lista = new ArrayList<Funcionario>();
while (rSet.next()) {
Orelha c1 = new Orelha();
c1.setNome(rSet.getString("nome"));
c1.setId((Integer.parseInt(rSet.getString("id"))));
c1.setSalario((Integer.parseInt(rSet.getString("salario"))));
lista.add(c1);
}
rSet.close();
stm.close();
return lista;
}
public void updateReg (Funcionario c1) throws SQLException {
String code = "update funcionario set nome=?, salario=?, empresa=?, where id=?";
PreparedStatement stm = cn.prepareStatement(code);
stm.setString(1, c1.getNome());
stm.setInt(2, (int) c1.getSalario());
stm.setString(3, c1.getEmpresa());
stm.setInt(4, c1.getId());
stm.execute();
stm.close();
}
public void removeReg (Funcionario c1) throws SQLException {
String code = "delete from funcionario where id = ?";
PreparedStatement stm = cn.prepareStatement(code);
stm.setInt(1, c1.getId());
stm.execute();
stm.close();
}
}
private void jBsaveActionPerformed(java.awt.event.ActionEvent evt) {
Orelha c1 = new Orelha();
c1.setNome(jLnome.getText());
c1.setEmpresa(jLempresa.getText());
c1.setSalario (Integer.parseInt(jLsalario.getText() ) );
try {
EmpresaDAO bd = new EmpresaDAO();
bd.insertReg(c1);
} catch (SQLException ex) {
Logger.getLogger(grafico.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(grafico.class.getName()).log(Level.SEVERE, null, ex);
}
}
Strack
run: Exception in thread "AWT-EventQueue-0" java.lang.NumberFormatException: For input string: "Salario:" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) at java.lang.Integer.parseInt(Integer.java:449) at java.lang.Integer.parseInt(Integer.java:499) at projetobd.grafico.grafico.jBsaveActionPerformed(grafico.java:280) at projetobd.grafico.grafico.access$400(grafico.java:26) at projetobd.grafico.grafico$5.actionPerformed(grafico.java:189) 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.Component.processMouseEvent(Component.java:6288) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6053) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4651) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4481) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577) 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:2478) at java.awt.Component.dispatchEvent(Component.java:4481) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643) at java.awt.EventQueue.access$000(EventQueue.java:84) at java.awt.EventQueue$1.run(EventQueue.java:602) at java.awt.EventQueue$1.run(EventQueue.java:600) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:616) at java.awt.EventQueue$2.run(EventQueue.java:614) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:613) 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ÍDO COM SUCESSO (tempo total: 15 segundos)
Alguem sabe pq ta dando erro? Sera que a conversao de string p/ int nao ta funcionando? Foi oque pareceu :)
