org.hibernate.Query.list()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(10.4k)|赞(0)|评价(0)|浏览(244)

本文整理了Java中org.hibernate.Query.list方法的一些代码示例，展示了Query.list的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Query.list方法的具体详情如下：
包路径：org.hibernate.Query
类名称：Query
方法名：list

Query.list介绍

[英]Return the query results as a List. If the query contains multiple results per row, the results are returned in an instance of Object[].
[中]以列表形式返回查询结果。如果查询每行包含多个结果，则结果将在对象[]的实例中返回。

代码示例

代码示例来源：origin: gocd/gocd

@Override
public List<Plugin> getAllPlugins() {
  return (List<Plugin>) transactionTemplate.execute((TransactionCallback) transactionStatus -> {
    Query query = sessionFactory.getCurrentSession().createQuery("FROM " + Plugin.class.getSimpleName());
    query.setCacheable(true);
    return query.list();
  });
}

代码示例来源：origin: citerus/dddsample-core

public List<Cargo> findAll() {
 return getSession().createQuery("from Cargo").list();
}

代码示例来源：origin: hibernate/hibernate-orm

/**
 * Call setEntity() on a cacheable query - see FORGE-265
 */
public List listEventsOfOrganizer(Person organizer) {
  Session session = sessionFactory.getCurrentSession();
  session.beginTransaction();
  Query query = session.createQuery("from Event ev where ev.organizer = :organizer");
  query.setCacheable(true);
  query.setEntity("organizer", organizer);
  List result = query.list();
  session.getTransaction().commit();
  return result;
}

代码示例来源：origin: hibernate/hibernate-orm

assertTrue(
    s.createFilter( master1.getIncoming(), "where this.id > 0 and this.name is not null" )
        .list()
        .size() == 2
);
Iterator iter = master1.getIncoming().iterator();
int i=0;
while ( iter.hasNext() ) {
  Master m = (Master) iter.next();
  assertTrue( "outgoing", m.getOutgoing().size()==1 );
  assertTrue( "outgoing", m.getOutgoing().contains(master1) );

代码示例来源：origin: hibernate/hibernate-orm

Query q = s.createQuery("from Simple s");
List list = q.setCacheable(true).list();
assertTrue( list.size()==1 );
t.commit();
q = s.createQuery("from Simple s");
list = q.setCacheable(true).list();
assertTrue( list.size()==1 );
t.commit();
q = s.createQuery("from Simple s");
list = q.setCacheable(true).list();
assertTrue( list.size()==2 );
t.commit();
t = s.beginTransaction();
q = s.createQuery("from Simple s");
list = q.setCacheable(true).list();
assertTrue( list.size()==2 );
Iterator i = list.iterator();
while ( i.hasNext() ) s.delete( i.next() );
t.commit();
s.close();

代码示例来源：origin: hibernate/hibernate-orm

Query query = s.createQuery("from HighestBid b where b.name = :name");
query.setParameter( "name", "widget", StringType.INSTANCE );
HighestBid highestBid = (HighestBid) query.list().iterator().next();

代码示例来源：origin: sakaiproject/sakai

protected List getCountedStudentGradeRecords(final Long gradebookId, final String studentId) throws HibernateException {
  return getSessionFactory().getCurrentSession().createQuery(
    "select agr from AssignmentGradeRecord as agr, GradebookAssignment as asn where agr.studentId = :studentid and agr.gradableObject = asn and asn.removed is false and asn.notCounted is false and asn.gradebook.id = :gradebookid and asn.ungraded is false")
    .setString("studentid", studentId)
    .setLong("gradebookid", gradebookId)
    .list();
}

代码示例来源：origin: hibernate/hibernate-orm

@Test
public void test2ndLevelSubClass() throws Exception {
  Session s = openSession();
  Transaction tx = s.beginTransaction();
  A320b a = new A320b();
  a.setJavaEmbeddedVersion( "Elephant" );
  a.setNbrOfSeats( 300 );
  s.persist( a );
  tx.commit();
  s.close();
  s = openSession();
  tx = s.beginTransaction();
  Query q = s.createQuery( "from " + A320.class.getName() + " as a where a.javaEmbeddedVersion = :version" );
  q.setString( "version", "Elephant" );
  List a320s = q.list();
  assertNotNull( a320s );
  assertEquals( 1, a320s.size() );
  tx.commit();
  s.close();
}

代码示例来源：origin: hibernate/hibernate-orm

Query q = s.createQuery("from Simple s where s.name=?");
q.setCacheable(true);
q.setString(0, "Simple 1");
assertTrue( q.list().size()==1 );
assertTrue( q.list().size()==1 );
assertTrue( q.list().size()==1 );
q = s.createQuery("from Simple s where s.name=:name");
q.setCacheable(true);
q.setString("name", "Simple 1");
assertTrue( q.list().size()==1 );
simple = (Simple) q.list().get(0);
q.setString("name", "Simple 2");
assertTrue( q.list().size()==0 );
assertTrue( q.list().size()==0 );
simple.setName("Simple 2");
assertTrue( q.list().size()==1 );
assertTrue( q.list().size()==1 );
t.commit();
s.close();
q = s.createQuery("from Simple s where s.name=:name");
q.setString("name", "Simple 2");
q.setCacheable(true);
assertTrue( q.list().size()==1 );
assertTrue( q.list().size()==1 );
t.commit();
s.close();

代码示例来源：origin: gocd/gocd

public Modifications getModificationsFor(final MaterialInstance materialInstance, final Pagination pagination) {
  String key = materialModificationsWithPaginationKey(materialInstance);
  String subKey = materialModificationsWithPaginationSubKey(pagination);
  Modifications modifications = (Modifications) goCache.get(key, subKey);
  if (modifications == null) {
    synchronized (key) {
      modifications = (Modifications) goCache.get(key, subKey);
      if (modifications == null) {
        List<Modification> modificationsList = (List<Modification>) getHibernateTemplate().execute((HibernateCallback) session -> {
          Query q = session.createQuery("FROM Modification WHERE materialId = ? ORDER BY id DESC");
          q.setFirstResult(pagination.getOffset());
          q.setMaxResults(pagination.getPageSize());
          q.setLong(0, materialInstance.getId());
          return q.list();
        });
        if (!modificationsList.isEmpty()) {
          modifications = new Modifications(modificationsList);
          goCache.put(key, subKey, modifications);
        }
      }
    }
  }
  return modifications;
}

代码示例来源：origin: org.jboss.dashboard-builder/dashboard-provider-core

protected void txFragment(Session session) throws Exception {
  FlushMode flushMode = session.getFlushMode();
  session.setFlushMode(FlushMode.COMMIT);
  StringBuffer sql = new StringBuffer();
  sql.append("from ").append(DataProviderImpl.class.getName()).append(" as instance ");
  sql.append("where instance.id = :id");
  Query query = session.createQuery(sql.toString());
  if (id != null) query.setLong("id", id.longValue());
  query.setCacheable(true);
  results.addAll(query.list());
  session.setFlushMode(flushMode);
}}.execute();
if (results.size() > 0) return (DataProviderImpl) results.get(0);

代码示例来源：origin: org.ow2.bonita/bonita-core

@SuppressWarnings("unchecked")
public Set<PackageDependency> getPackageDependencies(String className) {
 final Query query = getSession().getNamedQuery("getPackageDependencies");
 query.setCacheable(true);
 query.setString("className", className);
 final List<PackageDependency> results = query.list();
 if (results != null) {
  return new HashSet<PackageDependency>(results);
 }
 return null;
}

代码示例来源：origin: hibernate/hibernate-orm

queryWithCollection.setLong("id",  jboss.getId() );
list = queryWithCollection.list();
assertEquals(list.size(),1);

代码示例来源：origin: my2iu/Jinq

