idaoimpl.java

SSH框架

package com.sun.DAO;

import java.util.List;

import org.hibernate.Session;

import com.sun.bean.Book;
import com.sun.pojo.HibernateSessionFactory;
import com.sun.pojo.TBookBu;
import com.sun.pojo.TBookTypeBu;
import com.test.struts.form.InsertBookForm;

public class IDAOImpl implements IDAO{
	Session session;
	public List queryByType(String typename) {
		String HQL = "From TBookBu as u where u.bookType=?";
		session = HibernateSessionFactory.getSession();
		List mylist = session.createQuery(HQL).setString(0,typename).list();
		session.close();
		System.out.println(mylist.size());
		return mylist;
	}
	public List queryByName(String name) {
		String HQL = "From TBookBu as u where u.bookName like '%"+name+"%'";
		session = HibernateSessionFactory.getSession();
		List list = session.createQuery(HQL).list();
		session.close();
		return list;
	}
	
	
	public String queryForType(String name) {

		String HQL = "From TBookTypeBu as u where u.typeName=?";
		session = HibernateSessionFactory.getSession();
		TBookTypeBu type = (TBookTypeBu)session.createQuery(HQL).setString(0,name).uniqueResult();
		String s = type.getTypeId();
		return s;
	}
	public List queryAllType() {
		String HQL = "From TBookTypeBu ";
		session = HibernateSessionFactory.getSession();
		List mylist = session.createQuery(HQL).list();
		session.close();
		return mylist;

	}
	public void insertBook(TBookBu book) {
		session=HibernateSessionFactory.getSession();
		session.save(book);
		session.beginTransaction().commit();
		session.close();
	}

}