JQuery "DataTables" - Plugin
Hello everyone,
i have this code which is called 'tab.jsp':
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/media/images/favicon.ico" />
<title>DataTables example</title>
<link rel="stylesheet" type="text/css" href="media/css/jquery.dataTables.css">
<link rel="stylesheet" type="text/css" href="css/dataTables.tableTools.css">
<link rel="stylesheet" type="text/css" href="examples/resources/syntax/shCore.css">
<link rel="stylesheet" type="text/css" href="examples/resources/demo.css">
<script type="text/javascript" language="javascript" src="media/js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="media/js/jquery.dataTables.js"></script>
<script type="text/javascript" language="javascript" src="js/dataTables.tableTools.js"></script>
<script type="text/javascript" language="javascript" src="examples/resources/syntax/shCore.js"></script>
<script type="text/javascript" language="javascript" src="examples/resources/demo.js"></script>
<script type="text/javascript" charset="utf-8">
var oTable;
$(function () {
oTable = $("#datatables").dataTable({
"sDom": 'T<"clear">lfrtip',
"sPaginationType": "full_numbers",
"bProcessing": false,
"bServerSide": true,
"sAjaxSource": "server/server_v",
"bJQueryUI": true,
"oLanguage": {
"sProcessing": "Bitte warten...",
"sLengthMenu": "_MENU_ Einträge anzeigen",
"sZeroRecords": "Keine Einträge vorhanden.",
"sInfo": "_START_ bis _END_ von _TOTAL_ Einträgen",
"sInfoEmpty": "0 bis 0 von 0 Einträgen",
"sInfoFiltered": "(gefiltert von _MAX_ Einträgen)",
"sInfoPostFix": "",
"sSearch": "Suchen",
"sUrl": "",
"oPaginate": {
"sFirst": "Erster",
"sPrevious": "Zurück",
"sNext": "Nächster",
"sLast": "Letzter"
}
},
"tableTools" : {
"sSwfPath": "media/swf/copy_csv_xls_pdf.swf",
"aButtons": [
{
"sExtends": "collection",
"sButtonText": "Speichern als...",
"aButtons": [
{
"sExtends": "csv",
"sButtonText": "CSV"
},
{
"sExtends": "xls",
"sButtonText": "XLS"
},
{
"sExtends": "pdf",
"sButtonText": "PDF",
"sPdfOrientation": "landscape",
"sTitle": "Abfrage vom: ",
"sFileName": "*_Benjamin.pdf",
"sPdfMessage": "This is a testmessage.",
"mColumns": "sortable"
},
]
},
{
"sExtends": "print",
"sButtonText": "Drucken",
"sInfo": "Bitte nutzen Sie zum Drucken Ihren Broswer.\n Zum schließen 'ESC' drücken "
}
]
}
});
});
function druck()
{
var sData = oTable.$('input').serialize();
alert( "Folgende Zeile(n) wurden ausgewählt: \n\n"+sData );
return false;
}
</script>
<style type="text/css">
.wrapper{width: 900px;margin: 0 auto;}
</style>
</head>
<body>
<div class="wrapper">
<table id="datatables" class="display">
<thead>
<tr>
<th>Vorname</th>
<th>Nachname</th>
<th>AliasName</th>
</tr>
</thead>
<tbody>
<tr>
<td>${vorname }</td>
<td>${nachname }</td>
<td>${aliasName }</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
and this servlet "server_v":
package server;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.json.simple.JSONArray;
import org.json.simple.JSONObject;
public class server_v extends HttpServlet {
private static final long serialVersionUID = 1L;
private PrintWriter out;
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;
private JSONObject object;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("application/json");
try
{
out = response.getWriter();
Class.forName("com.jdbc.mysql.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:8080/personendaten","benni","counting88");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM kunden");
object= new JSONObject();
while(rs.next())
{
object.put("vorname", rs.getString("Vorname"));
object.put("nachname", rs.getString("Nachname"));
object.put("aliasName", rs.getString("AliasName"));
}
}catch(Exception e)
{
e.printStackTrace();
}
out.print(object);
out.flush();
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
My Problem is, that i get this error Message everytime i start:
"DataTables warning:table id=datatables - Ajax error"
why i get this error?
Thanks
-legalizeSINCE88-
DataTables example