connected htm/jsp file to server
test:

• you can access the first page on localhost:8080
• you can jump to the next page using a button

Test:

• method that receives resultSet
• and print it on the console
• and print it on the web page in a raw format

updateUser function

• have a function called : "updateUser(int userID, User u){}"
• it updates a whole User in Db of an already existing user in DB
• it throws an exception if that fails
• it prints some error message in console if it fails
• it prints a message if it works

• add logic that detects when the method tries to delete a user which does not exist
• add an error message that will be printed !!

• add some password to 2 existing users in DB
• make password varchar NOT NULL

insert new user in DB

• should add a new user to DB via a query like:
  "Insert into users(lastName,name,birthDate,eMail, password) values("Mustermann", "Hermann", 1968643592, "[email protected]", "password");"
• userID should automatically continue counting
• test if new Database from JVM is automatically updated

delete user

• method public void deleteUser(int userID) { }
• deletes the user with the certain user ID in userDB.db
• prints successful statement when it worked
• prints error message when it failed
• prints special error message when user does not exist

Test:

• have a servlet class representing html

• understand the servlet class

• it should be accessible via localhost:8080

create and connect simple javascript code / node js and connect it to html page to appache server
Test:
picture slide show, on button click
color change on button

• code should recognize if sth like following exception is thrown:
  org.sqlite.SQLiteException: [SQLITE_CONSTRAINT] Abort due to constraint violation (UNIQUE constraint failed: users.eMail)
• it should then print sth like your email is already registered ......

Test

• have 2 form on page where user can input sth

• both values should appear in a variable in java code debugger

• print the input or combination of input on web page

Test:

• have java logic be printed on page on button click

• either find a way to close the connection Object con without throwing exceptions
• or find a way to handle the exceptions

• create function that can convert String DAte format such as 24.08.2020 into int milliseconds since 1970 to save in Db
• test by reconverting it from int to a date Object

create and connect simple css file connected to HTML file/page to appache server
Test:

• "hello world" and box on the web page in different color
• different background color
• use selectors: id, ...

Test:

• hava a query executed in database once button is pressed
• have the data appear in a variable in Java
• have a getData method that returns the query as a result set

update function String

• have a function called : "updateUserString(int userID, String columnIndex, String columnValue){}"
• it updates a String value of an already existing user in DB
• it throws an exception if that fails
• it prints some error message in console if it fails
• it prints a message if it works

Test:

• Connection to mysql database
• print connection successful when connected
• print connection failed when not connecting
• have it be a method that returns a connection Object

• create servlet class DBController
• connect it in web.xml
• build logic to call db interacting functions at right time

Test

• hava a jsp file represnting html code

• understand the jsp file

• it should be accessible on localhost:8080

• add private String password with getters and setters in user.java
• update following methods:
  public void print(){}; in user.java
  public User getUser (int id) {} ; in userDAO.java
• retest if you can extract password and other variables of user Object

• create jsp page
• create buttons and prompt like a user login page
• connect buttons correctly to the dbController servlet

create a folder in WebInf to collect all HTML files

test:

• page should still be accessible on localhost
• page should still print the same stuff as before

Test

• have 2 html/ jsp pages
• have one start page
• start page still accesible over localhost 8080
• change page to 2nd page after button click and back

create a folder in WebInf to collect all cssfiles

test:

• page should still be accessible on localhost
• page should still print the same stuff as before

create and connect simple html page to appache server
Test:
it should be accessible by localhost:8080;
it should print "hello worl" or something like that in a box