I haven't used the java API, so I can't help you set it up, but it should be capable of reading from your existing database. Maybe someone else on the forums has experience with it and can chime in here?
On Wednesday, June 19, 2013 4:46:32 AM UTC-4, Benjamin Bandali wrote: > > The API-that you sent puts in datasource from the beginning in a table. I > want the charts to integrate with my MySQL database since the database in > on a company. I know that you can do this somehow with the API that you > sent, but dont know why. > > Den tisdagen den 18:e juni 2013 kl. 18:17:00 UTC+2 skrev asgallant: >> >> You are using java, right? If so, the you can use the API I linked above >> to hook into your database and handle the queries. You use a SQL-like >> language in javascript to query the data source API. None of this requires >> any changes to your database, nor does it require PHP. >> >> On the javascript end of things, the Visualization API takes the data >> returned by the query and inputs it into a DataTable object (which is the >> data structure required by the charts). There isn't any way to plug the >> charts directly into your MySQL database if that is what you were hoping >> for. >> >> On Tuesday, June 18, 2013 4:10:23 AM UTC-4, Benjamin Bandali wrote: >>> >>> But I have used SQL, and this doesent seem to work with it? I mean it >>> implements a new data table, I wanna use the exisiting one that I created >>> in mySQL and intregate it with Google Charts. Are there any ways? Without >>> php. >>> >>> Den måndagen den 17:e juni 2013 kl. 18:29:24 UTC+2 skrev asgallant: >>>> >>>> There is a Java datasource library that might be helpful for you: >>>> https://developers.google.com/chart/interactive/docs/dev/dsl_intro. >>>> It implements the SQL-like Query API for fetching data for a >>>> visualization. >>>> >>>> On Monday, June 17, 2013 8:47:28 AM UTC-4, Benjamin Bandali wrote: >>>>> >>>>> I have this database with this table that I want to put in on my .jsp >>>>> page that I coded in basic HTML. The project is in Spring mvc. >>>>> >>>>> CREATE TABLE `status` ( >>>>>> `idStatus` int(11) NOT NULL AUTO_INCREMENT, >>>>>> `timeStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, >>>>>> `value` varchar(45) NOT NULL, >>>>>> `unit` varchar(45) NOT NULL, >>>>>> `idCategory` int(11) NOT NULL, >>>>>> PRIMARY KEY (`idStatus`), >>>>>> UNIQUE KEY `idStatus_UNIQUE` (`idStatus`), >>>>>> KEY `timeStampIndex` (`timeStamp`), >>>>>> KEY `statusTocategory_idx` (`idCategory`), >>>>>> CONSTRAINT `statusTocategory` FOREIGN KEY (`idCategory`) REFERENCES >>>>>> `category` (`idCategory`) ON DELETE NO ACTION ON UPDATE NO ACTION >>>>>>> >>>>>>> ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8$$ >>>>>> >>>>>> >>>>> So far I can get the basic google line chart on the webpage, but not >>>>> with the values. I want it o show the Value based on time. >>>>> This is the code I have so far: >>>>> >>>>> <head> >>>>> <script type="text/javascript" >>>>> src="https://www.google.com/jsapi";></script><script >>>>> type="text/javascript"> >>>>> google.load("visualization", "1", { >>>>> packages : [ "corechart" ] >>>>> }); >>>>> google.setOnLoadCallback(drawChart); >>>>> function drawChart(serverData) { >>>>> >>>>> var serverData = [ [ 'Year', 'Sales', 'Expenses' ], >>>>> [ '2004', 1000, 400 ], [ '2005', 1170, 460 ], >>>>> [ '2006', 660, 1120 ], [ '2007', 1030, 540 ] ]; >>>>> var data = google.visualization.arrayToDataTable(serverData); >>>>> >>>>> var options = { >>>>> title : 'Company Performance' >>>>> }; >>>>> >>>>> var chart = new google.visualization.LineChart(document >>>>> .getElementById('chart_div')); >>>>> chart.draw(data, options); >>>>> }</script> >>>>> </head> >>>>> >>>>> >>>>> >>>>> How can I replace the Serverdata inputs with Value over time? (I don't >>>>> have any knowledge in php) The google code is in javascript, but does it >>>>> work to merge it with pure java or php code? Please help! >>>>> >>>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
