csce315_Project2

Project requirements: https://people.engr.tamu.edu/choe/choe/courses/20fall/315/proj2.html

Dependencies

All provided .jar files work when compiling in a Windows environment. Ensure these jar files are compatible in your environment before compiling.

• rs2xml.jar
• jcommon-1.0.0.jar
• jfreechart-1.0.1.jar
• xchart-3.6.5.jar
• mysql-connector-java-8.0.21.jar

Setup

1. Ensure all dependencies from the preceeding section are on the classpath when compiling and are compatible with your environment
2. If you are running Windows 10, skip this step. If you are not running Windows 10, the provided mysql-connector .jar file may not work and you will have to download the .jar file for your operating system from https://dev.mysql.com/downloads/connector/j/. This new file needs to be on the classpath in place of the original mysql-connector .jar file
3. Make sure Graphviz is installed on your system. If Graphviz is not installed, more information can be found at https://www.graphviz.org/download/
4. To use SQL_CommandLine, the server address, userID, and password need to be hardcoded in SQL_JDBC.java. This file is considered deprecated and prompt-based authentication has not been implemnented.
5. After the above steps, the program should compile and run successfully
6. If using SQL_GUI or SQL_Dashboard, when running the program have your MySQL server address, userID, and password ready to login

File information

• .jar files are dependencies which need to be included in the classpath at compile time
• src\SQL_JDBC.java manages the interface between the database and the Java application. To connect to your own DB, update the DB_URL, USER, and PASS variables for your DB
• src\SQL_CommandLine.java contains the user facing commandline interface, it is very simple and is primarily a while loop to scan for user input
• src\SQL_CommandLineInterpreter.java contains all input processing functions for command line input. It also contains all functions which support custom commands
• src\SQL_GUI.java contains the main class for the graphical user interface, initializes all sub panels.
• src\SQL_Dashboard.java contains the main class for the dashboard, it can launch an SQL_GUI
• All other .java files support the primary SQL_* classes by performing a function defined by their name.

Libraries

• https://hacksmile.com/rs2xml-jar-free-download/
• https://dev.mysql.com/downloads/connector/j/
• http://www.jfree.org/jfreechart/
• https://knowm.org/open-source/xchart/

Sources:

• https://www.w3schools.com/java/java_user_input.asp
• https://coderwall.com/p/609ppa/printing-the-result-of-resultset
• https://www.w3docs.com/snippets/java/how-to-split-a-string-in-java.html
• https://github.com/BranislavLazic/SwingTutorials/blob/master/src/main/java/CardLayoutTutorial.java
• https://stackoverflow.com/questions/4577792/how-to-clear-jtable
• https://stackoverflow.com/questions/192078/how-do-i-get-the-size-of-a-java-sql-resultset
• https://stackoverflow.com/questions/14407804/how-to-change-the-default-text-of-buttons-in-joptionpane-showinputdialog
• https://www.tutorialspoint.com/jfreechart/jfreechart_pie_chart.htm