jQuery Grid Plugin - jqGrid - Topic: navGird is not displayed... http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed Simple:Press Version 5.7.5.3 wowjako on navGird is not displayed... http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed#p8120 Help http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed#p8120 Thank's Tony, I found the problem, it's a typo!!

 <script src="js/jqDnR.js" type="text/javascript"></script>

  I have wrote "js/jqDnr.js" until now.....

Now, it's OK. Thank's Tony

]]> Wed, 29 Jul 2009 01:41:34 +0300 tony on navGird is not displayed... http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed#p8118 Help http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed#p8118 Hello,

Be a sure that all the needed modules are loaded - especially grid.formedit.js - See docs - installation

Regards

Tony

]]> Wed, 29 Jul 2009 01:25:21 +0300 wowjako on navGird is not displayed... http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed#p8112 Help http://www.trirand.com/blog/?page_id=393/help/navgird-is-not-displayed#p8112 <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<title>jqGrid Demo</title>
 <link rel=”stylesheet” type=”text/css” media=”screen”  href=”themes/sand/grid.css”/>
 <link rel=”stylesheet” type=”text/css” media=”screen”  href=”themes/jqModal.css” />
 <style>
html, body {
    margin: 0;            /* Remove body margin/padding */
    padding: 0;
    algin: center;   
    overflow: hidden;    /* Remove scroll bars on browser window */   
    font: 15x “Lucida Grande”, “Lucida Sans Unicode”, Tahoma, Verdana;
    width: 100%;
    height: 100%;
}
</style>
 
 <script src=”js/jquery.js” type=”text/javascript”></script>
 <script src=”js/jquery.ui.all.js” type=”text/javascript”></script>
 <script src=”js/jquery.jqGrid.js” type=”text/javascript”></script>
 <script src=”js/jqModal.js” type=”text/javascript”></script>
 <script src=”js/jqDnr.js” type=”text/javascript”></script>
 <script type=”text/javascript” >
jQuery(document).ready(function () {
    jQuery(”#list”).jqGrid({
        url: 'jsonGetp' ,
        datatype: 'json',
        mtype: 'GET',
        colNames: ['Num', 'Date', 'Amount', 'Tax', 'Total', 'Notes'],
        colModel : [
            {name: 'invid', index:'invid', width:55},
            {name: 'invdate', index: 'invdate', width:100},
            {name: 'amount', index: 'amount' , width:80, align:'right'},
            {name: 'tax', index:'tax', width:80, align:'right'},           
            {name: 'total', index:'total', width:80, align:'right'},
            {name: 'note', index:'note', width:150, sortable:false} ],
        pager: jQuery('#Pager'),       
        rowNum: 5 ,
        rowList: [5,10,20],
        sortname: 'invid',
        sortorder: “desc”,
        viewrecords: true,
        height: 350,
        width: 700,       
        imgpath: 'themes/sand/images',
        caption: 'My first grid'
    }).navGrid('#Pager',{edit:false,add:false,del:false});
});

</script>
 
</HEAD>

 <BODY>
    <table id=”list” class=”scroll” cellpadding=”0″ cellspacing=”0″></table>
    <div id=”Pager” class=”scroll” style=”text-align:center;” ></div>
 </BODY>
</HTML>

—- it's JQGrid.html

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.io.BufferedReader;
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.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import model.dto.JQGridJSONModel;
import model.dto.JQGridRow;
import model.Whatis;

import net.sf.json.JSONArray;
import net.sf.json.JSONSerializer;
import net.sf.json.JSONObject;

/**
 * Servlet implementation class jsonGetp
 */
public class jsonGetp extends HttpServlet {
    private static final long serialVersionUID = 1L;
      
    /**
     * @see HttpServlet#HttpServlet()
     */
   
   
    String driver = “oracle.jdbc.driver.OracleDriver”;
    String url = “jdbc:oracle:thin:@localhost:1521:XE”;
    String user = “user1″;
    String passwd  = “user1″;
   
