public static void changeClosed(int rentTransID, int closed, String dateReturned) {
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		try{
			conn.setAutoCommit(false);
			PreparedStatement stmnt = conn.prepareStatement("UPDATE RentTransactions SET closed = ?, date_in = ? WHERE rent_trans_id = ?");
			stmnt.setInt(1, closed);
			stmnt.setString(2, dateReturned);
			stmnt.setInt(3, rentTransID);
			stmnt.execute();

			conn.commit();
			conn.setAutoCommit(true);

		}
		catch(SQLException e){
			System.out.println("Update fail: " + e);
		}
	
	}