import java.applet.Applet;
import java.awt.*;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.sql.*;

public class CreateApplet extends Applet {


    TextArea status = new TextArea("", 2, 40, TextArea.SCROLLBARS_NONE);
    TextField quer = new TextField(30);
    public CreateApplet() {

    Button create = new Button("Create");

    add(quer, BorderLayout.NORTH);
    add(create, BorderLayout.NORTH);
    add(status, BorderLayout.CENTER);


  }

  public boolean action(Event evt, Object arg) {
     if (evt.target instanceof Button) {
        if(arg.equals("Create")) {
            String url = "jdbc:mysql://bbase.intrak.upjs.sk:3306/test";

            String createString = quer.getText();

            try {
               Class.forName("com.mysql.jdbc.Driver");
             } catch(Exception ex) {
	            status.append("Can't find Database driver class: " + ex);
	            System.exit(0);
               }

                	try {
                       Connection con = DriverManager.getConnection(url, "test", "test");
                       Statement stmt = con.createStatement();
                       stmt.executeUpdate(createString);
                       status.append("Succesful");
                       stmt.close();
                       con.close();

                     }catch(SQLException e) {
                         status.append("SQLException: " + e.getMessage() +"\n");

                      }

        }


     }
     return true;


  }


  public static void main(String args[]) {
    Frame f = new Frame("Create ");
    CreateApplet sApplet = new CreateApplet();
    sApplet.init();
    sApplet.start();

    f.add(sApplet);
    f.setSize(350, 200);
    f.show();

  }


}