Nancy Den has Published 330 Articles

How to Navigate through a ResultSet using a JDBC program?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

150 Views

The next() method of the ResultSet interface moves the pointer/Cursor of the current ResultSet object to the next row from the current position. This method returns a boolean value. If there are no rows next to its current position this method returns false, else it returns true.Therefore, using this method ... Read More

IntStream summaryStatistics() method in Java

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

405 Views

The summaryStatistics() method in the IntStream class is used to return summary data about the elements of this stream. The syntax is as follows:IntSummaryStatistics summaryStatistics()Create an IntStream and add some elements:IntStream intStream = IntStream.of(30, 60, 90);Now, get the summary data about the above elements:IntSummaryStatistics details = intStream.summaryStatistics();The following is an ... Read More

What is JDBC SQL Escape Syntax Explain?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

1K+ Views

The escape syntax gives you the flexibility to use database specific features unavailable to you by using standard JDBC methods and properties.The general SQL escape syntax format is as follow:{keyword 'parameters'}Following are various escape syntaxes in JDBC:d, t, ts Keywords: They help identify date, time, and timestamp literals. As you ... Read More

What are the methods provided by the ResultSet to navigate through it in JDBC?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

247 Views

We have two types of ResultSet objects namely, forward Only and, bi-directional as the names suggest you can move in only one direction (forward) in forward only ResultSet and, in bidirectional ResultSet you can move the pointer in both directions. The ResultSet interface provides several methods to navigate through both ... Read More

What are save points in JDBC? Explain?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

228 Views

Savepoint interface gives you the additional transactional control. Most modern DBMS, support save points within their environments such as Oracle's PL/SQL.When you set a save point you define a logical rollback point within a transaction. If an error occurs past a save point, you can use the rollback method to ... Read More

C++ Program to Find Fibonacci Numbers using Matrix Exponentiation

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

2K+ Views

The Fibonacci numbers, commonly denoted Fn form a sequence, called the Fibonacci sequence, i.e; each number is the sum of the two preceding ones, starting from 0 and 1. That is −F0 = 0 and F1 = 1 And Fn = Fn-1 + Fn-2 for n > 1.AlgorithmBegin ... Read More

What is ODBC?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

4K+ Views

ODBC stands for Oracle Database Connectivity. It is an API which is used to access different databases.The OFBC driver uses the Open Database connectivity interface provided by Microsoft to communicate with the databases. It is independent of Databases and platforms and operating systems. Once you develop an application using ODBC ... Read More

StringJoiner setEmptyValue() method in Java 8

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

272 Views

The setEmptyValue() method of the StringJoiner class in Java 8 sets the sequence of characters. These characters are to be used when determining the string representation of this StringJoiner and when it is empty. That would be none of the elements have been added.The syntax is as followspublic StringJoiner setEmptyValue(CharSequence ... Read More

What are the features of ODBC?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

1K+ Views

ODBC drivers implements standard SQL syntax, following are the important features of ODBC:Inter-operability: Using ODBC driver you can develop applications which can communicate with different Database Management Systems and, you can switch/migrate your application from one database to other easily.SQL Syntax: ODBC implements SQL syntax for easy understanding. Whenever an ... Read More

What is AbstractCollection class in Java?

Nancy Den

Nancy Den

Updated on 30-Jul-2019 22:30:25

373 Views

The AbstractCollection class provides an implementation of the Collection interface. This is done to minimize the effort in the implementation of this interface.For an unmodifiable collectionExtend this class and provide implementations for the iterator and size methods.For modifiable collectionAdditionally override the add() method of the class. The iterator method returns ... Read More

Advertisements