In this help topic you will learn how to bind a jqxGrid to a PostgreSQL database using JSP (JavaServer Pages).
before proceeding, please make sure you have followed the instructions of the tutorial
Configure MySQL, Eclipse
and Tomcat for Use with jQWidgets, but skip Step 1, because we will be using a PostgreSQL
database instead of MySQL. You also do not need the MySQL Connector/J. Instead,
download the PostgreSQL JDBC Driver from here: https://jdbc.postgresql.org/download.html (
and include it the same way as explained for MySQL Connector/J.
For the purposes of this tutorial, we will be using the PostgreSQL version of the Northwind database. You can get the it from here: https://code.google.com/p/northwindextended/downloads/detail?name=northwind.postgre.sql&can=2&q=.
CREATE DATABASE northwind;
northwind.postgre.sql). Enter the requested information in the window that appears and your user password in the next one:
You now have the northwind database ready for use and manipulation.
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.