package com.laoer.bbscs.business;

import com.laoer.bbscs.bean.*;
import com.laoer.comm.db.*;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.*;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.Query;

/**
 * <p>Title: TianYi BBS</p>
 * <p>Description: TianYi BBS System</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: LAOER.COM/TIANYISOFT.NET</p>
 * @author laoer
 * @version 6.0
 */

public class UserInfoServiceImp {

  private static String load_b = "from Board b where b.id = 1";

  public UserInfoServiceImp() {
  }

  public UserInfo saveUser(UserInfo ui) throws DAOException {
    Session session = null;
    net.sf.hibernate.Transaction txc = null;
    try {
      session = HibernateUtil.currentSession();
      txc = session.beginTransaction();
      session.saveOrUpdate(ui);
      txc.commit();
    }
    catch (Exception e) {
      try {
        txc.rollback();
      }
      catch (HibernateException hex) {
        hex.printStackTrace();
      }
      throw new DAOException(e);
    }
    finally {
      closeSession();
      return ui;
    }
  }

  protected void closeSession() {
    try {
      HibernateUtil.closeSession();
    }
    catch (HibernateException he) {
      System.err.println(he.getMessage());
    }
  }

  public static void main(String[] args) {
    Session session = null;
    net.sf.hibernate.Transaction txc = null;
    try {
      session = HibernateUtil.currentSession();
      txc = session.beginTransaction();
      //List l = session.find(load_b);
      //System.out.println(l.size());
      Board b = (Board) session.get(Board.class, new Long(1));
      System.out.println(b.getBoards().size());
      Boards bs = (Boards) b.getBoards().get(new Long(1));
      //b.getBoards().remove(new Long(16));
      bs.getBoard().getBoards().remove(new Long(1));
      //session.save(b);
      session.delete(bs);
      txc.commit();
      session.flush();
      System.out.println(b.getBoards().size());

      /*
             Boards bs = new Boards();
             bs.setAssiMaster("");
             bs.setAttrib1((short)0);
             bs.setAttrib2((short)0);
             bs.setAttrib3((short)0);
             bs.setAttrib4((short)0);
             bs.setAttrib5((short)0);
             bs.setAttrib6((short)0);
             bs.setAttrib7((short)0);
             bs.setAttrib8((short)0);
             bs.setAttrib9((short)0);
             bs.setAttrib10((short)0);
             bs.setBoardsEName(" ");
             bs.setBoardsName(" ");
             bs.setBulletin(" ");
             bs.setExplains(" ");
             bs.setHideMaster(" ");
             bs.setMainMaster(" ");
             bs.setMainPostNum(0);
             bs.setOrders((short)4);
             bs.setPic("");
             bs.setPostNum(0);
             bs.setUserCanIn("");
             bs.setUseStat((short)1);
             bs.setBoard(b);
             session.saveOrUpdate(bs);
             txc.commit();
             session.flush();
             System.out.println("bs id:"+bs.getId());
             System.out.println(b.getBoards().size());
       */

    }
    catch (HibernateException ex) {
      ex.printStackTrace();
    }
    /*
         UserInfoServiceImp userInfoServiceImp1 = new UserInfoServiceImp();
         UserInfo ui = new UserInfo();
         ui.setUsername("laoer");
         try {
      ui = userInfoServiceImp1.saveUser(ui);
      System.out.println(ui.getId().longValue());
         }
         catch (DAOException ex) {
      ex.printStackTrace();
         }*/
  }

}