Share on Google+Share on Google+

Ahmad
Sort Result set
1 Answer(s)      6 years ago
Posted in : JSP-Servlet

I build a connect for my page with the database and then read all rows and show it in a table, I want to change the view of my data to be sorted uppon a specific column when click on the column name, so what to do? I think of two choices: 1- if the column name is a button. 2- if the column name is a hyperlink.

also how to delete a row from the table? if I have a button beside each row called delete, if you have a better idea please get it for me but please I need the easer one.

for the both I don't know how to connect the code and how call a function to do sorting and reiew data again. pleasse I need a complete example

thanks Jar

Ads

View Answers

April 9, 2011 at 4:08 PM


Hi,

Have a look at the following link: Shorting Table View By Column Name

Thanks










Related Tutorials/Questions & Answers:
Sort Result set
Sort Result set   I build a connect for my page with the database and then read all rows and show it in a table, I want to change the view of my data to be sorted uppon a specific column when click on the column name, so what
Result=Set - Java Beginners
result set, first move the pointer from first record to last record and get...Result=Set  Hi Friend, Can u tell how to get the count of records. in a select operation like sqlstmt="SELECT * FROM search_log_tab WHERE
Advertisements
how to sort the result of this 2 class program in java.....????
how to sort the result of this 2 class program in java.....????  package setget1_method; import java.util.Scanner; public class Main { { { Scanner input = new Scanner(System.in); LBook[] book = new LBook[5]; String
Result Set one to many mapping
Result Set one to many mapping  Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D has one... Suppose result contains single entry of One record for A, Two records for B
java.sql.SQLExceptioan: Before start of result set - JDBC
java.sql.SQLExceptioan: Before start of result set   java.sql.SQLException: Before start of result set?what do i do?   Hi Friend... accessing the result like the following: while(resultSet.next()){ String st
Hibernate Narrowing Criteria Result Set
Hibernate Narrowing Criteria Result Set In this tutorial you will learn how to narrow the Criteria result set. In Hibernate result set can be narrowed... how can you narrow the result set. For creating this example at first I have
how to chech result set is null or not - Java Beginners
how to chech result set is null or not  Hi, really very thanks for fast reply.I want to know how to check whether the result set is null or not in jsp.Please help me thanks, sakthi  Hi friend, Code to help
How to add a columns with a button set to a Jtable built with database result set
How to add a columns with a button set to a Jtable built with database result set  hi, i have to build a gui to display account numbers and account... that button column to the table which is built with database result set. i would thank
How can we find the number of rows in a result set using PHP?
How can we find the number of rows in a result set using PHP?   How can we find the number of rows in a result set using PHP
how to store the REsult Set values in array and loop through it in java?
how to store the REsult Set values in array and loop through it in java?  I have two tables Slink and Locate Slink has column name Slinkid ,locate has Locateid,Slinkid. Slink has 9 rows 1,2,3,4,5,6,7,8,9 Locate has
how to store the REsult Set values in array and loop through it in java?
how to store the REsult Set values in array and loop through it in java?  I have two tables Slink and Locate Slink has column name Slinkid ,locate has Locateid,Slinkid. Slink has 9 rows 1,2,3,4,5,6,7,8,9 Locate has
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?  How many ways we can retrieve the date in result set of mysql using php
Sort
Sort  program to sort a list of numbers in decendimg order   Hi Friend, Try the following code: import java.util.*; class SortListInDescendingOrder{ public static void main(String[] args
Mysql ASC Order
; Mysql ASC Order is used to sort the result set by ascending or descending order. The Order by CLAUSE sort the result by specified column. Understand... | +------+---------+ Query The Query given below sort the records from 'stu' in ascending order
Hibernate Criteria Setfirst Result
Hibernate Criteria SetFirstResult Result The setFirstResult of hibernate criteria API is used for setting no of records to be fetched from the table criteria.setFirstResult(1); An example of set first is given below
How to sort the rows in SQL?
in your result set. The ORDER BY clause can only be used in SELECT statements... expression ORDER BY column ASC / DESC; The ORDER BY clause sorts the result set...How to sort the rows in SQL?  How to sort the rows in SQL?  
SQL ORDER BY
; The ORDER BY keyword sort the table result set by a specified column. You want to sort the records in ascending order,  you can use the ASC keyword... BY keyword sort the table result set by a specified column
SEARCH AND SORT
SEARCH AND SORT  Cam any one provide me the code in java that : Program to search for MAX,MIN and then SORT the set using any of the Divide and conquer method
bubble sort
bubble sort  how to calculate the number of passes in bubble sort
insertion sort
insertion sort  how many arrays needed for insertion sort and why
bubble sort
bubble sort  write a program in java using bubble sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
Array sort
Array sort  Program that uses a function to sort an array of integers
Tutorials   
Java Spring Hibernate Struts Training fat image from db fat image from db fat image from db fat image from db unable to get value returned from javascript variable in page How to change image size before adding to mysql using jsp Design a registration.jsp page with input for user registration details Cart Quantity jsp servlet coding issue servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? servlet,jsp login registration forms without database in ecalipse ide using hashmap to store the registraion details ? image pdf marking pdf marking Multiple image upload using JSP Read code from excel sheet and upload into database using JSP Student java about search engine Convert BLOB to PDF and save it to a location how to copy files from remote to local machine using SFTP SSL in java? Like Team viewer Socket and Servert -Jsp how to copy files from remote location to local using java? How To Store Multilple Images In MySQL database dynamically with image uploader and then retrieve them in image gallery using java how to create SOAP based web service in java? how to fetch data from mysql database table and draw a bar chart on that data using in jsp how to create users in LDAP using java? how to authenticate user using TIVOLI api in java? how to create users using IBM Tivoi API in jsp/servelet? Java/J2ee Please explain this code as many packages and classes are unknown to me .! how to download the uploaded folder files using jsp Login Query image is display from path of mysql database please reply the code to store dynamic fields in database? Reloading issue in jsp How to get Button Id ? calling one jap page from another jsp page login login Problem to get connection from DAO class to JDBC Page Loading Time Fix table's column's name row(1st row of the table) so that it does not move up when the table is scrolled up to view more rows below Sending hidden values

Ads

 
Advertisement null

Ads