IST
PLAN
ADialog (5)
ADialog_Hr_Cal (1)
AJob (3)
App-Detail (7)
App-Link (38)
AReport (3)
Server-VM (1)
Software (1)
demo-online
Beschreibung
Bemerkung
Support
Hist
Plan
OK
abbrechen
Material
Stunden
Wiederholung
OK
abbrechen
z.B. für eine Datenquellen, für die man eine URL hat und man als Tabelle anzeigen möchte. ( Cross-Origin ist hier zu beachten ) z.B. "Tabelle"
...
...
man kann mit wenig HTML / TypeScript/JavaScript auskommen, wenn Cross-Origin und Authentifizierung bereits gelöst sind. <html> <head> <title>Einstellungen - Tabelle</title> <style> td { border: solid 1px darkGray; min-width: 2rem; padding: 0.2rem; } </style> <script type="module" > "use strict"; window.addEventListener( "load", function() { const select_url = getEinstellungen_Tabelle_Select_url(); fetch( select_url, { credentials: 'include' }) .then( (response) => response.text() ) .then( (text) => { const table_ele = document.getElementById("d-print-table"); const json_doc = JSON.parse( text); fill_table( document, table_ele, json_doc); }) .catch( function( exc) { alert( "fetch failed (" + exc + ")"); }); }); function fill_table( html_doc, table_ele, json_doc) { const tag_names = [ "th", "td" ]; for( let tag_name_i=0; tag_name_i < tag_names.length; tag_name_i++ ) { let tag_name = tag_names[ tag_name_i]; let trs = json_doc; for( let tr_i=0; tr_i < ( tag_name == "th" && trs.length >= 1 ? 1 : trs.length ); tr_i++ ) { let tr = trs[ tr_i]; let tr_ele = html_doc.createElement( "tr"); table_ele.appendChild( tr_ele); let tds = tr; Object.entries( tds).forEach( ( [fdName, fdValue]) => { let td_ele = html_doc.createElement( tag_name); tr_ele.appendChild( td_ele); td_ele.innerText = ( tag_name == "th" ? fdName : fdValue ); }); } } } function getEinstellungen_Tabelle_Select_url() { const select = getEinstellungen_Tabelle_Select(); const select_sql = select[ "sql"]; const json_parameters = JSON.stringify( select[ "param"]); const select_url = "/MywebDb3Servlet" + "?sql=" + encodeURIComponent( select_sql) + "¶meters=" + encodeURIComponent( json_parameters); return select_url; } function getEinstellungen_Tabelle_Select() { const select_sql = "select _id, PREFERENCE_KEY, PREFERENCE_VALUE from Preferences order by _id"; return { sql: select_sql, param: [] }; } </script> </head> <body> <h1>Einstellungen - Tabelle</h1> <table id="d-print-table" > </table> </body> </html>