SQL SERVER2005 JDBC 获取最新插入一行的ID

java+JDBC+SQL SERVER2005开发版。

String sqlString="INSERT INTO [DBname].[dbo].[TableName]([col1],[col2],[col3])VALUES('"+val1+"','"+val2+"','"+val3+"') SELECT @@IDENTITY AS 'Identity'";
PreparedStatement smst= conn.prepareStatement(sqlString);
ResultSet rs = smst.executeQuery();
int id = 0;
if(rs.next()){
    id = rs.getInt("Identity");
}