-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathResults2.jsp
68 lines (52 loc) · 1.23 KB
/
Results2.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<%@page import ="java.util.*,java.text.SimpleDateFormat,java.util.Date,java.io.FileInputStream,java.io.FileOutputStream,java.io.PrintStream"%>
<%@page import ="java.sql.*"%>
<%@page import ="java.io.*"%>
<%@ page import="java.sql.*,java.util.Random"%>
<%@ include file="connect.jsp"%>
<%
try
{
ResultSet rs=connection.createStatement().executeQuery("select * from results");
%><html>
<head>
<title>Transaction Results</title>
<script type="text/javascript" src="sources/jscharts.js"></script>
</head>
<body>
<div id="graph">Loading graph...</div>
<script type="text/javascript">
var myData=new Array();
var colors=[];
<%
int i=0;
String s1=null;
while(rs.next())
{
s1=rs.getString(1);
int s3=Integer.parseInt(rs.getString(3));
%>
myData["<%=i%>"]=["<%= s1%>",<%= s3%>];
<%
i++;}
%>
var myChart = new JSChart('graph', 'bar');
myChart.setDataArray(myData);
myChart.setBarColor('#42aBdB');
myChart.setBarOpacity(0.8);
myChart.setSize(600,350);
myChart.setBarBorderColor('#D9EDF7');
myChart.setBarValues(true);
myChart.setTitleColor('#8C8383');
myChart.setAxisColor('#777E89');
myChart.setAxisValuesColor('#777E81');
myChart.draw();
</script>
</body>
</html>
<%
}
catch(Exception e)
{
e.printStackTrace();
}
%>