错误--> java.sql.SQLSyntaxErrorException: ORA-01722:数字无效

String value = "123"; // 确保这是一个有效的数字字符串
int number = Integer.parseInt(value);

String sql = "INSERT INTO my_table (id, value) VALUES (?, ?)";
try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
    pstmt.setInt(1, 1);
    pstmt.setString(2, "123"); // 确保这是一个有效的数字字符串
    pstmt.executeUpdate();
} catch (SQLException e) {
    e.printStackTrace();
}

public boolean isValidNumber(String str) {
    try {
        Double.parseDouble(str);
        return true;
    } catch (NumberFormatException e) {
        return false;
    }
}

public boolean isValidNumber(String str) {
    return str.matches("-?\\d+(\\.\\d+)?");
}

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DatabaseExample {
    public static void main(String[] args) {
        String value = "123"; // 假设这是从某处获取的值
        if (isValidNumber(value)) {
            try (Connection connection = getConnection();
                 PreparedStatement pstmt = connection.prepareStatement("INSERT INTO my_table (id, value) VALUES (?, ?)")) {
                pstmt.setInt(1, 1);
                pstmt.setString(2, value);
                pstmt.executeUpdate();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else {
            System.out.println("Invalid number format: " + value);
        }
    }

    private static boolean isValidNumber(String str) {
        return str.matches("-?\\d+(\\.\\d+)?");
    }

    private static Connection getConnection() throws SQLException {
        // 这里应该是获取数据库连接的代码
        return null;
    }
}