What am I doing wrong?

[Jennifer Sohl]

Hi. I'm trying to write a program that updates a table on SQL server. When I hardcode a ref number into my select statement and update it, it seems to work ok. But when I select all of the records from the table and try to update them, it doesn't update a darn thing. I've looked at it for a very long time trying to figure out what stupid mistakes I made, but can't find what I'm doing wrong. I was hoping someone could look at this code and help me out a bit??

Thanks for any help!!!

import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class UpdateARDOC {
    private Connection con;
    private Statement stmt;
    private ResultSet rs;
    private StringBuffer last2 = new StringBuffer();
    private StringBuffer refno = new StringBuffer();
    private StringBuffer user5all = new StringBuffer();
    public UpdateARDOC() {
        try {
            Class.forName("com.jnetdirect.jsql.JSQLDriver");
            String sourceURL = "jdbc:JSQLConnect://xxx.xx.xx.xx/database=northwind";
            con = DriverManager.getConnection(sourceURL, "master", "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("Select user5,refnbr from ardoc order by refnbr");
            while(rs.next()) {
                user5all.replace(0,9,rs.getString(1));
                last2.replace(0,1, rs.getString(1).substring(2,4));
                refno.replace(0,9, rs.getString(2));
                if(last2.charAt(0) != ' ') {
                    stmt.executeUpdate("Update ardoc set user5 = '" + last2.toString() + 
                                       "' where refnbr = '" + refno.toString() + 
                                       "' and user5 = '" + user5all.toString() + "'");
                }
            }
            stmt.close();
            con.close();
        }
        catch(ClassNotFoundException cnfe) {
            JOptionPane.showMessageDialog(null, cnfe, "Error!", JOptionPane.ERROR_MESSAGE);
        }
        catch(SQLException sqle) {
            JOptionPane.showMessageDialog(null, sqle, "Error!", JOptionPane.ERROR_MESSAGE);
        }
    }
    public static void main(String[] args) {
        UpdateARDOC ua = new UpdateARDOC();
    }
}

What I'm trying to do is trying to take pos. 3-4 of the customer code field(user5), check if they're blank(if so it's OK), if it's not blank, I want to move the value of those two positions to the beginning of the fields and fill the rest with blanks.
[ June 28, 2002: Message edited by: Jennifer Sohl ]
[ June 28, 2002: Message edited by: Dirk Schreckmann ]

[Dirk Schreckmann]

Get thee to The JDBC Forum...