下面这个示例已经可以运行了,但我不知道怎么样将这个示例数据替换成从后台数据库中获取。请各位能否给一个类似这样向后台请求数据库的例子?
开发语言:java
IDE:MyEclipse
数据库:sql server
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>MyStock</title>
</head>
<body>
<div id="container" style="height: 600px; min-width: 100px"></div>
</body>
<script type="text/javascript" src="js/jquery-2.1.1.min.js"></script>
<script type="text/javascript" src="js/highstock.js"></script>
<script type="text/javascript">
var usdeur = [
[Date.UTC(2011,1,1),0.7232],
[Date.UTC(2011,1,2),0.7239],
[Date.UTC(2011,1,3),0.7341],
[Date.UTC(2011,1,4),0.7364],
[Date.UTC(2011,1,7),0.7357],
[Date.UTC(2011,1,8),0.734],
[Date.UTC(2011,1,9),0.7289],
[Date.UTC(2011,1,10),0.7351],
[Date.UTC(2011,1,11),0.7377],
[Date.UTC(2011,1,14),0.7419],
[Date.UTC(2011,1,15),0.7409],
[Date.UTC(2011,1,16),0.7367],
[Date.UTC(2011,1,17),0.7341],
[Date.UTC(2011,1,18),0.7304],
[Date.UTC(2011,1,21),0.731],
[Date.UTC(2011,1,22),0.7315],
[Date.UTC(2011,1,23),0.7268],
[Date.UTC(2011,1,24),0.7236],
[Date.UTC(2011,1,25),0.7271],
[Date.UTC(2011,1,28),0.7235],
[Date.UTC(2011,2,1),0.7263],
[Date.UTC(2011,2,2),0.7213],
[Date.UTC(2011,2,3),0.7165],
[Date.UTC(2011,2,4),0.715],
[Date.UTC(2011,2,7),0.7162],
[Date.UTC(2011,2,8),0.7198],
[Date.UTC(2011,2,9),0.7192],
[Date.UTC(2011,2,10),0.7246],
[Date.UTC(2011,2,11),0.7194],
[Date.UTC(2011,2,14),0.7148],
[Date.UTC(2011,2,15),0.715],
[Date.UTC(2011,2,16),0.7203],
[Date.UTC(2011,2,17),0.7128],
[Date.UTC(2011,2,18),0.7052],
[Date.UTC(2011,2,21),0.7036],
[Date.UTC(2011,2,22),0.7058],
[Date.UTC(2011,2,23),0.7091],
[Date.UTC(2011,2,24),0.7058],
[Date.UTC(2011,2,25),0.71],
[Date.UTC(2011,2,28),0.7107],
[Date.UTC(2011,2,29),0.7082],
[Date.UTC(2011,2,30),0.7079],
[Date.UTC(2011,2,31),0.7064],
[Date.UTC(2011,3,1),0.7026],
[Date.UTC(2011,3,4),0.704],
[Date.UTC(2011,3,5),0.7026],
[Date.UTC(2011,3,6),0.6982],
[Date.UTC(2011,3,7),0.6996],
[Date.UTC(2011,3,8),0.6907],
[Date.UTC(2011,3,11),0.6934],
[Date.UTC(2011,3,12),0.6906],
[Date.UTC(2011,3,13),0.692],
[Date.UTC(2011,3,14),0.6896],
[Date.UTC(2011,3,15),0.6931],
[Date.UTC(2011,3,18),0.7024],
[Date.UTC(2011,3,19),0.6961],
[Date.UTC(2011,3,20),0.6888],
[Date.UTC(2011,3,21),0.6869],
[Date.UTC(2011,3,22),0.6869],
[Date.UTC(2011,3,25),0.6874],
[Date.UTC(2011,3,26),0.6801],
[Date.UTC(2011,3,27),0.6763],
[Date.UTC(2011,3,28),0.6738],
[Date.UTC(2011,3,29),0.6753],
[Date.UTC(2011,4,2),0.6759],
[Date.UTC(2011,4,3),0.674],
[Date.UTC(2011,4,4),0.6744],
[Date.UTC(2011,4,5),0.687],
[Date.UTC(2011,4,6),0.6983],
[Date.UTC(2011,4,8),0.696],
[Date.UTC(2011,4,10),0.6945]
];
$(function() {
var chart = new Highcharts.StockChart({
chart: {
renderTo: 'container'//指向的div的id属性
},
exporting: {
enabled: false //是否能导出趋势图图片
},
title : {
text : 'AAPL Stock Price(苹果股价)'//图表标题
},
xAxis: {
tickPixelInterval: 200,//x轴上的间隔
// title :{
// text:"title"
// },
type: 'datetime', //定义x轴上日期的显示格式
labels: {
formatter: function() {
var vDate=new Date(this.value);
//alert(this.value);
return vDate.getFullYear()+"-"+(vDate.getMonth()+1)+"-"+vDate.getDate();
},
align: 'center'
}
},
yAxis : {
title: {
text: 'Rate(汇率)' //y轴上的标题
}
},
tooltip: {
xDateFormat: '%Y-%m-%d, %A'//鼠标移动到趋势线上时显示的日期格式
},
rangeSelector: {
buttons: [{//定义一组buttons,下标从0开始
type: 'week',
count: 1,
text: '1w'
},{
type: 'month',
count: 1,
text: '1m'
}, {
type: 'month',
count: 3,
text: '3m'
}, {
type: 'month',
count: 6,
text: '6m'
}, {
type: 'ytd',
text: 'YTD'
}, {
type: 'year',
count: 1,
text: '1y'