Java在mssql数据表插入记录后取得自增长字段值

	prepare = connection.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS);
	prepare.setString(1, deptCode);
	prepare.setString(2, deptName);
	prepare.setString(3, beginTime);
	prepare.setString(4, endTime);
	prepare.executeUpdate();			
	// 获取自增长值
	resultSet= prepare.getGeneratedKeys();
	if (resultSet.next())
	{
		pid = resultSet.getInt(1);
	}
	else
	{
		pid = 0;
	}
	resultSet.close();
	prepare .close();

	return pid;