Using myBatis with dynamic table name and object

Question

I'm about to create a dynamic SQL insert using myBatis, where the table name and the object holding the parameters are different. Something like this:

INSERT INTO ${tablename} (column1, column2) VALUES (#{column1}, #{column2})

The interface method would be this:

@Insert(CREATE)
@Options(useGeneratedKeys = true, keyProperty = "id", flushCache = true)
public int write(String tablename, Object object) throws Exception;

Where the Object holds the field values:

class Object {
  int id;
  String column1;
  String column2;

  getters, setters...
}

Unfortunately I can't find out how to do this, the best and working way I found is when the table name is a property of the Object, so the myBatis can read the value in this way. For some practical reason I'd like to avoid this approach, maybe someone has a better idea? Thanks.

Use a Map of parameters. Put the table name and the other details into this map — WW.
– WW., Commented Feb 8, 2014 at 20:28
Yes, the Map is a working solution too, but principally the same as if I put the table name into the object. The table name and the object properties have to be in the same value object. — derək
– derək, Commented Feb 9, 2014 at 12:01

Roman-Stop RU aggression in UA · Accepted Answer · 2014-02-11 21:06:00Z

4

Use @Param annotation like this

@Insert(CREATE)
@Options(useGeneratedKeys = true, keyProperty = "object.id", flushCache = true)
public int write(@Param("tablename") String tablename,
                 @Param("object") Object object) throws Exception;

and query

INSERT INTO ${tablename} (column1, column2) VALUES (#{object.column1}, #{object.column2})

edited Feb 11, 2014 at 21:06

answered Feb 11, 2014 at 11:54

Roman-Stop RU aggression in UA

16k3 gold badges52 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

derək Over a year ago

Thanks for the answer, I did not know it can be identified the object and its property in the query. And of course it worked at the keyProperty = "object.id".

Collectives™ on Stack Overflow

Using myBatis with dynamic table name and object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related