?? selectandwhereclause.java
字號:
package com.free.hibernate.select;
import java.util.Iterator;
import org.hibernate.Query;
import org.hibernate.Session;
import com.free.hibernate.bo.Contact;
import com.free.hibernate.util.HibernateUtil;
/**
* <p>Title: Eclipse Plugin Development</p>
* <p>Description: Free download</p>
* <p>Copyright: Copyright (c) 2006</p>
* <p>Company: Free</p>
* @author gan.shu.man
* @version 1.0
*/
public class SelectAndWhereClause {
public static void main(String[] args) {
//創建SessionFactory
HibernateUtil.buildSessionFactory();
//取得Session
Session session = HibernateUtil.currentSession();
System.out.println("*******************************");
System.out.println("Query using Hibernate Query Language");
//查詢Contact對象,并遍歷所有的Contact對象
String SQL_QUERY = " from Contact as contact where contact.id='1'";
Query query = session.createQuery(SQL_QUERY);
for (Iterator it = query.iterate(); it.hasNext();) {
Contact contact = (Contact) it.next();
System.out.println("ID: " + contact.getId());
System.out.println("Name: " + contact.getFirstName()+contact.getLastName());
}
System.out.println("*******************************");
System.out.println("Where Clause With Select Clause");
//通過條件選擇出符合條件的對象屬性
SQL_QUERY = "Select contact.id,contact.firstName,contact.lastName"
+ " from Contact contact "
+ " where contact.id='1'";
query = session.createQuery(SQL_QUERY);
//遍歷所有的屬性
for (Iterator it = query.iterate(); it.hasNext();) {
Object[] row = (Object[]) it.next();
System.out.println("ID: " + row[0]);
System.out.println("Name: " + row[1]+row[2]);
}
System.out.println("*******************************");
session.close();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -