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; }