private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { file1= jTextField1.getText(); String Numero="",Numero2="";double Cout =0; res=0; java.util.Date date=null; SimpleDateFormat sdt = new SimpleDateFormat("dd/MM/yyyy"); Workbook WbFichier=null; try { WbFichier = Workbook.getWorkbook(new File(file1)); Sheet ShtFeuille = WbFichier.getSheet(0); int nombre =ShtFeuille.getRows(); for(int i=2;i<=nombre;i++) { String columnC ="C"+i; String columnD ="D"+i; String columnF ="F"+i; String columnH ="H"+i; Cell cel04 = ShtFeuille.getCell(columnC); if (cel04.getType() == CellType.LABEL) { LabelCell lc = (LabelCell) cel04; Nom = lc.getString(); } Cell cel02 =ShtFeuille.getCell(columnD); System.out.println(cel02.getType()); if (cel02.getType() == CellType.LABEL) { LabelCell lc = (LabelCell) cel02; Numero2 = lc.getString(); try { date= sdt.parse(Numero2); sqlDate = new java.sql.Date(date.getTime()); } catch (ParseException ex) { Logger.getLogger(Consultation.class.getName()).log(Level.SEVERE, null, ex); } } Cell cel01 = ShtFeuille.getCell(columnF); if (cel01.getType() == CellType.LABEL) { LabelCell lc = (LabelCell) cel01; Numero = lc.getString(); } Cell cel03 = ShtFeuille.getCell(columnH); if (cel03.getType() == CellType.NUMBER) { NumberCell lc = (NumberCell) cel03; Cout = lc.getValue(); } System.out.println("aaaaaaa"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:tester"); Statement stmt=con.createStatement(); PreparedStatement ps=con.prepareStatement("INSERT INTO Eagle(Occupant,Date_,N_Appele,Cout) VALUES("+Nom+",'"+sqlDate+"',"+Numero+","+Cout+")"); ps.executeUpdate(); ps.close(); con.close(); } catch(Exception exe){exe.printStackTrace();} } } catch (Exception e){e.printStackTrace();}
Warning: Usage of a local non-builtin name Label gggggg java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access] Trop peu de param?tres. 1 attendu. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3149) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:216) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:138) at pfe2.Consultation.jButton1ActionPerformed(Consultation.java:320) at pfe2.Consultation.access$500(Consultation.java:17) at pfe2.Consultation$6.actionPerformed(Consultation.java:128) 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:6038) at javax.swing.JComponent.processMouseEvent(JComponent.java:3260) at java.awt.Component.processEvent(Component.java:5803) at java.awt.Container.processEvent(Container.java:2058) at java.awt.Component.dispatchEventImpl(Component.java:4410) at java.awt.Container.dispatchEventImpl(Container.java:2116) at java.awt.Component.dispatchEvent(Component.java:4240) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916) at java.awt.Container.dispatchEventImpl(Container.java:2102) at java.awt.Window.dispatchEventImpl(Window.java:2429) at java.awt.Component.dispatchEvent(Component.java:4240)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPreparedStatement ps=con.prepareStatement("INSERT INTO Eagle(Occupant,Date_,N_Appele,Cout) VALUES("+Nom+",'"+sqlDate+"',"+Numero+","+Cout+")");
PreparedStatement ps=con.prepareStatement("INSERT INTO Eagle(Occupant,Date_,N_Appele,Cout) VALUES("'+Nom+'",'"+sqlDate+"',"+Numero+","+Cout+")");