MySQL Data type to Java Data type Conversion Table : MySQL « Database « Java Tutorial






  1. Java Tutorial
  2. Database
  3. MySQL
MySQL Data Types                                      Java Types

CHAR, VARCHAR, BLOB, TEXT, ENUM, and SET              java.lang.String, java.io.InputStream, 
                                                      java.io.Reader, java.sql.Blob, and java.sql.Clob      
                                                      
FLOAT, REAL, DOUBLE PRECISION, NUMERIC,               java.lang.String, java.lang.Short, java.lang.Integer, 
DECIMAL, TINYINT, SMALLINT, MEDIUMINT,                java.lang.Long, java.lang.Double, and java.math.BigDecimal
INTEGER, and BIGINT

DATE, TIME, DATETIME, and TIMESTAMP                   java.lang.String, java.sql.Date, and java.sql.Timestamp








20.34.MySQL
20.34.1.Get a MySQL Connection from the Driver Manager
20.34.2.JDBC Mysql Connection String
20.34.3.MySQL Connection Properties: Passing Additional Properties Using a Database URL
20.34.4.Keep the Connection Alive for MySQL
20.34.5.MySQL Data type to Java Data type Conversion Table
20.34.6.Create a MySQL Table to Store Java Types (Using Statement Objects)?
20.34.7.Retrieve Automatically Generated Keys Using a Statement (MySQL)?
20.34.8.Creating a MySQL Table to Store Java Types
20.34.9.Loading a Flat File to a MySQL Table, file is comma-separated
20.34.10.Loading a Flat File to a MySQL Table, file is terminated by \r\n, use this statement
20.34.11.Creating a Database in MySQL
20.34.12.Creating a MySQL Database Table to store Java Types
20.34.13.Deleting a Table from Database
20.34.14.Retrieving Tables from a Database
20.34.15.Inserting values in MySQL database table
20.34.16.Getting the Number of Rows in a Database Table
20.34.17.Updating a Row in a Database Table
20.34.18.Deleting All Rows from a Database Table
20.34.19.Exporting a MySQL Table to a Flat File
20.34.20.Retrieve auto-generated keys
20.34.21.MySQL Error code and message