package dao; import java.util.Iterator; import java.util.List; import org.hibernate. * ; import org.hibernate.cfg.Configuration; import mapping.AdminPopedomTable; import mapping.AdminTable; import mapping.base.BaseAdminTable; public class AdminTableDAO extends BaseAdminTable ... { /** *//** * */ private static final long serialVersionUID = 1L; public static SessionFactory sessionFactory; static...{ try...{ sessionFactory = new Configuration().configure().buildSessionFactory(); }catch(HibernateException e)...{ e.printStackTrace(); } } //插入一条数据 public boolean insertAdmin(AdminTable adminTable)...{ Session session = sessionFactory.openSession(); Transaction tx = null; try...{ tx = session.beginTransaction(); session.save(adminTable); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx!=null)...{ tx.rollback(); } return false; }finally...{ if(session.isOpen())...{ session.close(); } } return true; } //根据ID查找一条数据 public List queryAdmin(String id)...{ Session session = sessionFactory.openSession(); Transaction tx = null; List list = null; try...{ tx = session.beginTransaction(); Query query = session.createQuery("from AdminTable as a where a.Id=:adminID "); query.setString("adminID",id); list = query.list(); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx != null)...{ tx.rollback(); } }finally...{ if(session.isOpen())...{ session.close(); } } return list; } //根据用户名和额密码查找一条悉尼 public List queryAdminLogin(String nick , String pwd)...{ Session session = sessionFactory.openSession(); Transaction tx = null; List list = null; try...{ tx = session.beginTransaction(); Query query = session.createQuery("from AdminTable as a where a.AdminNick=:adminNick and a.AdminPwd=:adminPwd"); query.setString("adminNick",nick); query.setString("adminPwd",pwd); list = query.list(); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx != null)...{ tx.rollback(); } }finally...{ if(session.isOpen())...{ session.close(); } } return list; } //全部查找 public List queryAdminAll()...{ Session session = sessionFactory.openSession(); Transaction tx = null; List list = null; try...{ tx = session.beginTransaction(); Query query = session.createQuery("from AdminTable as a order by a.Id desc"); list = query.list(); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx != null)...{ tx.rollback(); } }finally...{ if(session.isOpen())...{ session.close(); } } return list; } //分页查找 public List queryAdminPage(int first , int items)...{ Session session = sessionFactory.openSession(); Transaction tx = null; List list = null; try...{ tx = session.beginTransaction(); Query query = session.createQuery("from AdminTable as a order by a.Id desc"); query.setFirstResult(first); query.setMaxResults(items); list = query.list(); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx != null)...{ tx.rollback(); } }finally...{ if(session.isOpen())...{ session.close(); } } return list; } //内容更新 public boolean updateAdmin(AdminTable adminTable)...{ Session session = sessionFactory.openSession(); Transaction tx = null; try...{ tx = session.beginTransaction(); session.update(adminTable); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx != null)...{ tx.rollback(); } return false; }finally...{ if(session.isOpen())...{ session.close(); } } return true; } //删除内容 public boolean delAdmin(AdminTable adminTable)...{ Session session = sessionFactory.openSession(); Transaction tx = null; try...{ tx = session.beginTransaction(); session.delete(adminTable); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx != null)...{ tx.rollback(); } return false; }finally...{ if(session.isOpen())...{ session.close(); } } return true; } //删除一条信息 public boolean delAdmin1(AdminTable adminTable)...{ Session session = sessionFactory.openSession(); Transaction tx = null; List list = null; Iterator it = null; try...{ //删除一条管理员信息 tx = session.beginTransaction(); String id = adminTable.getId().toString(); //删除所有ID等于 Query query = session.createQuery("from AdminPopedomTable as a where a.AdminId =:adminID"); query.setString("adminID",id); list = query.list(); if(!list.isEmpty())...{ it = list.iterator(); while(it.hasNext())...{ AdminPopedomTable adminPopedomTable = new AdminPopedomTable(); adminPopedomTable = (AdminPopedomTable) it.next(); session.delete(adminPopedomTable); } } session.delete(adminTable); tx.commit(); }catch(HibernateException e)...{ e.printStackTrace(); if(tx!=null)...{ tx.rollback(); } }finally...{ if(session.isOpen())...{ session.close(); } } return true; }} // Created by MyEclipse Struts // XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xsl package com.cccnet.struts.action; import java.util. * ; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import mapping.AdminPopedomTable; import mapping.AdminTable; import mapping.PopedomTable; import org.apache.struts.action.Action; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import tools.SessionTooles; import tools.StringUtil; import com.cccnet.struts.form.AdminLoginForm; import dao. * ; /** */ /** * MyEclipse Struts * Creation date: 03-30-2007 * * XDoclet definition: * @struts.action path="/adminLogin" name="adminLoginForm" input="/adminLogin.jsp" scope="request" validate="true" * @struts.action-forward name="success" path="/cccnetAdmin.jsp" */ public class AdminLoginAction extends Action ... { // --------------------------------------------------------- Instance Variables // --------------------------------------------------------- Methods /** *//** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */ public ActionForward execute( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) ...{ AdminLoginForm adminLoginForm = (AdminLoginForm) form; //判断用户是否登陆 SessionTooles sessionTooles = new SessionTooles(); if(sessionTooles.isLogin(request))...{ HttpSession session = request.getSession(); session.invalidate(); } //获得表单信息 String nick = adminLoginForm.getAdmin_nick(); String pwd = adminLoginForm.getAdmin_pwd(); //用户加密 StringUtil stringUtil = new StringUtil(); pwd = stringUtil.MD5Encode(pwd); //寻找用户名和密码匹配的数据项 AdminTableDAO adminTableDAO = new AdminTableDAO(); AdminTable adminTable = new AdminTable(); List list = null; Iterator it = null; try...{ list = adminTableDAO.queryAdminLogin(nick,pwd); if(!list.isEmpty())...{ //登陆成功,将登陆信息记录在session中 it = list.iterator(); adminTable = (AdminTable) it.next(); HttpSession session = request.getSession(); session.setAttribute("account",adminTable); //判断用户是否是超管 String is = adminTable.getAdminIs(); //获得用户权限 String id = adminTable.getId().toString(); AdminPopedomTableDAO adminPopedomTableDAO = new AdminPopedomTableDAO(); PopedomTableDAO popedomTableDAO = new PopedomTableDAO(); AdminPopedomTable adminPopedomTable = new AdminPopedomTable(); list = adminPopedomTableDAO.queryAdminPopedom1(id); if(!list.isEmpty())...{ it = list.iterator(); Vector popedoms = new Vector(); while(it.hasNext())...{ adminPopedomTable = (AdminPopedomTable) it.next(); id = adminPopedomTable.getPopedomId().toString(); PopedomTable popedomTable = new PopedomTable(); list = popedomTableDAO.queryPopedom(id); if(!list.isEmpty())...{ popedomTable = (PopedomTable) list.iterator().next(); popedoms.add(popedomTable); } } session.setAttribute("popedoms",popedoms); } session.setAttribute("is",is); return mapping.findForward("success"); } request.setAttribute("failure","登陆失败了...."); return mapping.findForward("failure"); }catch(Exception e)...{ e.printStackTrace(); request.setAttribute("failure","登陆失败了...."); return mapping.findForward("failure"); } }}