From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001
From: Sven Eisenhauer <sven@sven-eisenhauer.net>
Date: Fri, 10 Nov 2023 15:11:48 +0100
Subject: add new repo

---
 .../DSI1-ausgang/DSI-app-client/build.xml          |  74 ++
 .../DSI-app-client/nbproject/ant-deploy.xml        |  60 ++
 .../DSI-app-client/nbproject/build-impl.xml        | 847 +++++++++++++++++++++
 .../DSI-app-client/nbproject/genfiles.properties   |   8 +
 .../nbproject/private/private.properties           |  13 +
 .../DSI-app-client/nbproject/project.properties    |  69 ++
 .../DSI-app-client/nbproject/project.xml           |  30 +
 .../DSI-app-client/src/conf/MANIFEST.MF            |   3 +
 .../DSI-app-client/src/conf/application-client.xml |   4 +
 .../src/java/dsi/ArtikelListeTableModel.java       | 118 +++
 .../src/java/dsi/KundenListeTableModel.java        | 118 +++
 .../DSI-app-client/src/java/dsi/Main.form          | 694 +++++++++++++++++
 .../DSI-app-client/src/java/dsi/Main.java          | 807 ++++++++++++++++++++
 13 files changed, 2845 insertions(+)
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/build.xml
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/ant-deploy.xml
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/build-impl.xml
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/genfiles.properties
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/private/private.properties
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.properties
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.xml
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/MANIFEST.MF
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/application-client.xml
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/ArtikelListeTableModel.java
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/KundenListeTableModel.java
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.form
 create mode 100644 Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.java

(limited to 'Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client')

diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/build.xml b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/build.xml
new file mode 100644
index 0000000..d7269c2
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/build.xml	
@@ -0,0 +1,74 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!-- You may freely edit this file. See commented blocks below for -->
+<!-- some examples of how to customize the build. -->
+<!-- (If you delete it and reopen the project it will be recreated.) -->
+<!-- By default, only the Clean and Build commands use this build script. -->
+<!-- Commands such as Run, Debug, and Test only use this build script if -->
+<!-- the Compile on Save feature is turned off for the project. -->
+<!-- You can turn off the Compile on Save (or Deploy on Save) setting -->
+<!-- in the project's Project Properties dialog box.-->
+<project name="DSI-app-client" default="default" basedir=".">
+    <description>Builds, tests, and runs the project DSI-app-client.</description>
+    <import file="nbproject/build-impl.xml"/>
+    <!--
+
+    There exist several targets which are by default empty and which can be 
+    used for execution of your tasks. These targets are usually executed 
+    before and after some main targets. They are: 
+
+      -pre-init:                 called before initialization of project properties
+      -post-init:                called after initialization of project properties
+      -pre-compile:              called before javac compilation
+      -post-compile:             called after javac compilation
+      -pre-compile-single:       called before javac compilation of single file
+      -post-compile-single:      called after javac compilation of single file
+      -pre-compile-test:         called before javac compilation of JUnit tests
+      -post-compile-test:        called after javac compilation of JUnit tests
+      -pre-compile-test-single:  called before javac compilation of single JUnit test
+      -post-compile-test-single: called after javac compilation of single JUunit test
+      -pre-jar:                  called before JAR building
+      -post-jar:                 called after JAR building
+      -post-clean:               called after cleaning build products
+
+    (Targets beginning with '-' are not intended to be called on their own.)
+
+    Example of inserting an obfuscator after compilation could look like this:
+
+        <target name="-post-compile">
+            <obfuscate>
+                <fileset dir="${build.classes.dir}"/>
+            </obfuscate>
+        </target>
+
+    For list of available properties check the imported 
+    nbproject/build-impl.xml file. 
+
+
+    Another way to customize the build is by overriding existing main targets.
+    The targets of interest are: 
+
+      -init-macrodef-javac:     defines macro for javac compilation
+      -init-macrodef-junit:     defines macro for junit execution
+      -init-macrodef-debug:     defines macro for class debugging
+      -init-macrodef-java:      defines macro for class execution
+      -do-jar-with-manifest:    JAR building (if you are using a manifest)
+      -do-jar-without-manifest: JAR building (if you are not using a manifest)
+      run:                      execution of project 
+      -javadoc-build:           Javadoc generation
+      test-report:              JUnit report generation
+
+    An example of overriding the target for project execution could look like this:
+
+        <target name="run" depends="DSI-app-client-impl.jar">
+            <exec dir="bin" executable="launcher.exe">
+                <arg file="${dist.jar}"/>
+            </exec>
+        </target>
+
+    Notice that the overridden target depends on the jar target and not only on 
+    the compile target as the regular run target does. Again, for a list of available 
+    properties which you can use, check the target you are overriding in the
+    nbproject/build-impl.xml file. 
+
+    -->
+</project>
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/ant-deploy.xml b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/ant-deploy.xml
new file mode 100644
index 0000000..28ca9b4
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/ant-deploy.xml	
@@ -0,0 +1,60 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project default="-deploy-ant" basedir=".">
+    <target name="-init-cl-deployment-env" if="deploy.ant.enabled">
+        <property file="${deploy.ant.properties.file}" />
+        <available file="${deploy.ant.docbase.dir}/WEB-INF/sun-web.xml" property="sun.web.present"/>
+        <available file="${deploy.ant.resource.dir}" property="has.setup"/>
+        <tempfile prefix="sjsas" property="sjsas.password.file" destdir="${java.io.tmpdir}"/>  <!-- do not forget to delete this! -->
+        <echo message="AS_ADMIN_PASSWORD=${sjsas.password}" file="${sjsas.password.file}"/>
+    </target>
+    
+    <target name="-parse-sun-web" depends="-init-cl-deployment-env" if="sun.web.present">
+        <tempfile prefix="sjsas" property="temp.sun.web" destdir="${java.io.tmpdir}"/>
+        <copy file="${deploy.ant.docbase.dir}/WEB-INF/sun-web.xml" tofile="${temp.sun.web}"/>
+        <!-- The doctype triggers resolution which can fail -->
+        <replace file="${temp.sun.web}">
+            <replacetoken><![CDATA[<!DOCTYPE]]></replacetoken>
+            <replacevalue><![CDATA[<!-- <!DOCTYPE]]></replacevalue>
+        </replace>
+        <replace file="${temp.sun.web}">
+            <replacetoken><![CDATA[<sun-web-app]]></replacetoken>
+            <replacevalue><![CDATA[--> <sun-web-app]]></replacevalue>
+        </replace>
+        <xmlproperty file="${temp.sun.web}" validate="false">
+        </xmlproperty>    
+        <delete file="${temp.sun.web}"/>
+        <property name="deploy.ant.client.url" value="${sjsas.url}${sun-web-app.context-root}"/>
+    </target>
+    <target name="-add-resources" depends="-init-cl-deployment-env" if="has.setup">
+        <tempfile prefix="sjsas" property="sjsas.resources.dir" destdir="${java.io.tmpdir}"/>
+        <mkdir dir="${sjsas.resources.dir}"/>
+        <mkdir dir="${sjsas.resources.dir}/META-INF"/>
+        <property name="sjsas.resources.file" value="${sjsas.resources.dir}/META-INF/sun-resources.xml"/>
+        <copy todir="${sjsas.resources.dir}/META-INF">
+            <fileset dir="${deploy.ant.resource.dir}"/>
+        </copy>
+        <jar destfile="${deploy.ant.archive}" update="true">
+            <fileset dir="${sjsas.resources.dir}"/>
+        </jar>
+        <delete dir="${sjsas.resources.dir}"/>
+    </target>
+    <target name="-deploy-ant" depends="-parse-sun-web,-add-resources" if="deploy.ant.enabled">
+        <echo message="Deploying ${deploy.ant.archive}"/>
+        <taskdef name="sun-appserv-deploy" classname="org.apache.tools.ant.taskdefs.optional.sun.appserv.DeployTask"
+                 classpath="${sjsas.root}/lib/sun-appserv-ant.jar" />
+        <sun-appserv-deploy user="${sjsas.username}"
+                passwordfile="${sjsas.password.file}"
+                host="${sjsas.host}" port="${sjsas.port}"
+                file="${deploy.ant.archive}" asinstalldir="${sjsas.root}"/>
+        <delete file="${sjsas.password.file}"/>
+    </target>
+    <target name="-undeploy-ant" depends="-init-cl-deployment-env" if="deploy.ant.enabled">
+        <taskdef name="sun-appserv-undeploy" classname="org.apache.tools.ant.taskdefs.optional.sun.appserv.UndeployTask"
+                 classpath="${sjsas.root}/lib/sun-appserv-ant.jar" />
+        <sun-appserv-undeploy user="${sjsas.username}"
+                passwordfile="${sjsas.password.file}"
+                host="${sjsas.host}" port="${sjsas.port}"
+                file="${deploy.ant.archive}" asinstalldir="${sjsas.root}"/>
+        <delete file="${sjsas.password.file}"/>
+    </target>
+</project>
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/build-impl.xml b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/build-impl.xml
new file mode 100644
index 0000000..a9bfc03
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/build-impl.xml	
@@ -0,0 +1,847 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+        *** GENERATED FROM project.xml - DO NOT EDIT  ***
+        ***         EDIT ../build.xml INSTEAD         ***
+
+        For the purpose of easier reading the script
+        is divided into following sections:
+
+        - initialization
+        - compilation
+        - jar
+        - execution
+        - debugging
+        - javadoc
+        - junit compilation
+        - junit execution
+        - junit debugging
+        - applet
+        - cleanup
+
+        -->
+<project xmlns:carproject="http://www.netbeans.org/ns/car-project/1" basedir=".." default="default" name="DSI-app-client-impl">
+    <import file="ant-deploy.xml"/>
+    <target depends="dist,javadoc" description="Build whole project." name="default"/>
+    <!-- 
+                ======================
+                INITIALIZATION SECTION 
+                ======================
+            -->
+    <target name="-pre-init">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target name="-pre-init-am">
+        <!-- Access Manager pre-initialization -->
+    </target>
+    <target depends="-pre-init" name="-init-private">
+        <property file="nbproject/private/private.properties"/>
+    </target>
+    <target depends="-pre-init,-init-private" name="-init-libraries">
+        <property location="..\.\lib\nblibraries.properties" name="libraries.1.path"/>
+        <dirname file="${libraries.1.path}" property="libraries.1.dir.nativedirsep"/>
+        <pathconvert dirsep="/" property="libraries.1.dir">
+            <path path="${libraries.1.dir.nativedirsep}"/>
+        </pathconvert>
+        <basename file="${libraries.1.path}" property="libraries.1.basename" suffix=".properties"/>
+        <touch file="${libraries.1.dir}/${libraries.1.basename}-private.properties"/>
+        <loadproperties srcfile="${libraries.1.dir}/${libraries.1.basename}-private.properties">
+            <filterchain>
+                <replacestring from="$${base}" to="${libraries.1.dir}"/>
+            </filterchain>
+        </loadproperties>
+        <loadproperties srcfile="${libraries.1.path}">
+            <filterchain>
+                <replacestring from="$${base}" to="${libraries.1.dir}"/>
+            </filterchain>
+        </loadproperties>
+    </target>
+    <target depends="-pre-init,-init-private,-init-libraries" name="-init-user">
+        <property file="${user.properties.file}"/>
+        <!-- The two properties below are usually overridden -->
+        <!-- by the active platform. Just a fallback. -->
+        <property name="default.javac.source" value="1.4"/>
+        <property name="default.javac.target" value="1.4"/>
+    </target>
+    <target depends="-pre-init,-init-private,-init-libraries,-init-user" name="-init-project">
+        <property file="nbproject/project.properties"/>
+    </target>
+    <target depends="-pre-init,-init-private,-init-libraries,-init-user,-init-project,-init-macrodef-property" name="-do-init">
+        <condition property="have.tests">
+            <or>
+                <available file="${test.src.dir}"/>
+            </or>
+        </condition>
+        <condition property="have.sources">
+            <or>
+                <available file="${src.dir}"/>
+            </or>
+        </condition>
+        <condition property="netbeans.home+have.tests">
+            <and>
+                <isset property="netbeans.home"/>
+                <isset property="have.tests"/>
+            </and>
+        </condition>
+        <condition property="no.javadoc.preview">
+            <isfalse value="${javadoc.preview}"/>
+        </condition>
+        <property name="javac.compilerargs" value=""/>
+        <property name="work.dir" value="${basedir}"/>
+        <condition property="no.deps">
+            <and>
+                <istrue value="${no.dependencies}"/>
+            </and>
+        </condition>
+        <property name="javac.debug" value="true"/>
+        <property name="javadoc.preview" value="true"/>
+        <available file="${meta.inf}/MANIFEST.MF" property="has.custom.manifest"/>
+        <condition property="classes.dir" value="${build.ear.classes.dir}">
+            <isset property="dist.ear.dir"/>
+        </condition>
+        <property name="classes.dir" value="${build.classes.dir}"/>
+        <condition property="no.deps">
+            <and>
+                <istrue value="${no.dependencies}"/>
+            </and>
+        </condition>
+        <condition property="no.dist.ear.dir">
+            <not>
+                <isset property="dist.ear.dir"/>
+            </not>
+        </condition>
+        <condition property="do.display.browser">
+            <istrue value="${display.browser}"/>
+        </condition>
+        <condition else="" property="application.args.param" value="${application.args}">
+            <and>
+                <isset property="application.args"/>
+                <not>
+                    <equals arg1="${application.args}" arg2="" trim="true"/>
+                </not>
+            </and>
+        </condition>
+        <condition else="" property="run.jvmargs.param" value="${run.jvmargs}">
+            <and>
+                <isset property="run.jvmargs"/>
+                <not>
+                    <equals arg1="${run.jvmargs}" arg2="" trim="true"/>
+                </not>
+            </and>
+        </condition>
+        <property name="source.encoding" value="${file.encoding}"/>
+        <condition property="javadoc.encoding.used" value="${javadoc.encoding}">
+            <and>
+                <isset property="javadoc.encoding"/>
+                <not>
+                    <equals arg1="${javadoc.encoding}" arg2=""/>
+                </not>
+            </and>
+        </condition>
+        <property name="javadoc.encoding.used" value="${source.encoding}"/>
+        <property name="includes" value="**"/>
+        <property name="excludes" value=""/>
+        <condition else="" property="javac.compilerargs.jaxws" value="-Djava.endorsed.dirs='${jaxws.endorsed.dir}'">
+            <and>
+                <isset property="jaxws.endorsed.dir"/>
+                <available file="nbproject/jaxws-build.xml"/>
+            </and>
+        </condition>
+    </target>
+    <target name="-post-init">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="-pre-init,-init-private,-init-libraries,-init-user,-init-project,-do-init" name="-init-check">
+        <fail unless="src.dir">Must set src.dir</fail>
+        <fail unless="test.src.dir">Must set test.src.dir</fail>
+        <fail unless="build.dir">Must set build.dir</fail>
+        <fail unless="dist.dir">Must set dist.dir</fail>
+        <fail unless="build.classes.dir">Must set build.classes.dir</fail>
+        <fail unless="build.generated.dir">Must set build.generated.dir</fail>
+        <fail unless="dist.javadoc.dir">Must set dist.javadoc.dir</fail>
+        <fail unless="build.test.classes.dir">Must set build.test.classes.dir</fail>
+        <fail unless="build.test.results.dir">Must set build.test.results.dir</fail>
+        <fail unless="build.classes.excludes">Must set build.classes.excludes</fail>
+        <fail unless="dist.jar">Must set dist.jar</fail>
+        <fail unless="j2ee.platform.classpath">
+The Java EE server classpath is not correctly set up. Your active server type is ${j2ee.server.type}.
+Either open the project in the IDE and assign the server or setup the server classpath manually.
+For example like this:
+   ant -Duser.properties.file=&lt;path_to_property_file&gt; (where you put the property "j2ee.platform.classpath" in a .properties file)
+or ant -Dj2ee.platform.classpath=&lt;server_classpath&gt; (where no properties file is used)
+                </fail>
+    </target>
+    <target name="-init-macrodef-property">
+        <macrodef name="property" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute name="name"/>
+            <attribute name="value"/>
+            <sequential>
+                <property name="@{name}" value="${@{value}}"/>
+            </sequential>
+        </macrodef>
+    </target>
+    <target name="-init-macrodef-javac">
+        <macrodef name="javac" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute default="${src.dir}" name="srcdir"/>
+            <attribute default="${build.classes.dir}" name="destdir"/>
+            <attribute default="${javac.classpath}:${j2ee.platform.classpath}" name="classpath"/>
+            <attribute default="${includes}" name="includes"/>
+            <attribute default="${excludes}" name="excludes"/>
+            <attribute default="${javac.debug}" name="debug"/>
+            <element name="customize" optional="true"/>
+            <sequential>
+                <javac debug="@{debug}" deprecation="${javac.deprecation}" destdir="@{destdir}" encoding="${source.encoding}" excludes="@{excludes}" includeantruntime="false" includes="@{includes}" source="${javac.source}" srcdir="@{srcdir}" target="${javac.target}">
+                    <classpath>
+                        <path path="@{classpath}"/>
+                    </classpath>
+                    <compilerarg line="${javac.compilerargs} ${javac.compilerargs.jaxws}"/>
+                    <customize/>
+                </javac>
+            </sequential>
+        </macrodef>
+    </target>
+    <target name="-init-macrodef-junit">
+        <macrodef name="junit" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute default="${includes}" name="includes"/>
+            <attribute default="${excludes}" name="excludes"/>
+            <attribute default="**" name="testincludes"/>
+            <sequential>
+                <junit dir="${basedir}" errorproperty="tests.failed" failureproperty="tests.failed" fork="true" showoutput="true">
+                    <batchtest todir="${build.test.results.dir}">
+                        <fileset dir="${test.src.dir}" excludes="@{excludes},${excludes}" includes="@{includes}">
+                            <filename name="@{testincludes}"/>
+                        </fileset>
+                    </batchtest>
+                    <classpath>
+                        <path path="${run.test.classpath}"/>
+                        <path path="${j2ee.platform.classpath}"/>
+                    </classpath>
+                    <syspropertyset>
+                        <propertyref prefix="test-sys-prop."/>
+                        <mapper from="test-sys-prop.*" to="*" type="glob"/>
+                    </syspropertyset>
+                    <formatter type="brief" usefile="false"/>
+                    <formatter type="xml"/>
+                    <jvmarg line="${run.jvmargs.param}"/>
+                </junit>
+            </sequential>
+        </macrodef>
+    </target>
+    <target name="-init-macrodef-java">
+        <macrodef name="java" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute default="${main.class}" name="classname"/>
+            <element name="customize" optional="true"/>
+            <sequential>
+                <java classname="@{classname}" dir="${work.dir}" fork="true">
+                    <jvmarg line="${j2ee.appclient.tool.jvmoptions}"/>
+                    <jvmarg line="${run.jvmargs.param}"/>
+                    <classpath>
+                        <path path="${dist.jar}:${javac.classpath}:${j2ee.platform.classpath}:${j2ee.appclient.tool.runtime}"/>
+                    </classpath>
+                    <syspropertyset>
+                        <propertyref prefix="run-sys-prop."/>
+                        <mapper from="run-sys-prop.*" to="*" type="glob"/>
+                    </syspropertyset>
+                    <customize/>
+                </java>
+            </sequential>
+        </macrodef>
+    </target>
+    <target depends="-init-debug-args" name="-init-macrodef-nbjpda">
+        <macrodef name="nbjpdastart" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute default="${main.class}" name="name"/>
+            <attribute default="${debug.classpath}" name="classpath"/>
+            <attribute default="" name="stopclassname"/>
+            <sequential>
+                <nbjpdastart addressproperty="jpda.address" name="@{name}" stopclassname="@{stopclassname}" transport="${debug-transport}">
+                    <classpath>
+                        <path path="@{classpath}"/>
+                    </classpath>
+                </nbjpdastart>
+            </sequential>
+        </macrodef>
+        <macrodef name="nbjpdareload" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute default="${build.classes.dir}" name="dir"/>
+            <sequential>
+                <nbjpdareload>
+                    <fileset dir="@{dir}" includes="${fix.classes}">
+                        <include name="${fix.includes}*.class"/>
+                    </fileset>
+                </nbjpdareload>
+            </sequential>
+        </macrodef>
+        <macrodef name="nbjpdaappreloaded" uri="http://www.netbeans.org/ns/web-project/1">
+            <sequential>
+                <nbjpdaappreloaded/>
+            </sequential>
+        </macrodef>
+    </target>
+    <target name="-init-debug-args">
+        <property name="version-output" value="java version &quot;${ant.java.version}"/>
+        <condition property="have-jdk-older-than-1.4">
+            <or>
+                <contains string="${version-output}" substring="java version &quot;1.0"/>
+                <contains string="${version-output}" substring="java version &quot;1.1"/>
+                <contains string="${version-output}" substring="java version &quot;1.2"/>
+                <contains string="${version-output}" substring="java version &quot;1.3"/>
+            </or>
+        </condition>
+        <condition else="-Xdebug" property="debug-args-line" value="-Xdebug -Xnoagent -Djava.compiler=none">
+            <istrue value="${have-jdk-older-than-1.4}"/>
+        </condition>
+        <condition else="dt_socket" property="debug-transport-by-os" value="dt_shmem">
+            <os family="windows"/>
+        </condition>
+        <condition else="${debug-transport-by-os}" property="debug-transport" value="${debug.transport}">
+            <isset property="debug.transport"/>
+        </condition>
+    </target>
+    <target depends="-init-debug-args" name="-init-macrodef-debug">
+        <macrodef name="debug" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute default="${main.class}" name="classname"/>
+            <attribute default="${debug.classpath}" name="classpath"/>
+            <element name="customize" optional="true"/>
+            <attribute default="${application.args.param}" name="args"/>
+            <sequential>
+                <java classname="@{classname}" dir="${work.dir}" fork="true">
+                    <jvmarg line="${debug-args-line}"/>
+                    <jvmarg value="-Xrunjdwp:transport=${debug-transport},address=${jpda.address}"/>
+                    <jvmarg line="${run.jvmargs.param}"/>
+                    <classpath>
+                        <path path="@{classpath}"/>
+                    </classpath>
+                    <syspropertyset>
+                        <propertyref prefix="run-sys-prop."/>
+                        <mapper from="run-sys-prop.*" to="*" type="glob"/>
+                    </syspropertyset>
+                    <arg line="@{args}"/>
+                    <customize/>
+                </java>
+            </sequential>
+        </macrodef>
+    </target>
+    <target depends="-init-debug-args" name="-init-macrodef-debug-appclient">
+        <macrodef name="debug-appclient" uri="http://www.netbeans.org/ns/car-project/1">
+            <attribute name="mainclass"/>
+            <attribute default="${debug.classpath}" name="classpath"/>
+            <element name="customize" optional="true"/>
+            <attribute default="${application.args.param}" name="args"/>
+            <sequential>
+                <parallel>
+                    <java classname="@{mainclass}" dir="${work.dir}" fork="true">
+                        <jvmarg line="${j2ee.appclient.tool.jvmoptions}"/>
+                        <jvmarg line="${debug-args-line}"/>
+                        <jvmarg value="-Xrunjdwp:transport=${jpda.transport},server=y,address=${jpda.address},suspend=y"/>
+                        <jvmarg line="${run.jvmargs.param}"/>
+                        <arg line="@{args}"/>
+                        <classpath>
+                            <path path="${javac.classpath}:${j2ee.platform.classpath}:${j2ee.appclient.tool.runtime}"/>
+                            <path path="@{classpath}"/>
+                        </classpath>
+                        <syspropertyset>
+                            <propertyref prefix="run-sys-prop."/>
+                            <mapper from="run-sys-prop.*" to="*" type="glob"/>
+                        </syspropertyset>
+                        <customize/>
+                    </java>
+                    <nbjpdaconnect address="${jpda.address}" host="${jpda.host}" name="${name}" transport="${jpda.transport}">
+                        <classpath>
+                            <path path="${javac.classpath}:${j2ee.platform.classpath}:${j2ee.appclient.tool.runtime}"/>
+                            <path path="@{classpath}"/>
+                        </classpath>
+                        <sourcepath>
+                            <path path="${src.dir}"/>
+                        </sourcepath>
+                    </nbjpdaconnect>
+                </parallel>
+            </sequential>
+        </macrodef>
+    </target>
+    <target name="-init-taskdefs">
+        <fail unless="libs.CopyLibs.classpath">
+The libs.CopyLibs.classpath property is not set up.
+This property must point to 
+org-netbeans-modules-java-j2seproject-copylibstask.jar file which is part
+of NetBeans IDE installation and is usually located at 
+&lt;netbeans_installation&gt;/java&lt;version&gt;/ant/extra folder.
+Either open the project in the IDE and make sure CopyLibs library
+exists or setup the property manually. For example like this:
+ ant -Dlibs.CopyLibs.classpath=a/path/to/org-netbeans-modules-java-j2seproject-copylibstask.jar
+                </fail>
+        <taskdef classpath="${libs.CopyLibs.classpath}" resource="org/netbeans/modules/java/j2seproject/copylibstask/antlib.xml"/>
+    </target>
+    <target depends="-pre-init,-pre-init-am,-init-private,-init-user,-init-project,-do-init,-post-init,-init-check,-init-macrodef-property,-init-macrodef-javac,-init-macrodef-junit,-init-macrodef-java,-init-macrodef-nbjpda,-init-macrodef-debug,-init-macrodef-debug-appclient,-init-taskdefs" name="init"/>
+    <!--
+                ===================
+                COMPILATION SECTION
+                ===================
+            -->
+    <target name="-check-main-class">
+        <fail>
+                    Main class must be set. Go to DSI-app-client project properties -&gt; Run and set the main class there.
+                    <condition>
+                <not>
+                    <or>
+                        <isset property="dist.ear.dir"/>
+                        <isset property="main.class"/>
+                    </or>
+                </not>
+            </condition>
+        </fail>
+    </target>
+    <target depends="init" if="no.dist.ear.dir" name="-deps-module-jar" unless="no.deps">
+        <ant antfile="${project.DSI-ejb}/build.xml" inheritall="false" target="dist"/>
+    </target>
+    <target depends="init" if="dist.ear.dir" name="-deps-ear-jar" unless="no.deps">
+        <ant antfile="${project.DSI-ejb}/build.xml" inheritall="false" target="dist-ear">
+            <property location="${build.dir}" name="dist.ear.dir"/>
+        </ant>
+    </target>
+    <target depends="init, -check-main-class, -deps-module-jar, -deps-ear-jar" name="deps-jar"/>
+    <target depends="init,deps-jar" name="-pre-pre-compile">
+        <mkdir dir="${classes.dir}"/>
+    </target>
+    <target name="-pre-compile">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="compile" name="library-inclusion-in-archive">
+        <mkdir dir="${build.classes.dir}/META-INF/lib"/>
+        <copyfiles files="${reference.DSI-ejb.dist}" todir="${build.classes.dir}/META-INF/lib"/>
+    </target>
+    <target depends="compile" if="dist.ear.dir" name="library-inclusion-in-manifest">
+        <copyfiles files="${reference.DSI-ejb.dist}" manifestproperty="manifest.reference.DSI-ejb.dist" todir="${dist.ear.dir}"/>
+        <manifest file="${build.ear.classes.dir}/META-INF/MANIFEST.MF" mode="update">
+            <attribute name="Class-Path" value="${manifest.reference.DSI-ejb.dist} "/>
+        </manifest>
+    </target>
+    <target name="-copy-meta-inf">
+        <copy todir="${classes.dir}">
+            <fileset dir="${meta.inf}" includes="**/*.dbschema"/>
+        </copy>
+        <copy todir="${classes.dir}/META-INF">
+            <fileset dir="${meta.inf}" excludes="**/*.dbschema **/xml-resources/** ${meta.inf.excludes}"/>
+        </copy>
+    </target>
+    <target depends="init,deps-jar,-pre-pre-compile,-pre-compile,-copy-meta-inf" if="have.sources" name="-do-compile">
+        <carproject:javac destdir="${classes.dir}"/>
+        <copy todir="${classes.dir}">
+            <fileset dir="${src.dir}" excludes="${build.classes.excludes},${excludes}" includes="${includes}"/>
+        </copy>
+    </target>
+    <target name="-post-compile">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,deps-jar,-pre-pre-compile,-pre-compile,-do-compile,-post-compile" description="Compile project." name="compile"/>
+    <target name="-pre-compile-single">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,deps-jar,-pre-pre-compile" name="-do-compile-single">
+        <fail unless="javac.includes">Must select some files in the IDE or set javac.includes</fail>
+        <carproject:javac excludes="" includes="${javac.includes}"/>
+    </target>
+    <target name="-post-compile-single">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,deps-jar,-pre-pre-compile,-pre-compile-single,-do-compile-single,-post-compile-single" name="compile-single"/>
+    <!--
+                ====================
+                DIST BUILDING SECTION
+                ====================
+            -->
+    <target depends="init" name="-pre-pre-dist">
+        <dirname file="${dist.jar}" property="dist.jar.dir"/>
+        <mkdir dir="${dist.jar.dir}"/>
+    </target>
+    <target name="-pre-dist">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,compile,-pre-dist,library-inclusion-in-archive" if="has.custom.manifest" name="-do-dist-with-manifest">
+        <dirname file="${dist.jar}" property="dist.jar.dir"/>
+        <mkdir dir="${dist.jar.dir}"/>
+        <manifest file="${build.classes.dir}/META-INF/MANIFEST.MF" mode="update">
+            <attribute name="Main-Class" value="${main.class}"/>
+        </manifest>
+        <jar compress="${jar.compress}" jarfile="${dist.jar}" manifest="${build.classes.dir}/META-INF/MANIFEST.MF">
+            <fileset dir="${build.classes.dir}"/>
+        </jar>
+    </target>
+    <target depends="init,compile,-pre-dist,library-inclusion-in-archive" name="-do-dist-without-manifest" unless="has.custom.manifest">
+        <dirname file="${dist.jar}" property="dist.jar.dir"/>
+        <mkdir dir="${dist.jar.dir}"/>
+        <jar compress="${jar.compress}" jarfile="${dist.jar}">
+            <fileset dir="${build.classes.dir}"/>
+        </jar>
+    </target>
+    <target depends="init,compile,-pre-dist" if="has.custom.manifest" name="-do-ear-dist-with-manifest">
+        <dirname file="${dist.ear.jar}" property="dist.jar.dir"/>
+        <mkdir dir="${dist.jar.dir}"/>
+        <manifest file="${build.ear.classes.dir}/META-INF/MANIFEST.MF" mode="update">
+            <attribute name="Main-Class" value="${main.class}"/>
+        </manifest>
+        <jar compress="${jar.compress}" jarfile="${dist.ear.jar}" manifest="${build.ear.classes.dir}/META-INF/MANIFEST.MF">
+            <fileset dir="${build.ear.classes.dir}"/>
+        </jar>
+    </target>
+    <target depends="init,compile,-pre-dist" name="-do-ear-dist-without-manifest" unless="has.custom.manifest">
+        <dirname file="${dist.ear.jar}" property="dist.jar.dir"/>
+        <mkdir dir="${dist.jar.dir}"/>
+        <jar compress="${jar.compress}" jarfile="${dist.ear.jar}">
+            <fileset dir="${build.ear.classes.dir}"/>
+        </jar>
+    </target>
+    <target depends="init,compile,-pre-dist,library-inclusion-in-archive,-do-dist-without-manifest,-do-dist-with-manifest" name="-do-dist"/>
+    <target depends="init,compile,-pre-dist,library-inclusion-in-manifest,-do-ear-dist-without-manifest,-do-ear-dist-with-manifest" name="-do-ear-dist"/>
+    <target name="-post-dist">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,compile,-pre-dist,-do-dist,-post-dist" description="Build distribution (JAR)." name="dist"/>
+    <target depends="init,compile,-pre-dist,-do-ear-dist,-post-dist" description="Build distribution (JAR) to be packaged into an EAR." name="dist-ear"/>
+    <!--
+                =================
+                EXECUTION SECTION
+                =================
+            -->
+    <target depends="dist,run-deploy,run-tool,run-jar,run-display-browser" description="Run a main class." name="run"/>
+    <target depends="init" description="Run a main class." if="j2ee.clientName" name="run-jar" unless="j2ee.appclient.mainclass.args">
+        <carproject:java classname="${main.class}">
+            <customize>
+                <arg line="${application.args.param}"/>
+            </customize>
+        </carproject:java>
+    </target>
+    <target depends="init,-as-retrieve-option-workaround" description="Run a main class." if="j2ee.appclient.mainclass.args" name="run-tool" unless="j2ee.clientName">
+        <java classname="${j2ee.appclient.tool.mainclass}" dir="${work.dir}" fork="true">
+            <jvmarg line="${j2ee.appclient.tool.jvmoptions}"/>
+            <jvmarg line="${run.jvmargs.param}"/>
+            <arg line="${j2ee.appclient.tool.args}"/>
+            <arg line="-client ${client.jar}"/>
+            <arg line="${application.args.param}"/>
+            <classpath>
+                <path path="${javac.classpath}:${j2ee.platform.classpath}:${j2ee.appclient.tool.runtime}"/>
+            </classpath>
+            <syspropertyset>
+                <propertyref prefix="run-sys-prop."/>
+                <mapper from="run-sys-prop.*" to="*" type="glob"/>
+            </syspropertyset>
+        </java>
+    </target>
+    <target depends="init,compile-single" name="run-single">
+        <fail unless="run.class">Must select one file in the IDE or set run.class</fail>
+        <carproject:java classname="${run.class}"/>
+    </target>
+    <target if="j2ee.appclient.mainclass.args" name="-as-retrieve-option-workaround" unless="j2ee.clientName">
+        <property name="client.jar" value="${dist.dir}/DSI-app-clientClient.jar"/>
+        <sleep seconds="3"/>
+        <copy file="${wa.copy.client.jar.from}/DSI-app-client/DSI-app-clientClient.jar" todir="${dist.dir}"/>
+    </target>
+    <target name="pre-run-deploy">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target name="post-run-deploy">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target name="-pre-nbmodule-run-deploy">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- This target can be overriden by NetBeans modules. Don't override it directly, use -pre-run-deploy task instead. -->
+    </target>
+    <target name="-post-nbmodule-run-deploy">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- This target can be overriden by NetBeans modules. Don't override it directly, use -post-run-deploy task instead. -->
+    </target>
+    <target name="-run-deploy-am">
+        <!-- Task to deploy to the Access Manager runtime. -->
+    </target>
+    <target depends="init,compile,dist,pre-run-deploy,-pre-nbmodule-run-deploy,-run-deploy-nb,-init-deploy-ant,-deploy-ant,-run-deploy-am,-post-nbmodule-run-deploy,post-run-deploy" name="run-deploy">
+        <nbjpdaappreloaded/>
+    </target>
+    <target if="netbeans.home" name="-run-deploy-nb">
+        <nbdeploy clientUrlPart="${client.urlPart}" debugmode="false" forceRedeploy="${forceRedeploy}"/>
+    </target>
+    <target name="-init-deploy-ant" unless="netbeans.home">
+        <property name="deploy.ant.archive" value="${dist.jar}"/>
+        <property name="deploy.ant.resource.dir" value="${resource.dir}"/>
+        <property name="deploy.ant.enabled" value="true"/>
+    </target>
+    <target depends="init,-run-undeploy-nb,-init-deploy-ant,-undeploy-ant" name="run-undeploy"/>
+    <target if="netbeans.home" name="-run-undeploy-nb">
+        <fail message="Undeploy is not supported from within the IDE"/>
+    </target>
+    <target depends="run-deploy,-init-display-browser,-display-browser-nb,-display-browser-cl" name="run-display-browser"/>
+    <target if="do.display.browser" name="-init-display-browser">
+        <condition property="do.display.browser.nb">
+            <isset property="netbeans.home"/>
+        </condition>
+        <condition property="do.display.browser.cl">
+            <and>
+                <isset property="deploy.ant.enabled"/>
+                <isset property="deploy.ant.client.url"/>
+            </and>
+        </condition>
+    </target>
+    <target if="do.display.browser.nb" name="-display-browser-nb">
+        <nbbrowse url="${client.url}"/>
+    </target>
+    <target if="do.display.browser.cl" name="-get-browser" unless="browser">
+        <condition property="browser" value="rundll32">
+            <os family="windows"/>
+        </condition>
+        <condition else="" property="browser.args" value="url.dll,FileProtocolHandler">
+            <os family="windows"/>
+        </condition>
+        <condition property="browser" value="/usr/bin/open">
+            <os family="mac"/>
+        </condition>
+        <property environment="env"/>
+        <condition property="browser" value="${env.BROWSER}">
+            <isset property="env.BROWSER"/>
+        </condition>
+        <condition property="browser" value="/usr/bin/firefox">
+            <available file="/usr/bin/firefox"/>
+        </condition>
+        <condition property="browser" value="/usr/local/firefox/firefox">
+            <available file="/usr/local/firefox/firefox"/>
+        </condition>
+        <condition property="browser" value="/usr/bin/mozilla">
+            <available file="/usr/bin/mozilla"/>
+        </condition>
+        <condition property="browser" value="/usr/local/mozilla/mozilla">
+            <available file="/usr/local/mozilla/mozilla"/>
+        </condition>
+        <condition property="browser" value="/usr/sfw/lib/firefox/firefox">
+            <available file="/usr/sfw/lib/firefox/firefox"/>
+        </condition>
+        <condition property="browser" value="/opt/csw/bin/firefox">
+            <available file="/opt/csw/bin/firefox"/>
+        </condition>
+        <condition property="browser" value="/usr/sfw/lib/mozilla/mozilla">
+            <available file="/usr/sfw/lib/mozilla/mozilla"/>
+        </condition>
+        <condition property="browser" value="/opt/csw/bin/mozilla">
+            <available file="/opt/csw/bin/mozilla"/>
+        </condition>
+    </target>
+    <target depends="-get-browser" if="do.display.browser.cl" name="-display-browser-cl">
+        <fail unless="browser">
+                    Browser not found, cannot launch the deployed application. Try to set the BROWSER environment variable.
+                </fail>
+        <property name="browse.url" value="${deploy.ant.client.url}${client.urlPart}"/>
+        <echo>Launching ${browse.url}</echo>
+        <exec executable="${browser}" spawn="true">
+            <arg line="${browser.args} ${browse.url}"/>
+        </exec>
+    </target>
+    <target depends="dist" name="verify">
+        <nbverify file="${dist.jar}"/>
+    </target>
+    <target depends="init,compile-single" name="run-main">
+        <fail unless="run.class">Must select one file in the IDE or set run.class</fail>
+        <carproject:java classname="${run.class}"/>
+    </target>
+    <!--
+                =================
+                DEBUGGING SECTION
+                =================
+            -->
+    <target depends="init" if="netbeans.home" name="-debug-start-debugger">
+        <carproject:nbjpdastart name="${debug.class}"/>
+    </target>
+    <target depends="init,compile" name="-debug-start-debuggee">
+        <carproject:debug>
+            <customize>
+                <arg line="${application.args.param}"/>
+            </customize>
+        </carproject:debug>
+    </target>
+    <target if="j2ee.clientName" name="debug-jar" unless="j2ee.appclient.mainclass.args">
+        <carproject:debug-appclient args="${application.args.param}" mainclass="${main.class}"/>
+    </target>
+    <target depends="init,-as-retrieve-option-workaround" if="j2ee.appclient.mainclass.args" name="debug-tool" unless="j2ee.clientName">
+        <carproject:debug-appclient args="${j2ee.appclient.mainclass.args} ${application.args.param}" mainclass="${j2ee.appclient.tool.mainclass}"/>
+    </target>
+    <target depends="init,compile,run-deploy,debug-tool,debug-jar" description="Debug project in IDE." if="netbeans.home" name="debug"/>
+    <target depends="init" if="netbeans.home" name="-debug-start-debugger-stepinto">
+        <carproject:nbjpdastart stopclassname="${main.class}"/>
+    </target>
+    <target depends="init,compile,-debug-start-debugger-stepinto,-debug-start-debuggee" if="netbeans.home" name="debug-stepinto"/>
+    <target depends="init,compile-single" if="netbeans.home" name="-debug-start-debuggee-single">
+        <fail unless="debug.class">Must select one file in the IDE or set debug.class</fail>
+        <carproject:debug classname="${debug.class}"/>
+    </target>
+    <target depends="init,compile-single,-debug-start-debugger,-debug-start-debuggee-single" if="netbeans.home" name="debug-single"/>
+    <target depends="init" name="-pre-debug-fix">
+        <fail unless="fix.includes">Must set fix.includes</fail>
+        <property name="javac.includes" value="${fix.includes}.java"/>
+    </target>
+    <target depends="init,-pre-debug-fix,compile-single" if="netbeans.home" name="-do-debug-fix">
+        <carproject:nbjpdareload/>
+    </target>
+    <target depends="init,-pre-debug-fix,-do-debug-fix" if="netbeans.home" name="debug-fix"/>
+    <!--
+                ===============
+                JAVADOC SECTION
+                ===============
+            -->
+    <target depends="init" name="-javadoc-build">
+        <mkdir dir="${dist.javadoc.dir}"/>
+        <javadoc additionalparam="${javadoc.additionalparam}" author="${javadoc.author}" charset="UTF-8" destdir="${dist.javadoc.dir}" docencoding="UTF-8" encoding="${javadoc.encoding.used}" failonerror="true" noindex="${javadoc.noindex}" nonavbar="${javadoc.nonavbar}" notree="${javadoc.notree}" private="${javadoc.private}" source="${javac.source}" splitindex="${javadoc.splitindex}" use="${javadoc.use}" useexternalfile="true" version="${javadoc.version}" windowtitle="${javadoc.windowtitle}">
+            <classpath>
+                <path path="${javac.classpath}:${j2ee.platform.classpath}:${j2ee.appclient.tool.runtime}"/>
+            </classpath>
+            <fileset dir="${src.dir}" excludes="${excludes}" includes="${includes}">
+                <filename name="**/*.java"/>
+            </fileset>
+        </javadoc>
+    </target>
+    <target depends="init,-javadoc-build" if="netbeans.home" name="-javadoc-browse" unless="no.javadoc.preview">
+        <nbbrowse file="${dist.javadoc.dir}/index.html"/>
+    </target>
+    <target depends="init,-javadoc-build,-javadoc-browse" description="Build Javadoc." name="javadoc"/>
+    <!--
+                =========================
+                JUNIT COMPILATION SECTION
+                =========================
+            -->
+    <target depends="init,compile" if="have.tests" name="-pre-pre-compile-test">
+        <mkdir dir="${build.test.classes.dir}"/>
+    </target>
+    <target name="-pre-compile-test">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,compile,-pre-pre-compile-test,-pre-compile-test" if="have.tests" name="-do-compile-test">
+        <carproject:javac classpath="${javac.test.classpath}" debug="true" destdir="${build.test.classes.dir}" srcdir="${test.src.dir}"/>
+        <copy todir="${build.test.classes.dir}">
+            <fileset dir="${test.src.dir}" excludes="${build.classes.excludes},${excludes}" includes="${includes}"/>
+        </copy>
+    </target>
+    <target name="-post-compile-test">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,compile,-pre-pre-compile-test,-pre-compile-test,-do-compile-test,-post-compile-test" name="compile-test"/>
+    <target name="-pre-compile-test-single">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,compile,-pre-pre-compile-test,-pre-compile-test-single" if="have.tests" name="-do-compile-test-single">
+        <fail unless="javac.includes">Must select some files in the IDE or set javac.includes</fail>
+        <carproject:javac classpath="${javac.test.classpath}" debug="true" destdir="${build.test.classes.dir}" excludes="" includes="${javac.includes}" srcdir="${test.src.dir}"/>
+        <copy todir="${build.test.classes.dir}">
+            <fileset dir="${test.src.dir}" excludes="${build.classes.excludes},${excludes}" includes="${includes}"/>
+        </copy>
+    </target>
+    <target name="-post-compile-test-single">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,compile,-pre-pre-compile-test,-pre-compile-test-single,-do-compile-test-single,-post-compile-test-single" name="compile-test-single"/>
+    <!--
+                =======================
+                JUNIT EXECUTION SECTION
+                =======================
+            -->
+    <target depends="init" if="have.tests" name="-pre-test-run">
+        <mkdir dir="${build.test.results.dir}"/>
+    </target>
+    <target depends="init,compile-test,-pre-test-run" if="have.tests" name="-do-test-run">
+        <carproject:junit testincludes="**/*Test.java"/>
+    </target>
+    <target depends="init,compile-test,-pre-test-run,-do-test-run" if="have.tests" name="-post-test-run">
+        <fail if="tests.failed">Some tests failed; see details above.</fail>
+    </target>
+    <target depends="init" if="have.tests" name="test-report"/>
+    <target depends="init" if="netbeans.home+have.tests" name="-test-browse"/>
+    <target depends="init,compile-test,-pre-test-run,-do-test-run,test-report,-post-test-run,-test-browse" description="Run unit tests." name="test"/>
+    <target depends="init" if="have.tests" name="-pre-test-run-single">
+        <mkdir dir="${build.test.results.dir}"/>
+    </target>
+    <target depends="init,compile-test-single,-pre-test-run-single" if="have.tests" name="-do-test-run-single">
+        <fail unless="test.includes">Must select some files in the IDE or set test.includes</fail>
+        <carproject:junit excludes="" includes="${test.includes}"/>
+    </target>
+    <target depends="init,compile-test-single,-pre-test-run-single,-do-test-run-single" if="have.tests" name="-post-test-run-single">
+        <fail if="tests.failed">Some tests failed; see details above.</fail>
+    </target>
+    <target depends="init,compile-test-single,-pre-test-run-single,-do-test-run-single,-post-test-run-single" description="Run single unit test." name="test-single"/>
+    <!--
+                =======================
+                JUNIT DEBUGGING SECTION
+                =======================
+            -->
+    <target depends="init,compile-test" if="have.tests" name="-debug-start-debuggee-test">
+        <fail unless="test.class">Must select one file in the IDE or set test.class</fail>
+        <property location="${build.test.results.dir}/TEST-${test.class}.xml" name="test.report.file"/>
+        <delete file="${test.report.file}"/>
+        <!-- the directory must exist, otherwise the XML formatter would fail -->
+        <mkdir dir="${build.test.results.dir}"/>
+        <carproject:debug classname="org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner" classpath="${ant.home}/lib/ant.jar:${ant.home}/lib/ant-junit.jar:${debug.test.classpath}">
+            <customize>
+                <arg value="${test.class}"/>
+                <arg value="formatter=org.apache.tools.ant.taskdefs.optional.junit.BriefJUnitResultFormatter"/>
+                <arg value="formatter=org.apache.tools.ant.taskdefs.optional.junit.XMLJUnitResultFormatter,${test.report.file}"/>
+            </customize>
+        </carproject:debug>
+    </target>
+    <target depends="init,compile-test" if="netbeans.home+have.tests" name="-debug-start-debugger-test">
+        <carproject:nbjpdastart classpath="${debug.test.classpath}" name="${test.class}"/>
+    </target>
+    <target depends="init,compile-test,-debug-start-debugger-test,-debug-start-debuggee-test" name="debug-test"/>
+    <target depends="init,-pre-debug-fix,compile-test-single" if="netbeans.home" name="-do-debug-fix-test">
+        <carproject:nbjpdareload dir="${build.test.classes.dir}"/>
+    </target>
+    <target depends="init,-pre-debug-fix,-do-debug-fix-test" if="netbeans.home" name="debug-fix-test"/>
+    <!--
+                =========================
+                APPLET EXECUTION SECTION
+                =========================
+            -->
+    <target depends="init,compile-single" name="run-applet">
+        <fail unless="applet.url">Must select one file in the IDE or set applet.url</fail>
+        <carproject:java classname="sun.applet.AppletViewer">
+            <customize>
+                <arg value="${applet.url}"/>
+            </customize>
+        </carproject:java>
+    </target>
+    <!--
+                =========================
+                APPLET DEBUGGING  SECTION
+                =========================
+            -->
+    <target depends="init,compile-single" if="netbeans.home" name="-debug-start-debuggee-applet">
+        <fail unless="applet.url">Must select one file in the IDE or set applet.url</fail>
+        <carproject:debug classname="sun.applet.AppletViewer">
+            <customize>
+                <arg value="${applet.url}"/>
+            </customize>
+        </carproject:debug>
+    </target>
+    <target depends="init,compile-single,-debug-start-debugger,-debug-start-debuggee-applet" if="netbeans.home" name="debug-applet"/>
+    <!--
+                ===============
+                CLEANUP SECTION
+                ===============
+            -->
+    <target depends="init" if="no.dist.ear.dir" name="deps-clean" unless="no.deps">
+        <ant antfile="${project.DSI-ejb}/build.xml" inheritall="false" target="clean"/>
+    </target>
+    <target depends="init" name="-do-clean">
+        <delete dir="${build.dir}"/>
+        <delete dir="${dist.dir}"/>
+    </target>
+    <target name="-post-clean">
+        <!-- Empty placeholder for easier customization. -->
+        <!-- You can override this target in the ../build.xml file. -->
+    </target>
+    <target depends="init,deps-clean,-do-clean,-post-clean" description="Clean build products." name="clean"/>
+    <target depends="clean" description="Clean build products." name="clean-ear"/>
+</project>
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/genfiles.properties b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/genfiles.properties
new file mode 100644
index 0000000..ce3b083
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/genfiles.properties	
@@ -0,0 +1,8 @@
+build.xml.data.CRC32=a0cb5da8
+build.xml.script.CRC32=4b377cf7
+build.xml.stylesheet.CRC32=f851c264
+# This file is used by a NetBeans-based IDE to track changes in generated files such as build-impl.xml.
+# Do not edit this file. You may delete it but then the IDE will never regenerate such files for you.
+nbproject/build-impl.xml.data.CRC32=a0cb5da8
+nbproject/build-impl.xml.script.CRC32=bdd22fd2
+nbproject/build-impl.xml.stylesheet.CRC32=e1f9045c
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/private/private.properties b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/private/private.properties
new file mode 100644
index 0000000..95bd6ae
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/private/private.properties	
@@ -0,0 +1,13 @@
+deploy.ant.properties.file=C:\\Dokumente und Einstellungen\\Jan\\.netbeans\\6.5\\glassfish.properties
+j2ee.appclient.tool.args=-configxml "D:\\Programme\\glassfish-v2.1\\domains\\domain1\\config\\sun-acc.xml"
+j2ee.appclient.tool.jvmoptions=-Dcom.sun.aas.configRoot="D:\\Programme\\glassfish-v2.1\\config" -Dcom.sun.aas.installRoot="D:\\Programme\\glassfish-v2.1" -Dcom.sun.aas.imqLib="D:\\Programme\\glassfish-v2.1\\imq\\lib" -Djava.security.policy="D:\\Programme\\glassfish-v2.1\\lib\\appclient\\client.policy" -Djava.security.auth.login.config="D:\\Programme\\glassfish-v2.1\\lib\\appclient\\appclientlogin.conf" -Djava.endorsed.dirs="D:\\Programme\\glassfish-v2.1\\lib\\endorsed" -Djavax.xml.parsers.SAXParserFactory=com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl -Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl -Djavax.xml.transform.TransformerFactory=com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl -Dorg.xml.sax.parser=org.xml.sax.helpers.XMLReaderAdapter -Dorg.xml.sax.driver=com.sun.org.apache.xerces.internal.parsers.SAXParser -Djava.util.logging.manager=com.sun.enterprise.server.logging.ACCLogManager
+j2ee.appclient.tool.mainclass=com.sun.enterprise.appclient.Main
+j2ee.appclient.tool.runtime=D:\\Programme\\glassfish-v2.1\\lib\\dom.jar:D:\\Programme\\glassfish-v2.1\\lib\\xalan.jar:D:\\Programme\\glassfish-v2.1\\lib\\xercesImpl.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-rt.jar:D:\\Programme\\glassfish-v2.1\\lib\\javaee.jar:D:\\Programme\\glassfish-v2.1\\lib\\j2ee.jar:D:\\Programme\\glassfish-v2.1\\lib\\jmac-api.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-ext.jar:D:\\Programme\\glassfish-v2.1\\lib\\mail.jar:D:\\Programme\\glassfish-v2.1\\lib\\activation.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-rt.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-tools.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-ws.jar:D:\\Programme\\glassfish-v2.1\\lib\\jaxrpc-impl.jar:D:\\Programme\\glassfish-v2.1\\lib\\saaj-impl.jar:D:\\Programme\\glassfish-v2.1\\lib\\jaxr-impl.jar:D:\\Programme\\glassfish-v2.1\\lib\\relaxngDatatype.jar:D:\\Programme\\glassfish-v2.1\\lib\\xsdlib.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-cmp.jar:D:\\Programme\\glassfish-v2.1\\javadb\\lib\\derbyclient.jar:D:\\Programme\\glassfish-v2.1\\lib\\toplink-essentials.jar:D:\\Programme\\glassfish-v2.1\\lib\\dbschema.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-admin.jar:D:\\Programme\\glassfish-v2.1\\lib\\install\\applications\\jmsra\\imqjmsra.jar:D:\\Programme\\glassfish-v2.1\\lib\\fscontext.jar:D:\\Programme\\glassfish-v2.1\\lib\\dtds:D:\\Programme\\glassfish-v2.1\\lib\\schemas
+j2ee.platform.classpath=D:\\Programme\\glassfish-v2.1\\lib\\javaee.jar:D:\\Programme\\glassfish-v2.1\\lib\\jsf-impl.jar:D:\\Programme\\glassfish-v2.1\\lib\\activation.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-tags.jar:D:\\Programme\\glassfish-v2.1\\lib\\mail.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-jstl.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-tools.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-rt.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-ws.jar
+j2ee.platform.wscompile.classpath=D:\\Programme\\glassfish-v2.1\\lib\\j2ee.jar:D:\\Programme\\glassfish-v2.1\\lib\\saaj-api.jar:D:\\Programme\\glassfish-v2.1\\lib\\saaj-impl.jar:D:\\Programme\\glassfish-v2.1\\lib\\jaxrpc-api.jar:D:\\Programme\\glassfish-v2.1\\lib\\jaxrpc-impl.jar:D:\\Programme\\glassfish-v2.1\\lib\\endorsed\\jaxp-api.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-ws.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-tools.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-rt.jar
+j2ee.platform.wsimport.classpath=D:\\Programme\\glassfish-v2.1\\lib\\webservices-tools.jar:D:\\Programme\\glassfish-v2.1\\lib\\webservices-rt.jar:D:\\Programme\\glassfish-v2.1\\lib\\tools.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-jstl.jar:D:\\Programme\\glassfish-v2.1\\lib\\javaee.jar:D:\\Programme\\glassfish-v2.1\\lib\\appserv-ws.jar:D:\\Programme\\glassfish-v2.1\\lib\\mail.jar:D:\\Programme\\glassfish-v2.1\\lib\\activation.jar
+j2ee.server.instance=[D:\\Programme\\glassfish-v2.1]deployer:Sun:AppServer::localhost:4848
+jaxws.endorsed.dir=D:\\Programme\\NetBeans 6.5.1\\java2\\modules\\ext\\jaxws21\\api:D:\\Programme\\NetBeans 6.5.1\\ide10\\modules\\ext\\jaxb\\api
+source.encoding=UTF-8
+user.properties.file=C:\\Dokumente und Einstellungen\\Jan\\.netbeans\\6.5\\build.properties
+wa.copy.client.jar.from=D:\\Programme\\glassfish-v2.1\\domains\\domain1\\generated\\xml\\j2ee-modules
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.properties b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.properties
new file mode 100644
index 0000000..245c9dc
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.properties	
@@ -0,0 +1,69 @@
+build.classes.dir=${build.dir}/jar
+build.classes.excludes=**/*.java,**/*.form
+# This directory is removed when the project is cleaned:
+build.dir=build
+build.ear.classes.dir=${build.dir}/jar
+build.generated.dir=${build.dir}/generated
+# Only compile against the classpath explicitly listed here:
+build.sysclasspath=ignore
+build.test.classes.dir=${build.dir}/test/classes
+build.test.results.dir=${build.dir}/test/results
+debug.classpath=\
+    ${run.classpath}
+debug.test.classpath=\
+    ${run.test.classpath}
+# This directory is removed when the project is cleaned:
+dist.dir=dist
+dist.ear.jar=${dist.dir}/${jar.name}
+dist.jar=${dist.dir}/${jar.name}
+dist.javadoc.dir=${dist.dir}/javadoc
+excludes=
+includes=**
+j2ee.appclient.mainclass.args=-client ${dist.jar} ${j2ee.appclient.tool.args}
+j2ee.platform=1.5
+j2ee.server.type=J2EE
+jar.compress=false
+jar.name=DSI-app-client.jar
+javac.classpath=\
+    ${reference.DSI-ejb.dist}
+# Space-separated list of extra javac options
+javac.compilerargs=
+javac.deprecation=false
+javac.source=1.5
+javac.target=1.5
+javac.test.classpath=\
+    ${javac.classpath}:\
+    ${build.classes.dir}:\
+    ${libs.junit.classpath}:\
+    ${libs.junit_4.classpath}
+javadoc.additionalparam=
+javadoc.author=false
+javadoc.encoding=${source.encoding}
+javadoc.noindex=false
+javadoc.nonavbar=false
+javadoc.notree=false
+javadoc.private=false
+javadoc.splitindex=true
+javadoc.use=true
+javadoc.version=false
+javadoc.windowtitle=
+main.class=dsi.Main
+manifest.file=${meta.inf}/MANIFEST.MF
+meta.inf=${source.root}/conf
+platform.active=default_platform
+project.DSI-ejb=../DSI-ejb
+reference.DSI-ejb.dist=${project.DSI-ejb}/dist/DSI-ejb.jar
+resource.dir=setup
+run.classpath=\
+    ${javac.classpath}:\
+    ${build.classes.dir}
+# Space-separated list of JVM arguments used when running the project
+# (you may also define separate properties like run-sys-prop.name=value instead of -Dname=value
+# or test-sys-prop.name=value to set system properties for unit tests):
+run.jvmargs=
+run.test.classpath=\
+    ${javac.test.classpath}:\
+    ${build.test.classes.dir}
+source.root=src
+src.dir=${source.root}/java
+test.src.dir=test
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.xml b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.xml
new file mode 100644
index 0000000..17905a2
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/nbproject/project.xml	
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://www.netbeans.org/ns/project/1">
+    <type>org.netbeans.modules.j2ee.clientproject</type>
+    <configuration>
+        <data xmlns="http://www.netbeans.org/ns/car-project/1">
+            <name>DSI-app-client</name>
+            <minimum-ant-version>1.6.5</minimum-ant-version>
+            <source-roots>
+                <root id="src.dir" name="Source Packages"/>
+            </source-roots>
+            <test-roots>
+                <root id="test.src.dir" name="Test Packages"/>
+            </test-roots>
+            <included-library files="1">reference.DSI-ejb.dist</included-library>
+        </data>
+        <libraries xmlns="http://www.netbeans.org/ns/ant-project-libraries/1">
+            <definitions>..\.\lib\nblibraries.properties</definitions>
+        </libraries>
+        <references xmlns="http://www.netbeans.org/ns/ant-project-references/1">
+            <reference>
+                <foreign-project>DSI-ejb</foreign-project>
+                <artifact-type>jar</artifact-type>
+                <script>build.xml</script>
+                <target>dist</target>
+                <clean-target>clean</clean-target>
+                <id>dist</id>
+            </reference>
+        </references>
+    </configuration>
+</project>
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/MANIFEST.MF b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/MANIFEST.MF
new file mode 100644
index 0000000..1574df4
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/MANIFEST.MF	
@@ -0,0 +1,3 @@
+Manifest-Version: 1.0
+X-COMMENT: Main-Class will be added automatically by build
+
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/application-client.xml b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/application-client.xml
new file mode 100644
index 0000000..682188b
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/conf/application-client.xml	
@@ -0,0 +1,4 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<application-client version="5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/application-client_5.xsd">
+  <display-name>DSI-app-client</display-name>
+</application-client>
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/ArtikelListeTableModel.java b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/ArtikelListeTableModel.java
new file mode 100644
index 0000000..6c8bc8f
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/ArtikelListeTableModel.java	
@@ -0,0 +1,118 @@
+/*
+ * To change this template, choose Tools | Templates
+ * and open the template in the editor.
+ */
+
+package dsi;
+
+import entities.Artikel;
+import java.util.LinkedList;
+import java.util.List;
+import javax.swing.table.AbstractTableModel;
+
+/**
+ * Klasse die eine Liste von Artikeln kapselt, und als Table-Model
+ * zur Verfügung stellt
+ * @author jmueller
+ */
+public class ArtikelListeTableModel extends AbstractTableModel{
+    private List<Artikel> artikelListe;
+    
+    /**
+     * Default-Konstruktor
+     */
+    public ArtikelListeTableModel(){
+        artikelListe = new LinkedList<Artikel>();        
+    }
+    
+    /**
+     * Konstruktor mit Initialisierung
+     * @param liste     Liste der Artikel
+     */
+    public ArtikelListeTableModel(List<Artikel> liste){
+        artikelListe = new LinkedList<Artikel>();        
+        for(Artikel a : liste){
+            artikelListe.add(a);
+        }
+    }    
+    
+    
+    /**
+     * Setzt die Artikel-Liste
+     * @param liste
+     */
+    public void setArtikelListe(List<Artikel> liste){
+        artikelListe = new LinkedList<Artikel>();        
+        for(Artikel a : liste){
+            artikelListe.add(a);
+        }       
+        fireTableStructureChanged();
+    }
+    
+    
+    /**
+     * Gibt die Artikelliste zurück
+     * ACHTUNG: nicht mittels dieser Methode Änderungen an der Liste vornehmen,
+     * da diese nicht refreshed werden
+     * @return
+     */
+    public List<Artikel> getArtikelListe(){
+        return artikelListe;
+    }
+    
+    
+    /**
+     * Gibt die Anzahl der Zeilen zurück
+     * @return
+     */
+    public int getRowCount() {
+        return artikelListe.size();
+    }
+
+    
+    /**
+     * Gibt die Anzahl der Spalten zurück
+     * @return
+     */
+    public int getColumnCount() {
+        return 4;
+    }
+
+    
+    /**
+     * Gibt den Inhalt einer Zelle als String zurück
+     * @param zeile
+     * @param spalte
+     * @return
+     */
+    public Object getValueAt(int zeile, int spalte) {
+       switch(spalte){
+           case 0: return ""+ artikelListe.get(zeile).getId();
+           case 1: return ""+ artikelListe.get(zeile).getBezeichnung();
+           case 2: return ""+ artikelListe.get(zeile).getAnzahl();
+           case 3: return String.format("%.2f €", artikelListe.get(zeile).getPreis());
+           default: return "";
+       }
+    }
+
+    /**
+     * gibt den Namen (Bezeichnung) der Spalte zurück
+     * @param arg0
+     * @return
+     */
+    @Override
+    public String getColumnName(int spalte) {
+        switch(spalte){
+            case 0: return "id";
+            case 1: return "Bezeichnung";
+            case 2: return "Anzahl";
+            case 3: return "Preis";
+            default: return "";
+        }
+    }
+    
+    
+    
+    
+
+}
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/KundenListeTableModel.java b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/KundenListeTableModel.java
new file mode 100644
index 0000000..7870843
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/KundenListeTableModel.java	
@@ -0,0 +1,118 @@
+/*
+ * To change this template, choose Tools | Templates
+ * and open the template in the editor.
+ */
+
+package dsi;
+
+import entities.Kunde;
+import java.util.LinkedList;
+import java.util.List;
+import javax.swing.table.AbstractTableModel;
+
+/**
+ * Klasse die eine Liste von Kunden kapselt, und als Table-Model
+ * zur Verfügung stellt
+ * @author jmueller
+ */
+public class KundenListeTableModel extends AbstractTableModel{
+    private List<Kunde> kundeListe;
+    
+    /**
+     * Default-Konstruktor
+     */
+    public KundenListeTableModel(){
+        kundeListe = new LinkedList<Kunde>();        
+    }
+    
+    /**
+     * Konstruktor mit Initialisierung
+     * @param liste     Liste der Kunden
+     */
+    public KundenListeTableModel(List<Kunde> liste){
+        kundeListe = new LinkedList<Kunde>();        
+        for(Kunde a : liste){
+            kundeListe.add(a);
+        }
+    }    
+    
+    
+    /**
+     * Setter fuer die Kunden-Liste
+     * @param liste
+     */
+    public void setKundenListe(List<Kunde> liste){
+        kundeListe = new LinkedList<Kunde>();        
+        for(Kunde a : liste){
+            kundeListe.add(a);
+        }       
+        fireTableStructureChanged();
+    }
+    
+    
+    /**
+     * Gibt die Kundeliste zurück
+     * ACHTUNG: nicht mittels dieser Methode Änderungen an der Liste vornehmen,
+     * da diese nicht refreshed werden
+     * @return
+     */
+    public List<Kunde> getKundenListe(){
+        return kundeListe;
+    }
+    
+    
+    /**
+     * Gibt die Anzahl der Zeilen zurück
+     * @return
+     */
+    public int getRowCount() {
+        return kundeListe.size();
+    }
+
+    
+    /**
+     * Gibt die Anzahl der Spalten zurück
+     * @return
+     */
+    public int getColumnCount() {
+        return 4;
+    }
+
+    
+    /**
+     * Gibt den Inhalt einer Zelle als String zurück
+     * @param zeile
+     * @param spalte
+     * @return
+     */
+    public Object getValueAt(int zeile, int spalte) {
+       switch(spalte){
+           case 0: return ""+ kundeListe.get(zeile).getId();
+           case 1: return ""+ kundeListe.get(zeile).getNachname();
+           case 2: return ""+ kundeListe.get(zeile).getVorname();
+           case 3: return "" + kundeListe.get(zeile).getAdresse();
+           default: return "";
+       }
+    }
+
+    /**
+     * gibt den Namen (Bezeichnung) der Spalte zurück
+     * @param arg0
+     * @return
+     */
+    @Override
+    public String getColumnName(int spalte) {
+        switch(spalte){
+            case 0: return "id";
+            case 1: return "Nachname";
+            case 2: return "Vorname";
+            case 3: return "Adresse";
+            default: return "";
+        }
+    }
+    
+    
+    
+    
+
+}
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.form b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.form
new file mode 100644
index 0000000..1e334a3
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.form	
@@ -0,0 +1,694 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<Form version="1.5" maxVersion="1.5" type="org.netbeans.modules.form.forminfo.JFrameFormInfo">
+  <NonVisualComponents>
+    <Menu class="javax.swing.JMenuBar" name="jMenuBar1">
+      <SubComponents>
+        <Menu class="javax.swing.JMenu" name="jMenu1">
+          <Properties>
+            <Property name="text" type="java.lang.String" value="Datei"/>
+          </Properties>
+          <SubComponents>
+            <MenuItem class="javax.swing.JMenuItem" name="jMenuItem1">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="Beenden"/>
+              </Properties>
+              <Events>
+                <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jMenuItem1ActionPerformed"/>
+              </Events>
+            </MenuItem>
+          </SubComponents>
+        </Menu>
+        <Menu class="javax.swing.JMenu" name="jMenu2">
+          <Properties>
+            <Property name="text" type="java.lang.String" value="Edit"/>
+          </Properties>
+        </Menu>
+      </SubComponents>
+    </Menu>
+  </NonVisualComponents>
+  <Properties>
+    <Property name="defaultCloseOperation" type="int" value="3"/>
+  </Properties>
+  <SyntheticProperties>
+    <SyntheticProperty name="menuBar" type="java.lang.String" value="jMenuBar1"/>
+    <SyntheticProperty name="formSizePolicy" type="int" value="1"/>
+  </SyntheticProperties>
+  <AuxValues>
+    <AuxValue name="FormSettings_autoResourcing" type="java.lang.Integer" value="0"/>
+    <AuxValue name="FormSettings_autoSetComponentName" type="java.lang.Boolean" value="false"/>
+    <AuxValue name="FormSettings_generateMnemonicsCode" type="java.lang.Boolean" value="false"/>
+    <AuxValue name="FormSettings_i18nAutoMode" type="java.lang.Boolean" value="false"/>
+    <AuxValue name="FormSettings_layoutCodeTarget" type="java.lang.Integer" value="1"/>
+    <AuxValue name="FormSettings_listenerGenerationStyle" type="java.lang.Integer" value="0"/>
+    <AuxValue name="FormSettings_variablesLocal" type="java.lang.Boolean" value="false"/>
+    <AuxValue name="FormSettings_variablesModifier" type="java.lang.Integer" value="2"/>
+  </AuxValues>
+
+  <Layout>
+    <DimensionLayout dim="0">
+      <Group type="103" groupAlignment="0" attributes="0">
+          <Group type="102" alignment="0" attributes="0">
+              <EmptySpace max="-2" attributes="0"/>
+              <Component id="jTabbedPane1" pref="651" max="32767" attributes="0"/>
+              <EmptySpace max="-2" attributes="0"/>
+          </Group>
+      </Group>
+    </DimensionLayout>
+    <DimensionLayout dim="1">
+      <Group type="103" groupAlignment="0" attributes="0">
+          <Group type="102" alignment="0" attributes="0">
+              <EmptySpace max="-2" attributes="0"/>
+              <Component id="jTabbedPane1" pref="331" max="32767" attributes="0"/>
+              <EmptySpace max="-2" attributes="0"/>
+          </Group>
+      </Group>
+    </DimensionLayout>
+  </Layout>
+  <SubComponents>
+    <Container class="javax.swing.JTabbedPane" name="jTabbedPane1">
+
+      <Layout class="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout"/>
+      <SubComponents>
+        <Container class="javax.swing.JPanel" name="jPanelAuftragsAbwicklung">
+          <Constraints>
+            <Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout" value="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout$JTabbedPaneConstraintsDescription">
+              <JTabbedPaneConstraints tabName="Auftragsbearbeitung">
+                <Property name="tabTitle" type="java.lang.String" value="Auftragsbearbeitung"/>
+              </JTabbedPaneConstraints>
+            </Constraint>
+          </Constraints>
+
+          <Layout>
+            <DimensionLayout dim="0">
+              <Group type="103" groupAlignment="0" attributes="0">
+                  <Group type="102" alignment="0" attributes="0">
+                      <Group type="103" groupAlignment="1" attributes="0">
+                          <Group type="102" alignment="0" attributes="0">
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Component id="jButtonArtikelAbschicken" pref="174" max="32767" attributes="1"/>
+                          </Group>
+                          <Group type="102" alignment="1" attributes="0">
+                              <EmptySpace min="-2" pref="38" max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Component id="jLabel2" alignment="0" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jLabel3" alignment="0" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jLabel4" alignment="0" min="-2" max="-2" attributes="0"/>
+                              </Group>
+                              <EmptySpace min="-2" max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Group type="102" alignment="1" attributes="0">
+                                      <EmptySpace min="-2" max="-2" attributes="0"/>
+                                      <Component id="jSpinnerAnzahl" pref="92" max="32767" attributes="2"/>
+                                  </Group>
+                                  <Component id="jSpinnerArtikelId" alignment="1" pref="92" max="32767" attributes="2"/>
+                                  <Component id="jSpinnerKundenId" alignment="0" pref="92" max="32767" attributes="0"/>
+                              </Group>
+                          </Group>
+                      </Group>
+                      <EmptySpace min="-2" pref="35" max="-2" attributes="0"/>
+                      <Group type="103" groupAlignment="0" attributes="0">
+                          <Group type="102" alignment="0" attributes="0">
+                              <EmptySpace min="10" pref="10" max="10" attributes="0"/>
+                              <Component id="jLabel1ReportOutput" min="-2" pref="151" max="-2" attributes="0"/>
+                          </Group>
+                          <Component id="jLabel14" alignment="0" min="-2" max="-2" attributes="0"/>
+                      </Group>
+                      <EmptySpace pref="266" max="32767" attributes="0"/>
+                  </Group>
+              </Group>
+            </DimensionLayout>
+            <DimensionLayout dim="1">
+              <Group type="103" groupAlignment="0" attributes="0">
+                  <Group type="102" alignment="0" attributes="0">
+                      <EmptySpace min="-2" pref="30" max="-2" attributes="0"/>
+                      <Component id="jLabel14" min="-2" max="-2" attributes="0"/>
+                      <Group type="103" groupAlignment="0" max="-2" attributes="0">
+                          <Group type="102" attributes="0">
+                              <EmptySpace min="-2" pref="26" max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="3" attributes="0">
+                                  <Component id="jLabel2" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jSpinnerKundenId" alignment="3" min="-2" max="-2" attributes="0"/>
+                              </Group>
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="3" attributes="0">
+                                  <Component id="jLabel3" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jSpinnerArtikelId" alignment="3" min="-2" max="-2" attributes="0"/>
+                              </Group>
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="3" attributes="0">
+                                  <Component id="jLabel4" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jSpinnerAnzahl" alignment="3" min="-2" max="-2" attributes="0"/>
+                              </Group>
+                              <EmptySpace min="-2" pref="48" max="-2" attributes="0"/>
+                              <Component id="jButtonArtikelAbschicken" min="-2" max="-2" attributes="0"/>
+                          </Group>
+                          <Group type="102" attributes="1">
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Component id="jLabel1ReportOutput" max="32767" attributes="0"/>
+                          </Group>
+                      </Group>
+                      <EmptySpace pref="90" max="32767" attributes="0"/>
+                  </Group>
+              </Group>
+            </DimensionLayout>
+          </Layout>
+          <SubComponents>
+            <Component class="javax.swing.JSpinner" name="jSpinnerArtikelId">
+              <Properties>
+                <Property name="model" type="javax.swing.SpinnerModel" editor="org.netbeans.modules.form.editors2.SpinnerModelEditor">
+                  <SpinnerModel initial="1" minimum="1" numberType="java.lang.Long" stepSize="1" type="number"/>
+                </Property>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JLabel" name="jLabel3">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="Artikel-Id"/>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JLabel" name="jLabel4">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="Anzahl"/>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JSpinner" name="jSpinnerAnzahl">
+              <Properties>
+                <Property name="model" type="javax.swing.SpinnerModel" editor="org.netbeans.modules.form.editors2.SpinnerModelEditor">
+                  <SpinnerModel initial="1" minimum="1" numberType="java.lang.Long" stepSize="1" type="number"/>
+                </Property>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JButton" name="jButtonArtikelAbschicken">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="Bestellung abschicken"/>
+              </Properties>
+              <Events>
+                <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonArtikelAbschickenActionPerformed"/>
+              </Events>
+            </Component>
+            <Component class="javax.swing.JLabel" name="jLabel2">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="Kunden-Id"/>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JSpinner" name="jSpinnerKundenId">
+              <Properties>
+                <Property name="model" type="javax.swing.SpinnerModel" editor="org.netbeans.modules.form.editors2.SpinnerModelEditor">
+                  <SpinnerModel initial="1" minimum="1" numberType="java.lang.Long" stepSize="1" type="number"/>
+                </Property>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JLabel" name="jLabel14">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="Report"/>
+              </Properties>
+            </Component>
+            <Component class="javax.swing.JLabel" name="jLabel1ReportOutput">
+              <Properties>
+                <Property name="text" type="java.lang.String" value="..."/>
+                <Property name="verticalAlignment" type="int" value="1"/>
+              </Properties>
+            </Component>
+          </SubComponents>
+        </Container>
+        <Container class="javax.swing.JPanel" name="jPanel1">
+          <Constraints>
+            <Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout" value="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout$JTabbedPaneConstraintsDescription">
+              <JTabbedPaneConstraints tabName="Verwaltung">
+                <Property name="tabTitle" type="java.lang.String" value="Verwaltung"/>
+              </JTabbedPaneConstraints>
+            </Constraint>
+          </Constraints>
+
+          <Layout>
+            <DimensionLayout dim="0">
+              <Group type="103" groupAlignment="0" attributes="0">
+                  <Group type="102" alignment="0" attributes="0">
+                      <EmptySpace max="-2" attributes="0"/>
+                      <Component id="jTabbedPaneVerwaltung" max="32767" attributes="0"/>
+                      <EmptySpace max="-2" attributes="0"/>
+                  </Group>
+              </Group>
+            </DimensionLayout>
+            <DimensionLayout dim="1">
+              <Group type="103" groupAlignment="0" attributes="0">
+                  <Group type="102" alignment="0" attributes="0">
+                      <EmptySpace max="-2" attributes="0"/>
+                      <Component id="jTabbedPaneVerwaltung" pref="281" max="32767" attributes="0"/>
+                      <EmptySpace max="-2" attributes="0"/>
+                  </Group>
+              </Group>
+            </DimensionLayout>
+          </Layout>
+          <SubComponents>
+            <Container class="javax.swing.JTabbedPane" name="jTabbedPaneVerwaltung">
+
+              <Layout class="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout"/>
+              <SubComponents>
+                <Container class="javax.swing.JPanel" name="jPanelArtikel">
+                  <Constraints>
+                    <Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout" value="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout$JTabbedPaneConstraintsDescription">
+                      <JTabbedPaneConstraints tabName="Artikel">
+                        <Property name="tabTitle" type="java.lang.String" value="Artikel"/>
+                      </JTabbedPaneConstraints>
+                    </Constraint>
+                  </Constraints>
+
+                  <Layout>
+                    <DimensionLayout dim="0">
+                      <Group type="103" groupAlignment="0" attributes="0">
+                          <Group type="102" alignment="0" attributes="0">
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Group type="102" attributes="0">
+                                      <Component id="jLabel1" min="-2" max="-2" attributes="0"/>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Component id="jButtonArtikellisteRefresh" min="-2" max="-2" attributes="0"/>
+                                      <EmptySpace pref="79" max="32767" attributes="0"/>
+                                      <Component id="jButtonCreateDemoArtikel" min="-2" max="-2" attributes="0"/>
+                                  </Group>
+                                  <Component id="jScrollPane2" alignment="0" min="-2" pref="330" max="-2" attributes="0"/>
+                              </Group>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Group type="102" attributes="0">
+                                      <EmptySpace min="-2" pref="35" max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="0" max="-2" attributes="0">
+                                          <Group type="102" alignment="0" attributes="0">
+                                              <Component id="jLabel5" min="-2" max="-2" attributes="0"/>
+                                              <EmptySpace min="-2" pref="74" max="-2" attributes="0"/>
+                                              <Component id="jLabelLagerId" min="-2" max="-2" attributes="0"/>
+                                          </Group>
+                                          <Group type="102" alignment="0" attributes="0">
+                                              <Group type="103" groupAlignment="0" attributes="0">
+                                                  <Component id="jLabel7" alignment="0" min="-2" max="-2" attributes="0"/>
+                                                  <Component id="jLabel8" alignment="0" min="-2" max="-2" attributes="0"/>
+                                                  <Component id="jLabel9" alignment="0" min="-2" max="-2" attributes="0"/>
+                                              </Group>
+                                              <EmptySpace max="-2" attributes="0"/>
+                                              <Group type="103" groupAlignment="0" attributes="0">
+                                                  <Component id="jSpinnerLagerPreis" pref="80" max="32767" attributes="0"/>
+                                                  <Component id="jSpinnerLagerAnzahl" pref="80" max="32767" attributes="0"/>
+                                                  <Component id="jTextFieldLagerBezeichnung" alignment="0" min="-2" pref="99" max="-2" attributes="0"/>
+                                              </Group>
+                                          </Group>
+                                      </Group>
+                                  </Group>
+                                  <Group type="102" alignment="0" attributes="0">
+                                      <EmptySpace min="-2" pref="12" max="-2" attributes="0"/>
+                                      <Component id="jButtonLagerNeu" min="-2" max="-2" attributes="0"/>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Component id="jButtonLagerAendern" min="-2" max="-2" attributes="0"/>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Component id="jButtonLagerLoeschen" min="-2" max="-2" attributes="0"/>
+                                  </Group>
+                              </Group>
+                              <EmptySpace min="-2" pref="70" max="-2" attributes="0"/>
+                          </Group>
+                      </Group>
+                    </DimensionLayout>
+                    <DimensionLayout dim="1">
+                      <Group type="103" groupAlignment="0" attributes="0">
+                          <Group type="102" alignment="0" attributes="0">
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="3" attributes="0">
+                                  <Component id="jLabel1" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jButtonArtikellisteRefresh" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jButtonCreateDemoArtikel" alignment="3" min="-2" max="-2" attributes="0"/>
+                              </Group>
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Group type="102" attributes="0">
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel5" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jLabelLagerId" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel7" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jTextFieldLagerBezeichnung" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel8" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jSpinnerLagerAnzahl" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel9" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jSpinnerLagerPreis" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace min="-2" pref="34" max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jButtonLagerNeu" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jButtonLagerAendern" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jButtonLagerLoeschen" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                  </Group>
+                                  <Component id="jScrollPane2" pref="202" max="32767" attributes="0"/>
+                              </Group>
+                              <EmptySpace max="-2" attributes="0"/>
+                          </Group>
+                      </Group>
+                    </DimensionLayout>
+                  </Layout>
+                  <SubComponents>
+                    <Component class="javax.swing.JLabel" name="jLabel1">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Artikelliste"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonArtikellisteRefresh">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="refresh"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonArtikellisteRefreshActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Container class="javax.swing.JScrollPane" name="jScrollPane2">
+                      <AuxValues>
+                        <AuxValue name="autoScrollPane" type="java.lang.Boolean" value="true"/>
+                      </AuxValues>
+
+                      <Layout class="org.netbeans.modules.form.compat2.layouts.support.JScrollPaneSupportLayout"/>
+                      <SubComponents>
+                        <Component class="javax.swing.JTable" name="jTable1">
+                          <Properties>
+                            <Property name="model" type="javax.swing.table.TableModel" editor="org.netbeans.modules.form.editors2.TableModelEditor">
+                              <Table columnCount="4" rowCount="4">
+                                <Column editable="true" title="Title 1" type="java.lang.Object"/>
+                                <Column editable="true" title="Title 2" type="java.lang.Object"/>
+                                <Column editable="true" title="Title 3" type="java.lang.Object"/>
+                                <Column editable="true" title="Title 4" type="java.lang.Object"/>
+                              </Table>
+                            </Property>
+                          </Properties>
+                        </Component>
+                      </SubComponents>
+                    </Container>
+                    <Component class="javax.swing.JLabel" name="jLabel5">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="id"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabelLagerId">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="unbekannte id"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabel7">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Bezeichnung"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabel8">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Anzahl"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabel9">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Preis"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JTextField" name="jTextFieldLagerBezeichnung">
+                    </Component>
+                    <Component class="javax.swing.JSpinner" name="jSpinnerLagerAnzahl">
+                      <Properties>
+                        <Property name="model" type="javax.swing.SpinnerModel" editor="org.netbeans.modules.form.editors2.SpinnerModelEditor">
+                          <SpinnerModel initial="10" minimum="0" numberType="java.lang.Long" stepSize="1" type="number"/>
+                        </Property>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JSpinner" name="jSpinnerLagerPreis">
+                      <Properties>
+                        <Property name="model" type="javax.swing.SpinnerModel" editor="org.netbeans.modules.form.editors2.SpinnerModelEditor">
+                          <SpinnerModel initial="9.949999809265137" minimum="0.0" numberType="java.lang.Double" stepSize="1.0" type="number"/>
+                        </Property>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonLagerNeu">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="neu"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonLagerNeuActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonLagerAendern">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="&#xe4;ndern"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonLagerAendernActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonLagerLoeschen">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="l&#xf6;schen"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonLagerLoeschenActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonCreateDemoArtikel">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Demodaten erstellen"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonCreateDemoArtikelActionPerformed"/>
+                      </Events>
+                    </Component>
+                  </SubComponents>
+                </Container>
+                <Container class="javax.swing.JPanel" name="jPanelKunde">
+                  <Constraints>
+                    <Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout" value="org.netbeans.modules.form.compat2.layouts.support.JTabbedPaneSupportLayout$JTabbedPaneConstraintsDescription">
+                      <JTabbedPaneConstraints tabName="Kunden">
+                        <Property name="tabTitle" type="java.lang.String" value="Kunden"/>
+                      </JTabbedPaneConstraints>
+                    </Constraint>
+                  </Constraints>
+
+                  <Layout>
+                    <DimensionLayout dim="0">
+                      <Group type="103" groupAlignment="0" attributes="0">
+                          <Group type="102" alignment="0" attributes="0">
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Group type="102" alignment="0" attributes="0">
+                                      <Component id="jScrollPane3" min="-2" pref="330" max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="0" attributes="0">
+                                          <Group type="102" alignment="0" attributes="0">
+                                              <EmptySpace min="-2" pref="35" max="-2" attributes="0"/>
+                                              <Group type="103" groupAlignment="0" attributes="0">
+                                                  <Group type="102" alignment="0" attributes="0">
+                                                      <Component id="jLabel10" min="-2" max="-2" attributes="0"/>
+                                                      <EmptySpace min="-2" pref="74" max="-2" attributes="0"/>
+                                                      <Component id="jLabelKundeId" pref="94" max="32767" attributes="0"/>
+                                                  </Group>
+                                                  <Group type="102" alignment="0" attributes="0">
+                                                      <Group type="103" groupAlignment="0" attributes="0">
+                                                          <Component id="jLabel11" alignment="0" min="-2" max="-2" attributes="0"/>
+                                                          <Component id="jLabel12" alignment="0" min="-2" max="-2" attributes="0"/>
+                                                          <Component id="jLabel13" alignment="0" min="-2" max="-2" attributes="0"/>
+                                                      </Group>
+                                                      <EmptySpace max="-2" attributes="0"/>
+                                                      <Group type="103" groupAlignment="0" attributes="0">
+                                                          <Component id="jScrollPane4" pref="122" max="32767" attributes="1"/>
+                                                          <Component id="jTextFieldKundeVorname" alignment="0" pref="122" max="32767" attributes="1"/>
+                                                          <Component id="jTextFieldKundeNachname" alignment="0" pref="122" max="32767" attributes="1"/>
+                                                      </Group>
+                                                  </Group>
+                                              </Group>
+                                          </Group>
+                                          <Group type="102" alignment="0" attributes="0">
+                                              <EmptySpace type="unrelated" max="-2" attributes="0"/>
+                                              <Component id="jButtonKundeNeu" min="-2" max="-2" attributes="0"/>
+                                              <EmptySpace max="-2" attributes="0"/>
+                                              <Component id="jButtonKundeAendern" min="-2" max="-2" attributes="0"/>
+                                              <EmptySpace max="-2" attributes="0"/>
+                                              <Component id="jButtonKundeLoeschen" min="-2" max="-2" attributes="0"/>
+                                          </Group>
+                                      </Group>
+                                      <EmptySpace min="-2" pref="44" max="-2" attributes="0"/>
+                                  </Group>
+                                  <Group type="102" alignment="0" attributes="0">
+                                      <Component id="jLabel6" min="-2" max="-2" attributes="0"/>
+                                      <EmptySpace type="unrelated" max="-2" attributes="0"/>
+                                      <Component id="jButtonKundenlisteRefresh" min="-2" max="-2" attributes="0"/>
+                                      <EmptySpace min="-2" pref="88" max="-2" attributes="0"/>
+                                      <Component id="jButtonCreateDemoKunden" min="-2" max="-2" attributes="0"/>
+                                  </Group>
+                              </Group>
+                              <EmptySpace min="-2" pref="26" max="-2" attributes="0"/>
+                          </Group>
+                      </Group>
+                    </DimensionLayout>
+                    <DimensionLayout dim="1">
+                      <Group type="103" groupAlignment="0" attributes="0">
+                          <Group type="102" alignment="0" attributes="0">
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="3" attributes="0">
+                                  <Component id="jLabel6" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jButtonKundenlisteRefresh" alignment="3" min="-2" max="-2" attributes="0"/>
+                                  <Component id="jButtonCreateDemoKunden" alignment="3" min="-2" max="-2" attributes="0"/>
+                              </Group>
+                              <EmptySpace max="-2" attributes="0"/>
+                              <Group type="103" groupAlignment="0" attributes="0">
+                                  <Component id="jScrollPane3" alignment="0" pref="367" max="32767" attributes="0"/>
+                                  <Group type="102" alignment="0" attributes="0">
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel10" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jLabelKundeId" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel11" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jTextFieldKundeNachname" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jLabel12" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jTextFieldKundeVorname" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="0" attributes="0">
+                                          <Component id="jLabel13" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jScrollPane4" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace min="-2" pref="24" max="-2" attributes="0"/>
+                                      <Group type="103" groupAlignment="3" attributes="0">
+                                          <Component id="jButtonKundeNeu" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jButtonKundeAendern" alignment="3" min="-2" max="-2" attributes="0"/>
+                                          <Component id="jButtonKundeLoeschen" alignment="3" min="-2" max="-2" attributes="0"/>
+                                      </Group>
+                                      <EmptySpace min="-2" pref="172" max="-2" attributes="0"/>
+                                  </Group>
+                              </Group>
+                              <EmptySpace max="-2" attributes="0"/>
+                          </Group>
+                      </Group>
+                    </DimensionLayout>
+                  </Layout>
+                  <SubComponents>
+                    <Component class="javax.swing.JLabel" name="jLabel6">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Kundenliste"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonKundenlisteRefresh">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="refresh"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonKundenlisteRefreshActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Container class="javax.swing.JScrollPane" name="jScrollPane3">
+                      <AuxValues>
+                        <AuxValue name="autoScrollPane" type="java.lang.Boolean" value="true"/>
+                      </AuxValues>
+
+                      <Layout class="org.netbeans.modules.form.compat2.layouts.support.JScrollPaneSupportLayout"/>
+                      <SubComponents>
+                        <Component class="javax.swing.JTable" name="jTableKunden">
+                          <Properties>
+                            <Property name="model" type="javax.swing.table.TableModel" editor="org.netbeans.modules.form.editors2.TableModelEditor">
+                              <Table columnCount="4" rowCount="4">
+                                <Column editable="true" title="Title 1" type="java.lang.Object"/>
+                                <Column editable="true" title="Title 2" type="java.lang.Object"/>
+                                <Column editable="true" title="Title 3" type="java.lang.Object"/>
+                                <Column editable="true" title="Title 4" type="java.lang.Object"/>
+                              </Table>
+                            </Property>
+                          </Properties>
+                        </Component>
+                      </SubComponents>
+                    </Container>
+                    <Component class="javax.swing.JLabel" name="jLabel10">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="id"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabelKundeId">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="unbekannte id"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabel11">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Nachname"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabel12">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Vorname"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JLabel" name="jLabel13">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Adresse"/>
+                      </Properties>
+                    </Component>
+                    <Component class="javax.swing.JTextField" name="jTextFieldKundeNachname">
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonKundeNeu">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="neu"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonKundeNeuActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonKundeAendern">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="&#xe4;ndern"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonKundeAendernActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Component class="javax.swing.JButton" name="jButtonKundeLoeschen">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="l&#xf6;schen"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonKundeLoeschenActionPerformed"/>
+                      </Events>
+                    </Component>
+                    <Component class="javax.swing.JTextField" name="jTextFieldKundeVorname">
+                    </Component>
+                    <Container class="javax.swing.JScrollPane" name="jScrollPane4">
+                      <AuxValues>
+                        <AuxValue name="autoScrollPane" type="java.lang.Boolean" value="true"/>
+                      </AuxValues>
+
+                      <Layout class="org.netbeans.modules.form.compat2.layouts.support.JScrollPaneSupportLayout"/>
+                      <SubComponents>
+                        <Component class="javax.swing.JTextArea" name="jTextAreaKundeAdresse">
+                          <Properties>
+                            <Property name="columns" type="int" value="20"/>
+                            <Property name="rows" type="int" value="5"/>
+                          </Properties>
+                        </Component>
+                      </SubComponents>
+                    </Container>
+                    <Component class="javax.swing.JButton" name="jButtonCreateDemoKunden">
+                      <Properties>
+                        <Property name="text" type="java.lang.String" value="Demodaten erstellen"/>
+                      </Properties>
+                      <Events>
+                        <EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButtonCreateDemoKundenActionPerformed"/>
+                      </Events>
+                    </Component>
+                  </SubComponents>
+                </Container>
+              </SubComponents>
+            </Container>
+          </SubComponents>
+        </Container>
+      </SubComponents>
+    </Container>
+  </SubComponents>
+</Form>
diff --git a/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.java b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.java
new file mode 100644
index 0000000..8619c00
--- /dev/null
+++ b/Master/Daten- und Systemintegration/Praktikum/DSI-Praktikum-1_ausgang/DSI1-ausgang/DSI-app-client/src/java/dsi/Main.java	
@@ -0,0 +1,807 @@
+/*
+ * Main.java
+ *
+ * Created on 6. März 2008, 12:35
+ */
+package dsi;
+
+import beans.artikelManager.ArtikelManagerRemote;
+import beans.auftragsAbwicklung.AuftragsAbwicklungRemote;
+import beans.kundenManager.KundenManagerRemote;
+import beans.lager.LagerRemote;
+import entities.Artikel;
+import entities.Kunde;
+import exceptions.IdBereitsVergebenException;
+import helper.Auftrag;
+import java.util.logging.Level;
+import java.util.logging.Logger;
+import javax.ejb.EJB;
+import javax.swing.JOptionPane;
+import javax.swing.ListSelectionModel;
+import javax.swing.event.ListSelectionEvent;
+import javax.swing.event.ListSelectionListener;
+
+
+/**
+ *
+ * @author  jmueller
+ */
+public class Main extends javax.swing.JFrame {
+    @EJB
+    private static KundenManagerRemote kundenManagerBean;
+    @EJB
+    private static ArtikelManagerRemote artikelManagerBean;
+
+    @EJB
+    private static LagerRemote lagerBean;
+    @EJB
+    private static AuftragsAbwicklungRemote auftragsAbwicklungBean;
+    private Kunde kundeEntity;
+
+    /** Creates new form Main */
+    public Main() {
+        initComponents();
+        initModels();
+    }
+
+    /**
+     * initialisiert die Models für die Swing-Komponenten
+     */
+    private void initModels() {
+        Auftrag auftrag = new Auftrag();
+
+        ArtikelListeTableModel listeTableModel = new ArtikelListeTableModel();
+        jTable1.setModel(listeTableModel);
+        jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
+
+        jTable1.getSelectionModel().addListSelectionListener(new ListSelectionListener() {
+
+            public void valueChanged(ListSelectionEvent e) {
+                ListSelectionModel lsm = (ListSelectionModel) e.getSource();
+                if (lsm.isSelectionEmpty()) {
+                } else {
+                    int selectedRow = lsm.getMinSelectionIndex();
+                    Artikel a = ((ArtikelListeTableModel) jTable1.getModel()).getArtikelListe().get(selectedRow);
+
+                    jLabelLagerId.setText("" + a.getId());
+                    jTextFieldLagerBezeichnung.setText(a.getBezeichnung());
+                    jSpinnerLagerAnzahl.setValue((Long) a.getAnzahl());
+                    jSpinnerLagerPreis.setValue((Double) a.getPreis());
+                }
+            }
+        });
+
+        KundenListeTableModel kundenTableModel = new KundenListeTableModel();
+        jTableKunden.setModel(kundenTableModel);
+        jTableKunden.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
+
+        jTableKunden.getSelectionModel().addListSelectionListener(new ListSelectionListener() {
+
+            public void valueChanged(ListSelectionEvent e) {
+                ListSelectionModel lsm = (ListSelectionModel) e.getSource();
+                if (lsm.isSelectionEmpty()) {
+                } else {
+                    int selectedRow = lsm.getMinSelectionIndex();
+                    Kunde kunde = ((KundenListeTableModel) jTableKunden.getModel()).getKundenListe().get(selectedRow);
+
+                    jLabelKundeId.setText("" + kunde.getId());
+                    jTextFieldKundeNachname.setText(kunde.getNachname());
+                    jTextFieldKundeVorname.setText(kunde.getVorname());
+                    jTextAreaKundeAdresse.setText(kunde.getAdresse());
+                }
+            }
+        });
+    }
+
+    /** This method is called from within the constructor to
+     * initialize the form.
+
+    
+    }
+
+    /** This method is called from within the constructor to
+     * initialize the form.
+     * WARNING: Do NOT modify this code. The content of this method is
+     * always regenerated by the Form Editor.
+     */
+    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
+    private void initComponents() {
+
+        jTabbedPane1 = new javax.swing.JTabbedPane();
+        jPanelAuftragsAbwicklung = new javax.swing.JPanel();
+        jSpinnerArtikelId = new javax.swing.JSpinner();
+        jLabel3 = new javax.swing.JLabel();
+        jLabel4 = new javax.swing.JLabel();
+        jSpinnerAnzahl = new javax.swing.JSpinner();
+        jButtonArtikelAbschicken = new javax.swing.JButton();
+        jLabel2 = new javax.swing.JLabel();
+        jSpinnerKundenId = new javax.swing.JSpinner();
+        jLabel14 = new javax.swing.JLabel();
+        jLabel1ReportOutput = new javax.swing.JLabel();
+        jPanel1 = new javax.swing.JPanel();
+        jTabbedPaneVerwaltung = new javax.swing.JTabbedPane();
+        jPanelArtikel = new javax.swing.JPanel();
+        jLabel1 = new javax.swing.JLabel();
+        jButtonArtikellisteRefresh = new javax.swing.JButton();
+        jScrollPane2 = new javax.swing.JScrollPane();
+        jTable1 = new javax.swing.JTable();
+        jLabel5 = new javax.swing.JLabel();
+        jLabelLagerId = new javax.swing.JLabel();
+        jLabel7 = new javax.swing.JLabel();
+        jLabel8 = new javax.swing.JLabel();
+        jLabel9 = new javax.swing.JLabel();
+        jTextFieldLagerBezeichnung = new javax.swing.JTextField();
+        jSpinnerLagerAnzahl = new javax.swing.JSpinner();
+        jSpinnerLagerPreis = new javax.swing.JSpinner();
+        jButtonLagerNeu = new javax.swing.JButton();
+        jButtonLagerAendern = new javax.swing.JButton();
+        jButtonLagerLoeschen = new javax.swing.JButton();
+        jButtonCreateDemoArtikel = new javax.swing.JButton();
+        jPanelKunde = new javax.swing.JPanel();
+        jLabel6 = new javax.swing.JLabel();
+        jButtonKundenlisteRefresh = new javax.swing.JButton();
+        jScrollPane3 = new javax.swing.JScrollPane();
+        jTableKunden = new javax.swing.JTable();
+        jLabel10 = new javax.swing.JLabel();
+        jLabelKundeId = new javax.swing.JLabel();
+        jLabel11 = new javax.swing.JLabel();
+        jLabel12 = new javax.swing.JLabel();
+        jLabel13 = new javax.swing.JLabel();
+        jTextFieldKundeNachname = new javax.swing.JTextField();
+        jButtonKundeNeu = new javax.swing.JButton();
+        jButtonKundeAendern = new javax.swing.JButton();
+        jButtonKundeLoeschen = new javax.swing.JButton();
+        jTextFieldKundeVorname = new javax.swing.JTextField();
+        jScrollPane4 = new javax.swing.JScrollPane();
+        jTextAreaKundeAdresse = new javax.swing.JTextArea();
+        jButtonCreateDemoKunden = new javax.swing.JButton();
+        jMenuBar1 = new javax.swing.JMenuBar();
+        jMenu1 = new javax.swing.JMenu();
+        jMenuItem1 = new javax.swing.JMenuItem();
+        jMenu2 = new javax.swing.JMenu();
+
+        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
+
+        jSpinnerArtikelId.setModel(new javax.swing.SpinnerNumberModel(Long.valueOf(1L), Long.valueOf(1L), null, Long.valueOf(1L)));
+
+        jLabel3.setText("Artikel-Id");
+
+        jLabel4.setText("Anzahl");
+
+        jSpinnerAnzahl.setModel(new javax.swing.SpinnerNumberModel(Long.valueOf(1L), Long.valueOf(1L), null, Long.valueOf(1L)));
+
+        jButtonArtikelAbschicken.setText("Bestellung abschicken");
+        jButtonArtikelAbschicken.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonArtikelAbschickenActionPerformed(evt);
+            }
+        });
+
+        jLabel2.setText("Kunden-Id");
+
+        jSpinnerKundenId.setModel(new javax.swing.SpinnerNumberModel(Long.valueOf(1L), Long.valueOf(1L), null, Long.valueOf(1L)));
+
+        jLabel14.setText("Report");
+
+        jLabel1ReportOutput.setText("...");
+        jLabel1ReportOutput.setVerticalAlignment(javax.swing.SwingConstants.TOP);
+
+        javax.swing.GroupLayout jPanelAuftragsAbwicklungLayout = new javax.swing.GroupLayout(jPanelAuftragsAbwicklung);
+        jPanelAuftragsAbwicklung.setLayout(jPanelAuftragsAbwicklungLayout);
+        jPanelAuftragsAbwicklungLayout.setHorizontalGroup(
+            jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
+                    .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                        .addContainerGap()
+                        .addComponent(jButtonArtikelAbschicken, javax.swing.GroupLayout.DEFAULT_SIZE, 174, Short.MAX_VALUE))
+                    .addGroup(jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                        .addGap(38, 38, 38)
+                        .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                            .addComponent(jLabel2)
+                            .addComponent(jLabel3)
+                            .addComponent(jLabel4))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                                .addComponent(jSpinnerAnzahl, javax.swing.GroupLayout.DEFAULT_SIZE, 92, Short.MAX_VALUE))
+                            .addComponent(jSpinnerArtikelId, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 92, Short.MAX_VALUE)
+                            .addComponent(jSpinnerKundenId, javax.swing.GroupLayout.DEFAULT_SIZE, 92, Short.MAX_VALUE))))
+                .addGap(35, 35, 35)
+                .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                    .addGroup(jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                        .addGap(10, 10, 10)
+                        .addComponent(jLabel1ReportOutput, javax.swing.GroupLayout.PREFERRED_SIZE, 151, javax.swing.GroupLayout.PREFERRED_SIZE))
+                    .addComponent(jLabel14))
+                .addContainerGap(266, Short.MAX_VALUE))
+        );
+        jPanelAuftragsAbwicklungLayout.setVerticalGroup(
+            jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                .addGap(30, 30, 30)
+                .addComponent(jLabel14)
+                .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
+                    .addGroup(jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                        .addGap(26, 26, 26)
+                        .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel2)
+                            .addComponent(jSpinnerKundenId, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel3)
+                            .addComponent(jSpinnerArtikelId, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelAuftragsAbwicklungLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel4)
+                            .addComponent(jSpinnerAnzahl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addGap(48, 48, 48)
+                        .addComponent(jButtonArtikelAbschicken))
+                    .addGroup(jPanelAuftragsAbwicklungLayout.createSequentialGroup()
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addComponent(jLabel1ReportOutput, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
+                .addContainerGap(90, Short.MAX_VALUE))
+        );
+
+        jTabbedPane1.addTab("Auftragsbearbeitung", jPanelAuftragsAbwicklung);
+
+        jLabel1.setText("Artikelliste");
+
+        jButtonArtikellisteRefresh.setText("refresh");
+        jButtonArtikellisteRefresh.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonArtikellisteRefreshActionPerformed(evt);
+            }
+        });
+
+        jTable1.setModel(new javax.swing.table.DefaultTableModel(
+            new Object [][] {
+                {null, null, null, null},
+                {null, null, null, null},
+                {null, null, null, null},
+                {null, null, null, null}
+            },
+            new String [] {
+                "Title 1", "Title 2", "Title 3", "Title 4"
+            }
+        ));
+        jScrollPane2.setViewportView(jTable1);
+
+        jLabel5.setText("id");
+
+        jLabelLagerId.setText("unbekannte id");
+
+        jLabel7.setText("Bezeichnung");
+
+        jLabel8.setText("Anzahl");
+
+        jLabel9.setText("Preis");
+
+        jSpinnerLagerAnzahl.setModel(new javax.swing.SpinnerNumberModel(Long.valueOf(10L), Long.valueOf(0L), null, Long.valueOf(1L)));
+
+        jSpinnerLagerPreis.setModel(new javax.swing.SpinnerNumberModel(Double.valueOf(9.949999809265137d), Double.valueOf(0.0d), null, Double.valueOf(1.0d)));
+
+        jButtonLagerNeu.setText("neu");
+        jButtonLagerNeu.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonLagerNeuActionPerformed(evt);
+            }
+        });
+
+        jButtonLagerAendern.setText("ändern");
+        jButtonLagerAendern.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonLagerAendernActionPerformed(evt);
+            }
+        });
+
+        jButtonLagerLoeschen.setText("löschen");
+        jButtonLagerLoeschen.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonLagerLoeschenActionPerformed(evt);
+            }
+        });
+
+        jButtonCreateDemoArtikel.setText("Demodaten erstellen");
+        jButtonCreateDemoArtikel.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonCreateDemoArtikelActionPerformed(evt);
+            }
+        });
+
+        javax.swing.GroupLayout jPanelArtikelLayout = new javax.swing.GroupLayout(jPanelArtikel);
+        jPanelArtikel.setLayout(jPanelArtikelLayout);
+        jPanelArtikelLayout.setHorizontalGroup(
+            jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                .addContainerGap()
+                .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                    .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                        .addComponent(jLabel1)
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addComponent(jButtonArtikellisteRefresh)
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 79, Short.MAX_VALUE)
+                        .addComponent(jButtonCreateDemoArtikel))
+                    .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 330, javax.swing.GroupLayout.PREFERRED_SIZE))
+                .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                    .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                        .addGap(35, 35, 35)
+                        .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
+                            .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                                .addComponent(jLabel5)
+                                .addGap(74, 74, 74)
+                                .addComponent(jLabelLagerId))
+                            .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                                .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                                    .addComponent(jLabel7)
+                                    .addComponent(jLabel8)
+                                    .addComponent(jLabel9))
+                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                                .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                                    .addComponent(jSpinnerLagerPreis, javax.swing.GroupLayout.DEFAULT_SIZE, 80, Short.MAX_VALUE)
+                                    .addComponent(jSpinnerLagerAnzahl, javax.swing.GroupLayout.DEFAULT_SIZE, 80, Short.MAX_VALUE)
+                                    .addComponent(jTextFieldLagerBezeichnung, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)))))
+                    .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                        .addGap(12, 12, 12)
+                        .addComponent(jButtonLagerNeu)
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addComponent(jButtonLagerAendern)
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addComponent(jButtonLagerLoeschen)))
+                .addGap(70, 70, 70))
+        );
+        jPanelArtikelLayout.setVerticalGroup(
+            jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                .addContainerGap()
+                .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                    .addComponent(jLabel1)
+                    .addComponent(jButtonArtikellisteRefresh)
+                    .addComponent(jButtonCreateDemoArtikel))
+                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                    .addGroup(jPanelArtikelLayout.createSequentialGroup()
+                        .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel5)
+                            .addComponent(jLabelLagerId))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel7)
+                            .addComponent(jTextFieldLagerBezeichnung, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel8)
+                            .addComponent(jSpinnerLagerAnzahl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel9)
+                            .addComponent(jSpinnerLagerPreis, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addGap(34, 34, 34)
+                        .addGroup(jPanelArtikelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jButtonLagerNeu)
+                            .addComponent(jButtonLagerAendern)
+                            .addComponent(jButtonLagerLoeschen)))
+                    .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 202, Short.MAX_VALUE))
+                .addContainerGap())
+        );
+
+        jTabbedPaneVerwaltung.addTab("Artikel", jPanelArtikel);
+
+        jLabel6.setText("Kundenliste");
+
+        jButtonKundenlisteRefresh.setText("refresh");
+        jButtonKundenlisteRefresh.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonKundenlisteRefreshActionPerformed(evt);
+            }
+        });
+
+        jTableKunden.setModel(new javax.swing.table.DefaultTableModel(
+            new Object [][] {
+                {null, null, null, null},
+                {null, null, null, null},
+                {null, null, null, null},
+                {null, null, null, null}
+            },
+            new String [] {
+                "Title 1", "Title 2", "Title 3", "Title 4"
+            }
+        ));
+        jScrollPane3.setViewportView(jTableKunden);
+
+        jLabel10.setText("id");
+
+        jLabelKundeId.setText("unbekannte id");
+
+        jLabel11.setText("Nachname");
+
+        jLabel12.setText("Vorname");
+
+        jLabel13.setText("Adresse");
+
+        jButtonKundeNeu.setText("neu");
+        jButtonKundeNeu.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonKundeNeuActionPerformed(evt);
+            }
+        });
+
+        jButtonKundeAendern.setText("ändern");
+        jButtonKundeAendern.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonKundeAendernActionPerformed(evt);
+            }
+        });
+
+        jButtonKundeLoeschen.setText("löschen");
+        jButtonKundeLoeschen.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonKundeLoeschenActionPerformed(evt);
+            }
+        });
+
+        jTextAreaKundeAdresse.setColumns(20);
+        jTextAreaKundeAdresse.setRows(5);
+        jScrollPane4.setViewportView(jTextAreaKundeAdresse);
+
+        jButtonCreateDemoKunden.setText("Demodaten erstellen");
+        jButtonCreateDemoKunden.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jButtonCreateDemoKundenActionPerformed(evt);
+            }
+        });
+
+        javax.swing.GroupLayout jPanelKundeLayout = new javax.swing.GroupLayout(jPanelKunde);
+        jPanelKunde.setLayout(jPanelKundeLayout);
+        jPanelKundeLayout.setHorizontalGroup(
+            jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanelKundeLayout.createSequentialGroup()
+                .addContainerGap()
+                .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                    .addGroup(jPanelKundeLayout.createSequentialGroup()
+                        .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 330, javax.swing.GroupLayout.PREFERRED_SIZE)
+                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                            .addGroup(jPanelKundeLayout.createSequentialGroup()
+                                .addGap(35, 35, 35)
+                                .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                                    .addGroup(jPanelKundeLayout.createSequentialGroup()
+                                        .addComponent(jLabel10)
+                                        .addGap(74, 74, 74)
+                                        .addComponent(jLabelKundeId, javax.swing.GroupLayout.DEFAULT_SIZE, 94, Short.MAX_VALUE))
+                                    .addGroup(jPanelKundeLayout.createSequentialGroup()
+                                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                                            .addComponent(jLabel11)
+                                            .addComponent(jLabel12)
+                                            .addComponent(jLabel13))
+                                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                                            .addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 122, Short.MAX_VALUE)
+                                            .addComponent(jTextFieldKundeVorname, javax.swing.GroupLayout.DEFAULT_SIZE, 122, Short.MAX_VALUE)
+                                            .addComponent(jTextFieldKundeNachname, javax.swing.GroupLayout.DEFAULT_SIZE, 122, Short.MAX_VALUE)))))
+                            .addGroup(jPanelKundeLayout.createSequentialGroup()
+                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
+                                .addComponent(jButtonKundeNeu)
+                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                                .addComponent(jButtonKundeAendern)
+                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                                .addComponent(jButtonKundeLoeschen)))
+                        .addGap(44, 44, 44))
+                    .addGroup(jPanelKundeLayout.createSequentialGroup()
+                        .addComponent(jLabel6)
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
+                        .addComponent(jButtonKundenlisteRefresh)
+                        .addGap(88, 88, 88)
+                        .addComponent(jButtonCreateDemoKunden)))
+                .addGap(26, 26, 26))
+        );
+        jPanelKundeLayout.setVerticalGroup(
+            jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanelKundeLayout.createSequentialGroup()
+                .addContainerGap()
+                .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                    .addComponent(jLabel6)
+                    .addComponent(jButtonKundenlisteRefresh)
+                    .addComponent(jButtonCreateDemoKunden))
+                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                    .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 367, Short.MAX_VALUE)
+                    .addGroup(jPanelKundeLayout.createSequentialGroup()
+                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel10)
+                            .addComponent(jLabelKundeId))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel11)
+                            .addComponent(jTextFieldKundeNachname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jLabel12)
+                            .addComponent(jTextFieldKundeVorname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
+                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+                            .addComponent(jLabel13)
+                            .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
+                        .addGap(24, 24, 24)
+                        .addGroup(jPanelKundeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
+                            .addComponent(jButtonKundeNeu)
+                            .addComponent(jButtonKundeAendern)
+                            .addComponent(jButtonKundeLoeschen))
+                        .addGap(172, 172, 172)))
+                .addContainerGap())
+        );
+
+        jTabbedPaneVerwaltung.addTab("Kunden", jPanelKunde);
+
+        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
+        jPanel1.setLayout(jPanel1Layout);
+        jPanel1Layout.setHorizontalGroup(
+            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanel1Layout.createSequentialGroup()
+                .addContainerGap()
+                .addComponent(jTabbedPaneVerwaltung)
+                .addContainerGap())
+        );
+        jPanel1Layout.setVerticalGroup(
+            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(jPanel1Layout.createSequentialGroup()
+                .addContainerGap()
+                .addComponent(jTabbedPaneVerwaltung, javax.swing.GroupLayout.DEFAULT_SIZE, 281, Short.MAX_VALUE)
+                .addContainerGap())
+        );
+
+        jTabbedPane1.addTab("Verwaltung", jPanel1);
+
+        jMenu1.setText("Datei");
+
+        jMenuItem1.setText("Beenden");
+        jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
+            public void actionPerformed(java.awt.event.ActionEvent evt) {
+                jMenuItem1ActionPerformed(evt);
+            }
+        });
+        jMenu1.add(jMenuItem1);
+
+        jMenuBar1.add(jMenu1);
+
+        jMenu2.setText("Edit");
+        jMenuBar1.add(jMenu2);
+
+        setJMenuBar(jMenuBar1);
+
+        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
+        getContentPane().setLayout(layout);
+        layout.setHorizontalGroup(
+            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(layout.createSequentialGroup()
+                .addContainerGap()
+                .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 651, Short.MAX_VALUE)
+                .addContainerGap())
+        );
+        layout.setVerticalGroup(
+            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
+            .addGroup(layout.createSequentialGroup()
+                .addContainerGap()
+                .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 331, Short.MAX_VALUE)
+                .addContainerGap())
+        );
+
+        pack();
+    }// </editor-fold>//GEN-END:initComponents
+
+    /**
+     * Bestellt die ausgewählte Anzahl des gewählten Artikels
+     * @param evt
+     */
+    private void jButtonArtikelAbschickenActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonArtikelAbschickenActionPerformed
+        
+        try {
+            String report = auftragsAbwicklungBean.bestelleArtikel((Long) jSpinnerKundenId.getValue(), (Long) jSpinnerArtikelId.getValue() , (Long) jSpinnerAnzahl.getValue() );
+            jLabel1ReportOutput.setText(report);
+            JOptionPane.showMessageDialog(rootPane, "Auftrag erfolgreich durchgeführt.");            
+        } catch (Exception e) {
+            JOptionPane.showMessageDialog(rootPane, "Fehler beim Ausführen des Auftrags. \n" + e.getMessage(),"Fehler", JOptionPane.ERROR_MESSAGE );
+        }
+                
+    }//GEN-LAST:event_jButtonArtikelAbschickenActionPerformed
+
+    private void jButtonArtikellisteRefreshActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonArtikellisteRefreshActionPerformed
+        ((ArtikelListeTableModel) jTable1.getModel()).setArtikelListe( artikelManagerBean.readAllArtikel()  );                
+    }//GEN-LAST:event_jButtonArtikellisteRefreshActionPerformed
+
+    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem1ActionPerformed
+        System.exit(0);
+    }//GEN-LAST:event_jMenuItem1ActionPerformed
+
+    /**
+     * erstellt einen neuen Artikel
+     * @param evt
+     */
+    private void jButtonLagerNeuActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonLagerNeuActionPerformed
+        Artikel a = new Artikel();
+        a.setBezeichnung(jTextFieldLagerBezeichnung.getText());
+        a.setAnzahl((Long) jSpinnerLagerAnzahl.getValue());
+        a.setPreis((Double) jSpinnerLagerPreis.getValue());
+        try {
+            artikelManagerBean.createArtikel(a);
+        } catch (IdBereitsVergebenException ex) {
+            Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
+        }
+        refreshArtikel();
+    }//GEN-LAST:event_jButtonLagerNeuActionPerformed
+
+    /**
+     * loescht einen Artikel
+     * @param evt
+     */
+    private void jButtonLagerLoeschenActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonLagerLoeschenActionPerformed
+        Artikel a = ((ArtikelListeTableModel)jTable1.getModel()).getArtikelListe().get(jTable1.getSelectedRow());
+        artikelManagerBean.deleteArtikel(a.getId());
+        refreshArtikel();
+    }
+        
+        /* 
+        ((ArtikelListeTableModel) jTable1.getModel()).setArtikelListe(lagerBean.getArtikelListe());//GEN-LAST:event_jButtonLagerLoeschenActionPerformed
+    */
+    
+/**
+ * aendert einen Artikel
+ * @param evt
+ */
+    private void jButtonLagerAendernActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonLagerAendernActionPerformed
+        Artikel a =  ((ArtikelListeTableModel)jTable1.getModel()).getArtikelListe().get(jTable1.getSelectedRow());
+        a.setBezeichnung(jTextFieldLagerBezeichnung.getText());
+        a.setAnzahl((Long) jSpinnerLagerAnzahl.getValue());
+        a.setPreis((Double)  jSpinnerLagerPreis.getValue());
+        artikelManagerBean.updateArtikel(a);
+        refreshArtikel();
+    }//GEN-LAST:event_jButtonLagerAendernActionPerformed
+
+private void jButtonKundenlisteRefreshActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonKundenlisteRefreshActionPerformed
+   refreshKunden();
+}//GEN-LAST:event_jButtonKundenlisteRefreshActionPerformed
+
+private void jButtonKundeNeuActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonKundeNeuActionPerformed
+        Kunde kunde = new Kunde();
+        kunde.setVorname(jTextFieldKundeVorname.getText());
+        kunde.setNachname(jTextFieldKundeNachname.getText());
+        kunde.setAdresse(jTextAreaKundeAdresse.getText());
+        
+        kundenManagerBean.createKunde(kunde);        
+        refreshKunden();
+}//GEN-LAST:event_jButtonKundeNeuActionPerformed
+
+private void jButtonKundeAendernActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonKundeAendernActionPerformed
+        Kunde kunde =  ((KundenListeTableModel)jTableKunden.getModel()).getKundenListe().get(jTableKunden.getSelectedRow());      
+        kunde.setVorname(jTextFieldKundeVorname.getText());
+        kunde.setNachname(jTextFieldKundeNachname.getText());
+        kunde.setAdresse(jTextAreaKundeAdresse.getText());
+        
+        kundenManagerBean.updateKunde(kunde);        
+        refreshKunden();
+}//GEN-LAST:event_jButtonKundeAendernActionPerformed
+
+private void jButtonKundeLoeschenActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonKundeLoeschenActionPerformed
+        Kunde kunde =  ((KundenListeTableModel)jTableKunden.getModel()).getKundenListe().get(jTableKunden.getSelectedRow());      
+        kundenManagerBean.deleteKunde(kunde.getId());
+        refreshKunden();
+}//GEN-LAST:event_jButtonKundeLoeschenActionPerformed
+
+private void jButtonCreateDemoKundenActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonCreateDemoKundenActionPerformed
+  createDemoKunden();
+}//GEN-LAST:event_jButtonCreateDemoKundenActionPerformed
+
+private void jButtonCreateDemoArtikelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonCreateDemoArtikelActionPerformed
+createDemoArtikel();
+}//GEN-LAST:event_jButtonCreateDemoArtikelActionPerformed
+
+/**
+ * liest die Artikel neu ein und zeigt sie in der Tabelle an
+ */
+private void refreshArtikel(){
+       ((ArtikelListeTableModel) jTable1.getModel()).setArtikelListe( artikelManagerBean.readAllArtikel() );                
+}
+
+/**
+ * liest die Kunden neu ein und zeigt sie in der Tabelle an
+ */
+private void refreshKunden(){
+       ((KundenListeTableModel) jTableKunden.getModel()).setKundenListe( kundenManagerBean.readAllKunden() );                
+}
+
+private void createDemoKunden(){
+    kundenManagerBean.deleteAllKunden();
+    
+    kundenManagerBean.createKunde(new Kunde(1L, "Hans", "Bauer", "Kirchgasse 3, 12345 Musterstadt"));
+    kundenManagerBean.createKunde(new Kunde(2L, "Petra", "Schneider", "Opernplatz 3, 23234 Frankfurt"));
+    kundenManagerBean.createKunde(new Kunde(3L, "Sabine", "Friedrich", "Turmstrasse 17, 11122 Bielefeld"));
+    
+    refreshKunden();
+}
+
+private void createDemoArtikel(){
+        try {
+            artikelManagerBean.deleteAllArtikel();
+
+            artikelManagerBean.createArtikel(new Artikel(1L, "Reifen", 20L, 12.95));
+            artikelManagerBean.createArtikel(new Artikel(2L, "Klingel", 7L, 4.95));
+            artikelManagerBean.createArtikel(new Artikel(3L, "Trinkflasche", 18L, 7.95));
+            artikelManagerBean.createArtikel(new Artikel(4L, "Helm", 8L, 59.95));
+            artikelManagerBean.createArtikel(new Artikel(5L, "Fahradlampe", 23L, 8.95));
+            artikelManagerBean.createArtikel(new Artikel(6L, "Reflektor", 11L, 2.95));
+            artikelManagerBean.createArtikel(new Artikel(7L, "Schlauch", 12L, 11.50));
+
+            
+            
+            refreshArtikel();
+        } catch (IdBereitsVergebenException ex) {
+            Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
+        }
+}
+
+    /**
+     * Start des Clients
+     * @param args the command line arguments
+     */
+    public static void main(String args[]) {
+        java.awt.EventQueue.invokeLater(new Runnable() {
+
+            public void run() {
+                new Main().setVisible(true);
+            }
+        });
+    }
+    // Variables declaration - do not modify//GEN-BEGIN:variables
+    private javax.swing.JButton jButtonArtikelAbschicken;
+    private javax.swing.JButton jButtonArtikellisteRefresh;
+    private javax.swing.JButton jButtonCreateDemoArtikel;
+    private javax.swing.JButton jButtonCreateDemoKunden;
+    private javax.swing.JButton jButtonKundeAendern;
+    private javax.swing.JButton jButtonKundeLoeschen;
+    private javax.swing.JButton jButtonKundeNeu;
+    private javax.swing.JButton jButtonKundenlisteRefresh;
+    private javax.swing.JButton jButtonLagerAendern;
+    private javax.swing.JButton jButtonLagerLoeschen;
+    private javax.swing.JButton jButtonLagerNeu;
+    private javax.swing.JLabel jLabel1;
+    private javax.swing.JLabel jLabel10;
+    private javax.swing.JLabel jLabel11;
+    private javax.swing.JLabel jLabel12;
+    private javax.swing.JLabel jLabel13;
+    private javax.swing.JLabel jLabel14;
+    private javax.swing.JLabel jLabel1ReportOutput;
+    private javax.swing.JLabel jLabel2;
+    private javax.swing.JLabel jLabel3;
+    private javax.swing.JLabel jLabel4;
+    private javax.swing.JLabel jLabel5;
+    private javax.swing.JLabel jLabel6;
+    private javax.swing.JLabel jLabel7;
+    private javax.swing.JLabel jLabel8;
+    private javax.swing.JLabel jLabel9;
+    private javax.swing.JLabel jLabelKundeId;
+    private javax.swing.JLabel jLabelLagerId;
+    private javax.swing.JMenu jMenu1;
+    private javax.swing.JMenu jMenu2;
+    private javax.swing.JMenuBar jMenuBar1;
+    private javax.swing.JMenuItem jMenuItem1;
+    private javax.swing.JPanel jPanel1;
+    private javax.swing.JPanel jPanelArtikel;
+    private javax.swing.JPanel jPanelAuftragsAbwicklung;
+    private javax.swing.JPanel jPanelKunde;
+    private javax.swing.JScrollPane jScrollPane2;
+    private javax.swing.JScrollPane jScrollPane3;
+    private javax.swing.JScrollPane jScrollPane4;
+    private javax.swing.JSpinner jSpinnerAnzahl;
+    private javax.swing.JSpinner jSpinnerArtikelId;
+    private javax.swing.JSpinner jSpinnerKundenId;
+    private javax.swing.JSpinner jSpinnerLagerAnzahl;
+    private javax.swing.JSpinner jSpinnerLagerPreis;
+    private javax.swing.JTabbedPane jTabbedPane1;
+    private javax.swing.JTabbedPane jTabbedPaneVerwaltung;
+    private javax.swing.JTable jTable1;
+    private javax.swing.JTable jTableKunden;
+    private javax.swing.JTextArea jTextAreaKundeAdresse;
+    private javax.swing.JTextField jTextFieldKundeNachname;
+    private javax.swing.JTextField jTextFieldKundeVorname;
+    private javax.swing.JTextField jTextFieldLagerBezeichnung;
+    // End of variables declaration//GEN-END:variables
+}
-- 
cgit v1.2.3