// SQL1applet.java
import java.awt.*;
import java.applet.*;
import java.awt.event.*;
import java.sql.*;
 
public class SQL1applet extends Applet implements ActionListener {

  Button runsqlbutton;
  Label title, insqllabel, dblabel, userlabel, passlabel;
  TextField sql1, sql2, sql3, dbfield, userfield, passfield;
  TextArea textArea1;
 
  private void processQuery() {
    
    String dbname   = dbfield.getText();
    String user     = userfield.getText();
    String password = passfield.getText();
    String query    = sql1.getText() + " " + sql2.getText() + " " + sql3.getText();
   
    try {
      DataBase db = new DataBase(dbname,user,password);
      ResultSet rs = db.execute(query);
      if (rs != null) {
        ResultSetMetaData md = rs.getMetaData();
        textArea1.append(SQLutil.getRow(rs,md,true)+"\n");
        while(rs.next()) 
          textArea1.append(SQLutil.getRow(rs,md,false)+"\n"); 
        textArea1.append("\n");
      } else
        textArea1.append("Update/Insert/Delete completed.\n");
      db.close(); 
    } catch (Exception e){textArea1.append(e.getMessage()+"\n");} 

  }

  public void init() {
    super.init();
    setLayout(null);
  
    title = new Label("SQL1: Applet->JDBC->MySQL");
    title.setBounds(140,10,400,30);
    Font font = new Font("TimesRoman",Font.BOLD,15);
    title.setFont(font); 
    add(title);
    
    dblabel = new Label("Database:"); 
    dblabel.setBounds(20,50,60,30);
    add(dblabel);
    dbfield = new TextField(150); 
    dbfield.setBounds(90,50,150,30);
    dbfield.setText(getParameter("dbname"));
    add(dbfield);
  
    userlabel = new Label("User:"); 
    userlabel.setBounds(250,50,60,30);
    add(userlabel);
    userfield = new TextField(100); 
    userfield.setBounds(320,50,100,30);
    userfield.setText(getParameter("user"));
    add(userfield);
  
    passlabel = new Label("Password:"); 
    passlabel.setBounds(430,50,62,30);
    add(passlabel);
    passfield = new TextField(100); 
    passfield.setBounds(500,50,100,30);
    passfield.setEchoChar('*');
    passfield.setText(getParameter("password"));
    add(passfield);
  
    insqllabel = new Label("SQL Input:"); 
    insqllabel.setBounds(20,90,100,30);
    add(insqllabel);
  
    sql1 = new TextField(600); 
    sql1.setBounds(20,120,580,30);
    add(sql1);
    sql2 = new TextField(600); 
    sql2.setBounds(20,160,580,30);
    add(sql2);
    sql3 = new TextField(580); 
    sql3.setBounds(20,200,580,30);
    add(sql3);
    
    textArea1 = new TextArea();
    textArea1.setBounds(20,270,580,300);
    Font font1 = new Font("Courier",Font.PLAIN,10);
    textArea1.setFont(font1);
    add(textArea1);
      
    runsqlbutton = new Button("Run SQL");
    runsqlbutton.setBounds(20,240,70,25);
    add(runsqlbutton);
    runsqlbutton.addActionListener(this); 

  }
  
  public void actionPerformed(ActionEvent evt) {
    String arg = evt.getActionCommand();
    if (arg.equals("Run SQL")) {
      processQuery();
    }
  }
}