public SeachOption() throws Exception {
String sqlStr = "Select Depth,ThreadCount,StartTime,EndTime from searchconfig";
DBoperate myoperate = new DBoperate();
ResultSet rs = myoperate.executeQuery(sqlStr);
while (rs.next()) {
Depth = rs.getInt("Depth");
ThreadCount = rs.getInt("ThreadCount");
StartTime = rs.getInt("StartTime");
EndTime = rs.getInt("EndTime");
}
}
public static List WebsiteList() throws Exception {
String sqlStr = "Select URL from website where Avaible = 1";
WebsiteList = DBoperate.resultSetToSingleList(sqlStr);
return WebsiteList;
}
public static List GetKeywordList() throws Exception {
String sqlStr = "Select Ename from keyword where IsAvailble = 1";
KeywordList = DBoperate.resultSetToSingleList(sqlStr);
return KeywordList;
}