Another Method To Check Table Existance : Table « Database SQL JDBC « Java






Another Method To Check Table Existance

  

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {

  public static void main(String[] args) throws Exception {
    Connection conn = getMySqlConnection();
    System.out.println("Got Connection.");
    Statement st = conn.createStatement();
    st.executeUpdate("drop table survey;");
    st.executeUpdate("create table survey (id int,name varchar(30));");
    st.executeUpdate("insert into survey (id,name ) values (1,'nameValue')");

    String tableName = "survey";
    String query = "select count(*) from  " + tableName;
    Statement stmt = null;
    ResultSet rs = null;
    try {
      stmt = conn.createStatement();
      rs = stmt.executeQuery(query);
      System.out.println("Exist");;
    }
    catch (Exception e ) {
      // table does not exist or some other problem
      //e.printStackTrace();
      System.out.println("Not Exist");
    }

    st.close();
    conn.close();
  }

  private static Connection getHSQLConnection() throws Exception {
    Class.forName("org.hsqldb.jdbcDriver");
    System.out.println("Driver Loaded.");
    String url = "jdbc:hsqldb:data/tutorial";
    return DriverManager.getConnection(url, "sa", "");
  }

  public static Connection getMySqlConnection() throws Exception {
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost/demo2s";
    String username = "oost";
    String password = "oost";

    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

  public static Connection getOracleConnection() throws Exception {
    String driver = "oracle.jdbc.driver.OracleDriver";
    String url = "jdbc:oracle:thin:@localhost:1521:caspian";
    String username = "mp";
    String password = "mp2";

    Class.forName(driver); // load Oracle driver
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

}

           
         
    
  








AnotherMethodToCheckTableExistance.zip( 2,516 k)

Related examples in the same category

1.Table exist?
2.List tables in a database
3.Listing All Table Names in a Database
4.Get all table schemas
5.Get all table catalogs
6.Get Catalog Name From ResultSet Metadata
7.Get Available Table Name In A Database
8.Get Table Or View Name From A Database
9.Database metadata: data type
10.Deleting a Table from Database
11.Retrieving Tables from a Database
12.List the Tables in an SQL database
13.Copy One Database Table to Another
14.Create table with primary key
15.Create table with foreign key
16.Create data table 3
17.Create supplier table
18.Create data table: reference
19.Create data table 2
20.Creating a Database Table called my_table with one column, col_string, which holds strings.
21.Deleting a Database Table called my_table from a database.
22.Getting Rows from a Database Table
23.Getting the Number of Rows in a Database Table
24.Inserting a Row into a Database Table Using a Prepared Statement
25.Inserting a Row into a Database Table
26.Updating a Row in a Database Table
27.Deleting a Row from a Database Table
28.Deleting All Rows from a Database Table
29.Create data type and data table
30.Table and column existance