datagrid

please send datagrid in jsp lot fields including date

View Answers

August 21, 2012 at 4:48 PM

Here is an example of jsp datagrid.In the given code,we have created the database table student(rollNo,name,address,dateOfBirth).

<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%!
public int nullIntconvert(String str){
int num=0;
if(str==null) {
str="0";
}
else if((str.trim()).equals("null")) {
str="0";
}
else if(str.equals("")) {
str="0";
}
try{
num=Integer.parseInt(str);
}
catch(Exception e) { }
return num;
}
%>
<%
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
ResultSet rs1 = null;
ResultSet rs2 = null;
PreparedStatement ps1=null;
PreparedStatement ps2=null;

int showRows=10;
int totalRecords=10;
int totalRows=nullIntconvert(request.getParameter("totalRows"));
int totalPages=nullIntconvert(request.getParameter("totalPages"));
int iPageNo=nullIntconvert(request.getParameter("iPageNo"));
int cPageNo=nullIntconvert(request.getParameter("cPageNo"));

int startResult=0;
int endResult=0;
if(iPageNo==0) {
iPageNo=0;
}
else{
iPageNo=Math.abs((iPageNo-1)*showRows);
}
String query1="SELECT SQL_CALC_FOUND_ROWS * FROM student limit "+iPageNo+","+showRows+"";
ps1=conn.prepareStatement(query1);
rs1=ps1.executeQuery();

String query2="SELECT FOUND_ROWS() as cnt";
ps2=conn.prepareStatement(query2);
rs2=ps2.executeQuery();
if(rs2.next()) {
totalRows=rs2.getInt("cnt");
}
%>
<html>
<h3>Pagination of JSP page</h3>
<body>
<form>
<input type="hidden" name="iPageNo" value="<%=iPageNo%>">
<input type="hidden" name="cPageNo" value="<%=cPageNo%>">
<input type="hidden" name="showRows" value="<%=showRows%>">
<table width="100%" cellpadding="0" cellspacing="0" border="1" >
<tr>
<td>Roll No</td>
<td>Name</td>
<td>Address</td>
<td>Date Of Birth</td>
</tr>
<%
while(rs1.next()) {
    java.sql.Date dbSqlDate = rs1.getDate("dateOfBirth");
    java.util.Date date = new java.util.Date(dbSqlDate.getTime());
    SimpleDateFormat sdf=new SimpleDateFormat("dd-MM-yyyy");
%>
<tr>
<td><%=rs1.getInt("rollNo")%></td>
<td><%=rs1.getString("name")%></td>
<td><%=rs1.getString("address")%></td>
<td><%=sdf.format(date)%></td>
</tr>
<%
}
%>
<%
try{
if(totalRows<(iPageNo+showRows)) {
endResult=totalRows;
}
else{
endResult=(iPageNo+showRows);
}
startResult=(iPageNo+1);
totalPages=((int)(Math.ceil((double)totalRows/showRows)));
}
catch(Exception e){
e.printStackTrace();
}
%>
<tr>
<td colspan="3">
<div>

August 21, 2012 at 4:49 PM

continue..

<%
    int i=0;
    int cPage=0;
    if(totalRows!=0) {
    cPage=((int)(Math.ceil((double)endResult/(totalRecords*showRows))));

    int prePageNo=(cPage*totalRecords)-((totalRecords-1)+totalRecords);
    if((cPage*totalRecords)-(totalRecords)>0){
    %>
    <a href="pagination.jsp?iPageNo=<%=prePageNo%>&cPageNo=<%=prePageNo%>"> << Previous</a>
    <%
    }
    for(i=((cPage*totalRecords)-(totalRecords-1));i<=(cPage*totalRecords);i++){
    if(i==((iPageNo/showRows)+1)){%>
    <a href="pagination.jsp?iPageNo=<%=i%>" style="cursor:pointer;color: red"><b><%=i%></b></a>
    <%
    }
    else if(i<=totalPages){
    %>
    <a href="pagination.jsp?iPageNo=<%=i%>"><%=i%></a>
    <%
    }
    }
    if(totalPages>totalRecords && i<totalPages){
    %>
    <a href="pagination.jsp?iPageNo=<%=i%>&cPageNo=<%=i%>"> >> Next</a>
    <%
    }
    }
    %>
    <b>Rows <%=startResult%> - <%=endResult%> Total Rows <%=totalRows%> </b>
    </div>
    </td>
    </tr>
    </table>
    </form>
    </body>
    </html>

August 21, 2012 at 4:50 PM

