public int getIdOfVisit(LogInfo logInfo) {
// TODO Auto-generated method stub
// TODO Auto-generated method stub
SqlRowSet s =
this.queryForRowSet(
"SELECT *"
+ " FROM log_visit "
+ "WHERE ip= '"
+ logInfo.getIp()
+ "'"
+ " AND visit_date= '"
+ DateUtil.handleDateFormat(logInfo.getDate())
+ "'"
+ " AND config_os= '"
+ logInfo.getOs()
+ "'"
+ " AND config_browser_name= '"
+ logInfo.getBrowser()
+ "';");
int id = 0;
while (s.next()) {
id = s.getInt("idvisit");
}
return id;
}
public boolean checkVisitExist(String ip, String date, String configOs, String configBrowser) {
// TODO Auto-generated method stub
SqlRowSet s =
this.queryForRowSet(
"SELECT *"
+ " FROM log_visit "
+ "WHERE ip= '"
+ ip
+ "'"
+ " AND visit_date= '"
+ DateUtil.handleDateFormat(date)
+ "'"
+ " AND config_os= '"
+ configOs
+ "'"
+ " AND config_browser_name= '"
+ configBrowser
+ "';");
if (s.first() == true) return true;
else return false;
}
