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



Home Answers Viewqa JDBC parameter meta data
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


upendra kumar tiwari
parameter meta data
1 Answer(s)      6 years and 2 months ago
Posted in : JDBC



Advertisement
View Answers

October 13, 2008 at 10:23 AM


Hi friend,


public interface ResultSetMetaData

An object that can be used to get information about the types and properties of the columns in a ResultSet object.

For example :

ResultSet rs = stmt.executeQuery("SELECT * FROM table");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();


Method Summary
String getCatalogName(int column)
Gets the designated column's table's catalog name.
String getColumnClassName(int column)
Returns the fully-qualified name of the Java class whose instances are manufactured
if the method ResultSet.getObject is called to retrieve a value from the column.
int getColumnCount()
Returns the number of columns in this ResultSet object.
int getColumnDisplaySize(int column)
Indicates the designated column's normal maximum width in characters.
String getColumnLabel(int column)
Gets the designated column's suggested title for use in printouts and displays.
String getColumnName(int column)
Get the designated column's name.
int getColumnType(int column)
Retrieves the designated column's SQL type.
String getColumnTypeName(int column)
Retrieves the designated column's database-specific type name.
int getPrecision(int column)
Get the designated column's number of decimal digits.
int getScale(int column)
Gets the designated column's number of digits to right of the decimal point.
String getSchemaName(int column)
Get the designated column's table's schema.
String getTableName(int column)
Gets the designated column's table name.
boolean isAutoIncrement(int column)
Indicates whether the designated column is automatically numbered, thus read-only.
boolean isCaseSensitive(int column)
Indicates whether a column's case matters.
boolean isCurrency(int column)
Indicates whether the designated column is a cash value.
boolean isDefinitelyWritable(int column)
Indicates whether a write on the designated column will definitely succeed.
int isNullable(int column)
Indicates the nullability of values in the designated column.
boolean isReadOnly(int column)
Indicates whether the designated column is definitely not writable.
boolean isSearchable(int column)
Indicates whether the designated column can be used in a where clause.
boolean isSigned(int column)
Indicates whether values in the designated column are signed numbers.
boolean isWritable(int column)
Indicates whether it is possible for a write on the designated column to succeed.


For more information on JDBC visit to :

http://www.roseindia.net/jdbc/

Thanks


Related Tutorials/Questions & Answers:
parameter meta data - JDBC
parameter meta data   i wnts to know about the finition of parameter in jdbc as well as the diffrent methods used in parameter meta data  Hi friend, public interface ResultSetMetaData An object that can be used
what is meta data in java
what is meta data in java  what is meta data in java   Use ArrayList when there will be a large variation in the amount of data that you... in that database; the program knows exactly what kind of data it is dealing
Advertisements
meta tag in HTML
meta tag in HTML  Explain meta tag in HTML
Wrong parameter values while exporting data from jsp to excel
Wrong parameter values while exporting data from jsp to excel   This is a jsp report. When i export the report data to an excel, the parameter..., specifically, if the parameter value is ALL, it gets translated to NO in excel
url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp   the user can create an event. In the create page, we have three buttons. Save as draft, preview and save and post buttons. Once the user entered all the datas and if he
url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp  The user can create an event. In the create page, we have three buttons. Save as draft, preview and save and post buttons. Once the user entered all the datas and if he
JSP Meta refresh
JSP Meta refresh   ... a META tag in the jsp. The META tag with an HTTP-EQUIV attribute controls.... This will automatically reloads the browser. The attribute CONTENT="3" of the META tag
JSP get Parameter
JSP get Parameter          JSP get Parameter is used to return the value of a request parameter passed as query string and posted data which is encoded
SQL Out Parameter
SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data... an example from SQL Out Parameter .In this Example we create a procedure 'abc
Init Parameter
Init Parameter  How set Init Parameter in servlet
JDBC Meta Data Get tables
JDBC Meta Data Get tables       JDBC Meta Data is the collective information about the data structure and property of a column available in table. The meta data of any
SQL Out Parameter
SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data value ... from SQL Out Parameter .In this Example we create a procedure 'abc
validate parameter before using it
validate parameter before using it   How to validate the parameter before using it in JSP
Java parameter passing
Java parameter passing  What type of parameter passing does Java support
Passing Parameter - JSP-Servlet
associated with the data i selected. Therefore, i've modify it into something like..., there's var answer. I need to pass this parameter back into the jsp part, how should i do
pass parameter names and values
pass parameter names and values  What is the <jsp:param> standard action?   The <jsp:param> standard action is used with <jsp:include> or <jsp:forward> to pass parameter names and values
optional parameter of Test annotattion
optional parameter of Test annotattion   What are two optional parameters of @Test annotation ?   The Test annotation supports two optional... parameter, timeout, causes a test to fail if it takes longer than a specified amount
optional parameter of Test annotattion
optional parameter of Test annotattion   The Test annotation supports two optional parameters. The first, expected, declares that a test method should throw an exception. If it doesn't throw an exception or if it throws
Passing Parameter - JSP-Servlet
Passing Parameter  I would like to ask how to pass a parameter from javascript section into the jsp section.It will be something like this: function change() { var answer = document.getElementById('selc').value
how to pass the parameter in callable statement
how to pass the parameter in callable statement  calstat=conn.prepareCall("{call studentrc(?,?,?,?,?)}"); // it show error parameter value is null...(); //JOptionPane.showMessageDialog(null,"Data successfully Updated
Parameter Tag:
Parameter Tag:       bean:parameter...) of the specified request parameter. This tag retrieve the value of the specified request parameter and define the attribute of  type String or String[] in page scope
Set Date Parameter to get specific value
Set Date Parameter to get specific value  How to set the date parameter or fetch a specific data records based on date? For example fetching the two or three months old records
Passing a parameter using URL string
Passing a parameter using URL string  How to pass a parameter using the URL string in a JSF application
PHP add parameter to url - PHP
PHP add parameter to url  need an example of parse_url in PHP. Thanks in advance
How ot get a web page title and meta tags in java(jsp/ servlet) - JSP-Servlet
How ot get a web page title and meta tags in java(jsp/ servlet)  Hi i want to get a web page title and meta tags using servlet of java but i am unable to do that and my target will be to read only the title and meta tags
Parameter month I Report - Java Beginners
Parameter month I Report  hy, I want to ask about how to make parameter in I Report, parameter is month from date. How to view data from i report use like "12/2008". Thank's  Hi friend, Plz give details
Static Parameter
Static Parameter       In this section, we will develop a simple application to access the static parameters. We will use a JavaBean to set and get the static parameters. Each static parameter has a value
passing parameter from html to applet
passing parameter from html to applet  how to pass the following from HTML to applet in Java code - font size,font style,font size?give me suitable code
JSP Session Parameter rewrite
JSP Session Parameter rewrite       In the section you will study about the session parameter... Parameter Rewrite</title> </head> <body> Last visit
pass parameter - file - Java Beginners
pass parameter - file  Hi, I want to pass paramter file to method. how it is possible. please send me example programs.   Hi Friend... immediately. file.jsp ========== File Parameter Use
Set Parameter - JSP-Interview Questions
Set Parameter  Hi, could someone please explain the process of setting parameter in the session from JSP with the help of code? Thanks!  Hi,In your JSP page use the Set Tag, and set the scope attribute
Advertisements
 

 

 

DMCA.com