home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / Program_Files / JDPSQLInsert.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  9.5 KB  |  459 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 JDPSQLInsert 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 Panel2;
  21.    Panel Panel3;
  22.    JDPList tables;
  23.    Label Label1;
  24.    Panel Panel8;
  25.    Label Label5;
  26.    JDPList selectFrom;
  27.    Panel Panel7;
  28.    Panel Panel4;
  29.    JDPList insertColumns;
  30.    Label Label2;
  31.    Panel Panel5;
  32.    Label Label3;
  33.    JDPComboBox insertValue;
  34.    Vector valueinsertValue;
  35.    Panel Panel9;
  36.    Panel Panel10;
  37.    Label Label6;
  38.    JDPList whereColumns;
  39.    Panel Panel11;
  40.    Label Label7;
  41.    JDPComboBox whereSettings;
  42.    Vector valuewhereSettings;
  43.    boolean SQLOnly = false;
  44.    String alphabet = "abcdefghijklmnopqrstuvwxyz";
  45.    String value;
  46.  
  47.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  48.       this.user = var1;
  49.       this.moduleParameter = var3;
  50.       super.targetPanel = var2;
  51.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  52.       ((Container)this).setLayout(new BorderLayout());
  53.       this.popuppanel = new JDPPopupMessage(var1, this);
  54.       ((Container)this).add(this.popuppanel);
  55.       this.JDPMaskEditMain = new JDPMaskEdit();
  56.       this.Main = new Panel();
  57.       this.Panel1 = new Panel();
  58.       this.completeSQL = new TextArea("", 3, 20);
  59.       this.Label4 = new Label("SQL", 0);
  60.       this.Panel6 = new Panel();
  61.       this.Panel2 = new Panel();
  62.       this.Panel3 = new Panel();
  63.       this.tablesMain();
  64.       this.Label1 = new Label("Insert Into", 0);
  65.       this.Panel8 = new Panel();
  66.       this.Label5 = new Label("Select From (optional)", 0);
  67.       this.selectFromMain();
  68.       this.Panel7 = new Panel();
  69.       this.Panel4 = new Panel();
  70.       this.insertColumnsMain();
  71.       this.Label2 = new Label("Columns", 0);
  72.       this.Panel5 = new Panel();
  73.       this.Label3 = new Label("Insert Value", 0);
  74.       this.insertValueMain();
  75.       this.Panel9 = new Panel();
  76.       this.Panel10 = new Panel();
  77.       this.Label6 = new Label("Where (optional)", 0);
  78.       this.whereColumnsMain();
  79.       this.Panel11 = new Panel();
  80.       this.Label7 = new Label("Equals", 0);
  81.       this.whereSettingsMain();
  82.       this.Main.setLayout(new BorderLayout());
  83.       ((Container)this).add("Center", this.Main);
  84.       this.Main.add("Center", this.Panel1);
  85.       this.Panel1.setLayout(new BorderLayout());
  86.       this.Panel1.add("Center", this.completeSQL);
  87.       this.Panel1.add("North", this.Label4);
  88.       this.Main.add("North", this.Panel6);
  89.       this.Panel6.setLayout(new JDPRowLayout());
  90.       this.Panel6.add("Left", this.Panel2);
  91.       this.Panel2.setLayout(new JDPLineLayout());
  92.       this.Panel2.add("Left", this.Panel3);
  93.       this.Panel3.setLayout(new BorderLayout());
  94.       this.Panel3.add("Center", this.tables);
  95.       this.Panel3.add("North", this.Label1);
  96.       this.Panel6.add("Left", this.Panel8);
  97.       this.Panel8.setLayout(new BorderLayout());
  98.       this.Panel8.add("North", this.Label5);
  99.       this.Panel8.add("Center", this.selectFrom);
  100.       this.Panel6.add("Left", this.Panel7);
  101.       this.Panel7.setLayout(new JDPLineLayout());
  102.       this.Panel7.add("Left", this.Panel4);
  103.       this.Panel4.setLayout(new BorderLayout());
  104.       this.Panel4.add("Center", this.insertColumns);
  105.       this.Panel4.add("North", this.Label2);
  106.       this.Panel7.add("Left", this.Panel5);
  107.       this.Panel5.setLayout(new JDPRowLayout());
  108.       this.Panel5.add("Left", this.Label3);
  109.       this.Panel5.add("Left", this.insertValue);
  110.       this.Panel6.add("Left", this.Panel9);
  111.       this.Panel9.setLayout(new JDPLineLayout());
  112.       this.Panel9.add("Left", this.Panel10);
  113.       this.Panel10.setLayout(new BorderLayout());
  114.       this.Panel10.add("North", this.Label6);
  115.       this.Panel10.add("Center", this.whereColumns);
  116.       this.Panel9.add("Left", this.Panel11);
  117.       this.Panel11.setLayout(new JDPRowLayout());
  118.       this.Panel11.add("Left", this.Label7);
  119.       this.Panel11.add("Left", this.whereSettings);
  120.       this.tables.setBackground(var1.u._cvtcolor("White"));
  121.       this.tables.setMinHeight(50);
  122.       this.tables.setMinWidth(285);
  123.       this.selectFrom.setBackground(var1.u._cvtcolor("White"));
  124.       this.selectFrom.setMinHeight(50);
  125.       this.selectFrom.setMultipleSelections(true);
  126.       this.selectFrom.setSelectionsCheckboxes(true);
  127.       this.selectFrom.setMinWidth(285);
  128.       this.insertColumns.setBackground(var1.u._cvtcolor("White"));
  129.       this.insertColumns.setMinHeight(50);
  130.       this.insertColumns.setMultipleSelections(true);
  131.       this.insertColumns.setSelectionsCheckboxes(true);
  132.       this.insertValue.setMinimumWidth(140);
  133.       this.whereColumns.setBackground(var1.u._cvtcolor("White"));
  134.       this.whereColumns.setMinHeight(50);
  135.       this.whereColumns.setMultipleSelections(true);
  136.       this.whereColumns.setSelectionsCheckboxes(true);
  137.       this.whereSettings.setMinimumWidth(140);
  138.       this.InitComponents();
  139.       var1.gParm.addElement(this);
  140.    }
  141.  
  142.    public boolean handleEvent(Event var1) {
  143.       switch (var1.id) {
  144.          case 402:
  145.             if (var1.target.equals(this.insertValue)) {
  146.                String var16 = this.insertColumns.getSelectedKey();
  147.                String var21 = var16.substring(var16.indexOf(":"));
  148.                this.insertColumns.replaceItemKey(this.insertColumns.getSelectedIndex(), this.insertValue.getText() + var21);
  149.                this.constructSQL();
  150.                return true;
  151.             } else {
  152.                if (var1.target.equals(this.whereSettings)) {
  153.                   String var15 = this.whereColumns.getSelectedKey();
  154.                   String var20 = var15.substring(var15.indexOf(":"));
  155.                   this.whereColumns.replaceItemKey(this.whereColumns.getSelectedIndex(), this.whereSettings.getText() + var20);
  156.                   this.constructSQL();
  157.                   return true;
  158.                }
  159.  
  160.                return false;
  161.             }
  162.          case 503:
  163.          case 504:
  164.          case 505:
  165.             this.popuppanel.postEvent(var1);
  166.             return false;
  167.          case 701:
  168.             if (var1.target.equals(this.tables)) {
  169.                Event var14 = new Event(this, 1001, "Tables");
  170.                ((Container)this).deliverEvent(var14);
  171.                this.constructSQL();
  172.                return true;
  173.             } else if (var1.target.equals(this.selectFrom)) {
  174.                Event var13 = new Event(this, 1001, "SelectFrom");
  175.                ((Container)this).deliverEvent(var13);
  176.                this.constructSQL();
  177.                return true;
  178.             } else if (var1.target.equals(this.insertColumns)) {
  179.                if (this.insertColumns.getSelectedIndex() >= 0) {
  180.                   String var10 = this.insertColumns.getSelectedKey();
  181.                   var10 = var10.substring(0, var10.indexOf(":"));
  182.                   this.insertValue.setText(var10);
  183.                } else {
  184.                   this.insertValue.setText("");
  185.                }
  186.  
  187.                this.constructSQL();
  188.                Event var12 = new Event(this, 701, "insertColumns");
  189.                ((Container)this).deliverEvent(var12);
  190.                return true;
  191.             } else {
  192.                if (var1.target.equals(this.whereColumns)) {
  193.                   if (this.whereColumns.getSelectedIndex() >= 0) {
  194.                      String var7 = this.whereColumns.getSelectedKey();
  195.                      var7 = var7.substring(0, var7.indexOf(":"));
  196.                      this.whereSettings.setText(var7);
  197.                   } else {
  198.                      this.whereSettings.setText("");
  199.                   }
  200.  
  201.                   this.constructSQL();
  202.                   Event var9 = new Event(this, 701, "whereColumns");
  203.                   ((Container)this).deliverEvent(var9);
  204.                   return true;
  205.                }
  206.  
  207.                return false;
  208.             }
  209.          case 702:
  210.             if (var1.target.equals(this.insertColumns)) {
  211.                this.constructSQL();
  212.                return true;
  213.             } else {
  214.                if (var1.target.equals(this.whereColumns)) {
  215.                   this.constructSQL();
  216.                   return true;
  217.                }
  218.  
  219.                return false;
  220.             }
  221.          case 1001:
  222.             if (var1.target.equals(this.insertColumns)) {
  223.                this.constructSQL();
  224.                return true;
  225.             } else if (var1.target.equals(this.insertValue)) {
  226.                String var6 = this.insertColumns.getSelectedKey();
  227.                String var19 = var6.substring(var6.indexOf(":"));
  228.                this.insertColumns.replaceItemKey(this.insertColumns.getSelectedIndex(), this.insertValue.getText() + var19);
  229.                this.constructSQL();
  230.                return true;
  231.             } else if (var1.target.equals(this.whereColumns)) {
  232.                this.constructSQL();
  233.                return true;
  234.             } else {
  235.                if (var1.target.equals(this.whereSettings)) {
  236.                   String var5 = this.whereColumns.getSelectedKey();
  237.                   String var18 = var5.substring(var5.indexOf(":"));
  238.                   this.whereColumns.replaceItemKey(this.whereColumns.getSelectedIndex(), this.whereSettings.getText() + var18);
  239.                   this.constructSQL();
  240.                   return true;
  241.                }
  242.  
  243.                return false;
  244.             }
  245.          case 1005:
  246.             if (var1.target.equals(this.insertValue)) {
  247.                String var4 = this.insertColumns.getSelectedKey();
  248.                String var17 = var4.substring(var4.indexOf(":"));
  249.                this.insertColumns.replaceItemKey(this.insertColumns.getSelectedIndex(), this.insertValue.getText() + var17);
  250.                this.constructSQL();
  251.                return true;
  252.             } else {
  253.                if (var1.target.equals(this.whereSettings)) {
  254.                   String var2 = this.whereColumns.getSelectedKey();
  255.                   String var3 = var2.substring(var2.indexOf(":"));
  256.                   this.whereColumns.replaceItemKey(this.whereColumns.getSelectedIndex(), this.whereSettings.getText() + var3);
  257.                   this.constructSQL();
  258.                   return true;
  259.                }
  260.  
  261.                return false;
  262.             }
  263.          default:
  264.             return false;
  265.       }
  266.    }
  267.  
  268.    public void InitComponents() {
  269.       this.jaggSQL.setKeepConnectionOpen(false);
  270.    }
  271.  
  272.    public void MainMethod() {
  273.    }
  274.  
  275.    public JDPList getTableHandle() {
  276.       return this.tables;
  277.    }
  278.  
  279.    public String constructSQL() {
  280.       String var1 = this.constructCompleteSQL(this.SQLOnly);
  281.       this.completeSQL.setText(var1);
  282.       return var1;
  283.    }
  284.  
  285.    public JDPList getInsertColumnsHandle() {
  286.       return this.insertColumns;
  287.    }
  288.  
  289.    public JDPComboBox getInsertValueHandle() {
  290.       return this.insertValue;
  291.    }
  292.  
  293.    public JDPList getWhereColumnsHandle() {
  294.       return this.whereColumns;
  295.    }
  296.  
  297.    public JDPComboBox getWhereSettingsHandle() {
  298.       return this.whereSettings;
  299.    }
  300.  
  301.    public JDPList getSelectFromHandle() {
  302.       return this.selectFrom;
  303.    }
  304.  
  305.    public void setSQLOnly(boolean var1) {
  306.       this.SQLOnly = var1;
  307.    }
  308.  
  309.    public String constructCompleteSQL(boolean var1) {
  310.       StringBuffer var2 = new StringBuffer();
  311.       if (this.tables.getSelectedIndex() == -1) {
  312.          return "";
  313.       } else {
  314.          String var3 = "\"";
  315.          String var4 = "+";
  316.          if (var1) {
  317.             var3 = "";
  318.             var4 = "";
  319.          }
  320.  
  321.          var2.append(var3 + "INSERT INTO ");
  322.          var2.append(this.tables.getSelectedItem());
  323.          var2.append(" " + var3);
  324.          if (this.insertColumns.getSelectedIndexes().length > 0) {
  325.             var2.append(" " + var4 + "\n\t" + var3 + "(");
  326.             int[] var5 = this.insertColumns.getSelectedIndexes();
  327.  
  328.             for(int var6 = 0; var6 < var5.length; ++var6) {
  329.                if (var6 > 0) {
  330.                   var2.append(", " + var3 + " " + var4 + "\n\t" + var3);
  331.                }
  332.  
  333.                var2.append(this.insertColumns.getItem(var5[var6]));
  334.             }
  335.  
  336.             if (this.selectFrom.getSelectedItems().length == 0) {
  337.                var2.append(")" + var3 + " " + var4 + "\n" + var3 + "VALUES (");
  338.  
  339.                for(int var7 = 0; var7 < var5.length; ++var7) {
  340.                   if (var7 > 0) {
  341.                      var2.append(", " + var3 + " " + var4 + "\n\t" + var3);
  342.                   }
  343.  
  344.                   this.value = this.insertColumns.getItemKey(var5[var7]);
  345.                   this.value = this.value.substring(0, this.value.indexOf(":"));
  346.                   var2.append(this.value);
  347.                }
  348.  
  349.                var2.append(")" + var3);
  350.             } else {
  351.                var2.append(")" + var3 + " + \n" + var3 + "SELECT ");
  352.  
  353.                for(int var13 = 0; var13 < var5.length; ++var13) {
  354.                   if (var13 > 0) {
  355.                      var2.append(", " + var3 + " " + var4 + "\n\t" + var3);
  356.                   }
  357.  
  358.                   this.value = this.insertColumns.getItemKey(var5[var13]);
  359.                   this.value = this.value.substring(0, this.value.indexOf(":"));
  360.                   var2.append(this.value);
  361.                }
  362.  
  363.                var2.append(" " + var3 + " " + var4 + "\n" + var3 + "FROM ");
  364.                String[] var8 = this.selectFrom.getSelectedItems();
  365.  
  366.                for(int var9 = 0; var9 < var8.length; ++var9) {
  367.                   if (var9 > 0) {
  368.                      var2.append(", ");
  369.                   }
  370.  
  371.                   if (var8.length == 1) {
  372.                      var2.append(var8[var9]);
  373.                   } else {
  374.                      var2.append(var8[var9] + " " + this.alphabet.substring(var9, var9 + 1));
  375.                   }
  376.                }
  377.  
  378.                var2.append(" " + var3);
  379.                if (this.whereColumns.getSelectedIndexes().length > 0) {
  380.                   String var10 = " " + var4 + "\n" + var3 + "WHERE ";
  381.                   int[] var11 = this.whereColumns.getSelectedIndexes();
  382.  
  383.                   for(int var12 = 0; var12 < var11.length; ++var12) {
  384.                      var2.append(var10);
  385.                      var10 = " " + var4 + "\n" + var3 + "AND ";
  386.                      var2.append(this.whereColumns.getItem(var11[var12]));
  387.                      var2.append(" = ");
  388.                      this.value = this.whereColumns.getItemKey(var11[var12]);
  389.                      this.value = this.value.substring(0, this.value.indexOf(":"));
  390.                      var2.append(this.value);
  391.                      var2.append(" " + var3);
  392.                   }
  393.                }
  394.             }
  395.          }
  396.  
  397.          return var2.toString();
  398.       }
  399.    }
  400.  
  401.    public String getSQL() {
  402.       return this.SQLOnly ? this.completeSQL.getText() : this.constructCompleteSQL(true);
  403.    }
  404.  
  405.    public void clear() {
  406.       this.tables.clear();
  407.       this.selectFrom.clear();
  408.       this.insertColumns.clear();
  409.       this.insertValue.clear();
  410.       this.insertValue.setText("");
  411.       this.whereColumns.clear();
  412.       this.whereSettings.clear();
  413.       this.whereSettings.setText("");
  414.       this.completeSQL.setText("");
  415.    }
  416.  
  417.    public void tablesMain() {
  418.       if (this.tables == null) {
  419.          this.tables = new JDPList(this.user);
  420.       }
  421.  
  422.    }
  423.  
  424.    public void selectFromMain() {
  425.       if (this.selectFrom == null) {
  426.          this.selectFrom = new JDPList(this.user);
  427.       }
  428.  
  429.    }
  430.  
  431.    public void insertColumnsMain() {
  432.       if (this.insertColumns == null) {
  433.          this.insertColumns = new JDPList(this.user);
  434.       }
  435.  
  436.    }
  437.  
  438.    public void insertValueMain() {
  439.       if (this.insertValue == null) {
  440.          this.insertValue = new JDPComboBox(this.user);
  441.       }
  442.  
  443.    }
  444.  
  445.    public void whereColumnsMain() {
  446.       if (this.whereColumns == null) {
  447.          this.whereColumns = new JDPList(this.user);
  448.       }
  449.  
  450.    }
  451.  
  452.    public void whereSettingsMain() {
  453.       if (this.whereSettings == null) {
  454.          this.whereSettings = new JDPComboBox(this.user);
  455.       }
  456.  
  457.    }
  458. }
  459.