Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.util.HashMap;
- public class Sample {
- static Connection conn;
- static PreparedStatement stmt;
- static ResultSet rs;
- String sql;
- static String project="Project1";
- public static HashMap< String, String> map = new HashMap< String, String>();
- public static void main(String[] args) {
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn=DriverManager.getConnection("jdbc:mysql://localhost:3309/graphvalue","root","root");
- stmt=conn.prepareStatement("select * from TestCase where ProjectName= ?");
- stmt.setString(1,project);
- rs=stmt.executeQuery();
- while(rs.next())
- {
- System.out.println(rs.getString(1)+" "+rs.getInt(2)+" "+rs.getInt(3)+" "+rs.getInt(4)+" "+rs.getInt(5));
- map.put("ProjectName", rs.getString(1));
- map.put("Total TestCase", String.valueOf(rs.getInt(2)));
- map.put("TestCase Executed", String.valueOf(rs.getInt(3)));
- map.put("Failed TestCase", String.valueOf(rs.getInt(4)));
- map.put("TestCase Not Executed", String.valueOf(rs.getInt(5)));
- System.out.println("ProjectName "+map.get("ProjectName"));
- }
- conn.close();
- }
- catch(Exception e)
- { System.out.println(e);}
- }
- }
- ProjectName TotalTestCase TestCaseExecuted TestCaseFailed TestCaseNotExecuted
- Project1 50 30 8 20
- <html>
- <head>
- </head>
- <body>
- <select id="ChartType" name="ChartType" onchange="drawChart()">
- <option value = "PieChart">Select Chart Type
- <option value="PieChart">PieChart
- <option value="Histogram">Histogram
- <option value="LineChart">LineChart
- <option value="BarChart">BarChart
- </select>
- <div id="chart_div" style="border: solid 2px #000000;"></div>
- <p id="demo"></p>
- <p id="demo1"></p>
- <script type="text/javascript" src="https://www.google.com/jsapi"></script>
- <script type="text/javascript">
- var row = [];
- var temp;
- var stri;
- google.load('visualization', '1.0', {'packages':['corechart']});
- google.setOnLoadCallback(getValues);
- function getValues() {
- var xmlhttp = new XMLHttpRequest();
- xmlhttp.onreadystatechange = function() {
- if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
- stri = xmlhttp.responseText;
- drawChart();
- }
- };
- xmlhttp.open("GET", "sample.java", true);
- xmlhttp.send();
- }
- function drawChart() {
- var data = new google.visualization.DataTable();
- str = stri.split(",");
- // How to call the value from java file so that I will be able to draw the below graph by passing the value.
- data.addRows(row);
- var a = document.getElementById("ChartType").value;
- document.getElementById("demo1").innerHTML = "You selected: " + a;
- var options = {'title':'How Much Pizza I Ate Last Night',
- 'width':400,
- 'height':300
- };
- var chart = new google.visualization[document.getElementById("ChartType").value](document.getElementById('chart_div'));
- chart.draw(data, options);
- }
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement