Mybatis 注解方式实现获取插入自增id

Mapers

public interface Mapers {
    //自增字段为 id
    @Insert("${sql}")
	@Options(useGeneratedKeys=true, keyProperty="id",keyColumn="id")
	void doReturnInsertSQL(InsertId sql);
}

InsertId

public class InsertId {
	public int id;
	public String sql;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getSql() {
		return sql;
	}
	public void setSql(String sql) {
		this.sql = sql;
	}
	
	
}

用法：

String sql = "insert into test_1 set name='n_"+i+"'";
InsertId ia = new InsertId();
ia.sql = sql;
mapper1.doReturnInsertSQL(ia);
sysout("> id="+ia.id);