should have committed awhile ago.  first made it so repeat assigning of patient nums in the mass assign page turns the background of the input box red to differentiate it form other errors.  now made some changes to finally clauses of sql methods to close the resultSet and ensure that each of resultSet, connection, and statement is closed.