public class Test {
public static void main(String[] args) {
ResultSet results = null;
List<Integer> ids = new ArrayList<Integer>();
String querySQL = "select id, value from tb";
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = java.sql.DriverManager
.getConnection(
"jdbc:mysql://localhost/demo?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull",
"root", "root");
results = con.createStatement().executeQuery(querySQL);
String value;
while (results.next()) {
value = results.getString("value");
if (matches(value)) {
ids.add(results.getInt("id"));
}
}
con.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static boolean matches(String value) {
......
......
......
return flag;
}
}