Monday, May 24, 2010

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();
<<<<<<< color="#ffffff"> 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();
}
}
}

No comments:

Post a Comment