Poblar el google chart en javascript usando como base de datos Ms acess


30 de Julio del 2019

 

<script>

var pad = 'C:UsersyoxansourcereposPruebatxtPruebatxtDatabase1.accdb';
var strConn = 'Provider=microsoft.ace.oledb.12.0;Data Source=' + pad;
var cn = new ActiveXObject('ADODB.Connection');
cn.Open(strConn);
var rs = new ActiveXObject('ADODB.Recordset');
var SQL = 'SELECT Meses, Team A, Team B, Team C FROM Table1';
cn.Open(strConn);
rs.Open(SQL, cn);
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawVisualization);
function drawVisualization() {
var rowData=new gooogle.visualization.DataTable();
// Some raw data (not necessarily accurate)

rowData.addColumn=[['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua Guinea',
'Rwanda', 'Average'],
['2004/05', 165, 938, 522, 998, 450, 114.6],
['2005/06', 135, 1120, 599, 1268, 288, 382],
['2006/07', 157, 1167, 587, 807, 397, 623],
['2007/08', 139, 1110, 615, 968, 215, 409.4],
['2008/09', 136, 691, 629, 1026, 366, 569.6]];
var rowData2 = [['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua Guinea',
'Rwanda', 'Average'],
['2004/05', 165, 938, 522, 998, 450, 114.6],
['2005/06', 135, 1120, 599, 1268, 288, 382],
['2006/07', 157, 1167, 587, 807, 397, 623],
['2007/08', 139, 1110, 615, 968, 215, 409.4],
['2008/09', 136, 691, 629, 1026, 366, 569.6]];

var rowData3 = [['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua Guinea',
'Rwanda', 'Average'],
['2008/05', 122, 638, 722, 998, 450, 614.6],
['2009/06', 100, 1120, 899, 1268, 288, 682],
['2010/07', 183, 167, 487, 207, 397, 623],
['2011/08', 200, 510, 315, 1068, 215, 609.4],
['2012/09', 123, 491, 829, 826, 366, 569.6]];
var rowData4 = [['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua Guinea',
'Rwanda', 'Average'],
['2008/05', 122, 638, 722, 998, 450, 614.6],
['2009/06', 100, 1120, 899, 1268, 288, 682],
['2010/07', 183, 167, 487, 207, 397, 623],
['2011/08', 200, 510, 315, 1068, 215, 609.4],
['2012/09', 123, 491, 829, 826, 366, 569.6]];
var rowData5 = [['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua Guinea',
'Rwanda', 'Average'],
['2013/05', 111, 6398, 732, 298, 430, 114.6],
['2014/06', 123, 120, 889, 138, 248, 182],
['2015/07', 115, 187, 497, 227, 3117, 823],
['2016/08', 260, 520, 385, 138, 315, 709.4],
['2017/09', 133, 451, 859, 846, 666, 769.6]];
var rowData6 = [['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua Guinea',
'Rwanda', 'Average'],
['2013/05', 111, 6398, 732, 298, 430, 114.6],
['2014/06', 123, 120, 889, 138, 248, 182],
['2015/07', 115, 187, 497, 227, 3117, 823],
['2016/08', 260, 520, 385, 138, 315, 709.4],
['2017/09', 133, 451, 859, 846, 666, 769.6]];

// Create and populate the data tables.
var data = [];
data[0] = google.visualization.arrayToDataTable(rowData1);
data[1] = google.visualization.arrayToDataTable(rowData2);
data[2] = google.visualization.arrayToDataTable(rowData3);
data[4] = google.visualization.arrayToDataTable(rowData4);
data[5] = google.visualization.arrayToDataTable(rowData5);
var options = {
width: 700,
height: 400,
vAxis: {title: ''},
hAxis: {title: ''},
seriesType: 'bars',
series: {3: {type: 'line'}},
animation:{
duration: 1000,
easing: 'out'
},

};
var current = 0;
// Create and draw the visualization.
var chart = new google.visualization.ComboChart(document.getElementById('chart_div'));
var button = document.getElementById('b1');
var button2 = document.getElementById('b2');
var button3 = document.getElementById('b3');
function drawChart() {
// Disabling the button while the chart is drawing.
button.disabled = true;
google.visualization.events.addListener(chart, 'ready',
function() {
button.disabled = false;
button.value = 'Switch to ' + (current ? 'Tea' : 'Coffee');
});
options['title'] = 'Monthly ' + (current ? 'Coffee' : 'Tea') + ' Production by Country';

chart.draw(data[current], options);
}
drawChart();

function drawChart() {
// Disabling the button while the chart is drawing.
button2.disabled = true;
google.visualization.events.addListener(chart, 'ready',
function() {
button2.disabled = false;
button2.value = 'Switch to ' + (current ? 'Tea' : 'Water');
});
options['title'] = 'Monthly ' + (current ? 'Water' : 'Tea') + ' Production by Country';

chart.draw(data[current], options);
}
drawChart();

function drawChart() {
// Disabling the button while the chart is drawing.
button3.disabled = true;
google.visualization.events.addListener(chart, 'ready',
function() {
button3.disabled = false;
button3.value = 'Switch to ' + (current ? 'Water' : 'Bear');
});
options['title'] = 'Monthly ' + (current ? 'Bear' : 'Water') + ' Production by Country';

chart.draw(data[current], options);
}
drawChart();

button.onclick = function() {
current = 1-current+current;
drawChart();
}
button2.onclick = function() {
current = 1 - current + current + 1 ;
drawChart();
}
button3.onclick = function() {
current = 1- current + 1 + 2 +current + 1;
drawChart();
}


}
</script>

 

Este es mi codigo como ven las matrizes estan estaticas quiero hacerlas dinamicas que traiga los valores del access