Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Client:
- 1. Klasse "Benutzer" erstellen
- class User (
- benutzerID: number;
- nachname: string;
- vorname: string;
- telnr: number;
- )
- 2. Constructor erstellen
- constructor(bntzID: number, nname: string, vname: string, tnr: number) {
- this.benutzerID = bntzID;
- this.nachname = nname;
- this.vorname = vname;
- this.telnr = tnr;
- }
- 3. Funktion zum Erstellen eines Benutzers
- function handleCreate() {
- let nachnameinput: JQuery = $('#nachnameinput'); --> ID wird in HTML-Datei definiert
- let vornameinput: JQuery: $('vornameinput');
- let telnrinput: JQuery: $('telnrinput');
- ...if...else...leckomio - kann ich net
- 4. AJAX-Request zum Erstellen eines Benutzers
- $.ajax( {
- url: 'http://localhost:8080/user'
- type: 'POST'
- data: 'JSON.stringify(data)'
- datatype: 'json'
- success: kp
- error: kp
- Server:
- 1. Benötigte Routing-Frameworks:
- import express = require ("express");
- import (Request, Response) from "express";
- 2. Router starten:
- let router = express();
- 3. Server starten:
- router.listen(8080, "localhost", function() {
- });
- 4. Statische Routen anlegen:
- router.use("/views", express.static(_dirname + "/views")); --> HTML-Datei
- router.use("/css"), express.static(_dirname + "/css")); --> CSS
- router.use(bodyParser.urlencoded({extended:false})); --> BodyParser
- router.use(bodyParser.json()); --> Json
- 5. Datenbank einbinden
- import db = require ("mysql");
- import (Connection, MysqlError) from "mysql";
- let connection: Connection = db.createConnection( {
- host: 'localhost'
- user: 'root'
- password: ''
- database: 'integrationsprojektdb'
- });
- 6. Klasse "Benutzer" erstellen
- class User (
- nachname: string;
- vorname: string;
- telnr: number;
- )
- 7. Constructor erstellen
- constructor(nname: string, vname: string, tnr: number) {
- this.nachname = nname;
- this.vorname = vname;
- this.telnr = tnr;
- }
- 8. Userlist erstellen
- let userList: User[] = [];
- 9. POST-Route im Server
- router.post ("/user"), function (req: Request, res: Response) {
- let nachname: string = (req.body.nachname:"");
- let vorname: string = (req.body.vorname:"");
- let telnr: number = (req.body.telnr:"");
- 10. DB-Datensätze anlegen
- let insertData: [string, string, number] = [nachname, vorname, telnr];
- let query: string = 'INSERT INTO users (nachname, vorname, telnr) VALUES (?, ?, ?);'
- connection.query(query, insertData, function (err: MysqlError|null, rows: any) {
- if (!err) {
- message = "Create: Created: " + nachname + " " + vorname + " added";
- res.json({"message:": "successful"});
- else {
- message = "Create: Database error: " + err.code;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement