コード例 #1
0
 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;
 }
コード例 #2
0
 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;
 }