- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
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
How to get the data type name from the java.sql.Type code using JDBC?
The java.sql.Types class represents the SQL datatype in integer format. The valueOf() method of the enumeration JDBCType accepts an integer value representing the java.sql.Type and, returns the JDBC type corresponding to the specified value.
Example
Let us create a table with name MyPlayers in MySQL database using CREATE statement as shown below −
CREATE TABLE MyPlayers( ID INT, First_Name VARCHAR(255), Last_Name VARCHAR(255), Date_Of_Birth date, Place_Of_Birth VARCHAR(255), Country VARCHAR(255), PRIMARY KEY (ID) );
Following JDBC program establishes connection with the MySQL database retrieves the contents of the MyPlayers table into a ResultSet object, obtains its metadata, obtains the column types of all the columns of the table as java.sql.Types values (integers), and retrieves the names of the respective types using the valueOf() method.
Example
import java.sql.Connection; import java.sql.DriverManager; import java.sql.JDBCType; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; public class SQLTypeName { public static void main(String args[]) throws SQLException { //Registering the Driver DriverManager.registerDriver(new com.mysql.jdbc.Driver()); //Getting the connection String mysqlUrl = "jdbc:mysql://localhost/mydatabase"; Connection con = DriverManager.getConnection(mysqlUrl, "root", "password"); System.out.println("Connection established......"); //Creating the Statement Statement stmt = con.createStatement(); //Query to retrieve records String query = "Select * from MyPlayers"; //Executing the query ResultSet rs = stmt.executeQuery(query); //Getting the ResultSetMetadata object ResultSetMetaData mertadata = rs.getMetaData(); //Returns the specified column's java.sql.Type name //Retrieving the data type of a column int ID_Type = mertadata.getColumnType(1); int FirstName_Type = mertadata.getColumnType(2); int LastName_Type = mertadata.getColumnType(3); int DateOfBirth_Type = mertadata.getColumnType(4); int PlaceOfBirth_Type = mertadata.getColumnType(5); int Country_Type = mertadata.getColumnType(6); System.out.println("Data type of the column ID: "+JDBCType.valueOf(ID_Type)); System.out.println("Data type of the column First_Name: "+JDBCType.valueOf(FirstName_Type)); System.out.println("Data type of the column Last_Name: "+JDBCType.valueOf(LastName_Type)); System.out.println("Data type of the column Date_Of_Birth: "+JDBCType.valueOf(DateOfBirth_Type)); System.out.println("Data type of the column Place_Of_Birth: "+JDBCType.valueOf(PlaceOfBirth_Type)); System.out.println("Data type of the column Country: "+JDBCType.valueOf(Country_Type)); } }
Output
Connection established...... Price values updated ...... Contents of the Sales table after the update: Name: Key-Board, Customer Name: Raja, Dispatch Date: 2019-09-01, Delivery Time: 11:00:00, Price: 8500, Location: Hyderabad Name: Earphones, Customer Name: Roja, Dispatch Date: 2019-05-01, Delivery Time: 11:00:00, Price: 2000, Location: Vishakhapatnam Name: Mouse, Customer Name: Puja, Dispatch Date: 2019-03-01, Delivery Time: 10:59:59, Price: 4500, Location: Vijayawada Name: Mobile, Customer Name: Vanaja, Dispatch Date: 2019-03-01, Delivery Time: 10:10:52, Price: 9000, Location: Chennai Name: Headset, Customer Name: Jalaja, Dispatch Date: 2019-04-06, Delivery Time: 11:08:59, Price: 7500, Location: Goa
- Related Articles
- How to get the table name of the current ResultSet using JDBC?
- How to Read data from BLOB and CLOB type columns from a table using JDBC?
- How to get the colour name from colour code in R?
- What is JDBC Blob data type? how to store and read data from it?
- What is JDBC Clob data type? how to store and read data from it?
- How to get all the column names from a ResultSet using JDBC
- How to get LocalDateTime object from java.sql.Date using JDBC?
- How to retrieve binary data from a table using JDBC?
- How to read/retrieve data from Database to JSON using JDBC?
- How to get the code name and product name of the browser in JavaScript?
- How to get all table names from a database using JDBC?
- How to get the row count from ResultSet in JDBC
- How to get the variable data type in PowerShell?
- How to get the list of all databases using JDBC?
- How to get the properties of a driver using JDBC?

Advertisements