1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
String query = "Insert REQUEST(XmlQueryPath, Name) VALUES(?, ?)";
PreparedStatement preparedStatement = connectdb.prepareStatement(query,PreparedStatement.RETURN_GENERATED_KEYS);
try{
preparedStatement.setString(1, getXmlQueryPath());
preparedStatement.setString(2, getName());
preparedStatement.executeUpdate();
ResultSet keys = preparedStatement.getGeneratedKeys();
keys.beforeFirst();
while(keys.next()) {
this.idRequest = keys.getInt(1);
System.out.println("Id Generated : "+idRequest);
}
} catch (SQLException eSql) {
eSql.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally{
preparedStatement.close();
} |
Partager