Reopening the thread which I marked as Resolved by mistake!

[Pranit Sonawane]

Hi all. First of all I'm sorry for unknowingly making a mistake of marking my previous issue as resolved as I have reopen it.

try {  
        Class.forName("com.mysql.jdbc.Driver");  
        Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?charset=UTF-8", "root", "pranit");  
        PreparedStatement ps = cn.prepareStatement("select * from opbal");  
        ResultSet rs = ps.executeQuery();  
        rs.beforeFirst();  
        String fon, fov = "";  
        while (rs.next()) {  
            fon = rs.getString("name");  
            fov = rs.getString("vibhag");  
            out.println(fon+" = "fov+"<br>");  
            PreparedStatement ps1 = cn.prepareStatement("update salaries set vibhag = '" + fov + "' where name = '" + fon + "'");  
            ps1.executeUpdate();  
        }         
               
    } catch (Exception e) {  
        out.println(e.getMessage());  
    } 

Above was the code which I posted in my earlier thread as the record is not updating. I tried making changes such as

int i = ps1.executeupdate();
System.out.println(i);

which prints "1" as a result and in actual the query doesn't update the column's value!
Please help me its getting really tricky for me!
Many thanks!

[Maneesh Godbole]

Marking as resolved does not 'lock' the topic. You can still continue the discussion in it
https://coderanch.com/t/641452/JDBC/databases/update-query-doesn-run

Locking this one, so that all relevant discussion stays in one place