requiredialog.java~1~

基于面向对象的数据库编程

    coneVCdata.add("表面积");
    coneVCdata.add("体积");
    /**for 列出标题烂**/
    for(int i=0;i<coneVCdata.size();i++)
      coneDtm.addColumn((String)coneVCdata.elementAt(i));


    SphereDtm=new DefaultTableModel(); //定义模式
    sphereVCdata.add("名字");
    sphereVCdata.add("半径");
    sphereVCdata.add("表面积");
    sphereVCdata.add("体积");
    /**for 列出标题烂**/
    for(int i=0;i< sphereVCdata.size();i++)
      SphereDtm.addColumn((String) sphereVCdata.elementAt(i));
  }

  void jButton3_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jButton4_actionPerformed(ActionEvent e) {

    TransSession session = new TransSession("mydb");
    VEnumeration result=null;
    RequireMan require = new RequireMan(session);

    if (jRadioButton1.isSelected())
    {
      jTable1.setModel(SolidDtm);
      result = require.showSolid();
      if (!result.hasMoreElements()) {
        JOptionPane.showMessageDialog(this,"对不起，没有这个体","confirm",JOptionPane.PLAIN_MESSAGE);
        session.endSession();
      }
      else {
        SolidDtm.setRowCount(0);
        while (result.hasMoreElements()) {
          Solid solid = (Solid) result.nextElement();
          Vector vRdata=new Vector();

          for(int i=0;i<SolidVCdata.size();i++)
          {
            vRdata.addElement(solid.getClass());
            vRdata.addElement(new Double (solid .getSurface()));
            vRdata.addElement(new Double (solid .getVolume()));
          }
          SolidDtm.addRow(vRdata); //向表中添家数据

        }
        session.endSession();
      }

    }
    else if(jRadioButton2.isSelected())
    {
      jTable1.setModel(SolidDtm);
      result = require.showPlaneSolid();
      if (!result.hasMoreElements()) {
        JOptionPane.showMessageDialog(this,"对不起，没有平面体","confirm",JOptionPane.PLAIN_MESSAGE);
        session.endSession();
      }
      else {
        SolidDtm.setRowCount(0);
        while (result.hasMoreElements()) {
          PlaneSolid solid = (PlaneSolid) result.nextElement();
          Vector vRdata=new Vector();

          for(int i=0;i<SolidVCdata.size();i++)
          {
            vRdata.addElement(solid.getClass());
            vRdata.addElement(new Double (solid .getSurface()));
            vRdata.addElement(new Double (solid .getVolume()));
          }
          SolidDtm.addRow(vRdata); //向表中添家数据

        }
        session.endSession();
      }

    }
    else if(jRadioButton3.isSelected())
    {
      jTable1.setModel(SolidDtm);

      result = require.showCurveSolid();
      if (!result.hasMoreElements()) {
        JOptionPane.showMessageDialog(this,"对不起，没有曲面体","confirm",JOptionPane.PLAIN_MESSAGE);
        session.endSession();
      }
      else {
        SolidDtm.setRowCount(0);
        while (result.hasMoreElements()) {
          CurveSolid solid = (CurveSolid) result.nextElement();
          Vector vRdata=new Vector();

          for(int i=0;i<SolidVCdata.size();i++)
          {
            vRdata.addElement(solid.getClass());
            vRdata.addElement(new Double (solid .getSurface()));
            vRdata.addElement(new Double (solid .getVolume()));
          }
          SolidDtm.addRow(vRdata); //向表中添家数据

        }
        session.endSession();
      }

    }


    else if(jRadioButton4.isSelected()){
      jTable1.setModel(cuboidDtm);
      String s;
      s=jComboBox1.getSelectedItem().toString();
      if (s.equals("长方体")){
        result = require.showCoboidPlaneSolid();
        if (!result.hasMoreElements()) {
          JOptionPane.showMessageDialog(this,"对不起，没有这个体","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {
          cuboidDtm.setRowCount(0);
          while (result.hasMoreElements()) {
            CuboidPlaneSolid cuboidPlaneSolid = (CuboidPlaneSolid) result.nextElement();
            Vector vRdata=new Vector();

            for(int i=0;i<cuboidVCdata.size();i++)
            {
              vRdata.addElement(cuboidPlaneSolid.getName());
              vRdata.addElement(new Double (cuboidPlaneSolid .getLength()));
              vRdata.addElement(new Double (cuboidPlaneSolid .getWidth()));
              vRdata.addElement(new Double (cuboidPlaneSolid .getHigh()));
              vRdata.addElement(new Double (cuboidPlaneSolid .getSurface()));
              vRdata.addElement(new Double (cuboidPlaneSolid .getVolume()));
            }
            cuboidDtm.addRow(vRdata); //向表中添家数据

          }
          session.endSession();

        }





      }
      else if(s.equals("立方体")){
        jTable1.setModel(squareDtm);

        jTable1.setModel(squareDtm); //设定表模式

        result = require.showSquarePlaneSolid();
        if (!result.hasMoreElements()) {
          JOptionPane.showMessageDialog(this,"对不起， 现在还没有立方体","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {
          squareDtm.setRowCount(0);
          while (result.hasMoreElements()) {
            SquarePlaneSolid squarePlaneSolid = (SquarePlaneSolid) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<squareVCdata.size();i++)
            {
              vRdata.addElement(squarePlaneSolid .getName());
              vRdata.addElement(new Double (squarePlaneSolid .getLength()));
              vRdata.addElement(new Double (squarePlaneSolid .getSurface()));
              vRdata.addElement(new Double (squarePlaneSolid .getVolume()));
            }
            squareDtm.addRow(vRdata); //向表中添家数据
          }
          session.endSession();
        }

      }


      else if (s.equals("圆柱体")){
        jTable1.setModel(cylinderDtm);
        result = require.showCylinderCurveSolid();
        if (!result.hasMoreElements()) {
          JOptionPane.showMessageDialog(this,"对不起，没有这个体","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {

          cylinderDtm.setRowCount(0);
          while (result.hasMoreElements()) {
            CylinderCurveSolid cylinderCurveSolid = (CylinderCurveSolid) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<cylinderVCdata.size();i++)
            {
              vRdata.addElement(cylinderCurveSolid .getName());
              vRdata.addElement(new Double (cylinderCurveSolid  .getHigh()));
              vRdata.addElement(new Double (cylinderCurveSolid  .getRadius()));
              vRdata.addElement(new Double (cylinderCurveSolid  .getSurface()));
              vRdata.addElement(new Double (cylinderCurveSolid  .getVolume()));
            }
            cylinderDtm.addRow(vRdata); //向表中添家数据
          }
          session.endSession();
        }


      }else if (s.equals("圆锥体")){
        jTable1.setModel(coneDtm);
        result = require.showConeCurveSolid();
        if (!result.hasMoreElements()) {
          JOptionPane.showMessageDialog(this,"对不起，没有这个体","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {

          coneDtm.setRowCount(0);
          while (result.hasMoreElements()) {
            ConeCurveSolid coneCurveSolid = (ConeCurveSolid) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<coneVCdata.size();i++)
            {
              vRdata.addElement(coneCurveSolid.getName());
              vRdata.addElement(new Double (coneCurveSolid .getHigh()));
              vRdata.addElement(new Double (coneCurveSolid .getRadius()));
              vRdata.addElement(new Double (coneCurveSolid .getSurface()));
              vRdata.addElement(new Double (coneCurveSolid .getVolume()));
            }
            coneDtm.addRow(vRdata); //向表中添家数据
          }
          session.endSession();
        }


      }else if (s.equals("球体")){
        jTable1.setModel(SphereDtm);
        result =  require.showSphereCurveSolid();

        if (!result.hasMoreElements()) {
          JOptionPane.showMessageDialog(this,"对不起，现在还没有球体","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {

          SphereDtm.setRowCount(0);
          while (result.hasMoreElements()) {
            SphereCurveSolid sphereCurveSolid = (SphereCurveSolid) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<sphereVCdata.size();i++)
            {
              vRdata.addElement(sphereCurveSolid .getName());
            //vRdata.add(new Long(session.getOidAsLong(sphereCurveSolid)));
              session.getOidAsLong(sphereCurveSolid);
              vRdata.addElement(new Double (sphereCurveSolid .getRadius()));
              vRdata.addElement(new Double (sphereCurveSolid .getSurface()));
              vRdata.addElement(new Double (sphereCurveSolid .getVolume()));
            }
            SphereDtm.addRow(vRdata); //向表中添数据
          }
          session.endSession();
        }


      }


    }


  }






  void jButton6_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jButton1_actionPerformed(ActionEvent e) {
    TransSession session = new TransSession("mydb");
    VEnumeration result;
    String s1="",s2="",s3;

    try{
      s3=jTextField1.getText().toString();

      if(jRadioButton5.isSelected()){
        s1="SELECT * from brgeometry.Solid where surface";
      }else if(jRadioButton6.isSelected()){
        s1="SELECT * from brgeometry.Solid where volume";
      }else if(jRadioButton10.isSelected()){
        s1="SELECT * from brgeometry.Face where surface";
      }else if(jRadioButton11.isSelected()){
        s1="SELECT * from brgeometry.Edge where length";
      }
      if(jRadioButton7.isSelected()){
        s2="<";
      }else if(jRadioButton8.isSelected()){
        s2="=";
      }else if(jRadioButton9.isSelected()){
        s2=">";
      }
      RequireMan require = new RequireMan(session);
      result = require.showconSolid(s1+s2+s3);
      session.endSession();
    }
    catch (Exception ex){
      JOptionPane.showConfirmDialog(this,"请输入正确数据","confirm",JOptionPane.PLAIN_MESSAGE);
      session.endSession();
    }
  }

  void jToggleButton1_actionPerformed(ActionEvent e) {
  }

  void jToggleButton2_actionPerformed(ActionEvent e) {
    jTextField3.setText("");
  }

  void jToggleButton3_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jRadioButton1_actionPerformed(ActionEvent e) {
    jComboBox1.disable();
  }





  void jRadioButton2_actionPerformed(ActionEvent e) {
    jComboBox1.disable();
  }

  void jRadioButton3_actionPerformed(ActionEvent e) {
    jComboBox1.disable();
  }

  void jRadioButton4_actionPerformed(ActionEvent e) {
    jComboBox1.enable();
  }

  void jButton2_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
  }

  void jButton5_actionPerformed(ActionEvent e) {
    String s,s1,s2="";
    s=jComboBox2.getSelectedItem().toString();
    s1=jTextField3.getText().toString();
    Manager man=null;

    TransSession session = new TransSession("mydb");
    try{

      if (s.equals("长方体")){
        s2="CuboidPlaneSolid#"+s1;
        man=new CoboidPlaneSolidMan(session);
      }
      else if (s.equals("立方体")){
        s2="SquarePlaneSolid#"+s1;
        man=new SquarePlaneSolidMan(session);
      }
      else if (s.equals("圆柱体")){
        s2="CylinderCurveSolid#"+s1;
        man=new  CylinderCurveSoildMan(session);
      }
      else if (s.equals("圆锥体")){
        s2="ConeCurveSolid#"+s1;
        man=new ConeCurveSolidMan(session);
      }
      else if (s.equals("球体")){
        s2="SphereCurveSolid#"+s1;
        man=new SphereCurveSolidMan(session);
      }

      Solid solid=man.findByRoot(s2);
      session.endSession();

    }
    catch (VException exception ){
      JOptionPane.showConfirmDialog(this,"对不起，没有这个体","confirm",JOptionPane.PLAIN_MESSAGE);
      session.endSession();
    }
    catch (Exception ex ){
      JOptionPane.showConfirmDialog(this,"请输入正确数据","confirm",JOptionPane.PLAIN_MESSAGE);
      session.endSession();

    }
  }

  void jButton7_actionPerformed(ActionEvent e) {
    jTextField3.setText("");
  }

  void jButton8_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jComboBox1_actionPerformed(ActionEvent e) {

  }
}