wherebasictown.java

来自「一个用java写的地震分析软件(无源码)-used to write a sei」· Java 代码 · 共 33 行

package org.trinet.util.gazetteer.TN;
import org.trinet.util.gazetteer.*;
import java.sql.*;
import java.util.*;
/** Polymorphic type extension of WhereBasicPt */
public class WhereBasicTown extends WhereBasicPt {
    static final long TOWNTYPE =  GazetteerType.TOWN.getCode();

    public WhereBasicTown() {
	super();
    }
    public WhereBasicTown(Connection conn) {
	super(conn);
    }
    public WhereBasicTown(Connection conn, Geoidal reference) {
	super(conn, reference);
    }
    public WhereBasicTown(Geoidal reference) {
	super(reference);
    }
    public WhereBasicTown(double lat, double lon, double z) {
	super(lat, lon, z);
    }

/** Returns Vector of WhereItems constructed using gazetteer database data for town type. */
    protected Vector getDatabaseData() {
	String sql = "SELECT * FROM GAZETTEERPT, GAZETTEERTOWN WHERE (" +
		TOWNTYPE + " * FLOOR(GAZETTEERPT.TYPE/" + TOWNTYPE + ") = " +  TOWNTYPE + ")" + 
		" AND GAZETTEERPT.GAZID = GAZETTEERTOWN.GAZID (+)";
	return super.getDatabaseData(sql);
    }
}