// Decompiled by DJ v3.7.7.81 Copyright 2004 Atanas Neshkov  Date: 2007-5-14 下午 03:03:51
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   BusinessManage.java

package com.wang.business;

import com.wang.module.CDDate;
import com.wang.module.User;
import java.io.PrintStream;
import java.util.List;
import org.hibernate.*;
import org.hibernate.cfg.Configuration;

public class BusinessManage
{

    public BusinessManage()
    {
        sf = null;
        s = null;
        ts = null;
        query = null;
        sf = (new Configuration()).configure().buildSessionFactory();
        s = sf.openSession();
        ts = s.beginTransaction();
    }

    public void openSession()
    {
        s = sf.openSession();
    }

    public boolean checkLogin(User user)
    {
        boolean flag = false;
        try
        {
            query = s.createQuery((new StringBuilder()).append("from User user where user.userName='").append(user.getUserName()).append("' and userPwd='").append(user.getUserPwd()).append("'").toString());
            List list = query.list();
            if(list.size() > 0)
                flag = true;
            else
                flag = false;
        }
        catch(Exception e)
        {
            flag = false;
            e.printStackTrace();
        }
        return flag;
    }

    public List selectCDBean(String value, int page, int count)
    {
        List list = null;
        int pagelast = 0;
        try
        {
            query = s.createQuery((new StringBuilder()).append("from CDDate cd where cd.cdName like '%").append(value).append("%'").toString());
            if(query.list().size() / count == 0)
            {
                PAGECOUNT = query.list().size() / count;
            } else
            {
                PAGECOUNT = query.list().size() / count + 1;
                pagelast = query.list().size() / count;
            }
            System.out.println(query.list().size());
            int begin = page * count - count;
            int end = page * count;
            if(page == PAGECOUNT)
                end = query.list().size();
            list = query.list().subList(begin, end);
            System.out.println(list.size());
        }
        catch(Exception ex)
        {
            list = null;
            ex.printStackTrace();
        }
        return list;
    }

    public boolean updataCDDate(CDDate cd)
    {
        s.update(cd);
        ts.commit();
        return ts.wasCommitted();
    }

    public CDDate getCDDate(long id)
    {
        CDDate cd = (CDDate)s.load(com/wang/module/CDDate, Long.valueOf(id));
        ts.commit();
        return cd;
    }

    public boolean delCDDate(long id)
    {
        CDDate cd = (CDDate)s.get(com/wang/module/CDDate, Long.valueOf(id));
        s.delete(cd);
        ts.commit();
        return ts.wasCommitted();
    }

    public boolean updateUser(User user)
    {
        query = s.createQuery((new StringBuilder()).append("from User user where user.userName='").append(user.getUserName()).append("'").toString());
        User temp = (User)query.list().get(0);
        temp.setUserPwd(user.getUserPwd());
        s.update(temp);
        ts.commit();
        return ts.wasCommitted();
    }

    private boolean hasUser(User user)
    {
        boolean flag = false;
        query = s.createQuery((new StringBuilder()).append("from User user where user.userName='").append(user.getUserName()).append("'").toString());
        if(query.list().size() != 0)
            flag = true;
        return flag;
    }

    public boolean addCDDate(CDDate cd)
    {
        s.save(cd);
        ts.commit();
        return ts.wasCommitted();
    }

    public boolean addUser(User user)
    {
        if(hasUser(user))
        {
            return false;
        } else
        {
            s.save(user);
            ts.commit();
            return ts.wasCommitted();
        }
    }

    public void close()
    {
        s.close();
    }

    private SessionFactory sf;
    private Session s;
    private Transaction ts;
    private Query query;
    public static int PAGECOUNT;
}