MultiDchartSQLHelp.jsp
4.64 KB
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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ include file="/mobilemode/init.jsp"%>
<html>
<head>
<title></title>
<style>
*{
font-family: 'Microsoft YaHei', Arial;
}
html,body{
height: 100%;
margin: 0px;
padding: 0px;
}
.dataTable{
border-collapse: collapse;
margin: 5px 0px;
}
.dataTable td{
border: 1px solid #ccc;
padding: 3px 10px;
}
.dataTable tr.header td{
font-weight: bold;
background-color: #f8f8f8;
}
</style>
<script type="text/javascript">
function onClose(){
if(top && top.closeTopDialog){
top.closeTopDialog();
}else{
window.close();
}
}
</script>
</head>
<body>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
RCMenu += "{关闭,javascript:onClose(),_top} " ;
RCMenuHeight += RCMenuHeightStep ;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<div>
<img src="/mobilemode/images/mec/DemoMultiDChart_wev8.png" style="width: 520px;height: 201px;">
</div>
<%if(user.getLanguage() == 7){ %>
<div style="padding-left: 15px;">
以上图中的IE使用人数图标为例，其SQL返回的数据如下：
<table class="dataTable">
<tr class="header">
<td>name</td>
<td>value</td>
<td>color</td>
</tr>
<tr>
<td>2011</td>
<td>677</td>
<td>#de9972</td>
</tr>
<tr>
<td>2012</td>
<td>752</td>
<td>#de9972</td>
</tr>
<tr>
<td>2013</td>
<td>822</td>
<td>#de9972</td>
</tr>
<tr>
<td>2014</td>
<td>878</td>
<td>#de9972</td>
</tr>
<tr>
<td>2015</td>
<td>871</td>
<td>#de9972</td>
</tr>
</table>
<div style="line-height: 20px;">
书写SQL语句时需要指明name列，value列和color列。如：<br/>
select columnname as <b>name</b>, columnvalue as <b>value</b>, columncolor as <b>color</b> from tablename<br/>
如果没有明确指明name列，将使用查询结果的第1列作为name列。<br/>
如果没有明确指明value列，将使用查询结果的第2列作为value列。<br/>
如果没有明确指明color列，将由系统自行分配颜色值。<br/>
所以下面的查询SQL也是可以的，只是颜色值会由系统指定:<br/>
select columnname, columnvalue from tablename
</div>
</div>
<%}else if(user.getLanguage() == 8){ %>
<div style="padding-left: 15px;">
The IE uses the number of people icon in the above figure as an example. The data returned by SQL is as follows:
<table class="dataTable">
<tr class="header">
<td>name</td>
<td>value</td>
<td>color</td>
</tr>
<tr>
<td>2011</td>
<td>677</td>
<td>#de9972</td>
</tr>
<tr>
<td>2012</td>
<td>752</td>
<td>#de9972</td>
</tr>
<tr>
<td>2013</td>
<td>822</td>
<td>#de9972</td>
</tr>
<tr>
<td>2014</td>
<td>878</td>
<td>#de9972</td>
</tr>
<tr>
<td>2015</td>
<td>871</td>
<td>#de9972</td>
</tr>
</table>
<div style="line-height: 20px;">
When writing a SQL statement, you need to specify the name column, the value column, and the color column. Such as:<br/>
select columnname as <b>name</b>, columnvalue as <b>value</b>, columncolor as <b>color</b> from tablename<br/>
If the name column is not explicitly specified, the first column of the query result will be used as the name column.<br/>
If the value column is not explicitly specified, the second column of the query result will be used as the value column.<br/>
If the color column is not explicitly specified, the color value will be assigned by the system itself.<br/>
So the following query SQL is also possible, but the color value will be specified by the system:<br/>
select columnname, columnvalue from tablename
</div>
</div>
<%}else if(user.getLanguage() == 9){ %>
<div style="padding-left: 15px;">
以上圖中的IE使用人數圖標為例，其SQL返回的數據如下：
<table class="dataTable">
<tr class="header">
<td>name</td>
<td>value</td>
<td>color</td>
</tr>
<tr>
<td>2011</td>
<td>677</td>
<td>#de9972</td>
</tr>
<tr>
<td>2012</td>
<td>752</td>
<td>#de9972</td>
</tr>
<tr>
<td>2013</td>
<td>822</td>
<td>#de9972</td>
</tr>
<tr>
<td>2014</td>
<td>878</td>
<td>#de9972</td>
</tr>
<tr>
<td>2015</td>
<td>871</td>
<td>#de9972</td>
</tr>
</table>
<div style="line-height: 20px;">
書寫SQL語句時需要指明name列，value列和color列。如：<br/>
select columnname as <b>name</b>, columnvalue as <b>value</b>, columncolor as <b>color</b> from tablename<br/>
如果沒有明確指明name列，將使用查詢結果的第1列作為name列。<br/>
如果沒有明確指明value列，將使用查詢結果的第2列作為value列。<br/>
如果沒有明確指明color列，將由系統自行分配顏色值。<br/>
所以下面的查詢SQL也是可以的，只是顏色值會由系統指定:<br/>
select columnname, columnvalue from tablename
</div>
</div>
<%}%>
</body>
</html>