<hibernate-mapping package="com.softeem.hibernate.pojo">
<class
name="Booktype"
table="booktype"
>
<meta attribute="sync-DAO">false</meta>
<id
name="id"
type="integer"
column="id"
>
<generator class="identity"/>
</id>
<property
name="typeName"
column="typeName"
type="string"
not-null="false"
length="50"
/>
</class>
</hibernate-mapping>
(3)映射文件相應的POJO類由hibernate框架自動生成
(4)建立DAO：BookDAO
public class BookDAO {
private Session session;
public BookDAO(Session session) {
this.session = session;
}
public void add(Book book) {
//add Transaction
Transaction tx = session.beginTransaction();
session.save(book);
tx.commit();
session.close();
}
public void delete(int id) {
//add Transaction
Transaction tx = session.beginTransaction();
Book book = (Book) session.load(Book.class, id);
session.delete(book);
tx.commit();
session.close();
}
public void update(Book book) {
//add Transaction
Transaction trs = session.beginTransaction();
session.update(book);
trs.commit();
session.close();
}
//findById
public Book findById(int id) {
Book book = (Book)session.get(Book.class, id);
session.close();
return book;
}
//findById
public Book findBy_Id(int id) {
Criteria cri = session.createCriteria(Book.class);
Book book = (Book) cri.add(Restrictions.eq("id", id)).uniqueResult();
session.close();
return book;
}
//最大查找
public void findMaxId() {
Transaction tx = session.beginTransaction();
Query query = session.createQuery("select max(b.id) from Book b ");
Iterator itr = query.list().iterator();
if (itr.hasNext()) {
Integer id = (Integer) itr.next();
System.out.println(id);
}
tx.commit();
session.close();
}
//分段查找
public List findAll(int minId, int maxId) {
Transaction tx = session.beginTransaction();
Query query = session
.createQuery("from Book b where b.id between :minId and :maxId");
query.setInteger("minId", minId);
query.setInteger("maxId", maxId);
tx.commit();
session.close();
return query.list();
}
//分頁
public List findPage(int page, int count) {
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Book b order by b.id");
query.setFirstResult((page - 1) * count);
query.setMaxResults(count);
tx.commit();
session.close();
return query.list();
}
// findAll
public List findAll() {
//不能為select * from Book b，簡單查詢
Query query = session.createQuery("from Book b");
List list = query.list();
session.close();
return list;
}
// findAll
public List findAllBy() {
//不能為select * from Book b，缺省為asc升序，將按照price字段來asc或desc排序
Query query = session.createQuery("from Book b order by b.price desc");
List list = query.list();
session.close();
return list;
}
// findAll
public List leftJoin() {
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Book b left outer join fetch b.typeid tid ");
List list = query.list();
tx.commit();
session.close();
return list;
}
// findAll
public List findCriteria() {
// Transaction tx = session.beginTransaction();
Criteria cri = session.createCriteria(Book.class);
// tx.commit();
List list = cri.list();
session.close();
return list;
}
//模糊查找
public List findByLike() {
Query query = session
.createQuery("from Book b where b.bookName like '%s%' order by b.id desc ");
List list = query.list();
session.close();
return list;
}
//模糊查找
public List findCriterias() {
Transaction tx = session.beginTransaction();
Criteria cri = session.createCriteria(Book.class);
//根據s模糊查找,并按降序排序
cri.add(Restrictions.like("bookName", "%s%")).addOrder(Order.desc("id"));
List list = cri.list();
tx.commit();
session.close();
return list;
}
public static void main(String[] args) {
// 獲得session對象
Session sess = HibernateUtil.currentSession();
BookDAO bookDAO = new BookDAO(sess);
// Book bk = bookDAO.findById(2);
// System.out.println(bk.getBookName());
Book bk = bookDAO.findBy_Id(3);
System.out.println(bk.getBookName());
//
// bookDAO.delete(3);
// List list = bookDAO.leftJoin();
// for(int i = 0;i<list.size();i++){
// System.out.println(((Book)list.get(i)).getPrice());
// }
// List list = bookDAO.findByLike();
// for(int i = 0;i<list.size();i++){
// System.out.println(((Book)list.get(i)).getBookName());
// }
// List list = bookDAO.findByLike();
// for (int i = 0; i < list.size(); i++) {
// System.out.println(((Book) list.get(i)).getBookName());
// }
// Book b = new Book();
// //id自增長時不會報錯
// b.setId(1);
// b.setBookName("系統分析");
// b.setPrice(155.5f);
// b.setPublish("郵電出版社");
// b.setTypeid(new Booktype(3));
// bookDAO.update(b);
// bookDAO.add(b);
// bookDAO.findMaxId();
// List list = bookDAO.findAll(3,5);
// for(int i = 0;i<list.size();i++){
// System.out.println(list.get(i));
// }
// List list = bookDAO.findPage(2,3);
// for(int i = 0;i<list.size();i++){
// System.out.println(((Book)list.get(i)).getBookName());
// }
// List list = bookDAO.findAll();
// Iterator itr = list.iterator();
// Book book = new Book();
// while (itr.hasNext()) {
// Object[] result = (Object[]) itr.next();
// book = (Book) result[0];
// Booktype booktype = (Booktype) result[1];
// System.out.println(book.getBookName());
// System.out.println(booktype.getTypeName());
// }
}
}
(5)HibernateUtil類：
package com.softeem.hibernate.util;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
/**
* 此類是專門生產session
*
*/
public class HibernateUtil {
private static Log log = LogFactory.getLog(HibernateUtil.class);
private static final SessionFactory sessionFactory;
static {
try {
// Create the SessionFactory
sessionFactory = new Configuration().configure()
.buildSessionFactory();
} catch (Throwable ex) {
log.error("Initial SessionFactory creation failed.", ex);
throw new ExceptionInInitializerError(ex);
}
}
public static final ThreadLocal threadLocal = new ThreadLocal();
public static Session currentSession() {
Session s = (Session) threadLocal.get();
// Open a new Session, if this Thread has none yet
if (s == null) {
s = sessionFactory.openSession();
threadLocal.set(s);
}
return s;
}
public static void closeSession() {
Session s = (Session) threadLocal.get();
if (s != null)
s.close();
threadLocal.set(null);
}
}
posted on 2007-05-24 11:35
cheng 閱讀(3743)
評論(0) 編輯 收藏 所屬分類:
Hibernate