- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 317 Articles for JDBC
963 Views
Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries (in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the last row from the current position, using the last() method of the ResultSet interface.rs.last()This method returns a boolean value specifying whether the cursor has been moved to the last row successfully.If there are no rows in the current ResultSet object this method returns false, else ... Read More
600 Views
Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries(in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the previous row from the current position, using the previous() method of the ResultSet interface.rs.previous()This method returns a boolean value specifying whether the ResultSet object contains more rows. If there are no rows before its current position this method returns false, else it returns true.Let us ... Read More
1K+ Views
Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries(in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ResultSet object to the next row from the current position, using the next() method of the ResultSet interface.rs.next()This method returns a boolean value specifying whether the ResultSet object contains more rows.If there are no rows next to its current position this method returns false, else it returns true.Let us create ... Read More
464 Views
ResultSet objectCertain SQL queries (especially SELECT) returns tabular data, In JDBC the object of the java.sql.ResultSet interface holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).ResultSet Cursor/pointerThe ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.There are two types of result sets namely, forward only and, bidirectional. By default the ResultSet we get by the executeQuery() method is of the type forward only. Using this you can traverse/move the cursor only forward direction.Bidirectional ResultSetA bi-directional ResultSet ... Read More
222 Views
When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The isClosed() method of the ResultSet interface is used to determine whether the current ResultSet object is closed.rs.isclosed()CLOSE_CURSORS_AT_COMMITIf the holdability of the ResultSet object is set to this value. Whenever you commit/save ... Read More
1K+ Views
When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The isAfterLast() method of the ResultSet interface is used to determine whether the cursor is on the last row of the ResultSet.rs.isLast();This method returns an boolean this value is true, if the cursor is ... Read More
2K+ Views
When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The isBeforeFirst() method of the ResultSet interface is used to determine whether the cursor is at the default position of the ResultSet.rs.isBeforeFirst();This method returns an boolean this value is true, if the cursor is ... Read More
507 Views
When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The isAfterLast() method of the ResultSet interface is used to determine whether the cursor is after the end of the ResultSet.rs.isAfterLast();This method returns an boolean this value is true, if the cursor is ... Read More
83 Views
The getSearchStringEscape() method of the DatabaseMetaData interface is used to get the that is used to escape the wildcard characters ('_' or, '%') by the underlying database.This method returns a string parameter representing the value that is used to escape wildcard charactersTo get the DatabaseMetaData object −Make sure your database is up and running.Register the driver using the registerDriver() method of the DriverManager class. Pass an object of the driver class corresponding to the underlying database.Get the connection object using the getConnection() method of the DriverManager class. Pass the URL the database and, user name, password of a user in the database, ... Read More
276 Views
The getTypeInfo() method of the DatabaseMetadata interface is used to get the description of all the data-types supported by the underlying database.This method returns a ResultSet object describing data types supported. This object holds values for the following details (as column names) −Column NameData TypeDescriptionTYPE_NAMEStringName of the data type.DATA_TYPEintInteger value representing this datatype.PRECISIONintMaximum precision of this datatype.LITERAL_PREFIXStringPrefix used to quote a string literal.LITERAL_SUFFIXStringsuffix used to quote a string literal.CASE_SENSITIVEbooleanDetermines whether this datatype is case sensitiveUNSIGNED_ATTRIBUTEbooleanDetermines whether this datatype is an un-signed attribute.FIXED_PREC_SCALEbooleanDetermines whether the current datatype can be used as a value of currency.AUTO_INCREMENTbooleanDetermines whether the current datatype can be used ... Read More