logindaoimpl.java

基于java开发的邮件系统

package com.xiaoer.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.xiaoer.hibernate.Factory.HibernateSessionFactory;
import com.xiaoer.vo.Login;
import com.xiaoer.vo.Users;

public class LoginDaoImpl {

	//获得激活码
	private static Long getCode(String userName){
		Session session  = HibernateSessionFactory.getSession();
		String sql = " from Users users where users.username=?";
		Query query = session.createQuery(sql);
		query.setString(0, userName);
		List<Users> user = query.list();
		String strStatus = null;
		for (Users users : user) {
			strStatus = users.getStatus().toString();
		}
		return new Long(strStatus);
	}
	
	public static boolean login(String username,String pwd){
		if(getCode(username)==1){
			Session session  = HibernateSessionFactory.getSession();
			String sql = "from Login login where login.username=? and login.pwd=?";
			Query query = session.createQuery(sql);
			query.setString(0, username);
			query.setString(1, pwd);
			List<Login> list = query.list();
			if(list.size()>0){
				return true;
			}else{
				return false;
			}	
		}else{
			return false ;
		}
		
	}
	
	//确认激活码
	public static boolean jihuo(String code){
		Session session  = HibernateSessionFactory.getSession();
		String sql = "update com.xiaoer.vo.Users  set status=? where jcode=?";
		Query query = session.createQuery(sql);
		query.setLong(0, 1);
		query.setString(1, code);
		int count = query.executeUpdate();
		session.beginTransaction().commit();
		return count>0 ?true : false;
	}
	
	public static void main(String[] args){
		System.out.println(LoginDaoImpl.login("xcfxiaoer", "123456"));
	}
}