SSH网上商城毕业设计（界面漂亮，我自己用的）含Oracle数据库脚本

package com.hb.showpetshop.biz; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import com.hb.showpetshop.module.MemberDAO; public class MemberBiz { private MemberDAO memberDAO; private SessionFactory sessionFactory; public MemberDAO getMemberDAO() { return memberDAO; } public void setMemberDAO(MemberDAO memberDAO) { this.memberDAO = memberDAO; } public SessionFactory getSessionFactory() { return sessionFactory; } public void setSessionFactory(SessionFactory sessionFactory) { this.sessionFactory = sessionFactory; } /** * 验证用户(查询看是否有这个用户存在) * @param username * @param password * @return */ public List isExist(String username,String password) { List exist=null; Session session =this.getSessionFactory().openSession(); Transaction transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); exist=this.getMemberDAO().getUserPassword(username, password); transaction.commit(); return exist; } public boolean updateUser(Long userId,String realname,String phone,String address,String email,String remark) {boolean success=true; Transaction transaction=null; try{System.out.println(41); Session session =this.getSessionFactory().openSession(); transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); System.out.println(42); this.getMemberDAO().updateUser(userId, realname, phone, address, email, remark); transaction.commit(); System.out.println(43); }catch(Exception e) { success=false; transaction.rollback(); } return success; } public boolean setPassword(Long userId,String password) { boolean success=true; Transaction transaction=null; try{System.out.println(41); Session session =this.getSessionFactory().openSession(); transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); System.out.println(42); this.getMemberDAO().setPassword(userId, password); transaction.commit(); System.out.println(43); }catch(Exception e) { success=false; transaction.rollback(); } return success; } //**********************刘荣 public List getAllMembers() { List members=null; Session session=this.getSessionFactory().openSession(); Transaction transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); members=this.getMemberDAO().getAllMembers(); transaction.commit(); return members; } public boolean updateMember(Long userId,Long role) { boolean success=true; Transaction transaction=null; try{ Session session =this.getSessionFactory().openSession(); transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); this.getMemberDAO().updateMember(userId, role); transaction.commit(); } catch(Exception e) { success=false; transaction.rollback(); } return success; } //******************************* //************************88唐菁 /** * Method addUser * @Function 添加成员记录 * @param realname * @param username * @param password * @param phone * @param address * @param role * @param email * @param remark * @return boolean 为false,已存在该记录 */ public boolean addUser(String realname, String username, String password, String phone, String address, Long role, String email, String remark) { boolean success = true; Session session = this.getSessionFactory().openSession(); Transaction transaction = session.beginTransaction(); try { this.getMemberDAO().setDbSession(session); this.getMemberDAO().addUser(realname, username, password, phone, address, role, email, remark); transaction.commit(); } catch (Exception e) { transaction.rollback(); success = false; } return success; } /** * Method getuserInformation * @param username * @Function 按登陆名查询成员记录 * @return List结果集 */ public List getUserInformation(String username) { List information=null; Session session = this.getSessionFactory().openSession(); Transaction transaction = session.beginTransaction(); try { this.getMemberDAO().setDbSession(session); information = this.getMemberDAO().getuserInformation(username); transaction.commit(); } catch (Exception e) { transaction.rollback(); } return information; } /** * Method getUser * @param realname * @Function 按姓名查询成员记录 * @return List结果集 */ public List getUser(String realname) { List information = null; Session session = this.getSessionFactory().openSession(); Transaction transaction = session.beginTransaction(); try { this.getMemberDAO().setDbSession(session); information = this.getMemberDAO().getUser(realname); transaction.commit(); } catch (Exception e) { transaction.rollback(); } return information; } /** * Method getAllUser * @Function 查询数据库用户表中所有的记录 * @return List结果集 */ public List getAllUser() { List information = null; Session session = this.getSessionFactory().openSession(); Transaction transaction = session.beginTransaction(); try { this.getMemberDAO().setDbSession(session); information = this.getMemberDAO().getAllUser(); transaction.commit(); } catch (Exception e) { transaction.rollback(); } return information; } /** * Method updateUser * @Function 修改数据库中的记录 * @param userId * @param realname * @param username * @param password * @param phone * @param address * @param role * @param email * @param remark * @return boolean */ public boolean updateUser(Long userId,String realName,String userName,String password,String phone,String address,Long role,String email,String remark) { Transaction transaction=null; try{ Session session =this.getSessionFactory().openSession(); transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); this.getMemberDAO().updateUser(userId, realName, userName, password, phone, address, role, email, remark); transaction.commit(); return true; } catch(Exception e){ transaction.rollback(); return false; } } /** * Method deleteUser * @param userId * @Function 删除 */ public boolean deleteUser(Long userId) { Transaction transaction=null; try{ Session session =this.getSessionFactory().openSession(); transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); this.getMemberDAO().deleteUser(userId); transaction.commit(); return true; } catch(Exception e){ transaction.rollback(); return false; } } /** * Method getUserName * @param userId * @Function 根据用户号得到登陆名，用于订单管理中页面显示 * @return List结果集 */ public String getUserName(Long userId) { Transaction transaction=null; List information=null; String userName=null; try{ Session session =this.getSessionFactory().openSession(); transaction=session.beginTransaction(); this.getMemberDAO().setDbSession(session); information=this.getMemberDAO().getUserName(userId); if(information.size()>0) userName=(String) information.get(0); } catch(Exception e){ transaction.rollback(); } return userName; } //**************************8 }