public long readStringId(String value) throws SQLException {
		PreparedStatement s =
			selectByValueStatement.prepareIfNeeded(() -> db.prepareStatement(selectByValueSQL));
		long id = 0;
		s.setString(1, value);
		try (ResultSet rs = s.executeQuery()) {
			if (!rs.next()) {
				return id;
			}
			id = rs.getInt(1);
		}
		insertRecord(id, value);
		return id;
	}
Try to read the id of a specific string in the table
@param value is the string to try to find
@return the id of the string or 0 if the string is not in the table
@throws SQLException if the result set cannot be parsed
Ghidra/Features/BSim/src/main/java/ghidra/features/bsim/query/client/tables/SQLStringTable.java