Get the database-specific type name : SQL Data Type Java Data Type « Database « Java Tutorial






import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "com.jnetdirect.jsql.JSQLDriver";
    Class.forName(driverName);

    String serverName = "127.0.0.1";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase;
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
    DatabaseMetaData dbmd = connection.getMetaData();
    ResultSet resultSet = dbmd.getTypeInfo();

    while (resultSet.next()) {
      // Get the database-specific type name
      String typeName = resultSet.getString("TYPE_NAME");

      short dataType = resultSet.getShort("DATA_TYPE");
    }
  }
}








20.19.SQL Data Type Java Data Type
20.19.1.Mapping Between Java to JDBC SQL Types
20.19.2.Java Types Mapped to JDBC Types
20.19.3.JDBC Types Mapped to Java Object Types
20.19.4.Java Object Types Mapped to JDBC Types
20.19.5.Getting the Name of a JDBC Type
20.19.6.Get the database-specific type name
20.19.7.Get the java.sql.Types type to which this database-specific type is mapped
20.19.8.Retrieve type info from the result set
20.19.9.converting a java.sql.Types integer value into a printable name
20.19.10.uses reflection to get all the field names from java.sql.Types.