private void voegIngToe() { try { Statement query = db.createStatement(); String naam = naamVeld.getText(); Double p = new Double(prijsVeld.getText().trim()); double prijs = p.doubleValue(); String eenheid = eenheidVeld.getText(); String sql ="INSERT INTO Voorraad (naam,kost,perEenheid)" + "VALUES ('" + naam + "'," + prijs +",'" + eenheid + "')"; query.executeUpdate(sql); } //END try() TO WRITE RECORD //CATCH NUMBER FORMAT EXCEPTION FOR PRICE FIELD catch (NumberFormatException nfe) { JOptionPane.showMessageDialog(null,"\n\nWRITE FILE ERROR\n" + "MAKE SURE PRICE OR AMOUNT IS CORRECT\n" + nfe.toString()); }//END NumberFormatcatch() //CATCH ANY EXCEPTIONS WRITING TO FILE catch (SQLException io) { JOptionPane.showMessageDialog(null,"\nERROR WRITING FILE\n"+ io.toString()); }//END IO catch() //CLEAR TEXT FIELDS naamVeld.setText(""); prijsVeld.setText(""); eenheidVeld.setText(""); return true; }