Creating a MySQL Database Table to store Java Types
Dear user, consider a case where we need to store a
java types in our database table. Now one question may arise in your mind that
whether the MySQL supports java types or not. This section describes how to create a
table in MySQL database that stores all java types. Here we are providing you an example with code for
creating a table to store java types. Brief description is given below:
Description of program:
In this program we are going to establish the connection between MySQL
database table and java file. After the connection has been established creates a
database table for storing all java types. We have used most of the java types
provided to us by the jdbc.
Here is the code of program:
|
import java.sql.*;
public class CreateMySqlTable{
public static void main(String[] args) {
System.out.println("Creating a Mysql Table to Store Java Types!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "jdbctutorial";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement st = con.createStatement();
<<<<<<< CreateMySqlTable.shtml String table =
"CREATE TABLE java_DataTypes2
("+ "typ_boolean BOOL, "
=======
String table
= "CREATE TABLE java_DataTypes2("+ "typ_boolean BOOL, "
>>>>>>> 1.7 + "typ_byte TINYINT, "
+ "typ_short SMALLINT, "
+ "typ_int INTEGER, "
+ "typ_long BIGINT, "
+ "typ_float FLOAT, "
+ "typ_double DOUBLE PRECISION, "
+ "typ_bigdecimal DECIMAL(13,0), "
+ "typ_string VARCHAR(254), "
+ "typ_date DATE, "
+ "typ_time TIME, "
+ "typ_timestamp TIMESTAMP, "
+ "typ_asciistream TEXT, "
+ "typ_binarystream LONGBLOB, "
+ "typ_blob BLOB)";
st.executeUpdate(table);
System.out.println(table);
con.close();
}
catch (SQLException s){
System.out.println
("Table is all ready exists!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
|
Download this example.
