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

public class SelectApplet extends Applet {


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

    Button select = new Button("Select");

    add(quer, BorderLayout.NORTH);
    add(select, BorderLayout.SOUTH);
    add(status, BorderLayout.CENTER);

  }


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

            String query = 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();
                       ResultSet rs = stmt.executeQuery(query);
                       while(rs.next()) {
                          String s = rs.getString("COF_NAME");
                          float  f = rs.getFloat("PRICE");
                          int i1 = rs.getInt("SUP_ID");
                          int i2 = rs.getInt("SALES");
                          int i3 = rs.getInt("TOTAL");
                          status.append(s+" "+String.valueOf(i1)+" "+String.valueOf(f)+" "+String.valueOf(i2)+" "+String.valueOf(i3)+"\n");
                       }

                       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("Select from coffees");
    SelectApplet sApplet = new SelectApplet();
    sApplet.init();
    sApplet.start();

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

  }

  

}