Pensum

1. og 2. semesters pensum, Softwarekonstruktion Dat17v1

1. semester

Emnerne for første semesters konstruktionsundervisning var følgende:

• OOP
  • Klasser
  • Objekter
  • Attributter
  • Metoder
  • Konstruktøre
• Primitive datatyper
• Arrays
• ArrayList
• Variabler
• Selektioner (if/else)
• Løkker (for, foreach, while)
• vi har desuden berørt emnerne Arv og Interfaces

Følgende literatur er blevet brugt som basis for undervisningen:

Fra: Learning the Java Language https://docs.oracle.com/javase/tutorial/java/TOC.html

• Lesson: Object-Oriented Programming Concepts https://docs.oracle.com/javase/tutorial/java/concepts/index.html
• What Is an Object? https://docs.oracle.com/javase/tutorial/java/concepts/object.html
• What Is a Class? https://docs.oracle.com/javase/tutorial/java/concepts/class.html
• What Is Inheritance? https://docs.oracle.com/javase/tutorial/java/concepts/inheritance.html
• What Is an Interface? https://docs.oracle.com/javase/tutorial/java/concepts/interface.html

Fra: Lesson: Language Basics https://docs.oracle.com/javase/tutorial/java/nutsandbolts/index.html

• Variables https://docs.oracle.com/javase/tutorial/java/nutsandbolts/variables.html

  • Primitive Data Types https://docs.oracle.com/javase/tutorial/java/nutsandbolts/datatypes.html
  • Arrays https://docs.oracle.com/javase/tutorial/java/nutsandbolts/arrays.html

• Operators https://docs.oracle.com/javase/tutorial/java/nutsandbolts/operators.html

  • Assignment, Arithmetic, and Unary Operators https://docs.oracle.com/javase/tutorial/java/nutsandbolts/op1.html
  • Equality, Relational, and Conditional Operators https://docs.oracle.com/javase/tutorial/java/nutsandbolts/op2.html

• Control Flow Statements https://docs.oracle.com/javase/tutorial/java/nutsandbolts/flow.html

  • The if-then and if-then-else Statements (if/else) https://docs.oracle.com/javase/tutorial/java/nutsandbolts/if.html
  • The while Statements https://docs.oracle.com/javase/tutorial/java/nutsandbolts/while.html
  • The for Statement https://docs.oracle.com/javase/tutorial/java/nutsandbolts/for.html

• Classes and Objects https://docs.oracle.com/javase/tutorial/java/javaOO/index.html

  • Classes https://docs.oracle.com/javase/tutorial/java/javaOO/classes.html
  • Declaring Classes https://docs.oracle.com/javase/tutorial/java/javaOO/classdecl.html
  • Declaring Member Variables https://docs.oracle.com/javase/tutorial/java/javaOO/variables.html
  • Defining Methods https://docs.oracle.com/javase/tutorial/java/javaOO/methods.html
  • Providing Constructors for Your Classes https://docs.oracle.com/javase/tutorial/java/javaOO/constructors.html
  • Passing Information to a Method or a Constructor https://docs.oracle.com/javase/tutorial/java/javaOO/arguments.html

• Objects https://docs.oracle.com/javase/tutorial/java/javaOO/objects.html

  • Creating Objects https://docs.oracle.com/javase/tutorial/java/javaOO/objectcreation.html
  • Using Objects https://docs.oracle.com/javase/tutorial/java/javaOO/usingobject.html

• More on Classes https://docs.oracle.com/javase/tutorial/java/javaOO/more.html

  • Returning a Value from a Method https://docs.oracle.com/javase/tutorial/java/javaOO/returnvalue.html
  • Using the this Keyword https://docs.oracle.com/javase/tutorial/java/javaOO/thiskey.html
  • Controlling Access to Members of a Class https://docs.oracle.com/javase/tutorial/java/javaOO/accesscontrol.html
  • Understanding Class Members https://docs.oracle.com/javase/tutorial/java/javaOO/classvars.html
  • Initializing Fields https://docs.oracle.com/javase/tutorial/java/javaOO/initial.html

• Strings https://docs.oracle.com/javase/tutorial/java/data/strings.html

  • Converting Between Numbers and Strings https://docs.oracle.com/javase/tutorial/java/data/converting.html
  • Comparing Strings and Portions of Strings https://docs.oracle.com/javase/tutorial/java/data/comparestrings.html

