This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| namespace Datenbank | |
| { | |
| class Abteilung | |
| { | |
| public int abtNr; | |
| public string abtName; | |
| public Abteilung(int abtNr, string abtName) | |
| { | |
| this.abtNr = abtNr; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| namespace Baum | |
| { | |
| public class Baum | |
| { | |
| private int nr; | |
| private double x; | |
| private double y; | |
| private short sta; | |
| private float kro; | |
| private string art; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // TODO |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Collections.Generic; | |
| using System.ComponentModel; | |
| using System.Data; | |
| using System.Drawing; | |
| using System.Linq; | |
| using System.Text; | |
| using System.Threading.Tasks; | |
| using System.Windows.Forms; | |
| using System.IO; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- a) | |
| UPDATE mitarbeiter | |
| SET tagesarbeitszeit = 7 | |
| WHERE ma_id = 812; | |
| -- b) | |
| SELECT count(*) | |
| FROM mitarbeiter | |
| WHERE tagesarbeitszeit < 7.33; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| namespace Test | |
| { | |
| public class Auswahl | |
| { | |
| public Auswahl(Produkt pro, int anzahl) | |
| { | |
| this.Pro = pro; | |
| this.Anzahl = anzahl; | |
| this.Preis = pro.Preis * anzahl; | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Collections.Generic; | |
| using MySql.Data.MySqlClient; | |
| using System.Windows.Forms; | |
| // TODO: avoid injections | |
| // TODO: Better exception handling | |
| namespace PersonalDB | |
| { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| TODO |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 1) | |
| SELECT * | |
| FROM mitarbeiter | |
| WHERE tagesarbeitszeit IS NULL OR tagesarbeitszeit < 7; | |
| -- 2) | |
| UPDATE mitarbeiter | |
| SET tagesarbeitszeit = tagesarbeitszeit + tagesarbeitszeit * 0.10 | |
| WHERE tagesarbeitszeit IS NOT NULL; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Collections.Generic; | |
| using System.IO; | |
| namespace person | |
| { | |
| class Person | |
| { | |
| public Person(string nachname, string vorname) | |
| { |