Mybatis insert返回主键ID

Mybatis insert语句书写

<insert id="insertSelective" useGeneratedKeys="true" keyProperty="fileId" parameterType="fileAlias" >

    insert into t_file_info ...

</insert>

useGeneratedKeys:是否生成主键

重点是写上 keyProperty = "fileId" fileId对应 fileAlias实体类的属性值

public class TFileInfo extends BaseModel implements Serializable {

private Integer fileId;

private String fileName;

//保存入库

fileInfoDao.insertSelective(fileInfo);

//返回入库ID

id = fileInfo.getFileId();

上述sql执行完毕后，fileInfo对象里的fileID就会被自动附加上fileId