Java Servlets, Maven, JDBC, JSP and MySQL Integration Template This example shows how to run AnyChart library with Java programming language using Maven, Servlets, JDBC, JSP and MySQL.

View on GitHub

Running

To use this sample you must have:

MySQL installed and running, if not please check out MySQL download page and follow these instructions. To check your MySQL installation, run following command in command line:


$ mysql --version
mysql  Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6. # sample output
                    

Maven build tool, if not please checkout maven installation page. To check your Maven installation, run following command in command line:


$ mvn --version
Apache Maven 2.2.1 (rdebian-14) # sample output
Java version: 1.8.0_101
Java home: /usr/lib/jvm/java-8-oracle/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux" version: "3.16.0-38-generic" arch: "amd64" Family: "unix"
                

To start this example run commands listed below.

Clone the repository from github.com to your workspace folder:


$ git clone git@github.com:anychart-integrations/java-jsp-jdbc-mysql-template.git
                    

Navigate to the repository folder:


$ cd java-jsp-jdbc-mysql-template
                        

Set up MySQL database, use -u -p flags to provide your user name and password:


$  mysql < database_backup.sql
                        

Run app


mvn clean install tomcat7:run
                    

open browser at http://localhost:8080/


Workspace

Your workspace should look like:


java-jsp-jdbc-mysql-template/
    src/
        main/
            java/
                com.anychart/
                    listeners/
                        DatabaseContextListener.java    # Listener for database
                    models/
                        Fruit.java      # Data model
                    servlets/
                        MainServlet.java    # Servlet
                resources
                webapp/
                    resources/
                        css/
                            style.css   # css styles
                    WEB-INF/
                        views/
                            index.jsp   # html template
                    web.xml             # Main web settings
    .gitignore
    database_backup.sql     # MySQL database dump
    LICENSE
    pom.xml     # project dependencies
    README.md
                    

Technologies


Further Learning


License

AnyChart JSP/MySQL integration sample includes two parts:

  • Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with JSP technology, Java language and MySQL database with JDBC driver. You can use, edit, modify it, use it with other Javascript libraries without any restrictions. It is released under Apache 2.0 License.
  • AnyChart JavaScript library. It is released under Commercial license. You can test this plugin with the trial version of AnyChart. Our trial version is not limited by time and doesn't contain any feature limitations. Check details here.

If you have any questions regarding licensing - please contact us. sales@anychart.com