java jsp jdbc mysql template

Java basic template

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

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 [email protected]: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

Language - Java
Database - MySQL
Database driver - JDBC
Template - JSP
Build tool - Maven

Further Learning

• Documentation
• JavaScript API Reference
• Code Playground
• Technical Support

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. [email protected]