/**
 * 基于注解的SpringMVC+Hibernate3.6的CRUD
 * @author Saiteam
 *
 */
@Controller
public class UserController {
	
	private UserDaoImpl userDao=new UserDaoImpl();
	
	@RequestMapping(value="/list.action")
	public String list(HttpServletRequest request){
		List<User> user = userDao.list();
		request.setAttribute("users", user);
		return "list";
	}
	@RequestMapping(value="/saveForward.action")
	public String saveForward(HttpServletRequest request){
		return "add";
	}
	@RequestMapping(value="/add.action")
	public String add(HttpServletRequest request) throws Exception{
		request.setCharacterEncoding("UTF-8");
		User user = new User();
		user.setName(request.getParameter("name"));
		user.setPassword(request.getParameter("password"));
		user.setSex(request.getParameter("sex"));
		user.setAddress(request.getParameter("address"));
		user.setPhone(request.getParameter("phone"));
		user.setEmail(request.getParameter("email"));
		userDao.save(user);
		request.setAttribute("users", userDao.list());
		return "list";
	}
	
	@RequestMapping(value="/delete.action")
	public String delete(HttpServletRequest request){
		int id = Integer.parseInt(request.getParameter("id"));
		userDao.delete(id);
		request.setAttribute("users", userDao.list());
		return "list";
	}
	
	@RequestMapping(value="/update.action")
	public String update(HttpServletRequest request) throws Exception{
		request.setCharacterEncoding("UTF-8");
		User user = new User();
		user.setId(Integer.parseInt(request.getParameter("id")));
		user.setName(request.getParameter("name"));
		user.setPassword(request.getParameter("password"));
		user.setSex(request.getParameter("sex"));
		user.setAddress(request.getParameter("address"));
		user.setPhone(request.getParameter("phone"));
		user.setEmail(request.getParameter("email"));
		userDao.update(user);
		request.setAttribute("users", userDao.list());
		return "list";
	}
	
	@RequestMapping(value="/get.action")
	public String get(HttpServletRequest request){
		int id = Integer.parseInt(request.getParameter("id"));
		request.setAttribute("user", userDao.get(id));
		return "update";
	}
	/**
	 * 登陆功能
	 * @param request
	 * @return
	 * @throws Exception 
	 */
	@RequestMapping(value="login.action")
	public String login(HttpServletRequest request) throws Exception{
		request.setCharacterEncoding("UTF-8");
		String name = request.getParameter("name");
		String password = request.getParameter("password");
		
		//测试
		System.out.println("-------name-----------"+name);
		System.out.println("-------password-----------"+password);
		
		if(name != null && !name.equals("")){
			if(password != null && !password.equals("")){
				User model = userDao.login(name, password);
				//测试
				System.out.println("-------------model--------"+model);
				
				if(model != null && !model.equals("")){
						request.setAttribute("users", userDao.list());
						return "list";
				}else{
					request.setAttribute("error", "用户或密码错误！");
					return "forward:/login.jsp";
				}
			}else{
				request.setAttribute("error", "密码不能为空！");
				return "forward:/login.jsp";
			}
		}else{
			request.setAttribute("error", "用户名不能为空！");
			return "forward:/login.jsp";
		}
		
	}
	
	//实现注册功能
	@RequestMapping(value="register.action")
	public String register(HttpServletRequest request) throws Exception{
		request.setCharacterEncoding("UTF-8");
		User user = new User();
		user.setName(request.getParameter("name"));
		user.setPassword(request.getParameter("password"));
		user.setSex(request.getParameter("sex"));
		user.setAddress(request.getParameter("address"));
		user.setPhone(request.getParameter("phone"));
		user.setEmail(request.getParameter("email"));
		userDao.save(user);
		return "forward:/index.jsp";
	}
	
	
	/**
	 * 跳转到登陆页面
	 * @param request
	 * @return
	 */
	@RequestMapping(value="loginForward.action")
	public String loginForwad(HttpServletRequest request){
		return "forward:/login.jsp";
	}
	/**
	 * 转发到注册页面
	 * @param request
	 * @return
	 */
	@RequestMapping(value="rgf.action")
	public String registerForwad(HttpServletRequest request){
		return "forward:/register.jsp";
	}
	
}

public class UserDaoImpl implements UserDao {

	public  void save(User user) {  
        Session session = HibernateSessionFactory.getSession();  
        Transaction tx = session.getTransaction();  
        try {  
            tx.begin();  
            session.save(user);  
            tx.commit();  
        } catch (HibernateException e) {  
            if (tx != null) { // 如果存在事务，则回滚  
                tx.rollback();  
            }  
            throw e; // 抛出异常  
        } finally {  
            if (session != null) // 如果session存在，则关闭  
                session.close();  
        }  
    }  

	public  void delete(int id) {  
        Session session = HibernateSessionFactory.getSession(); 
        String hql = "DELETE User u WHERE u.id=:id";
        session.createQuery(hql).setInteger("id", id).executeUpdate();
    }  

	public void update(User user){
		 Session session = HibernateSessionFactory.getSession(); 
	     Transaction tx = session.getTransaction();   
        try {  
            tx.begin(); 
            session.update(user);  
            tx.commit();  
        } catch (HibernateException e) {  
            if (tx != null) { // 如果存在事务，则回滚  
                tx.rollback();  
            }  
            throw e; // 抛出异常  
        } finally {  
            if (session != null) // 如果session存在，则关闭  
                session.close();  
        }  
	}

	  public  User get(int id) {  
	        Session session = HibernateSessionFactory.getSession(); 
	        try {  
	            User user = (User) session.get(User.class, id);  
	            return user;  
	        } finally {  
	            if (session != null) {  
	                session.close();  
	            }  
	        }  
	    }

	public List<User> list(){
		Session session = HibernateSessionFactory.getSession();
		String hql = "FROM User";
		return session.createQuery(hql).list();
	}
	
	
	//登陆功能
	public User login(String name,String password){
		Session session = HibernateSessionFactory.getSession();
		String hql = "FROM User u WHERE u.name=:name AND u.password=:password";
		return (User) session.createQuery(hql).setString("name", name).setString("password", password).uniqueResult();
	}
}