'I am receiving a syntax error on "reimbursement_resolver" in the string line for index 5. My DAO package is set up correctly, yet this still occurs
@Override
public Reimbursement updateReimbursement(Reimbursement r) {
Connection c = cs.getConnection();
String sql = "UPDATE reimbursement " +
"SET amount = ?, " + //index 1
"submitted_date = ?, " + //index 2
"resolved_date = ?, " + //index 3
"description = ? " + //index 4
"reimbursement_resolver = ? " + //index 5
"reimbursement_status = ? " + //index 6
"reimbursement_type = ? "; //index 7
try{
PreparedStatement p = c.prepareStatement(sql);
p.setDouble(1, r.getAmount());
p.setDate(2, r.getSubmittedDate());
p.setDate(3, r.getResolvedDate());
p.setString(4, r.getDescription());
p.setInt(5, r.getReimbursementResolver().getEmpolyeeId());
p.setInt(6, r.getReimbursementStatus());
p.setInt(7, r.getReimbursementType());
p.execute();
return r;
} catch(SQLException e){
e.printStackTrace();
return null;
}
}
In IntelliJ it says "syntax error" on "reimbursement_resolver" but IntelliJ doesn't list the correct position, just "at or near". I don't know how to fix a syntax error when I don't see one explicitly stated with the red squigly line.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|