Doorcard creation system for California State University Sacramento Department of Computer Science
This system was designed and built by Team Inlustris for Senior Project for use in the Department of Computer Science to generate the schedules of professors to then be printed out and pasted to their office door.
The system is Java-based, with an accompanying website and database. The Java-based tool contains 3 functions:
- Creating an Excel spreadsheet containing the doorcards (which can then be printed for use by the department) based on information pulled from the database
- Reading and updating course information in the database from an Excel spreadsheet (downloaded from the existing school system)
- Deleting existing course information from the database
The following external libraries were used: Apache Commons Collections 4-4.1 https://commons.apache.org/proper/commons-collections/
JCraft Java Secure Channel (JSCH) 0.1.54 http://www.jcraft.com/jsch/
MySQL Java connector 5.1.46 https://dev.mysql.com/downloads/connector/j/
Apache POI 3.17 Apache POI OOXML 3.17 https://poi.apache.org
Apache XMLBeans 2.6.0 https://xmlbeans.apache.org