import org.squeryl.adapters.H2Adapter;
import org.squeryl.{Session, SessionFactory};
public class Main {
public static void main(String[] args) {
String url = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1";
String user = "sa";
String password = "";
SessionFactory sessionFactory = SessionFactory
.forDriver("org.h2.Driver")
.newBuilder()
.setAdapter(new H2Adapter())
.setUsername(user)
.setPassword(password)
.setUrl(url)
.create();
Session session = sessionFactory.openSession();
session.bindToCurrentThread();
}
}
import org.squeryl.KeyedEntity;
public class User implements KeyedEntity<Long> {
public Long id;
public String name;
public int age;
public Long id() {
return id;
}
public void setId(Long id) {
this.id = id;
}
}
import org.squeryl.Table;
import org.squeryl.Query;
import org.squeryl.PrimitiveTypeMode;
public class Main {
public static void main(String[] args) {
Table<User> users = SquerylHelper.users;
Query<User> query = from(users)
.where(u -> u.age.gt(18))
.select(u -> u);
List<User> userList = PrimitiveTypeMode.inTransaction(() -> {
return SquerylHelper.session().query(query).toList();
});
for (User user : userList) {
System.out.println(user.name);
}
}
}
