java preparedStatement.executeUpdate() 只插入最后一行

Question

这是我的代码:

String insertQuery = "INSERT INTO Links(PageId, LinkId) values(?, ?)";
PreparedStatement preparedStatement = con.prepareStatement(insertQuery);
Vector<String> links = page.getLinks();    
for (String string : links) {       
    Concept c = dbpedia.findConceptbyTitle(string);                     
    if (c != null) {
        preparedStatement.setInt(1, Integer.parseInt(page.getID()));
        preparedStatement.setInt(2, c.id);
    }    
}
preparedStatement.executeUpdate();

奇怪的是，当我在executeUpdate之后设置断点时，只有最后一行插入到SQL表中!

Answer 1

添加preparedStatement.addBatch();在你离开循环之前。

并替换preparedStatement.executeUpdate();与preparedStatement.executeBatch();。