CIS 480 - Advanced Java - Final Review Suggestions

*   REMEMBER: final is MONDAY, MAY 14th, 3:00 - 4:50
    in NHW 244!!

*   final is CUMULATIVE!
        *   if it was fair game for tests 1 or 2, it is fair game for the 
	final;
        *   so, studying the review sheets for tests #1, #2 would be wise;
        *   studying the tests #1 and #2 themselves would also be wise;
        *   there may indeed be similar styles of questions as on those 
	tests;
        *   EXPECT to have to read, write some code;

*   general style of questions will be similar to those on tests 1 and 2;

*   high points from material SINCE Test 2:
	*   in-class notes and in-class examples (available from
	course web page) are a good study resource, of course;

	*   things you had to do on homeworks are also definitely
	fair game as possible final material;

	*   intro to JDBC
		*   what is JDBC? which package provides it?

		*   what does this package provide mechanisms for?

		*   what is the basic idea/concept behind JDBC? what does
		a JDBC driver do?

		*   what are the basic steps for writing Java code
		using JDBC?

		*   how can one write a Java application on sorrel
		that uses JDBC to connect to the student Oracle database
		on redwood?

		*   how can one write a Java applet that uses
		JDBC to connect to the student Oracle database on 
		redwood?

		*   what are some of the major classes we used in
		our JDBC examples and homework problems?

		*   what are differences between a Statement object
		and a PreparedStatement object? 
			*   when might it be preferred to use one
			over the other?

			*   you need to be able to use each in 
			appropriate situations;

		*   what is it IMPORTANT to make sure that a program
		does before it finishes, when using JDBC?
			*   how does one make *sure* this is
			accomplished in a Java application?
			in a Java applet? 

		*   how does one execute SQL queries using JDBC?

		*   what is a ResultSet? how can one use it? via what
		methods? what is a cursor?

		*   you should be able to obtain the information
		within a ResultSet instance;

		*   what is the difference between executeQuery()
		and executeUpdate()?

		*   what are those ?'s in PreparedStatements? How
		are they "filled"?

		*   in terms of commit, what is the default mode
		of a connection? How can you explicitly set this
		mode, instead?
			*   when are commits done, in the default
			mode?

			*   when are commits done, if you change
			that default?

		*   what do we mean by Connection metadata?
			*   how do you obtain it? 

			*   what are some examples of information
			you can obtain?		

			*   what are some of the methods of class
			DatabaseMetaData?

		*   what do we mean by ResultSet metadata?
			*   how do you obtain it?
			
			*   what are some examples of information
			you can obtain?
		
			*   what are some of the methods of class
			ResultSetMetaData?

	*   intro to SERVLETS
   		*   what is a servlet?

		*   you should be able to compare/contrast how a servlet runs
		to how an applet runs;
			*   and, be able to compare/contrast issues
			such as worrying about what version
			of the JVM a user is using, for servlets
			vs. applets;

		*   what can a servlet be an alternative to?

		*   what do you need to run servlets?

		*   when writing the actual servlet code, for an
		HttpServlet, what packages should be imported?

		*   how are servlets invoked? run? what are
		some of the capabilities of servlets?

		*   understand what is happening in the simple examples
		from lectures 14 and 15.

		*   how does one write and execute a very simple servlet
		on sorrel?

		*   what is JSP? What are some of its potential
		benefits? How does it "fit" with the idea of servlets?

		*   how can one make use of a parameter in a servlet?
		how can the user specify that parameter in invoking
		the serlvet (say, in the URL)?