public List<Cart> getListAvailable() throws Exception {
Session session = HibernateUtil.getInstace().getSessionFactory().openSession();
session.beginTransaction();
String subQuery =
"(SELECT "
+ DBContract.CART_COLUMN_ID
+ " FROM "
+ DBContract.PRODUCTIONORDER_TABLE
+ " WHERE "
+ DBContract.ORDERSTATE_COLUMN_ID
+ " != 4)";
String query =
"SELECT "
+ DBContract.CART_COLUMN_ID
+ ","
+ DBContract.CART_COLUMN_NAME
+ ","
+ DBContract.CART_COLUMN_TABLETMAC
+ " FROM "
+ DBContract.CART_TABLE
+ " WHERE "
+ DBContract.CART_COLUMN_ID
+ " NOT IN "
+ subQuery;
List<Cart> listMyModel = session.createSQLQuery(query).addEntity(Cart.class).list();
session.close();
return listMyModel;
}
@Override
public List<MyModel> getListAll() throws Exception {
Session session = HibernateUtil.getInstace().getSessionFactory().openSession();
session.beginTransaction();
List<MyModel> listMyModel = session.createCriteria(Cart.class).list();
session.close();
return listMyModel;
}
@Override
public MyModel getOne(final int id) throws Exception {
Session session = HibernateUtil.getInstace().getSessionFactory().openSession();
session.beginTransaction();
MyModel myModel = (MyModel) session.get(Cart.class, id);
session.close();
return myModel;
}