LU10.A03 - myFirstServer

• Work type: Individual
• Timeframe: 15 Minutes
• Means of aid:
  • Only teaching materials, no websearch, no use of ai.
  • Webstorm Codeeditor
  • myFirstserver.js ZIP File
• Expected result:
  • A JavaScript program, that displays the table content.

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.

1. A01: Download the provided Zipfile, unzip it, and import the JavaScriptFile into your Webstorm project.
2. A02: Change the credentials by using your login data, which is only you know.
3. A03: Request via sql-script the system date from the database and display on your terminal by starting the server with the node command.

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:

1. B01: Change the sql statement from SELECT sysdate(); into SELECT * FROM users;
2. B02: Display the resultset from the database on your terminal by using the node command
3. B03: Change the order of the sql statement and display the result on your terminal

Lösung

Volkan Demir