Central Connecticut State University Spring 2000 CS 407 Advanced Topics in CS -- Java Database Connectivity 3 Credits Section 71 Mon, Wed 5:15-6:30 PM Room C 224 Copernicus Hall Instructor: Dr. Charles W. Neville Prerequisites: CS 152 and CS 254. Course Description: This is an experimental course, which will develop as we go. We shall go through Henri Jubin's book, Java Beans by Example. Ultimately, we shall develop a complete enterprise Java database system, where we shall connect via Java with a network database running on one of the CS Department's servers. Throughout this course, we shall stress object oriented design methodology, together with the design and use of reusable software components. We shall stress Java Beans because a Java Bean is a reusable software component intended for use in a visual development environment. We shall also stress JDBC (Java Database Connectivity) and JSQL (Java SQL) because this course is, after all, about Java Database Connectivity. Required Text: Henri Jubin, Java Beans by Example, Prentice Hall PTR, 1997, ISBN 0-13-790338-3. Software: Java version 1.2.2, frequently referred to as Java 2, and NetBeans DeveloperX2 2.1.2, a visual Java Beans development environment. The Sun Java Development Kit, version 1.2.2 containing the complete Java Beans API is available on the machines in the CS Lab in room 208 Maria Sanford Hall, and in the University Microcomputer Lab in Marcus White Annex. For those who wish to work at home, you may wish to download the most recent version of Sun's Java Development Kit and NetBeans Developer. Both are FREE! See my Java Resources Page, immediately off my web page (see below) for links. Java Resources Page: There is a comprehensive Java resources page immediately off my Web page, http://www.cs.ccsu.edu/~neville/. (No period at the end of the URL.) This page includes a large number of demos and tutorials, and links to SUN Microsystems' Java pages, including the SUN Microsystems Java Development Kit (free for the downloading!) and the SUN Microsystems Java API documentation. CS 407 -- Java Database Connectivity Course Web Page: There is a CS407 -- Java Database Connectivity Home Page immediately off of my Web page at the URL listed above. The page includes project descriptions and the course syllabus, as well as a link to the Java Resources Page. Assignments and Exams: Reading assignments are listed below. Each exam date is denoted by **. Make-up exams are scheduled by appointment only. Projects: There will be three projects. Each project will be announced in class, with due dates and instructions for handing in. The project descriptions will also available on the CS 407 - Java Database Connectivity Course Web page, immediately available off of my home page (see above). Grading: Your final grade will be based on on project assignments (1/3), in- class exams (1/3), and the final exam (1/3), and will be affected by classroom participation, conduct and attendance. The exams will include questions from the textbook and lab assignments on the computer. The numerical grades for the exams will be averaged and then converted to a letter grade. Attendance: Two unexcused absence are allowed, and any work missed must be made up. The student should notify the instructor concerning absences, or there will be a grade penalty. Student Conduct. It is expected that all students will conduct themselves in a respectful manner, and will assist in maintaining an atmosphere conducive to learning in the classroom. Honesty Policy. It is expected that all students will conduct themselves in an honorable and honest manner. It is alright to give and receive help on projects, but no student may claim another's work as his or her own, and no student may have another student's program in his or her possession. Students may use code from published sources, but if a student uses code from a source other than class or the text, the student should provide a reference in comments. Office Hours: MW 2:00 -- 2:50 PM, MW 4:30 -- 5:00 PM and Tue--Thur 10:00 -- 10:50 AM, or by appointment, especially before and after class. Feel free to stay for help, and feel free to stay to chat. My office is in room 205 Maria Sanford Hall. In an emergency call me at 832-2719 (work). My Web page URL (Web address) is http://www.cs.ccsu.edu/~neville/. (Again, no period at the end of the URL.) Week No. Reading and Problem Assignments 1. 1/24 Chapter1, How to Use This Book. Chapter 2, Introducing Beans. 2. 1/31 Chapter 2 continued. 3. 2/7 Chapter 3, Building Blocks, The Java Beans API. Events. 4. 2/14 Chapter 3 continued. Properties. Introspection. 5. 2/21 Lincoln's and Washington's Birthday, No Classes! 2/23 Chapter 3 continued. Customization. Property Editors and the Property Sheet. 6. 2/28 Chapter 4, The Chili Pepper Application. 7. 3/6** Exam 1 (chapters 1--3). 3/8 Chapter 5 Enterprise Functionality. Internationalization 8. 3/13 Chapter 5 continued. Distribution/Remote Method Invocation. 3/18 to 3/26 Spring Recess, No Classes! 9. 3/27 Chapter 5 continued. Persistency. (This is the JDBC and JSQL part.) 10. 4/3 Chapter 5 continued. Persistency continued. (This is the JDBC and JSQL part.) 11. 4/10 Chapter 5 continued. Printing Chapter 6, Additional Topics Packaging Beans, Applets and Applications. 4/12 Chapter 6 continued. Security and Beans. Visual Development Environments. 12. 4/17** Exam 2 (chapters 4 and 5). 13. 4/24 Final Project Workshop. 14. 5/1 Final Project Workshop. 15. 5/8 Catch up. 5/10 Review 16. 5/15 Review 5/17** Final Exam, 5:15 -- 6:30 PM. Have a Good Summer!