Java by API/javax.sql.rowset/Predicate

implements Predicate

   <source lang="java">
 

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import javax.sql.RowSet; import javax.sql.rowset.FilteredRowSet; import javax.sql.rowset.Predicate; import com.sun.rowset.FilteredRowSetImpl; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar, age int);");
   st.executeUpdate("insert into survey (id,name,age ) values (1,"nameValue", 10)");
   FilteredRowSet frs = new FilteredRowSetImpl();
   frs.setUsername("sa");
   frs.setPassword("");
   frs.setUrl("jdbc:hsqldb:data/tutorial");
   frs.setCommand("SELECT id, name, age FROM survey");
   frs.execute();
   while (frs.next()) {
     System.out.println(frs.getRow() + " - " + frs.getString("id") + ":" + frs.getString("name")
         + ":" + frs.getInt("age"));
   }
   AgeFilter filter = new AgeFilter(7, 10, 3);
   frs.beforeFirst();
   frs.setFilter(filter);
   while (frs.next()) {
     System.out.println(frs.getRow() + " - " + frs.getString("id") + ":" + frs.getString("name")
         + ":" + frs.getInt("age"));
   }
   frs.beforeFirst();
   while (frs.next()) {
     System.out.println(frs.getRow() + " - " + frs.getString("id") + ":" + frs.getString("name")
         + ":" + frs.getInt("age"));
   }
   frs.close();
   st.close();
   frs.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:databaseName";
   String username = "userName";
   String password = "password";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

} class AgeFilter implements Predicate {

 private int lowAge;
 private int highAge;
 private int columnIndex;
 private String columnName;
 public AgeFilter(int lowAge, int highAge, int columnIndex, String columnName) {
   this.lowAge = lowAge;
   this.highAge = highAge;
   this.columnName = columnName;
   this.columnIndex = columnIndex;
 }
 public AgeFilter(int lowAge, int highAge, int columnIndex) {
   this(lowAge, highAge, columnIndex, "age");
 }
 public boolean evaluate(Object value, String columnName) {
   boolean evaluation = true;
   if (columnName.equalsIgnoreCase(this.columnName)) {
     int columnValue = ((Integer) value).intValue();
     if ((columnValue >= this.lowAge) && (columnValue <= this.highAge)) {
       evaluation = true;
     } else {
       evaluation = false;
     }
   }
   return evaluation;
 }
 public boolean evaluate(Object value, int columnNumber) {
   boolean evaluation = true;
   if (columnIndex == columnNumber) {
     int columnValue = ((Integer) value).intValue();
     if ((columnValue >= this.lowAge) && (columnValue <= this.highAge)) {
       evaluation = true;
     } else {
       evaluation = false;
     }
   }
   return evaluation;
 }
 public boolean evaluate(RowSet rs) {
   if (rs == null) {
     return false;
   }
   FilteredRowSet frs = (FilteredRowSet) rs;
   boolean evaluation = false;
   try {
     int columnValue = frs.getInt(this.columnIndex);
     if ((columnValue >= this.lowAge) && (columnValue <= this.highAge)) {
       evaluation = true;
     }
   } catch (SQLException e) {
     return false;
   }
   return evaluation;
 }

}

 </source>