Обсуждение: Possible Bug in PreparedStatement

Поиск
Список
Период
Сортировка

Possible Bug in PreparedStatement

От
Sabio - PSQL
Дата:
Please do not respond last email, only this...

    public int cedula_actualizar(String strcedula, String strids) {
        PreparedStatement ST = null;
        int retVal = 0;
        try {
            ST = conexion.prepareStatement("UPDATE maestro_partes SET
cedula=? WHERE consecutivo_identificacion IN (?)");
             ST.setString(1, strcedula);
             ST.setString(2, strids);
            retVal = ST.executeUpdate();
            ST.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
        return retVal;
    }

When execute this function with single data like this 3434 in strids, it
works, but when is pass somethine like this: 12232,3434,3,4545,34,3
don't work, Why?
In database cedula is varchar and consecutivo_identificacion is int