📄 gettypeinfo.htm
字号:
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Listing Available SQL Types Used by a Database (Java Developers Almanac Example)
</TITLE>
<META CONTENT="Patrick Chan" NAME="AUTHOR">
<META CONTENT="Code Examples from The Java Developers Almanac 1.4" NAME="DESCRIPTION">
<META CONTENT="Addison-Wesley/Patrick Chan" NAME="OWNER">
<META CONTENT="3/20/02" NAME="revision">
<META CONTENT="no-cache" HTTP-EQUIV="Pragma">
<LINK href="/almanac.css" media="screen" type="text/css" rel="stylesheet">
</HEAD>
<BODY>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD></TD>
</TR>
</TABLE>
<br>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD></TD>
</TR>
<TR>
<TD rowspan="3"><A HREF="/?l=ex"><IMG BORDER="0" ALIGN="BOTTOM" HSPACE="10" SRC="/egs/almanac14a.jpg"></A></TD><TD VALIGN="top">
<h1>The Java Developers Almanac 1.4</h1>
<br>
Order this book from <a href="/cgi-bin/scripts/redirect.pl?l=ex&url=http://www.amazon.com/exec/obidos/ASIN/0201752808/xeo">Amazon</a>.
</TD>
</TR>
<TR>
<TD align="right" valign="bottom">
<FORM method="get" action="/cgi-bin/search/find.pl">
<INPUT size="25" name="words" type="text"><INPUT value="Search" type="submit">
</FORM>
</TD>
</TR>
</TABLE>
<HR color="#6666cc">
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD valign="top"><script type="text/javascript">
<!--
google_ad_client = "pub-6001183370374757";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_channel = "4777242811";
google_ad_type = "text_image";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "6666CC";
google_color_url = "6666CC";
google_color_text = "000000";
//--></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script></TD><TD> </TD><TD valign="top">
<DIV ALIGN="LEFT">
<A HREF="/">Home</A>
>
<A HREF="../index.html">List of Packages</A>
>
<A HREF="../java.sql/pkg.html">java.sql</A><font color="#666666" class="xsmall-font">
[73 examples]
</font>
>
<B><A HREF="../java.sql/pkg.html#Database Meta Data">Database Meta Data</A></B><font color="#666666" class="xsmall-font">
[8 examples]
</font>
</DIV><P>
<h3>e290. Listing Available SQL Types Used by a Database</h3>
This example retrieves the SQL data types supported by a database and
driver.
<pre> try {
// Get database meta data
DatabaseMetaData dbmd = <font color="#0066ff"><i>connection</i></font>.getMetaData();
// Get type info
ResultSet resultSet = dbmd.getTypeInfo();
// Retrieve type info from the result set
while (resultSet.next()) {
// Get the database-specific type name
String typeName = resultSet.getString("TYPE_NAME");
// Get the java.sql.Types type to which this database-specific type is mapped
short dataType = resultSet.getShort("DATA_TYPE");
// Get the name of the java.sql.Types value.
// This method is implemented in <a href="../java.sql/JdbcInt2Str.html" class="eglink"><b>e291</b> Getting the Name of a JDBC Type</a>
String jdbcTypeName = getJdbcTypeName(dataType);
}
} catch (SQLException e) {
}
</pre>
Here's an example of output for the MySQL database:
<pre> MySQL Type Name, JDBC Type Name
TINYINT, TINYINT
BIGINT, BIGINT
MEDIUMBLOB, LONGVARBINARY
MEDIUMTEXT, LONGVARBINARY
LONGBLOB, LONGVARBINARY
LONGTEXT, LONGVARBINARY
BLOB, LONGVARBINARY
TEXT, LONGVARBINARY
TINYBLOB, VARBINARY
TINYTEXT, VARBINARY
CHAR, CHAR
NUMERIC, NUMERIC
DECIMAL, DECIMAL
INT, INTEGER
MEDIUMINT, INTEGER
SMALLINT, SMALLINT
FLOAT, FLOAT
DOUBLE, DOUBLE
DOUBLE PRECISION, DOUBLE
REAL, DOUBLE
VARCHAR, VARCHAR
ENUM, VARCHAR
SET, VARCHAR
DATE, DATE
TIME, TIME
DATETIME, TIMESTAMP
TIMESTAMP, TIMESTAMP
</pre>
<P><table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td bgcolor="#6666cc" align="center"><font color="#ffffff">
<b>Related Examples</b></font></td>
</tr>
</table>
e284. <a class="eglink" href="GetSqlKeywords.html?l=rel">
Listing All Non-SQL92 Keywords Used by a Database
</a>
<br>
e285. <a class="eglink" href="GetStringFunctions.html?l=rel">
Listing the String Functions Supported by a Database
</a>
<br>
e286. <a class="eglink" href="GetNumericFunctions.html?l=rel">
Listing the Numeric Functions Supported by a Database
</a>
<br>
e287. <a class="eglink" href="GetSystemFunctions.html?l=rel">
Listing the System Functions Supported by a Database
</a>
<br>
e288. <a class="eglink" href="GetTimeDateFunctions.html?l=rel">
Listing the Time and Date Functions Supported by a Database
</a>
<br>
e289. <a class="eglink" href="GetMaxTableNameLength.html?l=rel">
Getting the Maximum Table Name Length in a Database
</a>
<br>
e291. <a class="eglink" href="JdbcInt2Str.html?l=rel">
Getting the Name of a JDBC Type
</a>
<br>
<table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td align="left">
<br>
See also:
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Batching">
Batching
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Connections">
Connections
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Deleting%20Data">
Deleting Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Drivers">
Drivers
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Importing%20and%20Exporting">
Importing and Exporting
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Inserting%20and%20Updating%20Data">
Inserting and Updating Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20OBJECTs">
Oracle OBJECTs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20VARRAYs">
Oracle VARRAYs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Procedures%20and%20Functions">
Procedures and Functions
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Retrieving%20Data">
Retrieving Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Scrollable%20Result%20Sets">
Scrollable Result Sets
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Tables">
Tables
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Updatable%20Result%20Sets">
Updatable Result Sets
</a>
</td>
</tr>
</table>
<br>
<br>
<FONT class="xsmall-font">
© 2002 Addison-Wesley.
</FONT></TD><TD> </TD><TD valign="top"><A href="http://compositesw.com/devzone?ref=javaalmanac"><IMG alt="Click Here" height="600" width="120" border="0" src="/csw_oad_120x600_final.gif"></A></TD>
</TR>
</TABLE>
</BODY>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META CONTENT="NO-CACHE" HTTP-EQUIV="PRAGMA">
</HEAD>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -