package dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Order;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import entity.Book;
import entity.Users;

public class BooksDao extends HibernateDaoSupport {
	
	SessionFactory sessionFactory=null;
	Session session=null;
	public List<Book> getXinshuShangjia()//新书上架
	{
		List<Book> list=new ArrayList<Book>();
		try {
			sessionFactory=new Configuration().configure().buildSessionFactory();
			session=sessionFactory.openSession();
			
			Criteria criteria=session.createCriteria(Book.class);
			criteria.setMaxResults(15);//显示多少天数据
			criteria.addOrder(Order.asc("addTime"));
			list=criteria.list();
		} catch (Exception e) {
			// TODO: handle exception
		}
		return list;
	}
	public List<Book> getTushuChangxiaobang()//图书畅销榜
	{
		List<Book> list=new ArrayList<Book>();
		try {
			sessionFactory=new Configuration().configure().buildSessionFactory();
			session=sessionFactory.openSession();
			Criteria criteria=session.createCriteria(Book.class);
			criteria.setMaxResults(15);//显示多少天数据
			criteria.addOrder(Order.desc("bookloandegree"));
			list=criteria.list();
		} catch (Exception e) {
			// TODO: handle exception
		}
		return list;
	}
	public Book getBookById(int id)//通过图书ID  获得 该图书的所有信息
	{
		Book book=new Book();
		book=(Book)super.getHibernateTemplate().get(Book.class, id);
		return book;
	}
	public List<Book> getTejiaxiaoshou()//特价销售
	{
		List<Book> list=new ArrayList<Book>();
		try {
			sessionFactory=new Configuration().configure().buildSessionFactory();
			session=sessionFactory.openSession();
			Criteria criteria=session.createCriteria(Book.class);
			criteria.setMaxResults(6);//显示几条数据
			criteria.addOrder(Order.asc("bookprice"));
			list=criteria.list();
		} catch (Exception e) {
			// TODO: handle exception
		}
		return list;
	}
	public List<Book> getAllBooks()//获得所有图书信息
	{
		List<Book> list=new ArrayList<Book>();
		list=super.getHibernateTemplate().find("from Book");
		return list;
	}
	public void addBooks(Book bk)//增加图书
	{
		super.getHibernateTemplate().save(bk);
	}
	public void delbookShanchu(Book bk)//删除图书
	{
		super.getHibernateTemplate().delete(bk);
	}
	public Book getbookById(int bid)//通过ID  得到相应 图书所有信息
	{
		Book book=(Book)super.getHibernateTemplate().get(Book.class, bid);
		return book;
	}
	public void updateBook(Book bk)//更改 图书信息
	{
		super.getHibernateTemplate().update(bk);
	}
	public List<Book> getAllBooksByName(String bkname)
	{
		List<Book> list=super.getHibernateTemplate().find("from Book where bookname like '%"+bkname+"%'");
		return list;
	}
	public List<Users> getUser(String uname)//通过用户名  获取 用户信息
	{
		String sql="from Users where uname='"+uname+"'";
		return (List<Users>)super.getHibernateTemplate().find(sql);
	}
	public int updateUserDepoist(double bookPrice,String uname)
	{
		List<Users> list=this.getUser(uname);
		String ud=null;
		Users users=null;
		for (Users userss : list) {
			ud=userss.getUserdeposit();
			users=userss;
		}
		int udeposit=Integer.parseInt(ud);
		udeposit=(int)(udeposit-bookPrice);
		users.setUserdeposit(udeposit+"");
		super.getHibernateTemplate().save(users);
		return udeposit;
	}
	public void update_Book_bookloandegree_add_one(int bookId)
	{
		Book bk=null;
		try {
			bk = getBookById(bookId);
			int bookloandegree=bk.getBookloandegree();//卖出次数
			System.out.println(bookloandegree);
			bookloandegree=bookloandegree+1;
			bk.setBookloandegree(bookloandegree);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			System.out.println("update_Book_bookloandegree_add_one(int bookId) ERROR");
		}
		super.getHibernateTemplate().save(bk);
	}
}