mybatis insert 操作返回主键

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

转自http://my.oschina.net/francis0115/blog/193543