home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / Program_Files / JDPSQLDelete.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  6.4 KB  |  266 lines
  1. import java.awt.BorderLayout;
  2. import java.awt.Container;
  3. import java.awt.Event;
  4. import java.awt.Label;
  5. import java.awt.Panel;
  6. import java.awt.TextArea;
  7. import java.util.Vector;
  8.  
  9. public class JDPSQLDelete extends JDPClassLayout {
  10.    JDPUser user;
  11.    JDPJagg jaggSQL;
  12.    JDPPopupMessage popuppanel;
  13.    JDPMaskEdit JDPMaskEditMain;
  14.    String moduleParameter;
  15.    Panel Main;
  16.    Panel Panel1;
  17.    TextArea completeSQL;
  18.    Label Label4;
  19.    Panel Panel6;
  20.    Panel Panel3;
  21.    JDPList tables;
  22.    Label Label1;
  23.    Panel Panel2;
  24.    Panel Panel4;
  25.    JDPList whereColumns;
  26.    Label Label2;
  27.    Panel Panel5;
  28.    Label Label3;
  29.    JDPComboBox whereSettings;
  30.    Vector valuewhereSettings;
  31.    boolean SQLOnly = false;
  32.  
  33.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  34.       this.user = var1;
  35.       this.moduleParameter = var3;
  36.       super.targetPanel = var2;
  37.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  38.       ((Container)this).setLayout(new BorderLayout());
  39.       this.popuppanel = new JDPPopupMessage(var1, this);
  40.       ((Container)this).add(this.popuppanel);
  41.       this.JDPMaskEditMain = new JDPMaskEdit();
  42.       this.Main = new Panel();
  43.       this.Panel1 = new Panel();
  44.       this.completeSQL = new TextArea("", 3, 20);
  45.       this.Label4 = new Label("SQL", 0);
  46.       this.Panel6 = new Panel();
  47.       this.Panel3 = new Panel();
  48.       this.tablesMain();
  49.       this.Label1 = new Label("Delete From", 0);
  50.       this.Panel2 = new Panel();
  51.       this.Panel4 = new Panel();
  52.       this.whereColumnsMain();
  53.       this.Label2 = new Label("Where", 0);
  54.       this.Panel5 = new Panel();
  55.       this.Label3 = new Label("Equals", 0);
  56.       this.whereSettingsMain();
  57.       this.Main.setLayout(new BorderLayout());
  58.       ((Container)this).add("Center", this.Main);
  59.       this.Main.add("Center", this.Panel1);
  60.       this.Panel1.setLayout(new BorderLayout());
  61.       this.Panel1.add("Center", this.completeSQL);
  62.       this.Panel1.add("North", this.Label4);
  63.       this.Main.add("North", this.Panel6);
  64.       this.Panel6.setLayout(new JDPRowLayout());
  65.       this.Panel6.add("Left", this.Panel3);
  66.       this.Panel3.setLayout(new BorderLayout());
  67.       this.Panel3.add("Center", this.tables);
  68.       this.Panel3.add("North", this.Label1);
  69.       this.Panel6.add("Left", this.Panel2);
  70.       this.Panel2.setLayout(new JDPLineLayout());
  71.       this.Panel2.add("Left", this.Panel4);
  72.       this.Panel4.setLayout(new BorderLayout());
  73.       this.Panel4.add("Center", this.whereColumns);
  74.       this.Panel4.add("North", this.Label2);
  75.       this.Panel2.add("Left", this.Panel5);
  76.       this.Panel5.setLayout(new JDPRowLayout());
  77.       this.Panel5.add("Left", this.Label3);
  78.       this.Panel5.add("Left", this.whereSettings);
  79.       this.tables.setBackground(var1.u._cvtcolor("White"));
  80.       this.tables.setMinHeight(60);
  81.       this.tables.setMinWidth(285);
  82.       this.whereColumns.setBackground(var1.u._cvtcolor("White"));
  83.       this.whereColumns.setMinHeight(60);
  84.       this.whereColumns.setMultipleSelections(true);
  85.       this.whereColumns.setSelectionsCheckboxes(true);
  86.       this.whereSettings.setMinimumWidth(140);
  87.       this.InitComponents();
  88.       var1.gParm.addElement(this);
  89.    }
  90.  
  91.    public boolean handleEvent(Event var1) {
  92.       switch (var1.id) {
  93.          case 402:
  94.             if (var1.target.equals(this.whereSettings)) {
  95.                String var9 = this.whereColumns.getSelectedKey();
  96.                String var11 = var9.substring(var9.indexOf(":"));
  97.                this.whereColumns.replaceItemKey(this.whereColumns.getSelectedIndex(), this.whereSettings.getText() + var11);
  98.                this.constructSQL();
  99.                return true;
  100.             }
  101.  
  102.             return false;
  103.          case 503:
  104.          case 504:
  105.          case 505:
  106.             this.popuppanel.postEvent(var1);
  107.             return false;
  108.          case 701:
  109.             if (var1.target.equals(this.tables)) {
  110.                Event var8 = new Event(this, 1001, this.tables.getSelectedItem());
  111.                ((Container)this).deliverEvent(var8);
  112.                this.constructSQL();
  113.                return true;
  114.             } else {
  115.                if (var1.target.equals(this.whereColumns)) {
  116.                   if (this.whereColumns.getSelectedIndex() >= 0) {
  117.                      String var5 = this.whereColumns.getSelectedKey();
  118.                      var5 = var5.substring(0, var5.indexOf(":"));
  119.                      this.whereSettings.setText(var5);
  120.                   } else {
  121.                      this.whereSettings.setText("");
  122.                   }
  123.  
  124.                   this.constructSQL();
  125.                   Event var7 = new Event(this, 701, this.whereSettings.getSelectedItem());
  126.                   ((Container)this).deliverEvent(var7);
  127.                   return true;
  128.                }
  129.  
  130.                return false;
  131.             }
  132.          case 702:
  133.             if (var1.target.equals(this.whereColumns)) {
  134.                this.constructSQL();
  135.                return true;
  136.             }
  137.  
  138.             return false;
  139.          case 1001:
  140.             if (var1.target.equals(this.whereColumns)) {
  141.                this.constructSQL();
  142.                return true;
  143.             } else {
  144.                if (var1.target.equals(this.whereSettings)) {
  145.                   String var4 = this.whereColumns.getSelectedKey();
  146.                   String var10 = var4.substring(var4.indexOf(":"));
  147.                   this.whereColumns.replaceItemKey(this.whereColumns.getSelectedIndex(), this.whereSettings.getText() + var10);
  148.                   this.constructSQL();
  149.                   return true;
  150.                }
  151.  
  152.                return false;
  153.             }
  154.          case 1005:
  155.             if (var1.target.equals(this.whereSettings)) {
  156.                String var2 = this.whereColumns.getSelectedKey();
  157.                String var3 = var2.substring(var2.indexOf(":"));
  158.                this.whereColumns.replaceItemKey(this.whereColumns.getSelectedIndex(), this.whereSettings.getText() + var3);
  159.                this.constructSQL();
  160.                return true;
  161.             }
  162.  
  163.             return false;
  164.          default:
  165.             return false;
  166.       }
  167.    }
  168.  
  169.    public void InitComponents() {
  170.       this.jaggSQL.setKeepConnectionOpen(false);
  171.    }
  172.  
  173.    public void MainMethod() {
  174.    }
  175.  
  176.    public JDPList getTableHandle() {
  177.       return this.tables;
  178.    }
  179.  
  180.    public JDPList getWhereColumnsHandle() {
  181.       return this.whereColumns;
  182.    }
  183.  
  184.    public JDPComboBox getWhereSettingsHandle() {
  185.       return this.whereSettings;
  186.    }
  187.  
  188.    public String constructSQL() {
  189.       String var1 = this.constructCompleteSQL(this.SQLOnly);
  190.       this.completeSQL.setText(var1);
  191.       return var1;
  192.    }
  193.  
  194.    public void setSQLOnly(boolean var1) {
  195.       this.SQLOnly = var1;
  196.    }
  197.  
  198.    public String constructCompleteSQL(boolean var1) {
  199.       StringBuffer var2 = new StringBuffer();
  200.       if (this.tables.getSelectedIndex() == -1) {
  201.          return "";
  202.       } else {
  203.          String var4 = "\"";
  204.          String var5 = "+";
  205.          if (var1) {
  206.             var4 = "";
  207.             var5 = "";
  208.          }
  209.  
  210.          var2.append(var4 + "DELETE FROM ");
  211.          var2.append(this.tables.getSelectedItem());
  212.          var2.append(" " + var4);
  213.          if (this.whereColumns.getSelectedIndexes().length > 0) {
  214.             String var6 = " " + var5 + "\n" + var4 + "WHERE ";
  215.             int[] var7 = this.whereColumns.getSelectedIndexes();
  216.  
  217.             for(int var8 = 0; var8 < var7.length; ++var8) {
  218.                var2.append(var6);
  219.                var6 = " " + var5 + "\n" + var4 + "AND ";
  220.                var2.append(this.whereColumns.getItem(var7[var8]));
  221.                var2.append(" = ");
  222.                String var3 = this.whereColumns.getItemKey(var7[var8]);
  223.                var3 = var3.substring(0, var3.indexOf(":"));
  224.                var2.append(var3);
  225.                var2.append(" " + var4);
  226.             }
  227.          }
  228.  
  229.          return var2.toString();
  230.       }
  231.    }
  232.  
  233.    public String getSQL() {
  234.       return this.SQLOnly ? this.completeSQL.getText() : this.constructCompleteSQL(true);
  235.    }
  236.  
  237.    public void clear() {
  238.       this.tables.clear();
  239.       this.whereColumns.clear();
  240.       this.whereSettings.clear();
  241.       this.whereSettings.setText("");
  242.       this.completeSQL.setText("");
  243.    }
  244.  
  245.    public void tablesMain() {
  246.       if (this.tables == null) {
  247.          this.tables = new JDPList(this.user);
  248.       }
  249.  
  250.    }
  251.  
  252.    public void whereColumnsMain() {
  253.       if (this.whereColumns == null) {
  254.          this.whereColumns = new JDPList(this.user);
  255.       }
  256.  
  257.    }
  258.  
  259.    public void whereSettingsMain() {
  260.       if (this.whereSettings == null) {
  261.          this.whereSettings = new JDPComboBox(this.user);
  262.       }
  263.  
  264.    }
  265. }
  266.