requiredialog.java

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

        jTable1.setModel(SphereDtm);
        result =  require.showSphereCurveSolid();

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

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


      }
    }

//显示所有的面

    else if (jRadioButton14.isSelected()){
      jTable1.setModel(faceDtm);
      result = require.showFace();
      if (!result.hasMoreElements()) {
        JOptionPane.showMessageDialog(this,"对不起， 现在还没有面","confirm",JOptionPane.PLAIN_MESSAGE);
        faceDtm.setRowCount(0);
        session.endSession();
      }
      else {
        faceDtm.setRowCount(0);
        faceDtm.addRow(faceVCdata);

        int j=0;
        while (result.hasMoreElements()) {
          Face face = (Face) result.nextElement();
          Vector vRdata=new Vector();
          for(int i=0;i<faceVCdata.size();i++)
          {
            vRdata.addElement(new Integer(j));
            vRdata.addElement(session.getOidAsString(face));
            vRdata.addElement(face.getClass());
            vRdata.addElement(new Float (face.getarea()));
          }
          faceDtm.addRow(vRdata); //向表中添家数据
          j++;
        }
        session.endSession();
      }
    }

    //显示所有的线
    else if (jRadioButton12.isSelected()){
      jTable1.setModel(edgeDtm);
      result = require.showEdge();
      if (!result.hasMoreElements()) {
        JOptionPane.showMessageDialog(this,"对不起， 现在还没有线","confirm",JOptionPane.PLAIN_MESSAGE);
        edgeDtm.setRowCount(0);
        session.endSession();
      }
      else {
        edgeDtm.setRowCount(0);
        edgeDtm.addRow(edgeVCdata);

        int j=0;
        while (result.hasMoreElements()) {
          Edge edge = (Edge) result.nextElement();
          Vector vRdata=new Vector();
          for(int i=0;i<edgeVCdata.size();i++)

          {
            vRdata.addElement(new Integer(j));
            vRdata.addElement(session.getOidAsString(edge));
            vRdata.addElement(edge.getClass());
            vRdata.addElement(new Float (edge.getLength()));
          }
          edgeDtm.addRow(vRdata); //向表中添家数据
          j++;
        }
        session.endSession();
      }
    }
    //显示所有的点
    else if (jRadioButton13.isSelected()){
      jTable1.setModel(verticeDtm);
      result = require.showVertice();
      if (!result.hasMoreElements()) {
        JOptionPane.showMessageDialog(this,"对不起， 现在还没有点","confirm",JOptionPane.PLAIN_MESSAGE);
        verticeDtm.setRowCount(0);
        session.endSession();
      }
      else {
        verticeDtm.setRowCount(0);
        verticeDtm.addRow(verticeVCdata);

        int j=0;
        while (result.hasMoreElements()) {
          Vertice vertice = (Vertice) result.nextElement();
          Vector vRdata=new Vector();
          for(int i=0;i<verticeVCdata.size();i++)

          {
            vRdata.addElement(new Integer(j));
            vRdata.addElement(session.getOidAsString(vertice));
            vRdata.addElement(new Float (vertice.getX()));
            vRdata.addElement(new Float (vertice.getY()));
            vRdata.addElement(new Float (vertice.getZ()));
          }
          verticeDtm.addRow(vRdata); //向表中添家数据
          j++;
        }
        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 area " ;
      }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.showcon(s1+s2+s3);

      // 查询指定条件的体

      if(jRadioButton5.isSelected()||jRadioButton6.isSelected()){
        jTable1.setModel(SolidDtm);

        if (!result.hasMoreElements()) {
          SolidDtm.setRowCount(0);
          JOptionPane.showMessageDialog(this,"对不起，没有指定条件的体","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {

          SolidDtm.setRowCount(0);
          SolidDtm.addRow( SolidVCdata);
          int j=0;
          while (result.hasMoreElements()) {
            Solid solid = (Solid) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<SolidVCdata.size();i++)
                      { vRdata.addElement(new Integer(j));
            //vRdata.addElement(""+i);
            vRdata.addElement(session.getOidAsString(solid));
            vRdata.addElement(solid .getClass());
            vRdata.addElement(new Float (solid.getSurface()));
            vRdata.addElement(new Float (solid .getVolume()));
            }
            SolidDtm.addRow(vRdata); //向表中添数据
            j++;
          }
          session.endSession();
        }
      }
      //查询指定条件的面
      if(jRadioButton10.isSelected()){
        jTable1.setModel(faceDtm);
        if (!result.hasMoreElements()) {
          faceDtm.setRowCount(0);
          JOptionPane.showMessageDialog(this,"对不起，没有指定条件的面","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {

          faceDtm.setRowCount(0);
          faceDtm.addRow( faceVCdata);
          int j=0;
          while (result.hasMoreElements()) {
            Face face = (Face) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<faceVCdata.size();i++)
            {
              vRdata.addElement(new Integer(j));
              // vRdata.addElement(""+i);
              vRdata.addElement(session.getOidAsString(face));
              vRdata.addElement(face .getClass());
              vRdata.addElement(new Float (face.getarea()));
            }
            faceDtm.addRow(vRdata); //向表中添数据
            j++;
          }
          session.endSession();
        }

      }
      //查询指定条件的线
      if(jRadioButton11.isSelected()){
        jTable1.setModel(edgeDtm);
        if (!result.hasMoreElements()) {
          edgeDtm.setRowCount(0);
          JOptionPane.showMessageDialog(this,"对不起，没有指定条件的线","confirm",JOptionPane.PLAIN_MESSAGE);
          session.endSession();
        }
        else {

          edgeDtm.setRowCount(0);
          edgeDtm.addRow( edgeVCdata);
          int j=0;
          while (result.hasMoreElements()) {
            Edge edge = (Edge) result.nextElement();
            Vector vRdata=new Vector();
            for(int i=0;i<edgeVCdata.size();i++)
            {
              vRdata.addElement(new Integer(j));
              vRdata.addElement(session.getOidAsString(edge));
              vRdata.addElement(edge.getClass());
              vRdata.addElement(new Float (edge.getLength()));
            }
            edgeDtm.addRow(vRdata); //向表中添数据
            j++;
          }
          session.endSession();
        }
      }

    }
    catch (Exception ex){
      JOptionPane.showConfirmDialog(this,"请输入正确数据","confirm",JOptionPane.PLAIN_MESSAGE);
      System.err.print(ex);
      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("");
  }

  private Vector face    =  new Vector(); //（以vector存储）;
  private Vector edge    = new Vector(); //（以vector存储）
  private Vector vertice = new Vector();
  private JScrollPane jScrollPane2 = new JScrollPane();
  private JScrollPane jScrollPane3 = new JScrollPane();
  private JScrollPane jScrollPane4 = new JScrollPane();
  private JList jList1 = new JList();
  private JList jList2 = new JList();
  private JList jList3 = new JList();//（以vector存储）

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

    face.clear();
    edge .clear();
    vertice.clear();


    TransSession  session = new TransSession("mydb");

    try{

      VEnumeration result=null;
      RequireMan requireMan =new RequireMan(session );

      if (s.equals("长方体")||s.equals("立方体")){

        if ( s.equals("长方体"))  {
          s2="Cuboid#"+s1;
          result=requireMan.deepSelect( s2,"Cuboid" );
        }

        else{
          s2="Cube#"+s1;
          result=requireMan.deepSelect( s2,"Cube" );
        }

        result.nextElement();//这个长方体或者立方体本身

        Face f1=(Face)result.nextElement();//e1,e2,e3,e4
        Face f2=(Face)result.nextElement();//e5,e6,e7,e8
        Face f3=(Face)result.nextElement();//e1,e10,e5,e9
        Face f4=(Face)result.nextElement();//e2,e11,e6,e10
        Face f5=(Face)result.nextElement();//e3,e12,e7,e11
        Face f6=(Face)result.nextElement();//e4,e9,e8,e12

        face.addElement(session.getOidAsString(f1));
        face.addElement(session.getOidAsString(f2));
        face.addElement(session.getOidAsString(f3));
        face.addElement(session.getOidAsString(f4));
        face.addElement(session.getOidAsString(f5));
        face.addElement(session.getOidAsString(f6));

        // jList1.setListData(face);

        Edge e1=(Edge)result.nextElement();//v1, v2
        Edge e2=(Edge)result.nextElement();//v2, v3
        Edge e3=(Edge)result.nextElement();//v3, v4
        Edge e4=(Edge)result.nextElement();//v4, v1

        Edge e5=(Edge)result.nextElement();//v5, v6
        Edge e6=(Edge)result.nextElement();//v6, v7
        Edge e7=(Edge)result.nextElement();//v7, v8
        Edge e8=(Edge)result.nextElement();//v8, v5

        Edge e9=(Edge)result .nextElement();//v1, v5
        Edge e10=(Edge)result.nextElement();//v2, v6
        Edge e11=(Edge)result.nextElement();//v3, v7
        Edge e12=(Edge)result.nextElement();//v4, v8

        edge.addElement(session.getOidAsString(e1));
        edge.addElement(session.getOidAsString(e2));
        edge.addElement(session.getOidAsString(e3));
        edge.addElement(session.getOidAsString(e4));
        edge.addElement(session.getOidAsString(e5));
        edge.addElement(session.getOidAsString(e6));
        edge.addElement(session.getOidAsString(e7));
        edge.addElement(session.getOidAsString(e8));
        edge.addElement(session.getOidAsString(e9));
        edge.addElement(session.getOidAsString(e10));
        edge.addElement(session.getOidAsString(e11));
        edge.addElement(session.getOidAsString(e12));