JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
JDBC: Accessing Relational Data
Sidebar
Prev
|
Up
|
Next
Introduction to
JDBC
™
Contents
Search
Preface
113105 Software development 1
Getting started
Lecture related resources
Using the exercises
Related resources
Coached exercises
Using plain Java™
Using Intellij IDEA
Play!
“Hello, World” and friends.
Simple calculations
A conditional
A loop
Language Fundamentals
Integer, ASCII and Unicode
Primitive types
Variables
Literals
Integer
char
Float
String
Arithmetic limitations
Conversions
Operators and expressions
Arithmetic and logical operators
Assignment operators
Unary operators
Operator precedence
Comments
Statements
The if conditional statement
if-then-else
Using else if
The switch statement
From blocks to methods
Loops
while
do ... while
for
A table of square numbers
Loops and calculations
Guessing numbers
Smallest multiple
Pythagorean triples
Logic related external exercises
Using automated tests.
Arrays
Multi-dimensional arrays
Objects and Classes
Static methods
Working with objects
Packages
Object methods
Encapsulation and access control
Getter and setter methods
Signatures
Method overloading
Constructors
Scopes
Class members and methods
A mathematical table.
Interest calculations
A simple interest calculator
Extending our interest calculator
Integer value considerations.
Programmer's favourite expression
Lotteries revisited
The greatest common divisor and the common multiple
Maven project dependencies
Maven command line usage
Intellij IDEA on top of Maven
Building a library of mathematical functions.
Maximum and absolute value
Factorial, the direct way
Factorial, the recursive way
Binomials, the recursive way
Implementing exponentials.
Adding sine
Strange things happen
Unit testing
Tests and implementation
Improving the algorithm
Parameterized testing
Helpful Junit methods
Technical details
Example: A class representing fractions
Value types and reference types
Arrays reconsidered
Varargs method parameter
Reconsidering System.out.format().
java.util.Arrays helpers
Extending arrays
Storing integer values
Understanding static int main(String[] args)
Tic-tac-toe
Tic-tac-toe using a two-dimensional array
Changing the game's internal representation
Tic-tac-toe, Computer vs. human
Providing statistical data
Prime numbers revisited
A simple algorithm
Improving performance
The median of a given sample.
Plotting functions
Method calls, the details
Enumerations (enum)
Enumeration by integer representation
Enumeration by dedicated class
Defining a private constructor
enum replacing class
Core Classes
Using class Math
String exercises
Analyzing file pathnames
Inheritance
Overriding equals()
Overriding toString()
final methods
Abstract methods
Geometry classes reconsidered
Scaling shapes
Providing toString() methods
protected access
final classes
The instanceof operator
The @Override annotation.
Runtime polymorphism
Error Handling
Checked vs unchecked exceptions
Exceptions and Junit
Variants
Class java.lang.Exception
Working with Numbers
Boxing and unboxing
Number Parsing
Number Formatting
Working with Money
Generating Random Numbers
Advanced topics
interface definitions and abstract Classes
Interfaces and sorting
A nonsense generator
An interface based plotter
Application deployment I
Preparations
Exercises
Part II, Exercises
Reading character streams
Preparations
Exercises
Collections
Preparations
Collections I, Exercises
A Set of Strings
A List of Strings
Defining a Coordinate class
A Set of Coordinate instances
Collections I, Exercises
Getting a Set of strings from a text file
Result string ordering
Sorting strings in an unusual way
Result string ordering
Collections III, Exercises
Collections IV, Exercises
Maps 1, Preparations
Exercises
Towns and country names
Creating an overview of grades
Appendix
Examination bonus point projects
Weather forecast
Reverse Polish notation (RPN) calculator
Desired functionality
Implementation hints
Currency converter, Summer 2017
An address database, Winter 2016
Poor man's UNIX grep, Summer 2016
Project Euler's sieve, Winter 2015
Exercising past examinations
Starting an exam
Implementing the project skeleton
Finish the exam
Examination hints
Past Software Development 1 examinations
2026 summer
Implementing tasks
Preparation
Task
Caveats
Computing an array's average
Coding flaws
2025 winter
Implementing tasks
Preparation
Task
Caveats
An IDE warning
Unexpected output
2025 summer
Implementing tasks
Preparation
Task
Caveats
Different outputs
Average computation
2024 winter
Implementing tasks
Preparation
Task
Warning
Swapping two variables
0 and null
2024 summer
Implementing tasks
Preparation
Task
Caveats
Executing main(...)
Strange arithmetics
2023 winter
Implementing tasks
Preparation
Task
Caveats
Learning Java
Strange endless loop
2023 summer
Implementing tasks
Preparation
Task
Caveats
switch versus if ... else if ... else
Exception handling
2022 winter
Implementing tasks
Preparation
Task
Caveats
Extraterrestrial's integer representation
Initialization issues
2021 winter
Implementing tasks
Preparation
Tasks
Caveats
equals() and hashCode()
The average of three byte values
2021 summer
Implementing tasks
Preparation
Tasks
Caveats
Spoiled execution
Method overriding
2020/1 winter
Implementing tasks
Preparation
Tasks
Caveats
Type conflict
Weird subtraction
2020/2 winter
Implementing tasks
Preparation
Tasks
Caveats
Surprising difference
Type assignment problem
2020 summer
Implementing tasks
Preparation
Tasks
Caveats
Return type
Weird behaviour
2019 winter
Implementing tasks
Preparations
Tasks
Caveats
Solution
Unexpected value
Assignment problems
NullPointerException problem
2019 summer
Implementing tasks
Preparations
Tasks
Caveats
Solution
Handling change money
Preparation
Description
Tasks
Solution upload
Solution
Logical expression
Device states
Missing exception warning
2018 winter
Implementing tasks
Preparation
Task
Caveats
Wahr oder falsch?
Zeitangaben und hashCode()
Vergleichen von StringBuffer Instanzen
2018 summer
Implementing tasks
Preparation
Task
Caveats
Primitive und Klassentypen
Ein Interface Problem
Mapping color representations
2017 winter
Implementing tasks
Preparation
Implementing tasks
Caveats
equals(...) und hashCode()
Weird arithmetic result
Compile time Error
2017 winter
Implementing tasks
Preparation
Task
Caveats
Basic algebra
String Objekte
Garbage collection
2015 winter
Implementing tasks
Preparation
Task
Caveats
Access Modifier
Heap memory cleanup
2015 Sommer
Implementing tasks
Preparation
Task
Caveats
Klassen und Vererbung
2014 Winter
Implementing tasks
Preparation
Task
Caveats
Past Software Development 1 exam preparing tests
Test 01
Implementing tasks
Preparation
Tasks
Test 02
Implementing tasks
Preparation
Task
Test 03
Implementation
Preparation
Tasks
Compile time error
Test 04
Implementing tasks
Preparation
Tasks
Other tasks
Test 05
Implementing tasks
Preparation
Tasks
Working with git
Using git
Working with git locally.
Shared development with centralized remote.
Conflicts
Apache Maven
The project object model pom.xml
Plugins
Dependencies
Lifecycle, phases and goals
List of software development 1 lecture exercises
113492 Technical Documentation
Software independent considerations
General remarks
Common building blocks
Block level elements
Docbook
Target formats
HTML
Eclipse Help
Printed output
Selected elements
Paragraph elements
List elements
Formal elements
Graphic elements
Admonition elements
Sectioning elements
Links
Top level elements
Schematron
Customizing
Docbook XSL built in parameters
Docbook XSL style sheets
CSS
Assemblies
Styling the editor application
Modular documents
RelaxNG Schema
Transforming documents
Target format HTML
Target format print
Software
Frontends
Backends
TeX / LaTeX
Docbook
Exercises
LaTeX
LaTeX hello,... world
Important elements
Macro
A complete document
Docbook
Project proposals
Building a reveal.js editor
Authoring journey descriptions
Gitlab pages integration of Docbook
Codingbat reloaded
XML based exercise compilations
Past projects
List of software development 1 lecture exercises
113473 Database and application development
Database features
Selected database products overview
Openldap
Installation
Features
CRUD
Query
Schema
Procedures / triggers
Transactions / recovery
Data access control
API support
Exercises
Mongodb
Installation
Features
CRUD
Query
Schema
Procedures / triggers
Transactions / recovery
Data access control
API support
High performance sharding cluster
Exercises
JDBC: Accessing Relational Data
Persistence in Object Oriented languages
Introduction to JDBC™
Write access, principles
Write access, coding!
JDBC™ and security
Network sniffing
SQL injection
Sanitizing user input
java.sql.PreparedStatement
Read Access
Getter methods and type conversion
Handling NULL values.
Dynamically load a JDBC™ driver
Handling surrogate keys
Transactions
JPA
Configuring a Maven based Eclipse Java™ project with Hibernate
Creating a JPA configuration
A round trip working with objects
Persisting objects
Loading Objects by primary key
Loading objects by queries
Criteria based queries
Mapping single entities and database tables
Transient properties
Properties and NULL values
Defining keys
Composed keys
Indexes (non-unique)
Renaming tables and attributes
Changing the default type mapping
Object states and transitions
XML to JPA using JAXB
Supplying a schema
Importing XML data to a RDBMS
Inheritance
Single table per class hierarchy
Database object retrieval
Null values
Joined subclasses
Retrieving Objects
Table per concrete class
Mapping related Components and entities
Primary keys revisited
Defining object equality by primary key
Object equality by natural key
Implementing Object.equals(Object) by natural keys
Entity and value types
Mapping components
Sets and lists
Caching
orphanRemoval vs. CascadeType.DELETE
Project ideas
Extending UNIX grep to databases
Database copy tool
Creating data samples
Database schema evolution tool
List of Database and application development lecture exercises
113475 Software defined Infrastructure
Manual server management
Preliminaries
Hetzner cloud administration GUI
Using ssh
Public / private key pair
Pass phrases and ssh agent
Agent forwarding
Port forwarding
X11 forwarding
Network data transfer using scp, rsync and ssh
Prerequisites
Ubuntu / Debian Package management
Prerequisites
Cloud provider
Terraform
Working with Terraform
A round trip
ssh and access
Outputs
Secrets and state
Cloud-init
Terraform modules
Volumes
Terraform loops
Terraform and DNS
Generating web SSL certificates
Private networks
Pulumi
Appendix
DNS
Preliminaries
Exercises
Querying DNS data.
Installing and configuring Bind
Reverse lookups
Forwarders
Mail exchange record
LDAP
Recommended Preparations
Exercises
Browse an existing LDAP Server
Set up an OpenLdap server
Populating your DIT.
Testing a bind operation as non - admin user
Extending an existing entry
Filter based search
Accessing LDAP data by a mail client
LDAP configuration
LDAP based user login
Backup and recovery / restore
Accessing LDAP by a Java™ application.
Apache web server
Preliminaries
Exercises
First Steps
Virtual hosts
SSL / TLS Support
LDAP authentication
Mysql™ database administration
Providing WEB based user management to your LDAP Server
Publish your documentation
File cloud
Exercises
Network file systems served by Samba
Prerequisites
Samba server installation
Mail
Recommended Preparations
Exercises
Install and send to local Users
Authentication Setup and Virtual Users
TLS
Spam and Virus defense
blacklisting and greylisting
Amavis, Clamav and Spamassasin
SPF (optional)
Docker
Introduction
Managing images
Running container
Volumes
Exercises
The simple way: Using SQLite
The real McCoy: Using Mariadb
Icinga
Functional checks
SNMP based checks
ssh based checks
List of Software defined Infrastructure lecture exercises
Common topics
Project documentation
Bibliographic links
Glossary
Search Highlighter (On/Off)
