Update Query
I am connected to a database and trying to update a table, wiht a value in a similar field, based on it's null values. I keep getting and error that says syntax error in update statement. This is my first time trying this my code is below any suggestions?
import java.sql.*;
public class CoalTotals {
public static void main(String[] arguments) {
int count=0;
String data = "jdbc:odbc:OSBUpdate";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(
data, "", "");
Statement st = conn.createStatement();
ResultSet rec = st.executeQuery(
"SELECT LoanNumber, CancellationDate, PayoffDate " +
"FROM [AllFixedLoansNoNull] " +
"WHERE " +
"(PayoffDate is null) " +
"ORDER BY LoanNumber");
while(rec.next()) {
ResultSet updat = st.executeQuery(
"Update [AllFixedLoansNoNull]"+
"(Set PayoffDate = '"+rec.getString(2)+"') "+
"WHERE "+
"(LoanNumber='"+rec.getString(1)+"')");
System.out.println(rec.getString(1) + "\t"
+ rec.getString(2) + "\t\t"
+ rec.getString(3));
}
System.out.println(count);
st.close();
} catch (SQLException s) {
System.out.println("SQL Error: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState());
} catch (Exception e) {
System.out.println("Error: " + e.toString()
+ e.getMessage());
}
}
}
