XignSys Anbindung
- Code Changes made by Wojciech
- ToDo

XignSys Anbindung

Code Changes made by Wojciech

BBOnlineClient

build-impl.xml
- + Some Libraries
project.properties
- + Some Libraries
project.xml
- + Some Libraries
+ BBOnlineClient\web\nutzerkonten.jsp
- ⇒ uffpassa: boolean nutzerkonten = true; / /“J”.equals(bboc.getNocSetting(“externeBenutzerkonten”, “AD”));
BBOnlineClient\web\BB_ausbilder.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
BBOnlineClient\web\BB_ausbildungsstaetten.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
BBOnlineClient\web\BB_auszubildende.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
- + <jsp:include page=“nutzerkonten.jsp”/>
BBOnlineClient\web\BB_pruefer.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
BBOnlineClient\web\bbAusbLogin.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
+ BBOnlineClient\web\nutzerkonten.jsp
BBOnlineClient\wsdl\BBOnlineService.wsdl
- Added some messages
  - …
BBOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.wsdl
- Added some messages
  - …
BBOnlineClient\src\conf\xml-resources\web-service-references\BBOnlineService\wsdl\BBOnlineService.xsd
- Added some types
  - …
BBOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.wsdl
- Added some messages / operations
  - ….
BBOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.xsd
- Added some types
  - …
BBOnlineClient\wsdl\OnlineAccountService.wsdl
- Added some messages / operations
  - ….
BBOnlineClient\wsdl\OnlineAccountService.xsd
- Added some types
  - ….

OnlineAccountClient

OnlineAccountClient\web\WEB-INF\web.xml
- + <servlet-name>OpenIDConnectCallbackServlet</servlet-name> …
build-impl.xml
- + Some Libraries
project.properties
- + Some Libraries
project.xml
- + Some Libraries
OnlineAccountClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.wsdl
- + Added some messages to the SOAP interface:
  - <message name=“insertExtAnmeldung”>
  - …
  - <operation name=“deleteNutzerkonto”>
  - …
OnlineAccountClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.xsd
- Added some types / elements
- + <xs:element name=“checkIDTokenResponse” type=“tns:checkIDTokenResponse”/>
- …
- + <xs:complexType name=“insertExtAnmeldung”>
- …
OnlineAccountClient\src\java\de\noc\tibros\oa\utils\OnlineAccountClient.java
- + public boolean insertExtAnmeldung(OnlineAnmeldung oa, String quelle, String idtoken, String art) throws Exception {…
- + public OnlineAnmeldung checkIDToken(String username, String idtoken) throws Exception {…
- + public boolean deleteNutzerkonto(Nutzerkonto nk) throws Exception {…
- + static synchronized void loadNocSettings() throws Exception {…
- + public String getNocSetting(String name, String programm) throws Exception {…
+ OnlineAccountClient\src\java\de\noc\tibros\oa\utils\OpenIDConnectCallbackServlet.java
+ OnlineAccountClient\web\delNutzerkonto.jsp
+ OnlineAccountClient\web\nutzerkonten.jsp
+ OnlineAccountClient\web\nutzerkonto.jsp
OnlineAccountClient\web\homeOA.jsp
- Added if (session.getAttribute(“idToken”) != null)
  - …
OnlineAccountClient\web\login.jsp
- Added:
  - …
  - <jsp:include page=“nutzerkonten.jsp”/>
  - …
OnlineAccountClient\web\zugDaten.jsp
- Added Code to show “delete” buttons for every account:
  - …
  - while (nKontenIter.hasNext()) {
  - …
OnlineAccountClient\wsdl\OnlineAccountService.wsdl
- + Added some messages to the SOAP interface:
  - … (should be the same as for OnlineAccountClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.wsdl)
OnlineAccountClient\wsdl\OnlineAccountService.xsd
- … (should be same as for OnlineAccountClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.xsd)

OnlineAccountServer

OnlineAccountServer\src\java\de\noc\tibros\oa\manager\OnlineBerechtigungManager.java
- + … reading now value of one parameter more:
  - where name=externeBenutzerkonten and programm=“AD”
OnlineAccountServer\src\java\de\noc\tibros\oa\manager\OnlineUserManager.java
- removed “private” from “readFromResultOA(ResultSet result)”
OnlineAccountServer\src\java\de\noc\tibros\oa\sql\DBConnection.java
- + Added some methods:
  - insertExtAnmeldungPstm()
  - …
  - delNutzerkontoExternPstm()
OnlineAccountServer\src\java\de\noc\tibros\oa\sql\DBDefinition.java
- + Added some new PreparedStatements
  - insertExtAnmeldungPstm
  - …
  - delNutzerkontoExternPstm
OnlineAccountServer\src\java\de\noc\tibros\oa\ws\OnlineAccountService.java
- Added some web(!) methods
  - insertExtAnmeldung()
  - checkIDToken()
    - Added @WebParam “username”
  - getNutzerkonten()
  - deleteNutzerkonto()
+ OnlineAccountServer\src\java\de\noc\tibros\oa\manager\ExtAnmeldungManager.java
+ OnlineAccountServer\src\java\de\noc\tibros\oa\object\Nutzerkonto.java
+ OnlineAccountServer\src\sql\checkIDTokenAzubiSQL.sql
+ OnlineAccountServer\src\sql\checkIDTokenStammSQL.sql
+ OnlineAccountServer\src\sql\insertOnAnExtSQL.sql
+ OnlineAccountServer\src\sql\insertOnAnRelExtSQL.sql
+ OnlineAccountServer\src\sql\delNutzerkontoExternSQL.sql
+ OnlineAccountServer\src\sql\delNutzerkontoExternRelSQL.sql
+ OnlineAccountServer\src\sql\getNutzerkontenByUsernameSQL.sql

PPOnlineClient

build-impl.xml
- + Some Libraries
project.properties
- + Some Libraries
project.xml
- + Some Libraries
+ PPOnlineClient\web\nutzerkonten.jsp
- Also added to the file:
- …
- <input type='hidden' name='redirect_uri' value='<%=PPOnlineProperties.getProperty(“client.codebase”)%>/tibrosOA/oauth/elster'>
- …
PPOnlineClient\web\PP_bildungstraeger.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
PPOnlineClient\web\PP_pruefer.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
PPOnlineClient\web\PP_teilnehmer.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
PPOnlineClient\web\projektePrueferAnsicht.jsp
- + String filterAzubiname = request.getParameter(“filterAzubiname”) != null ? request.getParameter(“filterAzubiname”) : (String) session.getAttribute(“filterAzubiname”);
- + …
- + <button class=“button2 smallbutton” type=submit name='filtern'>Aktualisieren</button>
PPOnlineClient\src\java\de\noc\tibros\pp\utils\PPOnlineClient.java
- + static synchronized void loadNocSettings() throws Exception { …
- + public String getNocSetting(String name, String programm) throws Exception { …
PPOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.wsdl
- Added some messages / operations
  - …
PPOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.xsd
- Added some types
  - …
PPOnlineClient\wsdl\OnlineAccountService.wsdl
- Added some messages / operations
  - …
PPOnlineClient\wsdl\OnlineAccountService.xsd
- Added some types
  - …

VDOnlineClient

build-impl.xml
- + Some Libraries
project.properties
- + Some Libraries
project.xml
- + Some Libraries
+ VDOnlineClient\web\nutzerkonten.jsp
- Also added:
- …
- <input type='hidden' name='redirect_uri' value='<%=VDOnlineProperties.getProperty(“client.codebase”)%>/tibrosOA/oauth/elster'>
- …
VDOnlineClient\web\VD_dozentenportal.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
VDOnlineClient\web\VD_firmenportal.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
VDOnlineClient\web\VD_teilnehmerportal.jsp
- + <jsp:include page=“nutzerkonten.jsp”/>
VDOnlineClient\src\java\de\noc\tibros\vd\utils\VDOnlineClient.java
- + static synchronized void loadNocSettings() throws Exception { …
- + public String getNocSetting(String name, String programm) throws Exception { …
VDOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.wsdl
- Added some messages / operations
  - …
VDOnlineClient\src\conf\xml-resources\web-service-references\OnlineAccountService\wsdl\OnlineAccountService.xsd
- Added some types
  - …
VDOnlineClient\wsdl\OnlineAccountService.wsdl
- Added some messages / operations
  - …
VDOnlineClient\wsdl\OnlineAccountService.xsd
- Added some types
  - …

ToDo

nutzerkonten.jsp
- Make URL configurable: <form class=“form-inline” action='https://id.xign.me/auth/realms/IHK-Test/protocol/openid-connect/auth' method=“get”>

Table of Contents

XignSys Anbindung

Code Changes made by Wojciech

BBOnlineClient

OnlineAccountClient

OnlineAccountServer

PPOnlineClient

VDOnlineClient

ToDo