Retrieve a rowcount from a ResultSet : Statement « Database « Java Tutorial

1.	Language
2.	Data Type
3.	Operators
4.	Statement Control
5.	Class Definition
6.	Development
7.	Reflection
8.	Regular Expressions
9.	Collections
10.	Thread
11.	File
12.	Generics
13.	I18N
14.	Swing
15.	Swing Event
16.	2D Graphics
17.	SWT
18.	SWT 2D Graphics
19.	Network
20.	Database
21.	Hibernate
22.	JPA
23.	JSP
24.	JSTL
25.	Servlet
26.	Web Services SOA
27.	EJB3
28.	Spring
29.	PDF
30.	Email
31.	J2ME
32.	J2EE Application
33.	XML
34.	Design Pattern
35.	Log
36.	Security
37.	Apache Common
38.	Ant
39.	JUnit

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Photoshop Tutorial

C# / CSharp Tutorial

C# / CSharp Open Source

ASP.NET Tutorial

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML CSS Reference

Python Tutorial

Python Open Source

SQL Server / T-SQL

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

VB.Net Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Java Tutorial » Database » Statement

20. 5. 6. Retrieve a rowcount from a ResultSet


import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;



public class Main {

  public static void main(String[] argv) throws Exception {

    Connection conn = null;

    Statement s = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

        ResultSet.CONCUR_READ_ONLY);

    ResultSet r = s

        .executeQuery("SELECT * FROM employee");

    r.last();

    int count = r.getRow();

    r.beforeFirst();

  }

}

20. 5. Statement
	20. 5. 1.	Change the fetch size on the result set
	20. 5. 2.	Get the fetch size of a statement
	20. 5. 3.	Set the fetch size on the statement
	20. 5. 4.	Retrieving All Rows from a Database Table
	20. 5. 5.	Getting Column Names from a database table in Java
	20. 5. 6.	Retrieve a rowcount from a ResultSet
	20. 5. 7.	Setting the Number of Rows to Prefetch When Executing a SQL Query
	20. 5. 8.	Create a result set
	20. 5. 9.	Creating a Database Table called my_table with one column, col_string, which holds strings.
	20. 5. 10.	Deleting a Database Table called my_table from a database.
	20. 5. 11.	Inserting a Row into a Database Table
	20. 5. 12.	Inserting a Row into a Database Table Using a Prepared Statement
	20. 5. 13.	Deleting a Row from a Database Table
	20. 5. 14.	Statement Batch Update

w__w_w_.___j__a___v__a___2__s___.___com |

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.