public class QueryDatabase extends java.lang.Object implements Query
it provide seven method to query, by date ,magnitude, region and their combination
限定符和类型 | 字段和说明 |
---|---|
private static java.lang.String |
comArea |
private static java.lang.String |
comDate |
private static java.lang.String |
comMag |
protected java.sql.Connection |
con |
private java.sql.ResultSet |
res |
构造器和说明 |
---|
QueryDatabase(loadCNF cnf)
a constructor for load information from a configuration file
the configuration file contains the model(csv,db,net)
of loading data and the path of file which stores data
|
限定符和类型 | 方法和说明 |
---|---|
void |
close()
a method to close the resource
|
private void |
getConnection(java.lang.String path)
a method to connect to database
|
java.sql.ResultSet |
getRes()
return the result set after query
|
void |
queryArea(java.lang.String area1,
java.lang.String area2)
query information by region
|
void |
queryDA(java.lang.String date1,
java.lang.String date2,
java.lang.String area1,
java.lang.String area2)
query information by date and magnitude
|
void |
queryDAM(java.lang.String date1,
java.lang.String date2,
double low,
double up,
java.lang.String area1,
java.lang.String area2)
query information by date, magnitude and region
|
void |
queryDate(java.lang.String date1,
java.lang.String date2)
query information by date
|
void |
queryDM(java.lang.String date1,
java.lang.String date2,
double low,
double up)
query information by date and magnitude
|
void |
queryMA(double low,
double up,
java.lang.String area1,
java.lang.String area2)
query information by magnitude and region
|
void |
queryMag(double low,
double up)
query information by magnitude
|
protected java.sql.Connection con
private java.sql.ResultSet res
private static java.lang.String comDate
private static java.lang.String comMag
private static java.lang.String comArea
public QueryDatabase(loadCNF cnf)
the configuration file contains the model(csv,db,net) of loading data and the path of file which stores data
cnf
- a object that will load the configuration filepublic java.sql.ResultSet getRes()
private void getConnection(java.lang.String path)
path,path
- of resourcepublic void queryDate(java.lang.String date1, java.lang.String date2)
date1
- a data earlierdate2
- a data laterpublic void queryMag(double low, double up)
low
- a number from lower magnitudeup
- a number from higher magnitudepublic void queryArea(java.lang.String area1, java.lang.String area2)
area1
- a String from one areaarea2
- a String from another areapublic void queryDM(java.lang.String date1, java.lang.String date2, double low, double up)
public void queryDA(java.lang.String date1, java.lang.String date2, java.lang.String area1, java.lang.String area2)
public void queryMA(double low, double up, java.lang.String area1, java.lang.String area2)
public void queryDAM(java.lang.String date1, java.lang.String date2, double low, double up, java.lang.String area1, java.lang.String area2)
public void close()