Time for action — creating a chart in Java using data from MySQL
1. Create a new JSP file and save it as
AnnualRevenues.jsp
.2. Paste the following code in it:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <%@ taglib prefix="tags" tagdir="/WEB-INF/tags"%> <%@ taglib uri="http://www.fusioncharts.com/jsp/core" prefix="fc"%> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <html> <head> <title>Database example in Java</title> <script type="text/javascript" src="FusionCharts/FusionCharts.js"></script> <script type="text/javascript" src="FusionCharts/FusionCharts.js"></script> </head> <body> <h1>Creating charts in Java using data from MySQL</h1> <% try { String connectionURL = "jdbc:mysql://localhost:3306/harrys_supermarket"; Connection connection = null...