home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / Program_Files / StoreInquiry.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  9.5 KB  |  302 lines
  1. import java.awt.BorderLayout;
  2. import java.awt.Checkbox;
  3. import java.awt.CheckboxGroup;
  4. import java.awt.Container;
  5. import java.awt.Event;
  6. import java.awt.Label;
  7. import java.awt.Panel;
  8. import java.awt.TextField;
  9. import java.util.StringTokenizer;
  10. import java.util.Vector;
  11.  
  12. public class StoreInquiry extends JDPClassLayout {
  13.    JDPUser user;
  14.    JDPJagg jaggSQL;
  15.    JDPPopupMessage popuppanel;
  16.    JDPMaskEdit JDPMaskEditMain;
  17.    String moduleParameter;
  18.    Panel Main;
  19.    Panel Columns1;
  20.    JDPScrollPanel ScrollPanel1;
  21.    Label stor_idLabel1;
  22.    TextField stor_id1;
  23.    Label stor_nameLabel1;
  24.    TextField stor_name1;
  25.    Label stor_addressLabel1;
  26.    TextField stor_address1;
  27.    Label cityLabel1;
  28.    JDPChoice city1;
  29.    Vector valuecity1;
  30.    Label stateLabel1;
  31.    Panel stateLine1;
  32.    Checkbox state1;
  33.    Checkbox state11;
  34.    Checkbox state12;
  35.    Label zipLabel1;
  36.    JDPComboBox zip1;
  37.    Vector valuezip1;
  38.    JDPSearchResults ResultList1;
  39.  
  40.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  41.       this.user = var1;
  42.       this.moduleParameter = var3;
  43.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  44.       ((Container)this).setLayout(new BorderLayout());
  45.       this.popuppanel = new JDPPopupMessage(var1, this);
  46.       ((Container)this).add(this.popuppanel);
  47.       this.JDPMaskEditMain = new JDPMaskEdit();
  48.       CheckboxGroup var4 = new CheckboxGroup();
  49.       this.Main = new Panel();
  50.       this.Columns1 = new Panel();
  51.       this.ScrollPanel1 = new JDPScrollPanel();
  52.       this.stor_idLabel1 = new Label("Stor Id:", 0);
  53.       this.stor_id1 = new TextField("stor_id", 6);
  54.       this.stor_nameLabel1 = new Label("Stor name:", 0);
  55.       this.stor_name1 = new TextField("stor_name", 42);
  56.       this.stor_addressLabel1 = new Label("Stor Address:", 0);
  57.       this.stor_address1 = new TextField("stor_address", 42);
  58.       this.cityLabel1 = new Label("City:", 0);
  59.       this.city1 = new JDPChoice();
  60.       this.stateLabel1 = new Label("State:", 0);
  61.       this.stateLine1 = new Panel();
  62.       this.state1 = new Checkbox("CA", var4, false);
  63.       this.state11 = new Checkbox("WA", var4, false);
  64.       this.state12 = new Checkbox("OR", var4, false);
  65.       this.zipLabel1 = new Label("Zip:", 0);
  66.       this.zip1 = new JDPComboBox(var1);
  67.       this.ResultList1Main();
  68.       this.Main.setLayout(new BorderLayout());
  69.       ((Container)this).add("Center", this.Main);
  70.       this.Main.add("Center", this.Columns1);
  71.       this.Columns1.setLayout(new BorderLayout());
  72.       this.Columns1Main();
  73.       this.Columns1.add("Center", this.ScrollPanel1);
  74.       this.ScrollPanel1.add("Left", this.stor_idLabel1);
  75.       this.ScrollPanel1.add("Right", this.stor_id1);
  76.       this.ScrollPanel1.add("Left", this.stor_nameLabel1);
  77.       this.ScrollPanel1.add("Right", this.stor_name1);
  78.       this.ScrollPanel1.add("Left", this.stor_addressLabel1);
  79.       this.ScrollPanel1.add("Right", this.stor_address1);
  80.       this.ScrollPanel1.add("Left", this.cityLabel1);
  81.       this.ScrollPanel1.add("Right", this.city1);
  82.       this.ScrollPanel1.add("Left", this.stateLabel1);
  83.       this.ScrollPanel1.add("Right", this.stateLine1);
  84.       this.stateLine1.setLayout(new JDPLineLayout());
  85.       this.stateLine1.add("Left", this.state1);
  86.       this.stateLine1.add("Left", this.state11);
  87.       this.stateLine1.add("Left", this.state12);
  88.       this.ScrollPanel1.add("Left", this.zipLabel1);
  89.       this.ScrollPanel1.add("Right", this.zip1);
  90.       this.Main.add("West", this.ResultList1);
  91.       this.popuppanel.addComponent(this.stor_id1, "Stor Id", "");
  92.       this.popuppanel.addComponent(this.stor_name1, "Stor name", "");
  93.       this.popuppanel.addComponent(this.stor_address1, "Stor Address", "");
  94.       this.popuppanel.addComponent(this.city1, "City", "");
  95.       this.popuppanel.addComponent(this.state1, "State", "");
  96.       this.popuppanel.addComponent(this.state11, "State", "");
  97.       this.popuppanel.addComponent(this.state12, "State", "");
  98.       this.popuppanel.addComponent(this.zip1, "Zip", "");
  99.       this.InitComponents();
  100.       var1.gParm.addElement(this);
  101.    }
  102.  
  103.    public boolean handleEvent(Event var1) {
  104.       switch (var1.id) {
  105.          case 503:
  106.          case 504:
  107.          case 505:
  108.             this.popuppanel.postEvent(var1);
  109.             return false;
  110.          case 1001:
  111.             if (var1.target.equals(this.ResultList1)) {
  112.                this.Columns1Load(this.ResultList1.getSelectedKey());
  113.                return true;
  114.             }
  115.  
  116.             return false;
  117.          default:
  118.             return false;
  119.       }
  120.    }
  121.  
  122.    public void InitComponents() {
  123.    }
  124.  
  125.    public void Columns1Main() {
  126.       this.Columns1LoadChoices();
  127.       this.Columns1ClearFields();
  128.    }
  129.  
  130.    public void Columns1Load(String[] var1) {
  131.       int var3 = 0;
  132.       Vector var4 = new Vector();
  133.       String var5 = this.jaggSQL.getSEP();
  134.       if (var1 != null && var1.length >= 0) {
  135.          String var8 = "SELECT stor_id,stor_name,stor_address,city,state,zip FROM dbo_stores WHERE (1=1)";
  136.          if (var1.length > 0 && var1[0] != null) {
  137.             var8 = var8 + " AND stor_id='" + var1[0] + "'";
  138.          }
  139.  
  140.          this.jaggSQL.setDSN("JDP Tutorial");
  141.          this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  142.          this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  143.          this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  144.          this.jaggSQL.setUID("");
  145.          this.jaggSQL.setPWD("");
  146.          this.jaggSQL.setCSTR(" ");
  147.          this.jaggSQL.setMRW("1000");
  148.          this.jaggSQL.setTOUT("60");
  149.          this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  150.          var3 = this.jaggSQL.execSQL(var8, var4);
  151.          if (var3 == -1) {
  152.             this.user.u.setSqlMessage(this.jaggSQL, var8);
  153.          } else if (var3 >= 1) {
  154.             String var6 = (String)var4.elementAt(0);
  155.             if (var6 != null && var6.trim().compareTo("") != 0) {
  156.                StringTokenizer var2 = new StringTokenizer(var6);
  157.                this.stor_id1.setText(var2.nextToken(var5).trim());
  158.                this.stor_name1.setText(var2.nextToken(var5).trim());
  159.                this.stor_address1.setText(var2.nextToken(var5).trim());
  160.                String var7 = var2.nextToken(var5).trim();
  161.                if (this.valuecity1.indexOf(var7) >= 0) {
  162.                   this.city1.select(this.valuecity1.indexOf(var7));
  163.                }
  164.  
  165.                var7 = var2.nextToken(var5).trim();
  166.                this.state1.setState(var7.equals("CA"));
  167.                this.state11.setState(var7.equals("WA"));
  168.                this.state12.setState(var7.equals("OR"));
  169.                this.zip1.setText(var2.nextToken(var5).trim());
  170.             }
  171.  
  172.             if (var3 > 1) {
  173.                this.user.mainmsg.setStatusMsg("Multiple records found - first match only displayed.", 10);
  174.             } else {
  175.                this.user.mainmsg.clearStatusMsg();
  176.             }
  177.          } else {
  178.             this.user.mainmsg.setStatusMsg("Requested entry does not exist.", 10);
  179.             this.Columns1ClearFields();
  180.          }
  181.       } else {
  182.          this.Columns1ClearFields();
  183.       }
  184.    }
  185.  
  186.    public boolean Columns1updateRow(String[] var1) {
  187.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "U") : false;
  188.    }
  189.  
  190.    public boolean Columns1insertRow(String[] var1) {
  191.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "I") : false;
  192.    }
  193.  
  194.    public boolean Columns1removeRow(String[] var1) {
  195.       return this.Columns1Save(var1, "D");
  196.    }
  197.  
  198.    boolean Columns1Save(String[] var1, String var2) {
  199.       int var3 = 0;
  200.       Vector var4 = new Vector();
  201.       this.jaggSQL.getSEP();
  202.       String var5 = "";
  203.       if (var2.equals("I")) {
  204.          var5 = "INSERT INTO dbo_stores (stor_id, stor_name, stor_address, city, state, zip) VALUES('" + this.user.u.replace(this.stor_id1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.stor_name1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.stor_address1.getText(), "'", "''") + "', " + "'" + (String)this.valuecity1.elementAt(this.city1.getSelectedIndex()) + "', " + "'" + (this.state1.getState() ? "CA" : (this.state11.getState() ? "WA" : (this.state12.getState() ? "OR" : " "))) + "', " + "'" + this.user.u.replace(this.zip1.getText(), "'", "''") + "')";
  205.       } else {
  206.          if (var1 == null || var1.length == 0) {
  207.             this.user.mainmsg.setStatusMsg("You must first make a selection", 5);
  208.             return false;
  209.          }
  210.  
  211.          if (var2.equals("D")) {
  212.             var5 = "DELETE FROM dbo_stores WHERE stor_id='" + var1[0] + "'";
  213.          } else {
  214.             var5 = "UPDATE dbo_stores SET stor_name = '" + this.user.u.replace(this.stor_name1.getText(), "'", "''") + "', " + "stor_address = '" + this.user.u.replace(this.stor_address1.getText(), "'", "''") + "', " + "city = '" + (String)this.valuecity1.elementAt(this.city1.getSelectedIndex()) + "', " + "state = '" + (this.state1.getState() ? "CA" : (this.state11.getState() ? "WA" : (this.state12.getState() ? "OR" : " "))) + "', " + "zip = '" + this.user.u.replace(this.zip1.getText(), "'", "''") + "'" + " WHERE stor_id='" + var1[0] + "'";
  215.          }
  216.       }
  217.  
  218.       this.jaggSQL.setDSN("JDP Tutorial");
  219.       this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  220.       this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  221.       this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  222.       this.jaggSQL.setUID("");
  223.       this.jaggSQL.setPWD("");
  224.       this.jaggSQL.setCSTR(" ");
  225.       this.jaggSQL.setMRW("1000");
  226.       this.jaggSQL.setTOUT("60");
  227.       this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  228.       var3 = this.jaggSQL.execSQL(var5, var4);
  229.       if (var3 == -1) {
  230.          this.user.u.setSqlMessage(this.jaggSQL, var5);
  231.          return false;
  232.       } else {
  233.          if (var3 == 1) {
  234.             if (var2.equals("I")) {
  235.                this.user.mainmsg.setStatusMsg("Record successfully added.", 3);
  236.             } else if (var2.equals("D")) {
  237.                this.user.mainmsg.setStatusMsg("Record successfully removed.", 3);
  238.             } else {
  239.                this.user.mainmsg.setStatusMsg("Record successfully updated.", 3);
  240.             }
  241.          } else {
  242.             this.user.u.setSqlMessage(this.jaggSQL, var5);
  243.          }
  244.  
  245.          return true;
  246.       }
  247.    }
  248.  
  249.    public void Columns1ClearFields() {
  250.       this.stor_id1.setText("");
  251.       this.stor_name1.setText("");
  252.       this.stor_address1.setText("");
  253.       this.city1.select(0);
  254.       this.state1.setState(false);
  255.       this.state11.setState(false);
  256.       this.state12.setState(false);
  257.       this.zip1.setText("");
  258.    }
  259.  
  260.    void Columns1LoadChoices() {
  261.       this.jaggSQL.setDSN("JDP Tutorial");
  262.       this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  263.       this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  264.       this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  265.       this.jaggSQL.setUID("");
  266.       this.jaggSQL.setPWD("");
  267.       this.jaggSQL.setCSTR(" ");
  268.       this.jaggSQL.setMRW("1000");
  269.       this.jaggSQL.setTOUT("60");
  270.       this.valuecity1 = new Vector();
  271.       new JDPLoadChoice(this.user, this.jaggSQL, this.city1, "city", "city", "dbo_stores", "(1=1)", this.valuecity1);
  272.       new JDPLoadChoice(this.user, this.jaggSQL, this.zip1, "zip", "zip", "dbo_stores", "(1=1)", (Vector)null);
  273.    }
  274.  
  275.    public boolean Columns1CheckFields() {
  276.       return true;
  277.    }
  278.  
  279.    public void ResultList1Main() {
  280.       String var1 = "stor_id";
  281.       String[] var2 = new String[0];
  282.       String var3 = "(1=1)";
  283.       String[] var4 = new String[]{"Stor name"};
  284.       String[] var5 = new String[]{"stor_name"};
  285.       JDPJagg var6 = new JDPJagg(this.user.jaggPath);
  286.       var6.setDSN("JDP Tutorial");
  287.       var6.setUID("");
  288.       var6.setPWD("");
  289.       var6.setMRW("1000");
  290.       var6.setTOUT("60");
  291.       this.ResultList1 = new JDPSearchResults(this.user, super.targetPanel, true, var6, false, var1, var2, var3, var4, var5, var5, "", true, "Total Entries:");
  292.       int[] var7 = new int[8];
  293.       var7[0] = 3;
  294.       var7[1] = 5;
  295.       this.ResultList1.setMinWidth(130);
  296.       this.ResultList1.setIcons(var7);
  297.       this.ResultList1.setFromWhereClause(" FROM dbo_stores WHERE (1=1)");
  298.       this.ResultList1.clearList("");
  299.       this.ResultList1.loadList();
  300.    }
  301. }
  302.