How do you implement Mysql insert query using an if statement in java?

Question

Let's say if you were to create a form where if you input a certain value inside a field it would return a certain value as well. For example, field name: salary, if salary equal to $500 then insert 5.0 into the table. The 5.0 represent scale rating.

I'm sorry if this sounds confusing to you guys. English is my second language. Thank you for any answers.

Answer 1

if(salary == 500){
statement.executeUpdate
}

like that ?