mybatis insertOrUpdate

MyBatis does not have a built-in "insertOrUpdate" method like some other ORMs do. However, you can achieve similar functionality by using the "insert" and "update" statements separately.

To perform an insert or update operation in MyBatis, you can use the `<insert>` and `<update>` tags in your XML mapper file. Here's an example:

<!-- Insert statement -->
<insert id="insertOrUpdate" parameterType="YourModelClass">
  INSERT INTO your_table (id, column1, column2)
  VALUES (#{id}, #{column1}, #{column2})
  ON DUPLICATE KEY UPDATE
  column1 = VALUES(column1),
  column2 = VALUES(column2)
</insert>

<!-- Update statement -->
<update id="update" parameterType="YourModelClass">
  UPDATE your_table
  SET column1 = #{column1},
      column2 = #{column2}
  WHERE id = #{id}
</update>

In the above example, the `<insertOrUpdate>` method first tries to insert a new record. If there is a duplicate key conflict, it performs an update instead. The `ON DUPLICATE KEY UPDATE` clause is used in the insert statement to specify the columns to be updated.

In your Java code, you can call this operation using the `insertOrUpdate` method:

YourModelClass model = new YourModelClass();
model.setId(123);