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.

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.

Related Tags for Creating a MySQL Database Table to store Java Types:
java,  sql,  mysql,  c,  database,  table,  data,  io,  types,  type,  vi,  this,  id,  create,  tab,  for,  example,  with,  to,  base,  exam,  store,  e,  it,  des,  section,  pe,  in,  as,  m,  j,  es,  ase,  all,  how,  pro,  creating,  describe,  tor,  xa,  xamp,  s,  at,  my,  is,  ha,  ll,  mpl,  ea,  ar,  cod,  code,  va,  scr,  s,  s,  ri,  th,  av,  bes,  st,  ab,  abl,  ati,  hat,  ple,  pl,  pr,  ode,  on,  o

More Tutorials from this section

• Jdbc Mysql Connection Url
• JDBC Example with MySQL
• Adding a New Column Name in Database Table
• Retrieving Tables from a Database
• Change Column Name of a Table
• Arrange a Column of Database Table
• Arrange a Column of Database Table
• Getting Column Names from a database table in Java
• Jdbc Mysql Connection String
• Copy One Database Table to Another
• Copy Table in a MySQL Database
• Count Records using the Prepared Statement
• Count Rows from a Database Table
• Creating a Database in MySQL
• Creating a MySQL Database Table to store Java Types
• Creating a Database Table
• Cross Join Tables in a Specific Database
• Deleting All Rows from a Database Table
• Delete a Column from a Database Table
• Deleting Records using the Prepared Statement