    Connection conn = null;
    PreparedStatement ps = null;
    Statement st = null;
    ResultSet rs = null;
    int count;
    int total_pages;
   
    public jsonGetp() {
        super();
        // TODO Auto-generated constructor stub
       
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
       
   
       
        response.setContentType(”text/html;charset=euc-kr”);
        PrintWriter pw = response.getWriter();
       
        int page = Integer.parseInt(request.getParameter(”page”));       
        int limit = Integer.parseInt(request.getParameter(”rows”));
        String sidx = request.getParameter(”sidx”);
        String sord = request.getParameter(”sord”);
       
        System.out.println(page);
        System.out.println(limit);
        System.out.println(sidx);
        System.out.println(sord);
       
        if(sidx == null ) sidx = “1″;
       
            
       
        String sql = “select count(*) as count from invheader”;
       
        try {
                Class.forName(driver);
                conn = DriverManager.getConnection(url, user, passwd);
                st = conn.createStatement();
                rs = st.executeQuery(sql);
                while(rs.next())
                    count = rs.getInt(”count”);       
           
        }catch(SQLException ex)
        {
            System.out.println(ex);           
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            if ( rs != null)
                try {
                    rs.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            if ( st != null)
                try {
                    st.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            if ( conn != null)
                try {
                    conn.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
          }
       
  
     double ii = (double)count/(double)limit;
    
     if( count > 0 ) { total_pages = (int) Math.ceil(ii); }          
     else { total_pages = 0; } // if for some    
 
     
     if ( page  > total_pages)
         page=  total_pages; // calculate the starting position of the rows
     
     int start = limit*page – limit; // if for some reasons start position
     
     if(start <0) start = 0;
   
        JSONObject jsonOB = new JSONObject();       
       
        JQGridJSONModel json = new JQGridJSONModel();               
       
   
        ArrayList<JQGridRow> cell = new ArrayList<JQGridRow>();
               
        
        sql = “SELECT invid,invdate, amount, tax, total, note FROM (SELECT a.invid, a.invdate, a.amount, a.tax, a.total, a.note”   
                + “, ROWNUM num FROM ( select  invid, invdate, amount, tax, total, note from invheader” +  ” ORDER BY “+ sidx + ” ” + sord
                +    “)a WHERE ROWNUM <= ” + (start + limit) + “) WHERE num >= ” + (start + 1);       
       
                 
       
        json.setPage(page);
        json.setTotal(total_pages);
        json.setRecords(count);       
       
        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(url,user,passwd);
            st = conn.createStatement();
            rs = st.executeQuery(sql);
         
            while ( rs.next())
            {
                JQGridRow jq = new JQGridRow();
                List<String> n1 = new ArrayList<String>();       
                jq.setId(rs.getInt(”invid”));
                n1.add(rs.getString(”invid”));
                n1.add(rs.getString(”invdate”));
                n1.add(rs.getString(”amount”));
                n1.add(rs.getString(”tax”));
                n1.add(rs.getString(”total”));
                n1.add(rs.getString(”note”));
                jq.setCell(n1);                                  
                cell.add(jq);          
          
            }                   
       
        } catch(SQLException ex) {
           
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
           
        }

        json.setRows(cell);
               
        JSONArray arrayObj=new JSONArray();
 
        jsonOB = JSONObject.fromObject(JSONSerializer.toJSON(json));   
       
       
        System.out.println(jsonOB);
        pw.print(jsonOB);
       

       
    }

}
— It's jsonGetp.java

Here's my Code, I've run with Servlet/JSON/Oracle.

But NavGrid is not displayed…..( ex) add, refresh, edit, del…. there's buttons )

I add '.navGrid('#Pager',{edit:false,add:false,del:false});' end of jqgrid, but this is not displayed…

it's my running screen…

( in HTML, navGrid is displayed, But in SERVER RUN MODE, it's not displayed…why is this ? Please, teach for me..)

http://blogfiles15.naver.net/2.....ilpiyo.jpg

Image Enlarger

(if this link is brokened, enter the URL Box again as same URL)

]]> Wed, 29 Jul 2009 00:52:24 +0300