在hibernate中命名查询,想要查询全部字段可以,但要查询某两个字段就不行了,能否解决呢。
<sql-query name="select_5">
<![CDATA[select name,age from person limit 3]]>
<return alias="s" class="cn.itcast.bean.Person"/>
</sql-query>下面是构造函数
package cn.itcast.bean;public class Person {
private Integer id;
private String name;
private Integer age;
public Person() {
}
public Person(String name,Integer age ) {
this.name=name;
this.age=age;
} //public Person(Integer id) {this.id = id;}
public Person(String name) {this.name = name;}
//public Person(Integer age) {this.age = age;}
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;} public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Integer getage() {return age;}
public void setage(Integer age) {this.age = age;}
}
<sql-query name="select_5">
<![CDATA[select name,age from person limit 3]]>
<return alias="s" class="cn.itcast.bean.Person"/>
</sql-query>下面是构造函数
package cn.itcast.bean;public class Person {
private Integer id;
private String name;
private Integer age;
public Person() {
}
public Person(String name,Integer age ) {
this.name=name;
this.age=age;
} //public Person(Integer id) {this.id = id;}
public Person(String name) {this.name = name;}
//public Person(Integer age) {this.age = age;}
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;} public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Integer getage() {return age;}
public void setage(Integer age) {this.age = age;}
}
解决方案 »
- Hibernate执行存储过程报了一个郁闷的异常(Column 'user2_0_0_' not found.)
- java 怎么上生成的xml写到客户机上
- 照搬老紫竹的一个javabean计数器,我怎么调试不通过啊. 急啊!
- 关于tomact的问题
- 请教 JSP中显示SVG图形的方法
- 100分:求解如何用jsp实现上传图片,并存到数据库中
- 用JSP编写一个在线播放音乐系统
- URIEncoding转码问题
- 怎么样让网页上传的图片放到指定的文件夹里呢?
- 谁知道怎样配置catalina.bat设置用户的home目录?
- 登录出现错误,请求帮助
- 在linux下,怎么创建多个tomcat,也就是说创建一个tomcat集群,分散一个tomcat的压力
SessionFactory sessionfactory = HSF.getSessionFactory();
Session session = sessionfactory.openSession();
Query query = session.createQuery("select id,name, pass from Haha");
List<Object[]> list = query.list();
for (Object[] user : list) {
System.out.print(user[0]);
System.out.print(user[1]);
System.out.print(user[2]);
System.out.println(); }
session.close();
sessionfactory.close();
SessionFactory sessionfactory = HibernateSessionFactory.getSessionFactory();
Session session = sessionfactory.openSession();
Query query = session.createQuery("select p.age,p.name from Person p"); //注意HQL查询是查询对象,所以Person是大写开头的
List <Object[]> list = query.list();
for (Object[] attribute: list) {
System.out.print(attribute[0]);
System.out.print(attribute[1]);
System.out.print(attribute[2]);
}