requireman.java

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

package operation;

import brgeometry.*;
import java.util.*;
import helper.ProBag;
import com.versant.fund.*;
import com.versant.trans.*;
import java.util.ArrayList;
import javax.swing.table.*;
import javax.swing.border.*;

/**
 * <p>Title: Broundary Rrepresentaion</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: USTC</p>
 * @author unascribed
 * @version 1.0
 */

public class RequireMan {

  VQLQuery myQuery;
  VEnumeration result;
  TransSession session;
  Manager man;

  public RequireMan(TransSession session) {
    this.session = session;
  }

  //显示数据库中所有的体
  public VEnumeration showSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.Solid");
    result = myQuery.execute();
    return result;
  }
  //显示数据库中所有的面
  public VEnumeration showFace() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.Face");
    result = myQuery.execute();
    return result;
  }
  //显示数据库中所有的线
  public VEnumeration showEdge() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.Edge");
    result = myQuery.execute();
    return result;
  }
  public VEnumeration showVertice() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.Vertice");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的平面体
  public VEnumeration showPlaneSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.PlaneSolid");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的长方体
  public VEnumeration showCoboidPlaneSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.CuboidPlaneSolid");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的正方体
  public VEnumeration showSquarePlaneSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.SquarePlaneSolid");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的曲面体
  public VEnumeration showCurveSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.CurveSolid");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的圆柱体
  public VEnumeration showCylinderCurveSolid() {
    myQuery = new VQLQuery(session,
                           "SELECT * from brgeometry.CylinderCurveSolid");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的圆锥体
  public VEnumeration showConeCurveSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.ConeCurveSolid");
    result = myQuery.execute();
    return result;
  }

  //显示数据库中所有的球体
  public VEnumeration showSphereCurveSolid() {
    myQuery = new VQLQuery(session, "SELECT * from brgeometry.SphereCurveSolid");
    result = myQuery.execute();
    return result;
}


public VEnumeration deepSelect(String  root , String op){

  try {
    String s=null;
    if (op=="Cuboid") s= "SELECT * from brgeometry.CuboidPlaneSolid where name = $1";
    else if  (op=="Cube") s= "SELECT * from brgeometry.SquarePlaneSolid where name = $1";
    else if (op=="Cylinder") s="SELECT * from brgeometry.CylinderCurveSolid where name = $1";
    else if (op=="Cone") s= "SELECT * from brgeometry.ConeCurveSolid where name = $1";
    else if (op=="Sphere") s="SELECT * from brgeometry.SphereCurveSolid where name = $1";

    myQuery = new VQLQuery( session , s );
    myQuery.bind (root);
    result = myQuery.execute(Constants.FLUSH_ALL,-1,Constants.NOLOCK,Constants.NOLOCK );
    return result;
  }

  catch (VException exception) {
   // session.endSession();
   // Ignore error if root name does not exist
   int err = exception.getErrno();
   if (err != Constants.EVJ_ROOTNAME_DOES_NOT_EXIST) {
     throw exception;
   }
 }
  return null;

}
//************************************条件查询

//显示数据库中指定条件的体/面/点
 public VEnumeration showcon(String s) {
   myQuery = new VQLQuery(session,s);
   result = myQuery.execute();
   return result;
 }
}