Guriddo » legalizeSINCE88's Replies

legalizeSINCE88

Guriddo

Forum Replies Created

Viewing 1 replies (of 1 total)

Author

Replies

July 1, 2014 at 1:05 pm in reply to: Jqgrid with Servlet and MySql not working #88308

legalizeSINCE88

Participant

@legalizeSINCE88 said:
Hello,

Â

i have the following code:

Â

<div class="sfcode">"package server; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONArray;import net.sf.json.JSONObject; import org.json.simple.JSONValue; @WebServlet("/servlet")publicclass servlet extendsHttpServlet{privatestaticfinallong serialVersionUID =1L;public servlet(){super();}protectedvoid doPost(HttpServletRequest request,HttpServletResponse response)throwsServletException,IOException{ doGet(request, response);}protectedvoid doGet(HttpServletRequest request,HttpServletResponse response)throwsServletException,IOException{ response.setContentType("application/json"); PrintWriterout= response.getWriter(); JSONObject responseData=newJSONObject(); JSONArray jArray=newJSONArray(); try{ Class.forName("com.mysql.jdbc.Driver"); Connection con =DriverManager.getConnection("jdbc:mysql://localhost:8080/neue","*****","****"); PreparedStatement prepared = con.prepareStatement("Select * from person"); ResultSet rs = prepared.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); int numberOfColumns = rsmd.getColumnCount(); while(rs.next()){ JSONObject jObject=newJSONObject(); JSONArrayJarr=newJSONArray(); Jarr.add(rs.getString("a")); Jarr.add(rs.getString("b")); Jarr.add(rs.getString("c")); Jarr.add(rs.getString("d")); Jarr.add(rs.getString("e")); jObject.put("cell",Jarr); jArray.add(jObject); } responseData.put("total",5); responseData.put("page",1); responseData.put("records",numberOfColumns); responseData.put("rows",jArray);out.println(JSONValue.toJSONString(responseData)); }catch(Exception e){} } " And my script.js file looks like this: </div>

1
2
3
4
5
6
7
8
9
10
11

<div class="sfcode">"package server; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONArray;import net.sf.json.JSONObject; import org.json.simple.JSONValue; @WebServlet("/servlet")publicclass servlet extendsHttpServlet{privatestaticfinallong serialVersionUID =1L;public servlet(){super();}protectedvoid doPost(HttpServletRequest request,HttpServletResponse response)throwsServletException,IOException{ 
doGet(request, response);}protectedvoid doGet(HttpServletRequest request,HttpServletResponse response)throwsServletException,IOException{ 
 
response.setContentType("application/json"); PrintWriterout= response.getWriter(); JSONObject responseData=newJSONObject(); JSONArray jArray=newJSONArray(); try{ Class.forName("com.mysql.jdbc.Driver"); Connection con =DriverManager.getConnection("jdbc:mysql://localhost:8080/neue","*****","****"); PreparedStatement prepared = con.prepareStatement("Select * from person"); ResultSet rs = prepared.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); int numberOfColumns = rsmd.getColumnCount(); while(rs.next()){ JSONObject jObject=newJSONObject(); JSONArrayJarr=newJSONArray(); Jarr.add(rs.getString("a")); Jarr.add(rs.getString("b")); Jarr.add(rs.getString("c")); Jarr.add(rs.getString("d")); Jarr.add(rs.getString("e")); 
jObject.put("cell",Jarr); 
jArray.add(jObject); } 
responseData.put("total",5); 
responseData.put("page",1); 
responseData.put("records",numberOfColumns); 
 
responseData.put("rows",jArray);out.println(JSONValue.toJSONString(responseData)); }catch(Exception e){} } " And my script.js file looks like this: </div>

<div class="sfcode">"$(document).ready(function(){ $("#list").jqGrid({ url:'servlet', datatype:"json", mtype :'get', colNames:['a','b','c','d','e'], colModel:[{name:'a',index:'a', width:75},{name:'b',index:'b', width:90},{name:'c',index:'c', width:100},{name:'d',index:'d', width:80,align:"right"},{name:'e',index:'e', width:80, align:"right"},], rowNum:10, autowidth:true, rowList:[10,20,30], pager: jQuery('#pager'), sortname:'id', viewrecords:true, sortorder:"desc", caption:"JSON Example", jsonReader:{ repeatitems:false, id:"0", cell:"", root:"rows", page:function(){return1;}, total:function(){return1;}, records:function(obj){return obj.length;}}}).navGrid('#pager',{edit:false,add:false,del:false});</div>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

<div class="sfcode">"$(document).ready(function(){ 
$("#list").jqGrid({ 
url:'servlet', 
datatype:"json", 
mtype :'get', 
colNames:['a','b','c','d','e'], 
colModel:[{name:'a',index:'a', width:75},{name:'b',index:'b', width:90},{name:'c',index:'c', width:100},{name:'d',index:'d', width:80,align:"right"},{name:'e',index:'e', width:80, align:"right"},], 
 
rowNum:10, 
autowidth:true, 
rowList:[10,20,30], 
pager: jQuery('#pager'), 
sortname:'id', 
viewrecords:true, 
sortorder:"desc", 
caption:"JSON Example", 
jsonReader:{ 
repeatitems:false, 
id:"0", 
cell:"", 
root:"rows", 
page:function(){return1;}, 
total:function(){return1;}, 
records:function(obj){return obj.length;}}}).navGrid('#pager',{edit:false,add:false,del:false});</div>

} " But my table is empty. Nothing happens. The only thing i get from the server is this message(Firebug): Status-Code: 500 Internal Server Error IÂ´ve tried to set a breakpoint in my code and run in debug-mode but it also not work. Can somewone please help me Many thanks 

1

} " But my table is empty. Nothing happens. The only thing i get from the server is this message(Firebug): Status-Code: 500 Internal Server Error IÂ´ve tried to set a breakpoint in my code and run in debug-mode but it also not work. Can somewone please help me Many thanks

Author

Replies

Viewing 1 replies (of 1 total)