67,513
社区成员
发帖
与我相关
我的任务
分享
Session session2 =SessionUtil.getSession();
String hql2="select p.id,p.name from Person p where p.name like :nameCondition";
//hql2="select p.id,p.name from Person p";
Query query2=session2.createQuery(hql2)
.setParameter("nameCondition", "%张三%")
.setFirstResult(2)
.setMaxResults(3);
List personList2=query2.list();
System.out.println("@@@@@@@@@@@@@@"+personList2);
System.out.println("*****************************");
for (int i = 0; i < personList2.size(); i++) {
Object[] objs=(Object[]) personList2.get(i);//声明对象数组同时用查到的结果初始化数组
System.out.println(objs[0].toString()+" "+objs[1].toString());
}
session2.close();
System.out.println("8888888888888888888");
@@@@@@@@@@@@@@[]
*****************************
8888888888888888888
\-[SELECT] QueryNode: 'SELECT' querySpaces (person)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[DOT] DotNode: 'person0_.id' {propertyName=id,dereferenceType=PRIMITIVE,getPropertyPath=id,path=p.id,tableAlias=person0_,className=org.hibernate.bean.Person,classAlias=p}
| | +-[ALIAS_REF] IdentNode: 'person0_.id' {alias=p, className=org.hibernate.bean.Person, tableAlias=person0_}
| | \-[IDENT] IdentNode: 'id' {originalText=id}
| +-[SELECT_COLUMNS] SqlNode: ' as col_0_0_'
| +-[DOT] DotNode: 'person0_.name' {propertyName=name,dereferenceType=PRIMITIVE,getPropertyPath=name,path=p.name,tableAlias=person0_,className=org.hibernate.bean.Person,classAlias=p}
| | +-[ALIAS_REF] IdentNode: 'person0_.id' {alias=p, className=org.hibernate.bean.Person, tableAlias=person0_}
| | \-[IDENT] IdentNode: 'name' {originalText=name}
| \-[SELECT_COLUMNS] SqlNode: ' as col_1_0_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[p], fromElementByTableAlias=[person0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'person person0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=p,role=null,tableName=person,tableAlias=person0_,origin=null,columns={,className=org.hibernate.bean.Person}}
\-[WHERE] SqlNode: 'where'
\-[LIKE] BinaryLogicOperatorNode: 'like'
+-[DOT] DotNode: 'person0_.name' {propertyName=name,dereferenceType=PRIMITIVE,getPropertyPath=name,path=p.name,tableAlias=person0_,className=org.hibernate.bean.Person,classAlias=p}
| +-[ALIAS_REF] IdentNode: 'person0_.id' {alias=p, className=org.hibernate.bean.Person, tableAlias=person0_}
| \-[IDENT] IdentNode: 'name' {originalText=name}
\-[NAMED_PARAM] ParameterNode: '?' {name=nameCondition, expectedType=org.hibernate.type.StringType@4f6f416f}