<%@page contentType="text/xml"%><%@page pageEncoding="UTF-8"%><%@include file="../Framework/TreeGridFramework.jsp"%><% /*----------------------------------------------------------------------------------------------------------------- ! Support file only, run Framework.html instead ! This file is used as both Data_Url and Upload_Url Generates data for TreeGrid when no data received or saves received changes to database Uses routines in TreeGridFramework.jsp to load and save data ------------------------------------------------------------------------------------------------------------------*/ //------------------------------------------------------------------------------------------------------------------ response.addHeader("Cache-Control","max-age=1, must-revalidate"); // --- Database connection --- java.sql.Statement Cmd = getHsqlStatement(request,out,"../Database","sa",""); // --- Save data to database --- org.w3c.dom.Element[] Ch = getChanges(request.getParameter("TGData")); if(Ch!=null){ try { for(int i=0;i"); } catch(Exception ex){ out.print("Error in saving data !
"); out.print(ex.getMessage()); } } // --- Load data from database --- else { java.sql.ResultSet R = Cmd.executeQuery("SELECT * FROM TableData"); String[] Names = {"id","Project","Resource","Week","Hours"}; out.print(getTableXML(R,Names)); R.close(); } //------------------------------------------------------------------------------------------------------------------ %>