I want to update a data in my row in the database but it will only add it to the existing data where this existing data is a integer.. example i have a existing data of 100 and my update data is 200.. so the result should be 300... please give me a sample code for this query update in jdbc... thanks

update [tableName] set [valueFieldName] = [valueFieldName]+[amount] where [row criteria expression]

Use Statement.executeUpdate() or PreparedStatement.executeUpdate() to execute the update.