Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu08:aufgaben:02 [2024/10/30 14:47] – angelegt vdemir
+++ modul:m290:learningunits:lu08:aufgaben:02 [2024/11/06 16:55] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU10.A02 - myFirstServer ======
+====== LU10.A03 - myFirstServer ======
 ===== Requirements  =====
@@ Zeile 7: / Zeile 7: @@
       * Only teaching materials, no websearch, no use of ai.
       * Webstorm Codeeditor
+      * {{ :modul:m290:learningunits:lu08:aufgaben:myfirstserver0.zip | myFirstserver.js ZIP File }}
   * Expected result:
-    * A JavaScript programm, that displays a greeting on the terminal of Webstorm.
+    * A JavaScript program, that displays the table content.
 ===== Assignments =====
-As always, our first program on the server is a small script designed to greet the world with the infamous “Hello World”.
-  - Open your Webstorm editor and establish a JavaScriptfile. Name ist //helloWorld.js//. The file extension is assigned automatically.
+==== Task A: Letting the given script run ====
-  - Write in this script your helloWorld statement, using the JS command //console.log()//. Save your file.
+After being able to handle a node server, it is time to connect to a database and display a table's content at the terminal.
-  - Generate more terminal outputs by using arrays, for iterations and console.log() function. e.g. //['Hello ', 'World!', 'Hello', 'Universe!'];//
-  - Open a terminal window by clicking the terminal-icon at the left lower rim of Webstorm.
-  - Install all missing JS packages, that Webstorm requires from you.
-  - Start your server by using the node command, e.g. //node myServer.js//
-  - If everything is correct, you will see the helloWorld statement as a output from your server in the bottom terminal window of Webstorm.
+  - A01: Download the provided Zipfile, unzip it, and import the JavaScriptFile into your Webstorm project.
+  - A02: Change the credentials by using your login data, which is only you know.
+  - A03: Request via sql-script the system date from the database and display on your terminal by starting the server with the node command.
+==== Task B: Displaying a table conent ====
+After successful receiving data from the database, we want to display more data on our terminal, e.g. the content of an already existing database table. Follow for that the steps below:
+  - B01: Change the sql statement from SELECT sysdate(); into //SELECT * FROM users;//
+  - B02: Display the resultset from the database on your terminal by using the node command
+  - B03: Change the order of the sql statement and display the result on your terminal
 ===== Solution =====
-[[modul:m290:learningunits:lu08:loesungen:l01|Lösung]]
+[[modul:m290:learningunits:lu08:loesungen:l02|Lösung]]
 ===== Vocabulary =====
 ^ English ^ German ^
-| preparatary work | Vorarbeit |
+| ... | ... |
-| infamous | berühmt-berüchtigt |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir