boa tarde
estou fazendo uma aplicação com banco de dados e impressao de relatorios
criei a classe dao, para os metodos de adicionar, alterar, exlcuir… itens do banco
public void adiciona(DESCONTAMINADOR c1) throws SQLException{
// prepara a conexão
String sql = "insert into DESCONTAMINADOR(ANO, DATA, RAZAOSOC, CNPJ, NOME, CPF, MARCA_MODELO,"
+"PLACA, CHASSI, TIPO, N_INMETRO, CAPACIDADE, FABRICANTE, CAPACITACAO, MANUTENCAO, REFORMA,"
+"VERIFIC_METROL, OUTROS_FIN, OUTRO_DESC_FIN, VAPOR, VENTILACAO, EXAUSTAO, AGUA , OUTROS,"
+"OUTROS_DESC, VOLUME1, ULT_PRODUTO1, N_ONU1, CLASSE_RISCO1, TEMP_APLIC1, MASSA_VAPOR1, VOLUME2,"
+"ULT_PRODUTO2, N_ONU2, CLASSE_RISCO2, TEMP_APLIC2, MASSA_VAPOR2, VOLUME3, ULT_PRODUTO3, N_ONU3,"
+"CLASSE_RISCO3, TEMP_APLIC3, MASSA_VAPOR3, VOLUME4, ULT_PRODUTO4, N_ONU4, CLASSE_RISCO4, TEMP_APLIC4,"
+"MASSA_VAPOR4, VOLUME5, ULT_PRODUTO5, N_ONU5, CLASSE_RISCO5, TEMP_APLIC5, MASSA_VAPOR5, VOLUME6,"
+" ULT_PRODUTO6, N_ONU6, CLASSE_RISCO6, TEMP_APLIC6, MASSA_VAPOR6, VOLUME7, ULT_PRODUTO7, N_ONU7, CLASSE_RISCO7,"
+"TEMP_APLIC7, MASSA_VAPOR7, VOLUME8, ULT_PRODUTO8, N_ONU8, CLASSE_RISCO8, TEMP_APLIC8, MASSA_VAPOR8, REG_ANOMALIAS,"
+"NOME_INST_1, NOME_INST_2, MARCA_INST_1, MARCA_INST_2, N_SERIE_INST_1, N_SERIE_INST_2, ULTCALIBRACAO_INST_1,"
+"ULTCALIBRACAO_INST_2, REGTECNICA, PROCED, NOTAS, NOME_COL, FUNCAO, CPF_COL, OBS )" + "values(?,?,?,?,?,?,?,?,?,?,?,"
+"?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
+"?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
PreparedStatement stmt = conexao.prepareStatement(sql);
stmt.setString(1, c1.getAno());
stmt.setString(2, c1.getData());
stmt.setString(3, c1.getRazaosoc());
stmt.setString(4, c1.getCnpj());
stmt.setString(5, c1.getNome());
stmt.setString(6, c1.getCpf());
stmt.setString(7, c1.getMarca_modelo());
stmt.setString(8, c1.getPlaca());
stmt.setString(9, c1.getChassi());
stmt.setString(10, c1.getTipo());
stmt.setString(11, c1.getN_inmetro());
stmt.setString(12, c1.getCapacidade());
stmt.setString(13, c1.getFabricante());
stmt.setString(14, c1.getCapacitacao());
stmt.setString(15, c1.getManutencao());
stmt.setString(16, c1.getReforma());
stmt.setString(17, c1.getVerific_metrol());
stmt.setString(18, c1.getOutros_fin());
stmt.setString(19, c1.getOutro_desc_fin());
stmt.setString(20, c1.getVapor());
stmt.setString(21, c1.getVentilacao());
stmt.setString(22, c1.getExaustao());
stmt.setString(23, c1.getAgua());
stmt.setString(24, c1.getOutros());
stmt.setString(25, c1.getOutros_desc());
stmt.setString(26, c1.getVolume1());
stmt.setString(27, c1.getN_onu1());
stmt.setString(28, c1.getClasse_risco1());
stmt.setString(29, c1.getTemp_aplic1());
stmt.setString(30, c1.getMassa_vapor1());
stmt.setString(31, c1.getVolume2());
stmt.setString(32, c1.getN_onu2());
stmt.setString(33, c1.getClasse_risco2());
stmt.setString(34, c1.getTemp_aplic2());
stmt.setString(35, c1.getMassa_vapor2());
stmt.setString(36, c1.getVolume3());
stmt.setString(37, c1.getN_onu3());
stmt.setString(38, c1.getClasse_risco3());
stmt.setString(39, c1.getTemp_aplic3());
stmt.setString(40, c1.getMassa_vapor3());
stmt.setString(41, c1.getVolume4());
stmt.setString(42, c1.getN_onu4());
stmt.setString(43, c1.getClasse_risco4());
stmt.setString(44, c1.getTemp_aplic4());
stmt.setString(45, c1.getMassa_vapor4());
stmt.setString(46, c1.getVolume5());
stmt.setString(47, c1.getN_onu5());
stmt.setString(48, c1.getClasse_risco5());
stmt.setString(49, c1.getTemp_aplic5());
stmt.setString(50, c1.getMassa_vapor5());
stmt.setString(51, c1.getVolume6());
stmt.setString(52, c1.getN_onu6());
stmt.setString(53, c1.getClasse_risco6());
stmt.setString(54, c1.getTemp_aplic6());
stmt.setString(55, c1.getMassa_vapor6());
stmt.setString(56, c1.getVolume7());
stmt.setString(57, c1.getN_onu7());
stmt.setString(58, c1.getClasse_risco7());
stmt.setString(59, c1.getTemp_aplic7());
stmt.setString(60, c1.getMassa_vapor7());
stmt.setString(61, c1.getVolume8());
stmt.setString(62, c1.getN_onu8());
stmt.setString(63, c1.getClasse_risco8());
stmt.setString(64, c1.getTemp_aplic8());
stmt.setString(65, c1.getMassa_vapor8());
stmt.setString(66, c1.getReg_anomalias());
stmt.setString(67, c1.getNome_inst_1());
stmt.setString(68, c1.getNome_inst_2());
stmt.setString(69, c1.getMarca_inst_1());
stmt.setString(70, c1.getMarca_inst_2());
stmt.setString(71, c1.getN_serie_inst_1());
stmt.setString(72, c1.getN_serie_inst_2());
stmt.setString(73, c1.getUltcalibracao_inst_1());
stmt.setString(74, c1.getUltcalibracao_inst_2());
stmt.setString(75, c1.getRegtecnica());
stmt.setString(76, c1.getProced());
stmt.setString(77, c1.getNotas());
stmt.setString(78, c1.getNome_col());
stmt.setString(79, c1.getFuncao());
stmt.setString(80, c1.getCpf_col());
stmt.setString(82, c1.getObs());
stmt.execute();
stmt.close();
}
criei tambem a classe conexao para conectar ao banco
`public class Conexao {
public static Connection getConexao() {
// Cria e retorna uma nova conexão com o BD
//private Connection getConnection() {
//---> CONEXÃO COM FIREBIRD <--- \\
//Connection conn = null;
//try {
// Class.forName("org.firebirdsql.jdbc.FBDriver").newInstance();
// String url = "jdbc:firebirdsql:localhost/3050:C:/DESCONTAMINADOR/DATABASE/DESCONTAMINADOR.GDB";
// String user = "sysdba";
// String pass = "masterkey";
// conn = DriverManager.getConnection(url, user, pass);
//} catch (InstantiationException e) {
// e.printStackTrace();
//} catch (IllegalAccessException e) {
// e.printStackTrace();
//} catch (ClassNotFoundException e) {
// e.printStackTrace();
//} catch (SQLException e) {
// e.printStackTrace();
//}
//return conn;
//---> CONEXÃO COM SQLITE <--- \\
Connection conn = null;
try {
Class.forName("org.sqlite.JDBC").newInstance();
String url = "jdbc:sqlite:C:\\DESCONTAMINADOR\\DATABASE\\DESCONTAMINADOR.DB";
// return DriverManager.getConnection("jdbc:sqlite:C:\\DESCONTAMINADOR\\DATABASE\\DESCONTAMINADOR.DB");
conn = DriverManager.getConnection(url);
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
//Class.forName ("org.firebirdsql.jdbc.FBDriver");
//System.out.println ("Conectando ao banco de dados");
//return DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:C:\\DESCONTAMINADOR\\DATABASE\\DESCONTAMINADOR.GDB");
//Class.forName("org.sqlite.JDBC");
//System.out.println("Conectando ao banco de dados");
//return DriverManager.getConnection("jdbc:sqlite:C:\\CARGAS PERIGOSAS\\DataBase\\CARGASPERIGOSAS");
//return DriverManager.getConnection("jdbc:sqlite:C:\\CARGAS PERIGOSAS\\DataBase\\DB");
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//System.out.println("Conectando ao banco de dados");
//return DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=CIPP.mdb");
}
}`
testei a conexão na minha classe main e conectou ao banco certinho.
mas quando clico no botao salvar da minha aplicação que tem o seguinte codigo
private void jBSALVARActionPerformed(java.awt.event.ActionEvent evt) {
cadastro();
verificardados();
verificaseleção_fin();
verificaseleção_proc();
}
public void cadastro(){
try {
DESCONTAMINADOR c1 = new DESCONTAMINADOR();
c1.setAno(jFTano.getText());
c1.setData(jFTdata.getText());
c1.setRazaosoc(jTFProprietario.getText());
c1.setCnpj(jTFCNPJ.getText());
c1.setNome(jTFCONDUTOR.getText());
c1.setCpf(jTFCPF.getText());
c1.setMarca_modelo(jTFMARCA.getText());
c1.setPlaca(jTFPLACA.getText());
c1.setChassi(jTFCHASSI.getText());
c1.setTipo(jTFEQUIPAMENTO.getText());
c1.setN_inmetro(jTFN_INMETRO.getText());
c1.setCapacidade(jTFCAPACIDADE.getText());
c1.setFabricante(jTFFABRICANTE.getText());
if (jRBCAPACITACAO.isSelected()){
c1.setCapacitacao("X");
c1.setManutencao("");
c1.setReforma("");
c1.setVerific_metrol("");
c1.setOutros_fin("");
c1.setOutro_desc_fin("");
}else if(jRBMANUTENCAO.isSelected()){
c1.setCapacitacao("");
c1.setManutencao("X");
c1.setReforma("");
c1.setVerific_metrol("");
c1.setOutros_fin("");
c1.setOutro_desc_fin("");
}else if(jRBREFORMA.isSelected()){
c1.setCapacitacao("");
c1.setManutencao("");
c1.setReforma("X");
c1.setVerific_metrol("");
c1.setOutros_fin("");
c1.setOutro_desc_fin("");
}else if(jRBVERIFC_METROL.isSelected()){
c1.setCapacitacao("");
c1.setManutencao("");
c1.setReforma("");
c1.setVerific_metrol("X");
c1.setOutros_fin("");
c1.setOutro_desc_fin("");
}else {
c1.setCapacitacao("");
c1.setManutencao("");
c1.setReforma("");
c1.setVerific_metrol("");
c1.setOutros_fin("X");
c1.setOutro_desc_fin(jTFOUTROS_DESCRICAO.getText());
}
if(jRBVAPOR.isSelected()){
c1.setVapor("X");
c1.setVentilacao("");
c1.setExaustao("");
c1.setAgua("");
c1.setOutros("");
c1.setOutros_desc("");
}else if(jRBVENTILACAO.isSelected()){
c1.setVapor("");
c1.setVentilacao("X");
c1.setExaustao("");
c1.setAgua("");
c1.setOutros("");
c1.setOutros_desc("");
}else if(jRBEXAUSTAO.isSelected()){
c1.setVapor("");
c1.setVentilacao("");
c1.setExaustao("X");
c1.setAgua("");
c1.setOutros("");
c1.setOutros_desc("");
}else if(jRBAGUA.isSelected()){
c1.setVapor("");
c1.setVentilacao("");
c1.setExaustao("");
c1.setAgua("X");
c1.setOutros("");
c1.setOutros_desc("");
} else {
c1.setVapor("");
c1.setVentilacao("");
c1.setExaustao("");
c1.setAgua("");
c1.setOutros("X");
c1.setOutros_desc(jTFOUTROS_DESCRICAO1.getText());
}
c1.setVolume1(jTFVOLUME1.getText());
c1.setUlt_produto1(jTFULT_PROD_1.getText());
c1.setN_onu1(jTFN_ONU_1.getText());
c1.setClasse_risco1(jTFCLASSE_RISCO_1.getText());
c1.setTemp_aplic1(jTFTEMP_APLIC_1.getText());
c1.setVolume2(jTFVOLUME2.getText());
c1.setUlt_produto2(jTFULT_PROD_2.getText());
c1.setN_onu2(jTFN_ONU_2.getText());
c1.setClasse_risco2(jTFCLASSE_RISCO_2.getText());
c1.setTemp_aplic2(jTFTEMP_APLIC_2.getText());
c1.setVolume3(jTFVOLUME3.getText());
c1.setUlt_produto3(jTFULT_PROD_3.getText());
c1.setN_onu3(jTFN_ONU_3.getText());
c1.setClasse_risco3(jTFCLASSE_RISCO_3.getText());
c1.setTemp_aplic3(jTFTEMP_APLIC_3.getText());
c1.setVolume4(jTFVOLUME4.getText());
c1.setUlt_produto4(jTFULT_PROD_4.getText());
c1.setN_onu4(jTFN_ONU_4.getText());
c1.setClasse_risco4(jTFCLASSE_RISCO_4.getText());
c1.setTemp_aplic4(jTFTEMP_APLIc_4.getText());
c1.setVolume5(jTFVOLUME5.getText());
c1.setUlt_produto5(jTFULT_PROD_5.getText());
c1.setN_onu5(jTFN_ONU_5.getText());
c1.setClasse_risco5(jTFCLASSE_RISCO_5.getText());
c1.setTemp_aplic5(jTFTEMP_APLIC_5.getText());
c1.setVolume6(jTFVOLUME6.getText());
c1.setUlt_produto6(jTFULT_PROD_6.getText());
c1.setN_onu6(jTFN_ONU_6.getText());
c1.setClasse_risco6(jTFCLASSE_RISCO_6.getText());
c1.setTemp_aplic6(jTFTEMP_APLIC_6.getText());
c1.setVolume7(jTFVOLUME7.getText());
c1.setUlt_produto7(jTFULT_PROD_7.getText());
c1.setN_onu7(jTFN_ONU_7.getText());
c1.setClasse_risco7(jTFCLASSE_RISCO_7.getText());
c1.setTemp_aplic7(jTFTEMP_APLIC_7.getText());
c1.setVolume8(jTFVOLUME8.getText());
c1.setUlt_produto8(jTFULT_PROD_8.getText());
c1.setN_onu8(jTFN_ONU_8.getText());
c1.setClasse_risco8(jTFCLASSE_RISCO_8.getText());
c1.setTemp_aplic8(jTFTEMP_APLIC_8.getText());
c1.setReg_anomalias(jTAREG_ANOMALIAS.getText());
c1.setNome_inst_1("");
c1.setNome_inst_2("");
c1.setMarca_inst_1("");
c1.setMarca_inst_2("");
c1.setN_serie_inst_1(jTFN_SERIE_INST_1.getText());
c1.setN_serie_inst_2(jTFN_SERIE_INST_2.getText());
c1.setUltcalibracao_inst_1(jFTULT_CALIB_INST_1.getText());
c1.setUltcalibracao_inst_2(jFTULT_CALIB_INST_2.getText());
c1.setRegtecnica(jTFREG_TEC_APLIC1.getText());
c1.setProced(jTFPROC_APLIC.getText());
c1.setNotas("");
c1.setNome_col(jTFNOME_COL.getText());
c1.setFuncao(jTFFUNCAO.getText());
c1.setCpf_col(jTFCPF_COL.getText());
c1.setObs(jTAOBS.getText());
DESCONTAMINADOR_DAO dao = new DESCONTAMINADOR_DAO();
dao.adiciona(c1);
} catch (SQLException ex) {
Logger.getLogger(Descontaminação.class.getName()).log(Level.SEVERE, null, ex);
}
}
acontece esse erro
nov 03, 2016 1:40:13 PM descontaminador.telas.Descontaminação cadastro
GRAVE: null
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (86 values for 89 columns)
at org.sqlite.core.DB.newSQLException(DB.java:920)
at org.sqlite.core.DB.newSQLException(DB.java:932)
at org.sqlite.core.DB.throwex(DB.java:897)
at org.sqlite.core.NativeDB.prepare(Native Method)
at org.sqlite.core.DB.prepare(DB.java:227)
at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:41)
at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:48)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:254)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226)
at descontaminador.classes.DESCONTAMINADOR_DAO.adiciona(DESCONTAMINADOR_DAO.java:42)
at descontaminador.telas.Descontaminação.cadastro(Descontaminação.java:1950)
at descontaminador.telas.Descontaminação.jBSALVARActionPerformed(Descontaminação.java:1711)
at descontaminador.telas.Descontaminação.access$1300(Descontaminação.java:33)
at descontaminador.telas.Descontaminação$13.actionPerformed(Descontaminação.java:1394)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
sera que alguem consegue me ajudar