How to Delete row/rows in sqlite (java, not Android java)

Question

Need to delete records from sqlite db. One record row at a time and/or all records with a particular string value. I read many posts and most seem to be for Android and very different from plain Java - didn't find what I need.

Here's the code snippet I'm trying (delString comes in from a textfield), I did not set up record ID's.:

    Class.forName("org.sqlite.JDBC");
    Connection conn = DriverManager.getConnection("jdbc:sqlite:dufuss.db");

    delIt = Dialog_RecToDelete.delString; 
    String sql = "DELETE * FROM " + TABLE_NAME + " WHERE docName = ?";
    PreparedStatement preparedStatement = conn.prepareStatement(sql);
    preparedStatement.setString(1, delIt);
    ResultSet rs = preparedStatement.executeQuery();

    while (rs.next()) {
      // iterate through results
    }
  rs.close();
  conn.close();

did not work - tried it before posting. Get message: near "*": syntax error — headscratch
– headscratch, Commented Jun 18, 2013 at 21:57

DannyMo · Accepted Answer · 2013-06-18 22:01:59Z

5

According to the documentation, it should just be DELETE FROM ..., so remove the * in DELETE * FROM ....

Also, you should use PreparedStatement#executeUpdate instead of PreparedStatement#executeQuery

answered Jun 18, 2013 at 22:01

DannyMo

12.1k4 gold badges34 silver badges38 bronze badges

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

1 Comment

headscratch Over a year ago

Pefect! - it works! (deletes the row whose first column contain the delString value - just as I needed).

ddmps · Accepted Answer · 2013-06-18 22:09:04Z

2

SQLite is light also on the syntax, they do not use the * as it's unnecessary (Who only deletes a column only and not the entire row?).

So, the following syntax should work:

"DELETE FROM " + TABLE_NAME + " WHERE docName = ?"

Also note, as @damo commented, that you need to use executeUpdate() instead of executeQuery() and possibly a commit is in order if it's not auto-commiting.

More info on DELETE syntax here.

edited Jun 18, 2013 at 22:09

answered Jun 18, 2013 at 22:03

ddmps

4,3901 gold badge23 silver badges34 bronze badges

Collectives™ on Stack Overflow

How to Delete row/rows in sqlite (java, not Android java)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related