krams on Problem when trying to use jqgrid with jsp

Mon, 13 Dec 2010 01:48:54 +0200

Check this tutorial I wrote:

http://krams915.blogspot.com/2.....ation.html

axel9641 on Problem when trying to use jqgrid with jsp

Tue, 07 Dec 2010 21:33:43 +0200

Hi everyone

I've trying to adapt the 'My First Grid' from the jqgrid wiki to use it with jsp instead of php, but I stil can do it.What do I need to change? Is it neccesary to add page,limit,count,total_pages, etc to the session?

public class MantenimientoPrueba implements Controller {

private Integer page;
private Integer limit;
private Integer count, total_pages, start;
private String sidx = null;
private String sord = null;
private String s = null;
HttpSession session = null;

public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws Exception {

session = request.getSession();

page = Integer.parseInt(request.getParameter("page"));
limit = Integer.parseInt(request.getParameter("rows"));

sidx = request.getParameter("sidx");
sord = request.getParameter("sord");

if (!sidx.equals("")) {
sidx = "invid";
}
RNPrueba facade = new RNPrueba();
List<Prueba> tab = new ArrayList(1);

//'ContarConsultarTodos' calculates the number of rows for the query
count = facade.ContarConsultarTodos();

if (count > 0 && limit > 0) {
total_pages = (int) (count / limit);
} else {
total_pages = 0;
}

if (page > total_pages) {
page = total_pages;
}

start = limit * page – limit;

if (start < 0) {
start = 0;
}
//'ConsultarTodos' gets all the rows
tab = facade.ConsultarTodos(sidx, sord, start, limit);
s = "<?xml version='1.0' encoding='utf-8'?>";
s += "<rows>";
s += "<page>" + page + "</page>";
s += "<total>" + total_pages + "</total>";
s += "<records>" + count + "</records>";

for (int i = 0; i < tab.size(); i++) {
s += "<row id='" + tab.get(i).getInvid() + "'>";
s += "<cell>" + tab.get(i).getInvid() + "</cell>";
s += "<cell>" + tab.get(i).getInvdate() + "</cell>";
s += "<cell>" + tab.get(i).getAmount() + "</cell>";
s += "<cell>" + tab.get(i).getTax() + "</cell>";
s += "<cell>" + tab.get(i).getTotal() + "</cell>";
s += "<cell><![CDATA[" + tab.get(i).getNote() + "]]></cell>";
s += "</row>";
}
s += "</rows>";
System.out.println(s);
return new ModelAndView("mantenimiento.prueba");
} }

Another thing I don't know how to adapt is this:


header("Content-type: text/xml;charset=utf-8");

And since the java code (shown above) inside the SourcePackages in a package called: 'Mantenimiento' I'd would like to know, how I have to call this file (MantenimientoPrueba.java) from my jsp file , that is where the jqgrid is.

$(function(){
$("#list").jqGrid({
url:'mantenimientoprueba.htm',
//...some other code

});

Should I use this url?, which is the name I give to MantenimientoPrueba.java in the spring-servlet.xml,or shoul I just use MantenimientoPrueba.java?

I really hope you can help me out,thanks in advance

PS:I'm using Jsp with Spring and … sorry for my bad English

jQuery Grid Plugin - jqGrid - Topic: Problem when trying to use jqgrid with jsp

krams on Problem when trying to use jqgrid with jsp

axel9641 on Problem when trying to use jqgrid with jsp