• Exeptions

  • What Is an Exception? https://docs.oracle.com/javase/tutorial/essential/exceptions/definition.html
  • The Catch or Specify Requirement https://docs.oracle.com/javase/tutorial/essential/exceptions/catchOrDeclare.html
  • Catching and Handling Exceptions https://docs.oracle.com/javase/tutorial/essential/exceptions/handling.html
  • The try Block https://docs.oracle.com/javase/tutorial/essential/exceptions/try.html
  • The catch Blocks https://docs.oracle.com/javase/tutorial/essential/exceptions/catch.html
  • The finally Block https://docs.oracle.com/javase/tutorial/essential/exceptions/finally.html

• Writing to a Text File

  • Class File https://docs.oracle.com/javase/8/docs/api/java/io/File.html)
  • Class PrintStream https://docs.oracle.com/javase/8/docs/api/java/io/PrintStream.html

2. semester

Emnerne for andet semesters konstruktionsundervisning var følgende:

• Databases
  • Er-diagram
  • DDL
  • DML
  • Relation mellem UML og ER
  • Normalisering
  • JDBCTemplate
• Spring Boot MVC
• Thymeleaf
• Html
• Css
• Collections Framework
• Polymorfi
• Generiske Datatyper
• Arv
• Interfaces

Følgende literatur er blevet brugt som basis for undervisningen:

• Interfaces and Inheritance https://docs.oracle.com/javase/tutorial/java/IandI/index.html

  • Interfaces https://docs.oracle.com/javase/tutorial/java/IandI/createinterface.html
    • Defining an Interface https://docs.oracle.com/javase/tutorial/java/IandI/interfaceDef.html
    • Implementing an Interface https://docs.oracle.com/javase/tutorial/java/IandI/usinginterface.html

• Inheritance https://docs.oracle.com/javase/tutorial/java/IandI/subclasses.html

  • Multiple Inheritance of State, Implementation, and Type https://docs.oracle.com/javase/tutorial/java/IandI/multipleinheritance.html
  • Overriding and Hiding Methods https://docs.oracle.com/javase/tutorial/java/IandI/override.html
  • Polymorphism https://docs.oracle.com/javase/tutorial/java/IandI/polymorphism.html
  • Hiding Fields https://docs.oracle.com/javase/tutorial/java/IandI/hidevariables.html
  • Using the Keyword super https://docs.oracle.com/javase/tutorial/java/IandI/super.html
  • Object as a Superclass https://docs.oracle.com/javase/tutorial/java/IandI/objectclass.html

• Package https://docs.oracle.com/javase/tutorial/java/concepts/package.html

• Autoboxing and Unboxing https://docs.oracle.com/javase/tutorial/java/data/autoboxing.html

• Generics

  • Why Use Generics? https://docs.oracle.com/javase/tutorial/java/generics/index.html
  • Generic Types https://docs.oracle.com/javase/tutorial/java/generics/types.html
  • Raw Types https://docs.oracle.com/javase/tutorial/java/generics/rawTypes.html

• Collection Framework

  • Dag 22 Java Collections Framework https://github.com/dat17v1/2_22_Java_Collections_framework
  • Dag 23 Sets og Maps https://github.com/dat17v1/2_23_Set_Map

Spring

• Serving Web Content with Spring MVC https://spring.io/guides/gs/serving-web-content/
• Tutorial: Build a spring boot application using intellij idea https://github.com/dat17v1/2_03_hello_spring/blob/master/README.md
• My First Website https://github.com/dat17v1/03_my_first_website/blob/master/README.md
• The MVC Pattern https://github.com/dat17v1/2_04_user_interface_ii/blob/master/MVC.pdf

snippets

• Repository https://github.com/dat17v1/2_24_Thymeleaf_followup/blob/master/repository.md
• Controller https://github.com/dat17v1/2_24_Thymeleaf_followup/blob/master/controller.md
• Create https://github.com/dat17v1/2_24_Thymeleaf_followup/blob/master/create.md
• Read https://github.com/dat17v1/2_24_Thymeleaf_followup/blob/master/read.md
• Update https://github.com/dat17v1/2_24_Thymeleaf_followup/blob/master/update.md
• Delete https://github.com/dat17v1/2_24_Thymeleaf_followup/blob/master/delete.md

Thymeleaf

• Thyleaf Kompendie https://github.com/dat17v1/05_thymeleaf/blob/master/README.md

Database

SQL

DML

