UPDATE oracle in java

Question

UPDATE oracle in java

Navigation

#1 by (1 votes)

0

I have a problem with an UPDATE in java, this one receives a parameter, it does not run, my syntax will put it here, maybe there is something that I forget, from what I've seen on the net, it's fine but I do not know pass: c

public void CollectRv(String Bcode){
      try{
    ConexionOracle conexionOracle = new ConexionOracle();
    conexionOracle.conectar();
    Connection conn = conexionOracle.getConnection();
    PreparedStatement ps = conn.prepareStatement("UPDATE tabla\n" +
                    "set tabla.estado = 1 \n" +
                    "where tabla.task_class_cd = 'CHECK' \n" +
                    "and tabla.estado = 0 \n" +
                    "and num = 3002000 \n" +
                    "and sched= (select sched from tabla where num =3002000 and code= ?");
    ps.setString(1,Bcode.trim());
    ps.executeUpdate();
    ps.close();
    conn.close();
    conexionOracle.cerrar();
     }catch (SQLException ex) {
        Logger.getLogger(Consulta.class.getName()).log(Level.SEVERE, null, ex);

    }
}

java oracle jsp

asked by elsa 25.05.2016 в 17:50

source

1 answer

Html Table, Get text from one cell by clicking on another Modify a datafile, but in the OS it still has the same space. SQL SERVER

score 1 · Answer 1

I put the query in a variable of type String and execute it in this way and it works:

PreparedStatement ps = conn.prepareStatement(sql); 
                   ps.setString(1,Bcode.trim());
                   ps.executeUpdate();
                   ps.close(); 
                   conn.close(); 
                   conexionOracle.cerrar();