Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Some times in java programming, It is a big pain deal with Collections and Arrays, it's not so easy getting the flexibility presented in our sql engine.
Using hsqldb open source database engine you can manage your in-memory data the same way that your persistent databases.
I prepared a small example to show this funcionality.

Create a java project.

Add hsqldb.jar in your java build path.

Try this example.

See, you can select from your in-memory table using like condition:

  customers.insert(1, "Alvaro Tejada","Perú");
  customers.insert(2, "Craig Cmehil","Germany");
  customers.insert(3, "Jim Spath","US");
  customers.insert(4, "Mark Yolton","US");
  customers.insert(5, "Mark Finnern","US");
  ResultSet rs = customers.read("WHERE name like '%Mark%'");  
  while (rs.next()) {
   System.out.println(rs.getString("id") + "-" + rs.getString("name") + "-" + rs.getString("address"));   
  }

Console output:
4-Mark Yolton-US
5-Mark Finnern-US

 

Your comments are welcome,
Thanks and Regards,
Ignacio.

1 Comment