private long writeNewString(String value) throws SQLException {
		PreparedStatement s = insertStatement.prepareIfNeeded(
			() -> db.prepareStatement(insertSQL, Statement.RETURN_GENERATED_KEYS));
		s.setString(1, value);
		s.executeUpdate();
		try (ResultSet rs = s.getGeneratedKeys()) {
			if (!rs.next()) {
				throw new SQLException("Error during insertion");
			}
			long 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