How to transfer listview items to java database in JavaFX?

Question

I have a problem transferring listview items from a listview to a SQL database on netbeans using javaFX.

Here is a method that is called when you click the button to add to the listView items to the database (Add Order). I need all the items in the listview to be written to a column.

 private static void insertColl(){
    try{
        stmt = conn1.createStatement();
        String description = listView.getText();
        String query = " insert into ORDERS(DESCRIPTION)"
        + " values (?)";

    PreparedStatement preparedStmt = conn1.prepareStatement(query);

    preparedStmt.execute();
        stmt.close();
    }
    catch (SQLException sqlExcept){
        sqlExcept.printStackTrace();
    }

Here is what our javafx project looks like, the listview in question has an arrow pointing next to it.
Apologies if I am not using the correct terminology, as I am new to this. Thank you for your help.

can you please post your error?

Youcef LAIDANI
– Youcef LAIDANI

2017-03-21 14:52:37 +00:00
Commented Mar 21, 2017 at 14:52 — Youcef LAIDANI
– Youcef LAIDANI, Commented Mar 21, 2017 at 14:52

Graham · Accepted Answer · 2017-09-27 20:43:29Z

1

I think you misunderstood how PreparedStatement work, you should to set your paremetres to your statement ;

PreparedStatement preparedStmt = conn1.prepareStatement(query);
preparedStmt.setString(1, description );//<-------------------

edited Sep 27, 2017 at 20:43

Graham

7,86020 gold badges67 silver badges92 bronze badges

answered Mar 21, 2017 at 14:51

Youcef LAIDANI

60.3k21 gold badges111 silver badges178 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

programode0 · Accepted Answer · 2017-03-21 14:52:51Z

0

You missed to add to the PreparedStatement the values, and try with executeUpdate().

Also, you are not using the first Statement.

PreparedStatement preparedStmt=conexion.getConexion().prepareStatement(query);

preparedStmt.setString(1, description);

preparedStmt.executeUpdate();

answered Mar 21, 2017 at 14:52

programode0

196 bronze badges

Collectives™ on Stack Overflow

How to transfer listview items to java database in JavaFX?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related