public boolean checkUrlExist(String url) {
   // TODO Auto-generated method stub
   SqlRowSet s =
       this.queryForRowSet("SELECT * " + " FROM log_url " + "WHERE name= '" + url + "';");
   if (s.first() == true) return true;
   else return false;
 }
 @Override
 public Integer getLineId(final int lineNo, final String file, final String project) {
   final String sql = "SELECT (lineid) FROM lines WHERE " + "project=? AND file=? AND lineno=?;";
   SqlRowSet lineRows = jdbcTemplate.queryForRowSet(sql, new Object[] {project, file, lineNo});
   if (lineRows.first()) {
     return lineRows.getInt("lineId");
   }
   return null;
 }
  @Override
  public LikelihoodData retrieve(final Long likelihoodId) {
    final SqlRowSet likelihood = this._getLikelihood(likelihoodId);

    likelihood.first();

    return new LikelihoodData(
        likelihood.getLong("id"),
        likelihood.getString("name"),
        likelihood.getString("code"),
        likelihood.getLong("enabled"));
  }
 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;
 }