Name above jsp code to pagination.jsp

August 21, 2012 at 4:51 PM

You can also visit the following links:

http://www.roseindia.net/jsp/data-grid.shtml

http://www.roseindia.net/jsp/paging.shtml

August 21, 2012 at 5:14 PM

thank you sir but i want to display grid view is contain scroll bars and if we want to select one row depending upon one column i want update the records details also

please send urgent i will submit the project in 5days

Advertisements

DataGrid in flex
DataGrid in flex Hi..... Please tell me about DataGrid extends which class? please give me the syntax......... Thanks

DataGrid in flex
DataGrid in flex Hi....... I want to know about How do you access methods in DataGrid from external itemRenderers? please give an example so i can clearly understand.... Thanks

DataGrid in flex
DataGrid in flex Hi.... What kind of data grids you can create through Flex applications? please tell me about the datagrid so i can implement it in my application .... Thanks

Datagrid not working
Datagrid not working The code here is working fine, apart from... the datagrid tag gives an error saying that the items attribute does not accept ant... This works fine for datagrid but then the javascript for drop down menu stops

ArrayCollection in DataGrid
ArrayCollection in DataGrid Hi.... I want to know about What are the advantages of using arraycollection as a dataprovider instead of array in DataGrid? please give the ans ASAP....... Thanks

DataGrid in flex
DataGrid in flex Hi........ Please provide the solution of that problem When I add or modify an item in my dataProvider, why doesn't it show up in my DataGrid? Thanks in advance Ans: When you work

DataGrid in flex
DataGrid in flex Hi.... please provide the solution of that problem When I have only a single record, why doesn't it appear in my DataGrid? please give an example Thanks Ans: This is a caused in flex

jsp-datagrid
jsp-datagrid hello sir.....i have 20 records in my database and i am showing those data in datagrid view but now i want to show 10 data in one page... option in my datagrid view with 1,2 pages....plz help me...awaiting for your

editable datagrid
editable datagrid How to create a editable datagrid in jsp,struts1.3,glassfish v2.x application server and database oracle using netbeans6.8 ide? Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 http

DataGrid ItemRenderer
DataGrid ItemRenderer Hi... I have a datagrid which contains a Spark dropdownlist that needs to obtain dynamic data. The datagrid uses a separate..." chromeColor="#555555" color="#CCCCCC" backgroundColor="#000000"> <mx:DataGrid id

jsp-datagrid
jsp-datagrid hello sir...i have one view page in which edit and delete option are there in a datagrid view and i want to show data in page wise(pagination)...with previous and next links....i am also attaching my code for your

ModuleNotFoundError: No module named 'DataGrid'
ModuleNotFoundError: No module named 'DataGrid' Hi, My Python... 'DataGrid' How to remove the ModuleNotFoundError: No module named 'DataGrid... to install padas library. You can install DataGrid python with following

datagrid including combobox
datagrid including combobox please send datagrid in jsp using mysql database based on id in the datagrid select each record and also update record with available to old values updation is done in form wise. using combo box

datagrid in JSP - JSP-Servlet
datagrid in JSP sir i want code t create a datagrid view in JSP. I am using oracle 10g. please help me. Hi Friend, Please visit the following code: http://www.roseindia.net/jsp/data-grid.shtml Hope

Datagrid in JSP - JSP-Servlet
Datagrid in JSP I Want to display some record in datagrid of JSP page. I am using Apache tomcat server. please help me. Hi Friend, Please visit the following code: http://www.roseindia.net/jsp/data-grid.shtml

datagrid search - Hibernate
datagrid search Hi friend, i have displayed a datagrid using jsp but i need a search option in that which is used to display and sort it in a alphabetical order.... pls help me... Thanks in advance... �

ModuleNotFoundError: No module named 'django-datagrid'
ModuleNotFoundError: No module named 'django-datagrid' Hi, My... named 'django-datagrid' How to remove the ModuleNotFoundError: No module named 'django-datagrid' error? Thanks Hi, In your python

DataGrid without DataBase
DataGrid without DataBase I want display list of data without using database. Ex- Employee have some elements like- name, sex, place, designation. I have to display the content of these elements but without having

ComboBox ItemRenderer in DataGrid
ComboBox ItemRenderer in DataGrid Hi..... How can I create custom combo box itemtenderer in the flex datagrid? please give me an example.....ADS...="#000000"> <mx:DataGrid id="myDG" dataProvider="{myDP