• SQL Tutorial https://www.w3schools.com/sql/default.asp
• Introduction to SQL https://www.w3schools.com/sql/sql_intro.asp
• SQL Syntax https://www.w3schools.com/sql/sql_syntax.asp
• SQL SELECT Statement https://www.w3schools.com/sql/sql_select.asp
• SQL WHERE Clause https://www.w3schools.com/sql/sql_where.asp
• SQL AND, OR and NOT Operators https://www.w3schools.com/sql/sql_and_or.asp
• SQL ORDER BY Keyword https://www.w3schools.com/sql/sql_orderby.asp
• SQL INSERT INTO Statement https://www.w3schools.com/sql/sql_insert.asp
• SQL UPDATE Statement https://www.w3schools.com/sql/sql_update.asp
• SQL DELETE Statement https://www.w3schools.com/sql/sql_delete.asp
• SQL COUNT(), AVG() and SUM() Functions https://www.w3schools.com/sql/sql_count_avg_sum.asp
• SQL Joins https://www.w3schools.com/sql/sql_join.asp
• SQL INNER JOIN Keyword https://www.w3schools.com/sql/sql_join_inner.asp

DDL

• SQL CREATE DATABASE Statement https://www.w3schools.com/sql/sql_create_db.asp
• SQL DROP DATABASE Statement https://www.w3schools.com/sql/sql_drop_db.asp
• SQL CREATE TABLE Statement https://www.w3schools.com/sql/sql_create_table.asp
• SQL DROP TABLE Statement https://www.w3schools.com/sql/sql_drop_table.asp
• SQL PRIMARY KEY Constraint https://www.w3schools.com/sql/sql_primarykey.asp
• SQL FOREIGN KEY Constraint https://www.w3schools.com/sql/sql_foreignkey.asp

Relationship

• The features of a relational database https://www.lynda.com/Programming-Foundations-tutorials/features-relational-database/412845/438417-4.html?autoplay=true
• Primary Keys https://github.com/dat17v1/2_15_databaser_primary_keys/blob/master/slides/Database%20modeling_%20tables%20-%20keys.pdf
• Database Modeling: Relationships https://github.com/dat17v1/2_16_Relationer_mellem_tabeller/blob/master/Slides/16%20-%20Database%20Modeling_%20Relationships.pdf

Normalisering

• Normalisering https://docs.google.com/document/d/e/2PACX-1vS5A34jXa-Qy0HY7b4hAXqbswLpMWyQoOuFJY1WM8PZysKywwXECtj89Xv0lDv_f58K_BdD1yogvWOI/pub
• 19 Database Modeling_Normalization.pdf https://github.com/dat17v1/19_normalisering/blob/master/19%20Database%20Modeling_%20Normalization.pdf

JDBC

• JdbcTemplate https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html
  • queryForRowSet https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html#queryForRowSet-java.lang.String-
  • update https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html#update-java.lang.String-
• SqlRowSet https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/support/rowset/SqlRowSet.html

Html og Css

html

• HTML Introduction https://www.w3schools.com/html/html_intro.asp
• HTML Basic Examples https://www.w3schools.com/html/html_basic.asp
• HTML Elements https://www.w3schools.com/html/html_elements.asp
• HTML Attributes https://www.w3schools.com/html/html_attributes.asp
• HTML Headings https://www.w3schools.com/html/html_headings.asp
• HTML Paragraphs https://www.w3schools.com/html/html_paragraphs.asp
• HTML Styles https://www.w3schools.com/html/html_styles.asp
• HTML Text Formatting https://www.w3schools.com/html/html_formatting.asp
• HTML Comments https://www.w3schools.com/html/html_comments.asp
• HTML Colors https://www.w3schools.com/html/html_colors.asp
• HTML Styles - CSS https://www.w3schools.com/html/html_css.asp
• HTML Links https://www.w3schools.com/html/html_links.asp
• HTML Images https://www.w3schools.com/html/html_images.asp
• Tables https://www.w3schools.com/html/html_tables.asp
• HTML Lists https://www.w3schools.com/html/html_lists.asp
• HTML Block and Inline Elements https://www.w3schools.com/html/html_blocks.asp
• HTML The class Attribute https://www.w3schools.com/html/html_classes.asp
• HTML Forms https://www.w3schools.com/html/html_forms.asp
• HTML Form Elements https://www.w3schools.com/html/html_form_elements.asp
• HTML Input Types https://www.w3schools.com/html/html_form_input_types.asp
• HTML Input Attributes https://www.w3schools.com/html/html_form_attributes.asp

Css

• Alt fra CSS Tutorial sektionen https://www.w3schools.com/css/default.asp