Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Shibin Varghese
Result=Set
3 Answer(s)      6 years and 4 months ago
Posted in : Java Beginners



Advertisement
View Answers

August 24, 2008 at 4:10 PM


use the scrollable result set, first move the pointer from first record to last record and get the count and then again place the pointer to the above first position.

hope your question resolved.


August 25, 2008 at 10:10 AM


hai frnd..
SELECT COUNT(*) FROM search_log-tab WHERE visible='v";
will return the exact number of rows....

Otherwise in the while loop,insert a count variable..and increment by one
while(rs.next())
{
count++;
}

hai shibin varghese are u frm kannur district of kerala?

Thanks and Reg/
Prashob
prashobvee@gmail.com


August 26, 2008 at 11:45 AM


Hi friend,

Read for more information.


http://www.roseindia.net/jsp/user-search.shtml


Thanks.

Amardeep


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
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
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
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 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 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 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
Iterating Through JDBC ResultSet
. The iteration depends on the types of the result set object 1. Forward Only.- In this type of result set object we move only from start to end i.e.... Scroll insensitive. This type of result set object is not capable for scrolling
SQL Aggregate Concatenate
; Sometimes it is required to combine the result set of  records... fields in Mysql : concat ( ): The Syntax is used to combine the result set from... by sub_id) returns the combine set of records in ascending order id. The Group
SQL UNION Operator
; The UNION operator combine the result-set of two or more... of UNION in SQL Query, The UNION query return you the set of distinct records... Result Stu_Id Stu_Name Stu_Class 1
JDBC Nested Resultset
you a code that helps in understanding JDBC Nested Result Set. The code include a class JDBC Nested Result Set, Inside the class we have a main method, follow... from a table and store the record set in a result set. The select statement
Mysql Group By
functions to group the result-set by specified one or more columns. Understand... 'employee' and group the result set by specified column 'empname... | +-------+----------+--------+------------+ 5 rows in set (0.00 sec) Query for viewing data using
Mysql Group By
to group the result-set by specified one or more columns. Understand with Example...' and group the result set by specified column 'empname'. mysql>... | +-------+----------+--------+------------+ 5 rows in set (0.00 sec) Query for viewing data using group
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.... Select * from Stu order by id ASC; Result
Mysql Alter View
not contain data. The view is the outcome result set of a SELECT statement... in set (0.00 sec) Query to create view of Table named employees... | 2008-12-23 | +---------+------------+ 2 rows in set (0.00 sec) Query
JDBC ResultSet Forward Type Example
JDBC ResultSet Forward Type Example: Through this ResultSet type the cursor only move forward in the result set and are non-scrollable. The following syntax are use for initialize the statement object to create a forward-only, read
SQL ORDER BY
; The ORDER BY keyword sort the table result set by a specified column. You... BY keyword sort the table result set by a specified column..._Name, Stu_Class FROM Stu_Table ORDER BY Stu_Name Result
SQL Alter View
SQL Alter View       View is a virtual and imaginary table come out as result -set of an SQL statement. A virtual table contains rows and columns, as same
Mysql Merge Statement
UNION clause. The UNION clause is used to combine the result set of any two... | +-------+----------+------------+ 3 rows in set (0.00 sec) Query to create table name employee02... | 2009-01-01 | +-------+------+------------+ 6 rows in set (0.00 sec) Query
Mysql Merge
UNION clause.The UNION clause is used to combine the result set of any two sql... in set (0.00 sec) Query to create table name employee02 : mysql> CREATE... | +-------+------+------------+ 6 rows in set (0.00 sec) Query to create table
Mysql Merge
. The UNION clause is used to combine the result set of any two sql queries... | Mahendra | 2009-01-04 | +-------+----------+------------+ 3 rows in set (0.00... | +-------+------+------------+ 6 rows in set (0.00 sec) Query to create table named Emptotal which
Advertisements
 

 

 

DMCA.com