/itec-746

Example Data Access code for item-746 database systems

Primary LanguageJavaMIT LicenseMIT

ITEC-746

Example Data Access code for ITEC-746 Database Systems at the University of Kansas

Directories explained

  • dat - contains sql files and scripts
    • start_postgres.sh - starts a docker image running postgres, please note you should change the postgres password
    • schema.sql - contains ddl to add tables to the database.
    • data.sql - contains dml to add data to the tables
    • see instructions for information on use
  • java-raw-jdbc - a projedt that connects to the database and serves data out of a REST api to show how to use raw JDBC.
    • Requires: JDK 17
    • Requires: Apache Maven