package org.ithinking.datamanager;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.ithinking.strutsExample.entity.Userinfo;
import org.ithinking.utils.MessageDigestUtil;
import org.ithinking.utils.StringUtil;
//數據庫檢查和初始化類
public class CheckDb {
	public static void initDb()
	{
		Session session=null;
		try
		{
		session=HibernateSessionFactory.currentSession();
		Criteria criteria=session.createCriteria(Userinfo.class);
		//檢驗administrator用戶是否存在
		criteria.add(Expression.eq("userloginid","administrator"));
		List list=criteria.list();
		if(list==null||list.isEmpty())
		{
			Userinfo user=new Userinfo();
			user.setUserloginid("administrator");
			user.setUsername("系統管理員");
			//消息摘要類，數據庫中的密碼按照摘要的形式存放
			MessageDigestUtil messageDigest=new MessageDigestUtil(MessageDigestUtil.MD5);
			//缺省的密碼123
			String passwordMD5=StringUtil.convertBytesToString(messageDigest.computeDigest("123"));
			user.setPassword(passwordMD5);
			user.setSex("M");
			session.save(user);
			session.flush();
		}
		else
		{
			HibernateSessionFactory.closeSession();
		}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			
		}
		finally
		{
			if(session!=null)
			{
				HibernateSessionFactory.closeSession();
			}
		}
	}

}