jQuery Grid Plugin - jqGrid

legalizeSINCE88 said
Hello,

 

i have the following code:

 

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

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

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