In this help topic you will learn how to create a sample MySQL database and configure the Eclipse IDE and the Apache Tomcat server before creating your first jQWidgets example in the Java environment.
For the purposes of this tutorial, we will be using the MySQL version of the Northwind database. You can get the it from here: http://dev.wavemaker.com/forums/sites/default/files/files/northwind.sql_.zip.
CREATE DATABASE northwind;
northwind.sqlfound in the downloaded
C:/pathis the path to the folder you extracted the file to.
You now have the northwind database ready for use and manipulation.
In this tutorial, we will be using Eclipse IDE for Java EE Developers, version Luna. You can get it from here: https://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/lunasr2. Run Eclipse and go to File → New → Dynamic Web Project. In the window that appears, type the project's name (we will name it "jQWidgetsJSP") and click Finish.
Several Java class packages (
.jar files) are necessary for the jQWidgets
examples and have to be included in the Java build path. These are:
java-rt-jar-stubs-1.5.0.jar- contains all of the compiled class files for the base Java Runtime Environment.
mysql-connector-java-5.1.34-bin.jar- MySQL Connector/J is the official JDBC driver for MySQL. It is necessary for the connection to the MySQL database.
gson-2.3.1.jar- Gson is a Java library that can be used to convert Java Objects into their JSON representation.
Here is how to add these to the Eclipse project:
The added JARs should appear in
Java Resources\Libraries and be ready
Create two folders in the project folder
css. Include in them all (or only the necessary) jQWidgets files
- the scripts (including
jqxcore.js and the specific widget files)
js and the stylesheets (
jqx.base.css and any themes
and associated images) in
css. Remember to include a version of jQuery
Apache Tomcat is an open source software implementation of the Java Servlet and JavaServer Pages technologies. We will be using Tomcat 8.0 in this tutorial. If you do not already have Apache Tomcat on your system, download it from here: http://tomcat.apache.org/download-80.cgi and install it. Then:
Your project is now set up and you can proceed with any of the following tutorials showcasing jQWidgets components loaded through JSP: