/******************************************************************
 *                        EXAMPLE4.JAVA                           *
 *                                                                *
 * Ukazka JDBC.                                                   *
 * - DDL prikazy.                                                 *
 * Max OTTA, 5/2000                                               *
 *                                                                *
 * Prelozeni a spusteni programu :                                *
 *                                                                *
 * javac example4.java                                            *
 * java  example4 nanic                                           *
 ******************************************************************/

import java.lang.*;
import java.sql.*;

public class example4 {

    public static String driver = "oracle.jdbc.driver.OracleDriver";
    public static String dburl  = "jdbc:oracle:thin:@stroj.zcu.cz:1521:databaze";
    public static String user = "uzivatel";
    public static String pwd  = "heslo";

    public static void main(String args[]) {
	Connection db;
	boolean dummy;
	Statement st;

	if (args.length != 1) {
	    System.out.println("Chybi parametr.");
	    return;
	}
	try {
	    Class.forName(driver);
	} catch (ClassNotFoundException e) {
	    System.out.println("Nemohu najit ovladac.");
	    return;
	}
	try {
	    db = DriverManager.getConnection(dburl, user, pwd);

	    st = db.createStatement();

	    dummy = st.execute(
	      "CREATE TABLE testovaci (" +
              "  id     NUMBER(5) PRIMARY KEY," +
	      "  str    VARCHAR2(30) NOT NULL," +
	      "  dat    DATE )");

            dummy = st.execute("DROP TABLE " + args[0]);

	    db.commit();
	    db.close();
	} catch (Exception e) {
	    System.out.println("Chyba :");
	    e.printStackTrace();
	}
    }
}
/*** EOF ***/