List<Object> results = q.list();
   if (results.size() > hints.automaticResultsPagingSize)
   List<Object> results = q.list();
   resultIterator = results.iterator();
if (resultIterator.hasNext())
  nextElement(reader.readResult(resultIterator.next()));

代码示例来源：origin: hibernate/hibernate-orm

s.save( bar2 );
Query q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar%'");
list = q.list();
if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 );
q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where ( bar.name in (:nameList) or bar.name in (:nameList) ) and bar.string = :stringVal");
HashSet nameList = new HashSet();
nameList.add( "bar" );
q.setParameterList( "nameList", nameList );
q.setParameter( "stringVal", "a string" );
list = q.list();
if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 );
assertTrue( result != null );
q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like :name and b.name like :name");
q.setString( "name", "Bar%" );
list = q.list();
assertTrue( list.size()==1 );
q = s.createQuery("select bar from Bar bar order by ((bar.x - :valueX)*(bar.x - :valueX))");
q.setInteger( "valueX", bar.getX() + 1 );
list = q.list();
assertTrue( ((Bar) list.get( 0 )).getX() == bar.getX() );
q.setInteger( "valueX", bar2.getX() + 1 );
list = q.list();
assertTrue( ((Bar)list.get(0)).getX() == bar2.getX());

代码示例来源：origin: hibernate/hibernate-orm

cOrig.getProxyOwner(),
        cOrig.getNonLazyOwner(),
        cOrig.getLazyDataPoints().iterator().next(),
        cOrig.getNonLazyJoinDataPoints().iterator().next(),
        cOrig.getNonLazySelectDataPoints().iterator().next()
List list = s.createFilter( c.getLazyDataPoints(), "" )
    .setMaxResults( 1 )
    .list();
assertEquals( 1, list.size() );
assertFalse( s.isReadOnly( list.get( 0 ) ) );
list = s.createFilter( c.getNonLazyJoinDataPoints(), "" )
    .setMaxResults( 1 )
    .list();
assertEquals( 1, list.size() );
assertFalse( s.isReadOnly( list.get( 0 ) ) );
list = s.createFilter( c.getNonLazySelectDataPoints(), "" )
    .setMaxResults( 1 )
    .list();
assertEquals( 1, list.size() );
assertFalse( s.isReadOnly( list.get( 0 ) ) );

代码示例来源：origin: org.sakaiproject.edu-services.gradebook/gradebook-service-impl

protected List getCountedStudentGradeRecords(Long gradebookId, String studentId) throws HibernateException {
  return getSessionFactory().getCurrentSession().createQuery(
    "select agr from AssignmentGradeRecord as agr, GradebookAssignment as asn where agr.studentId = :studentid and agr.gradableObject = asn and asn.removed is false and asn.notCounted is false and asn.gradebook.id = :gradebookid and asn.ungraded is false")
    .setString("studentid", studentId)
    .setLong("gradebookid", gradebookId)
    .list();
}

代码示例来源：origin: netgloo/spring-boot-samples

@SuppressWarnings("unchecked")
public List<User> getAll() {
 return getSession().createQuery("from User").list();
}

代码示例来源：origin: hibernate/hibernate-orm

/**
 * Call setEntity() on a cacheable query - see FORGE-265
 */
public List listEventsOfOrganizer(Person organizer) {
  Session session = sessionFactory.getCurrentSession();
  session.beginTransaction();
  Query query = session.createQuery("from Event ev where ev.organizer = :organizer");
  query.setCacheable(true);
  query.setEntity("organizer", organizer);
  List result = query.list();
  session.getTransaction().commit();
  return result;
}

代码示例来源：origin: hibernate/hibernate-orm

s = openSession();
tx = s.beginTransaction();
Query q = s.createQuery( "from Being h where h.identity = :name1 or h.identity = :name2" );
q.setString("name1", "marc");
q.setString("name2", "steve");
final List result = q.list();
assertEquals( 2, result.size() );
s.delete( result.get(0) );

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Query类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com