Forum
Log In
Home
Topic RSS
00:52
29/07/2009
Offline
<!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
(if this link is brokened, enter the URL Box again as same URL)
01:25
Moderators
30/10/2007
Offline
Hello,
Be a sure that all the needed modules are loaded - especially grid.formedit.js - See docs - installation
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
71 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
