Java Connector for dhtmlxGantt


#21

#22

Hello Orlando,
Connectors are not actively developed. Although it is easier to configure a connector for a quick start, you cannot create a complex solution with it. So, it is recommended to use a backend:
https://docs.dhtmlx.com/gantt/desktop__howtostart_guides.html


#23

Hello Ramil, I am starting with dhtmlx and java JSF, started following the contacs-manager demo, i’ll be using dhtmlx -> java servlet -> MSSql server data base.

After initialization and running the servlet on page load, the grid is not populated, its looks like the render_table(“TCiudades”,“id”,“csCodigoCiudad,csDescripcionCiudad,csTipoRiesgo”); is not returning data.

Do you any idea what’s happening, some help, sorry for my bad english.

Initialization page:

dhtmlxEvent(window,“load”,function()
{ //provides the script as a handler of the ‘onload’ HTML event
//dhtmlx.message({ type: “alert”, text: “Starting dhtmlx test” });

        var layout,menu,toolbar,contactsGrid,contactForm;
        dhtmlx.image_path = "contact_manager/codebase/imgs/";
        layout = new dhtmlXLayoutObject(document.body,"2U");                       //initializes dhtmlxLayout
        layout.cells("a").setText("Contacts");                                     //sets the text in the header of the 'grid' column
        layout.cells("b").setText("Contact Details");                              //sets the text in the header of the 'form' column
        layout.cells("b").setWidth(500);                                           //sets the width of the 'form' column

        menu = layout.attachMenu();                                                //initializes dhtmlxMenu
        menu.setIconsPath("contact_manager/icons/");                                               //sets the path to custom icons
        menu.loadStruct("contact_manager/data/menu.xml");                                           //loads items from the "data/menu.xml" file to the menu

        toolbar = layout.attachToolbar();                                          //initializes dhtmlxToolbar
        toolbar.setIconsPath("contact_manager/icons/");                                            //sets the path to custom images
        toolbar.loadStruct("contact_manager/data/toolbar.xml");                                      //loads items from the "data/toolbar.xml" file to the toolbar

        contactsGrid = layout.cells("a").attachGrid();                             //initializes dhtmlxGrid
        contactsGrid.setHeader("Codigo,Descripcion,Riesgo");   //sets the headers of columns
        contactsGrid.setColumnIds("csCodigoCiudad,csDescripcionCiudad,csTipoRiesgo");    //sets the columns' values                           //sets the column ids
        //contactsGrid.setInitWidths("200,200,*");                                 //sets the initial widths of columns
        contactsGrid.setColAlign("left,left,left");                                //sets the horizontal alignment
        contactsGrid.setColTypes("ro,ro,ro");                                      //sets the types of columns
        contactsGrid.setColSorting("str,str,str");                                 //sets the sorting types of columns
        contactsGrid.attachHeader("#text_filter,#text_filter,#text_filter");       //sets the filters for columns
        contactsGrid.init();                                                       //renders  dhtmlxGrid on the page
        
        //----------------- load data from server --------------------//
        contactsGrid.load("dhtmlx_Servlet");                                    //loads data from the "data/contacts.php" file to the grid
        //------------------------------------------------------------//
        
        contactForm = layout.cells("b").attachForm();                              //initializes dhtmlxForm
        contactForm.loadStruct("contact_manager/data/form.xml");                                   //loads controls, specified in the "data/form.xml" file to the form
        contactForm.bind(contactsGrid);                                            //binds the form to the grid

        var dpg = new dataProcessor("data/contacts.php");                          //inits dataProcessor
        dpg.init(contactsGrid);                                                    //associates the dataProcessor instance with the grid

        dpg.attachEvent("onAfterUpdate", function(sid, action, tid, tag){
            if (action == "inserted"){
                contactsGrid.selectRowById(tid);                                   //selects a row
                contactForm.setFocusOnFirstActive();                               //sets focus to the 1st form's input
            }
        })

        contactForm.attachEvent("onButtonClick", function(id){                     //attaches a handler function to the "onButtonClick" event
            contactForm.save();                                                    //sends the values of the updated row to the server
        });
        toolbar.attachEvent("onclick",function(id){                                //attaches a handler function to the "onclick" event
            if(id=="newContact"){                                                  //'newContact' is the id of the button in the toolbar
                var rowId=contactsGrid.uid();                                      //generates an unique id
                var pos = contactsGrid.getRowsNum();                               //gets the number of rows in the grid
                contactsGrid.addRow(rowId,["New contact","",""],pos);              //adds a new row to the grid. The 'addRow()' method takes 3 parameters: the row id (must be unique), the initial values of the row, the  position where the new must be inserted
            };
            if(id=="delContact"){                                                  //'delContact' is the id of the button in the toolbar
                var rowId = contactsGrid.getSelectedRowId();                       //gets the id of the currently selected row
                var rowIndex = contactsGrid.getRowIndex(rowId);                    //gets the index of the row with the specified id

                if(rowId!=null){
                    contactsGrid.deleteRow(rowId);                                 //deletes the currently selected row
                    if(rowIndex!=(contactsGrid.getRowsNum()-1)){                   //checks whether  the currently selected row is NOT last in the grid
                        contactsGrid.selectRow(rowIndex+1,true);                   //if the currently selected row isn't last - moves selection to the next row
                    } else{                                                        //otherwise, moves selection to the previous row
                        contactsGrid.selectRow(rowIndex-1,true)
                    }
                }
            }
        });

    })
</script>

My servlet:
public class dhtmlx_Servlet extends HttpServlet {

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
          throws ServletException, IOException 
{
    String data = "**** test ****";
    PreparedStatement qps;
    ResultSet rs = null;
    String city = "test";
    String sql;
    Connection conn = null;
    String username = "psv";
    String password = "psv_pw";
    com.dhtmlx.connector.GridConnector gc = null ;
    
    response.setContentType("text/html;charset=UTF-8");
    /*
    
    try {
        InitialContext ctx = new InitialContext();
        DataSource ds = (DataSource) ctx.lookup("jdbc/PsFlowWeb");
        conn = ds.getConnection(username, password);

        sql = "SELECT top 1 *, csDescripcionCiudad as city from TCiudades";
        
        qps = conn.prepareStatement(sql);
        rs = qps.executeQuery();

        if (rs.next()) {
            city = rs.getString("city");
            //response.getWriter().write("---- inside rs.next ----");
        }
        response.getWriter().write(city);
        rs.close();
        qps.close();
        conn.close();
        
    } catch (SQLException ex) {
        Logger.getLogger("DashboardDAO").log(Level.SEVERE, null, ex);
    } catch (Exception ex) {
        Logger.getLogger("DashboardDAO").log(Level.SEVERE, null, ex);
    }
   */
    
    //response.getWriter().write(data);
    
    response.setContentType("text/html;charset=UTF-8");
    
    try (PrintWriter out = response.getWriter()) 
    {
        try 
        {
            InitialContext ctx = new InitialContext();
            DataSource ds = (DataSource) ctx.lookup("jdbc/PsFlowWeb");
            conn = ds.getConnection(username, password);
            gc = new com.dhtmlx.connector.GridConnector(conn);
            gc.servlet(request, response);
            //gc.dynamic_loading(100);
            gc.enable_log("c:/PSFlow/logs/grid.log", true);
            gc.render_table("TCiudades","id","csCodigoCiudad,csDescripcionCiudad,csTipoRiesgo");
        } 
        catch (SQLException | NamingException ex) 
        {
            //Logger.getLogger(SqlServerDAOFactory.class.getName()).log(Level.SEVERE, null, ex);
        }
        
    }
   
}