How to get data datagrid ?
How to get data datagrid ? How to get data datagrid in jsp from arrayList in java? Code in java CategoryDao dao = new CategoryDao(); ArrayList<Categories> lstCategory = new ArrayList<Categories>

ModuleNotFoundError: No module named 'drf-dx-datagrid'
ModuleNotFoundError: No module named 'drf-dx-datagrid' Hi, My... named 'drf-dx-datagrid' How to remove the ModuleNotFoundError: No module named 'drf-dx-datagrid' error? Thanks Hi, In your python

DataGrid Control in Flex4
DataGrid control in Flex4: The DataGrid control is a MX component. There is no spark component. DataGrid Control is like a Table in html. The DataGrid.... It supports for paging. You can use ArrayList or AvtionScript for creating a DataGrid

DataGrid in Flex
Adobe Flex DataGrid: In Flex, DataGrid is a kind of list which can display... column. Adobe Flex DataGrid provides many features like columns can be resized... Flex Datagrid Example 1: <?xml version="1.0" encoding="utf-8

How can i write a datagrid coding - Java Beginners
How can i write a datagrid coding Hi, I want make a datagrid..plz send me datagrid coding using mysql database and jsp..plz tell me brief description about grid how can i connect datagrid with database. Thanks

how to make a matrix like datagrid in ide in java pls help
how to make a matrix like datagrid in ide in java pls help how to make a datagrid mainly matrix in ajava standalone app

Flex DataGrid control
DataGrid in Flex:- A DataGrid is a control in flex which is display data... and display via custom renderers. The main features of the DataGrid is that, you can... a DataGrid and what is the procedure to provide data by array collection. ADS

I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid.
I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid. I want to Populate ComBobox value from database that combox is Itemrenderer of DataGrid

How to add a DropDown List in Flex DataGrid
a DropDownList in a DataGrid table. After the user selects one of the items from... a dropDownList in dataGrid. Pls can u tell me how the selected item in my dropdownlist can be recognize and update the value of the cell in the dataGrid and save

JSP Paging Example in Datagrid - JSP-Servlet
JSP Paging Example in Datagrid Hi, I have tested JSP Paging Example in Datagrid which is available at the following url which i am able to run it successfully. http://www.roseindia.net/jsp/paging.shtml When i try

JSP Paging Example in Datagrid - JSP-Servlet
========================================= Paging Example Using Datagrid th a:link...-color: cyan; color: #000000;font-weight: bold } .datagrid { border

Java JTable Question or Datagrid - Java Beginners

how to pass the mutiple values from <Ui:datagrid hyperlink - JSP-Servlet

How to create a OLAP DataGrid in Flex4
How to create a OLAP DataGrid in Flex4: The following figure shows the procedure for create a OLAPDataGrid control. There are the following procedure for create a OLAPDataGrid: 1.Start with a flat data in a local collection

JSP Paging Example in Datagrid
JSP Paging Example in Datagrid In this section, we have developed a web application to create paging in JSP. Two files are used "paging.jsp" and "

AdvancedDataGrid Control in Flex4
AdvancedDataGrid control in Flex4: The AdvancedDataGrid control is same as a DataGrid control. It has a functionality of the standard DataGrid control. It provides the good control of data display and data formatting. You can provide

About OLAP Cube in OLAP DataGrid in Flex4
About OLAP Cube in OLAP DataGrid in Flex4: OLAP cube have many dimensions. Dimensions of an OLAP cube represent the field of the flat data. for example: value:Object = { product:"monitor" month :"Jan" price

About OLAP Schemas in OLAP DataGrid in Flex4
About OLAP Schemas in OLAP DataGrid in Flex4: OLAP Schema is used for to convert a flat data in to an OLAP cube. You will create OLAP schema which is used for defines the dimensions of the cube. The fields of the flat data that supply

SweetDEV RIA
SweetDEV RIA SweetDEV RIA contains widgets such as with Datagrid, Combo multiselect, Virtual window, Calendar, Click to open, Expand/Collapse, Excel export, client /server

Copying and Moving data using drag and drop
from list to dataGrid using different data formats in this example. When you...:DataGrid = DataGrid(event.currentTarget); var itemsVector:Vector.<...; <mx:DataGrid id="studentData" ADS_TO_REPLACE_26

Asp.net - Development process
Asp.net hi! how to display image in datagrid by using backend

how can i create a data grid - Java Beginners
plz help me i want make a datagrid but i have no idea about this how can i create datagrid. and how can i connect to the database plz help me give brief description abut datagrid using jsp and mysql. this information send

Ads