取得MySQL中的自動字串

EX:
Table 型態 : survey ( SurveyId int unsigned not null auto_increment ,
SurveyName varchar(20) not null ,
SurveyTemplateId varchar(5) not null)

Statement stmt;
stmt.executeUpdate ( " insert into survey ( SurveyName , SurveyTemplateId ) values( ' Name ' , ' Id ' );

int autoIncKeyFromFunc = -1;
ResultSet rs = stmt.executeQuery("SELECT LAST_INSERT_ID()");
if (rs.next())
autoIncKeyFromFunc = rs.getInt(1);
rs.close();

autoIncKeyFromFunc就是自動字串

取的方法好像好幾種,這只是其中一種