ResultSetMetaData

Click to rate this post!
[Total: 0 Average: 0]

ResultSetMetaData :

The metadata implies information about information i.e. we can get additional data from the information.

In the event that you need to get metadata of a table like aggregate number of segment, section name, segment sort and so forth, ResultSetMetaData interface is helpful in light of the fact that it gives strategies to get metadata from the ResultSet question.

METHODS OF RESULTSETMETADATA :

Methods of ResultSetMetaData

object of ResultSetMetaData:

The getMetaData() method of ResultSet interface returns proceeds the entity of ResultSetMetaData

Syntax:

  public ResultSetMetaData getMetaData()throws SQLException

 DatabaseMetaData:

DatabaseMetaData interface gives techniques to get meta information of a database, for example, database item name, database item form, driver name, name of aggregate number of tables, name of aggregate number of perspectives and so forth.

 Methods of DatabaseMetaData:

  • public String getDriverName()throws SQLException
  • public String getDriverVersion()throws SQLException
  • public String getUserName()throws SQLException
  • public String getDatabaseProductName()throws SQLException
  • public String getDatabaseProductVersion()throws SQLException
  • public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)throws SQLException
Object of DatabaseMetaData:

The getMetaData() method of link line returns the object of DatabaseMetaData.

Syntax:

public DatabaseMetaData getMetaData()throws SQLException

Example:

import java.sql.*;

class Dbmd2{

try{

Class.forName(“oracle.jdbc.driver.OracleDriver”);

public static void main(String args[]){

Connection con=DriverManager.getConnection(

“jdbc:oracle:thin:@localhost:1521:xe”,”system”,”oracle”);

DatabaseMetaData dbmd=con.getMetaData();

String table[]={“TABLE”};

ResultSet rs=dbmd.getTables(null,null,null,table);

while(rs.next()){

System.out.println(rs.getString(3));

}  con.close();

}catch(Exception e){ System.out.println(e);}

}

}

Transaction Management:

Exchange speaks to a solitary unit of work. The ACID properties depicts the exchange administration well. Corrosive stands for Atomicity, Consistency, confinement and toughness.

Atomic implies either all effective or none. Consistency guarantees bringing the database starting with one reliable state then onto the next predictable state. Confinement guarantees that exchange is disconnected from other exchange. Toughness implies once an exchange has been conferred, it will remain along these lines, even in case of blunders, control misfortune and so on.

 Methods:

void setAutoCommit(boolean status)

void rollback()

void commit()

Subscribe
to our newsletter

Drop Us A Query

Trending Courses
  • Microsoft Azure Architect Technologies(AZ-300) | ITGuru
    Microsoft Azure Architect Technologies(AZ-300)
  • Azure is a great Microsoft Cloud Computing platform in providing various cloud services through online. ITGuru Certified Azure Architect certification course gives you the practical knowledge on Azure Cloud platform through real-world use cases from live experts

  • ServiceNow Admin Training | ITGuru
    ServiceNow Admin Training
  • Getting knowledge of cloud platforms like ServiceNow is essential in today’s world for the smooth running of projects in cloud platform. Turn your dream to the reality of becoming the Certified ServiceNow Administrator through ServiceNow Administration online certification Course with practical examples by live industry experts through online at ITGuru with real-world use cases.

  • Workday Financials Training | ITGuru
    Workday Financials Training
  • knowing the basics on any platform like Workday is not enough to sustain the IT industry. Hence it is essential to go beyond on Workday basics like Workday Financials training which lets you know the application of Financials management in real -world use cases from ITGuru Live Experts in a practical way.

  • Workday Training
  • An organization is considered as the best one when it offers the best benefits to the employee. Moreover, the greater the employee benefits, the greater the contribution to the organization. ITGuru let you know the practical workday Human Resource Management(HRM) features with live examples by experts

  • Python Online Course | ITGuru
    Python Online Course
  • Turn your dream into reality by ITGuru live experts with real-world use cases through practical knowledge on python online course and become the certified associate in python programming and become a master in python programming

  • Python Programming | ITGuru
    Python Programming
  • Python is the trending programming language in the IT industry. Mastering in python programming gives you more value among the people in the IT industry. Hence start today to learn python programming online by live experts with real-time uses cases at ITGuru


100% Secure Payments. All major credit & debit cards accepted.

Call Now Button