System.out.println("------------------------------------------------");
SeInstance.SeInstanceTableLocks[] tablelocks=instance.getTableLocks();
for(int i=0;i
System.out.println("表级别锁类型："+tablelocks[i].getLockType());
System.out.println("表级别锁PID："+tablelocks[i].getPid());
System.out.println("表级别锁注册ID："+tablelocks[i].getRegistrationId());
System.out.println("*****************************");
}
System.out.println("------------------------------------------------");
}
catch (SeException e) { e.printStackTrace(); }
}
//空间条件查询
public static void SpatialQuery()
{
try {
SeConnection conn = getConn();
SeLayer layer = new SeLayer(conn,"quxian","SHAPE");
SeTable table = new SeTable(conn, "quxian");
SeColumnDefinition[] tableDef = table.describe();
String[] cols = new String[tableDef.length];
for (int j = 0; j < cols.length; j++)
{
cols[j] = tableDef[j].getName();
}
SeCoordinateReference cr = layer.getCoordRef();
SeFilter[] filters = new SeFilter[1];
SeShape shape = new SeShape(cr);
shape.generateFromText("POLYGON((125.091 44.324,125.070 43.428,125.887 44.027,125.091 44.324))");
//SDEPoint pt = new SDEPoint(125.091,44.324);
//shape.generatePoint(1, new SDEPoint[] { pt });
SeFilter filter = new SeShapeFilter(layer.getName(), layer
.getSpatialColumn(), shape, SeShapeFilter.METHOD_ENVP);
filters[0] = filter;
SeSqlConstruct sqlCons = new SeSqlConstruct(layer.getName());
SeQuery query = new SeQuery(conn, cols, sqlCons);
query.prepareQuery();
query.setSpatialConstraints(SeQuery.SE_OPTIMIZE, false,filters);
query.execute();
SeRow row =query.fetch();
while(row!=null)
{
System.out.println(row.getObject(1).toString());
row =query.fetch();
}
}
catch (Exception ex) {
ex.printStackTrace();
}
}
//属性条件查询
public static void AttributeQuery()
{
try {
SeConnection conn = getConn();
SeTable table = new SeTable(conn, "quxian");
SeColumnDefinition[] tableDef = table.describe();
String[] cols = new String[tableDef.length];
for (int j = 0; j < cols.length; j++)
{
cols[j] = tableDef[j].getName();
}
SeSqlConstruct sqlCons = new SeSqlConstruct("quxian");
sqlCons.setWhere("CITY='长春市'");
SeQuery query = new SeQuery(conn, cols, sqlCons);
query.prepareQuery(cols,sqlCons);
query.execute();
SeRow row =query.fetch();
while(row!=null)
{
System.out.println(row.getObject(1).toString());