Spring MVC Chart Data from Database

Download Spring MVC Chart Samples 
<!--chart.jsp-->
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<script type="text/javascript">
window.onload = function() {

var dps = [[]];
<c:if test="${error == null}">
var chart = new CanvasJS.Chart("chartContainer", {
	theme: "light2", // "light1", "dark1", "dark2"
	animationEnabled: true,
	title: {
		text: "Column Chart from Database"
	},
	data: [{
		type: "column",
		dataPoints: dps[0]
	}]
});
</c:if>

var xValue;
var yValue;

<c:forEach items="${dataPointsList}" var="dataPoints" varStatus="loop">	
	<c:forEach items="${dataPoints}" var="dataPoint">
		xValue = parseInt("${dataPoint.x}");
		yValue = parseFloat("${dataPoint.y}");
		dps[parseInt("${loop.index}")].push({
			x : xValue,
			y : yValue,
		});		
	</c:forEach>	
</c:forEach> 

<c:if test="${error == null}">
chart.render();
</c:if>

}
</script>
</head>
<body>
	<c:if test="${error != null}">
	<div  style='width: 50%; margin-left: auto; margin-right: auto; margin-top: 200px; text-align: center;'>${error}</div>
	</c:if>
	<c:if test="${error == null}">
	<div id="chartContainer" style="height: 370px; width: 100%;"></div>
	</c:if>
	<script src="https://cdn.canvasjs.com/canvasjs.min.js"></script>
</body>
</html>                              
//CanvasjsChartController.java
package com.canvasjs.chart.controllers;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import com.canvasjs.chart.data.CanvasjsChartData.DataPointModel;
import com.canvasjs.chart.data.CanvasjsChartData.DatabaseConnectionException;
import com.canvasjs.chart.services.CanvasjsChartService;

@Controller
@RequestMapping("/canvasjschart")
public class CanvasjsChartController {

	@Autowired
	private CanvasjsChartService canvasjsChartService;

	@RequestMapping(method = RequestMethod.GET)
	public String springMVC(ModelMap modelMap) {
		List<List<DataPointModel>> canvasjsDataList = canvasjsChartService.getCanvasjsChartData();
		modelMap.addAttribute("dataPointsList", canvasjsDataList);
		return "chart";
	}

	@ExceptionHandler({DatabaseConnectionException.class})
	public ModelAndView getSuperheroesUnavailable(DatabaseConnectionException ex) {
	    return new ModelAndView("chart", "error", ex.getMessage());
	}
}                        
//CanvasjsChartService.java
package com.canvasjs.chart.services;

import java.util.List;

import com.canvasjs.chart.data.CanvasjsChartData.DataPointModel;

public interface CanvasjsChartService {

	List<List<DataPointModel>> getCanvasjsChartData();

}


//CanvasjsChartServiceImpl.java
package com.canvasjs.chart.services;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import com.canvasjs.chart.daos.CanvasjsChartDao;
import com.canvasjs.chart.data.CanvasjsChartData.DataPointModel;

public class CanvasjsChartServiceImpl implements CanvasjsChartService {

	@Autowired
	private CanvasjsChartDao canvasjsChartDao;

	public void setCanvasjsChartDao(CanvasjsChartDao canvasjsChartDao) {
		this.canvasjsChartDao = canvasjsChartDao;
	}

	@Override
	public List<List<DataPointModel>> getCanvasjsChartData() {
		return canvasjsChartDao.getCanvasjsChartData();
	}

}                        
//CanvasjsChartDao.java
package com.canvasjs.chart.daos;

import java.util.List;

import com.canvasjs.chart.data.CanvasjsChartData.DataPointModel;

public interface CanvasjsChartDao {

	List<List<DataPointModel>> getCanvasjsChartData();

}

//CanvasjsChartDaoImpl.java
package com.canvasjs.chart.daos;

import java.util.List;

import com.canvasjs.chart.data.CanvasjsChartData;
import com.canvasjs.chart.data.CanvasjsChartData.DataPointModel;

public class CanvasjsChartDaoImpl implements CanvasjsChartDao {

	@Override
	public List<List<DataPointModel>> getCanvasjsChartData() {
		return CanvasjsChartData.getCanvasjsDataList();
	}

}                        
//CanvasjsChartData.java
package com.canvasjs.chart.data;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class CanvasjsChartData {

	private static JdbcTemplate jdbcTemplate;
	static Map<Object,Object> map = null;
	static List<List<DataPointModel>> list = new ArrayList<List<DataPointModel>>();
	static List<DataPointModel> dataPoints1 = new ArrayList<DataPointModel>();
	
	static {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/canvasjs_db");
        dataSource.setUsername("root");
        dataSource.setPassword("");
        jdbcTemplate = new JdbcTemplate(dataSource);
	}

	public static class DataPointModel {
		int x;
		int y;
		
		public int getX() {
			return x;
		}
		public void setX(int x) {
			this.x = x;
		}
		public int getY() {
			return y;
		}
		public void setY(int y) {
			this.y = y;
		}
	}
	
	public static class DatabaseConnectionException  extends RuntimeException{
		
		private static final long serialVersionUID = 1L;

		public DatabaseConnectionException(String message) {
			super(message);
		}
	}
	
	private static void getDataPoints(){
        String sql = "select * from datapoints";
        
        try {
        	dataPoints1 = jdbcTemplate.query(sql, new RowMapper<DataPointModel>() {

				@Override
				public DataPointModel mapRow(ResultSet rs, int rowNum) throws SQLException {
	            	DataPointModel dataPoint = new DataPointModel();
	     
	            	dataPoint.setX(rs.getInt("x"));
	            	dataPoint.setY(rs.getInt("y"));
	     
	                return dataPoint;
				}});
        }
        catch(Exception e){
        	dataPoints1 = null;
        	throw new DatabaseConnectionException("Error while getting dataPoints");
        }
		list.add(dataPoints1);
	}
	
	public static List<List<DataPointModel>> getCanvasjsDataList() {
		getDataPoints();
		return list;
	}
}