In this help topic you will learn how to bind a jqxGrid to a MySQL database using JSP (JavaServer Pages).
Important: before proceeding, please make sure you have followed the instructions of the tutorial Configure MySQL, Eclipse and Tomcat for Use with jQWidgets.
To populate the grid, we need a JSP file that connects to the Northwind database and retieves data from it.
Create a new JSP by right-clicking the project's
then choosing New → JSP File. Name the file
Import the necessary classes in the beginning of the JSP:
Finally, add a scriptlet to the JSP that does the following:
Create a new HTML page by right-clicking the project's
then choosing New → HTML File. Here is the code
of the page in our example:
Through jqxDataAdapter, the grid is populated by the data retrieved from the database
select-data.jsp. To run the page, right-click it and select Run As → Run on Server. In the window that appears,
select Tomcat v8.0 Server at localhost and click Finish.