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
| <%@ page language="java" import="java.text.*, java.util.*,java.io.*,org.apache.poi.poifs.filesystem.POIFSFileSystem,org.apache.poi
.hssf.record.*,org.apache.poi.hssf.model.*,org.apache.poi.hssf.usermodel.*,java.sql.*" pageEncoding="UTF-8" %>
<%@ page import="java.sql.ResultSet" %>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>Details Participations</title>
<style type="text/css" title="currentStyle">
@import "datatable/media/css/demo_page.css";
@import "datatable/media/css/demo_table_jui.css";
@import "datatable/examples/examples_support/themes/smoothness/jquery-ui-1.8.4.custom.css";
</style>
<script type="text/JavaScript">
<!--
function timedRefresh(timeoutPeriod)
{
setTimeout("location.reload(true);",timeoutPeriod);
}
// -->
</script>
<script type="text/javascript" charset="utf-8" src="datatable/media/js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="datatable/media/js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="datatable/media/js/jquery.dataTables.js"></script>
<script type="text/javascript" language="javascript" src="datatable/media/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="dataTables.fnDraw.js"></script>
<script type="text/javascript" language="javascript" src="jquery/dataTables.tableTools.min.js"></script>
<script type="text/javascript" language="javascript" src="jquery/dataTables.tableTools.js"></script>
<script type="text/javascript" charset="utf-8">
var oTable;
$(document).ready(function () {
$('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "http://testXXXX.com/test/json.jsp",
"bDestroy": false,
"bRetrieve": true,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bStateSave": true,
"pages": "all",
"iDisplayLength": 10,
"dom": 'T<"clear">lfrtip',
"tableTools": {
"sSwfPath": "swf/copy_csv_xls.swf",
"aButtons": [
{
"sExtends": "xls",
"oSelectorOpts": { filter: 'applied', order: 'current' },
"sFileName": "Dlilek_mlak.xls"
},
{
"sExtends": "pdf",
"oSelectorOpts": { filter: 'applied', order: 'current' },
"sFileName": "Dlilek_Mlak.pdf",
"sPdfOrientation": "landscape",
"sPdfMessage": "Account List" + ($('div.dataTables_filter input').length > 0 ? " Filter: " + $('div.dataTables_filter input').val() : "")
},
{
"sExtends": "print",
"oSelectorOpts": { filter: 'applied', order: 'current' },
}
]
},
} );
} );
</script>
</head>
<body id="">
<div class="demo_jui">
<table cellpadding="0" cellspacing="0" align="center" border="0" class="display" id="example">
<thead>
<tr>
<th width="50" style="color:blue;">ID</th>
<th width="100" style="color:blue;">Phone</th>
<th width="300" style="color:blue;">Message</th>
<th width="150" style="color:blue;">Date</th>
</tr>
</thead>
</table>
</div>
</body>
</html> |
