package cn.register.user;

import cn.register.MD5;
import cn.register.db.DBConnect;

public class SqlUser extends AbstractUser{

    //確認兩次輸入的密碼是否相等
	//private boolean checkRPwd(String password, String rpassword)
	public boolean checkRPwd(String password, String rpassword)
	{
		if(password !=null && rpassword != null){
			if(password.equals(rpassword))
				return true;
			else 
				return false;
		}else
			return false;
	}
 
    //注冊用戶：
    public boolean saveUser(User user){
		String User_id = user.getUser_id();
		String Password = user.getPassword();
		String Name = user.getName();
		String Sex = user.getSex();
		long   Birth = user.getBirth();
		String Description = user.getDescription();
		String str = "insert into users values('"
		             +User_id  + "','"
					 +Password + "','"
					 +Name+      "','"
					 +Sex+       "',"
					 +Birth+     ",'"
					 +Description+   "')";
		try{
			DBConnect dbconnect = new DBConnect();
			dbconnect.excuteUpdate(str);
			return true;		
		}catch(Exception e){
			e.printStackTrace();
			return false;
		}
		
    }
    
	//根據用戶ID將用戶信息傳入User接口內保存
	public User getUser(String ID){
		//User user = null;
		String str = "select * from users where USER_ID='"+ID+"'";
		//String str = "select * from users where USER_ID='jkh' ";
		try{
			DBConnect dbconnect = new DBConnect();
			dbconnect.excuteQuery(str);
			if(dbconnect.next()){
				this.setUser_id(dbconnect.getString(1));
				this.setPassword(dbconnect.getString(2));
				setName(dbconnect.getString(3));
				setSex(dbconnect.getString(4));
				setBirth(dbconnect.getLong(5));
				setDescription(dbconnect.getString(6));
			}
		}catch(Exception e){
			e.printStackTrace();
		}	
		return this;    //若無用戶信息則返回null.
	}


    //存在用戶返回0  不存在用戶返回1 密碼錯誤返回2
	public int checkUser(String ID, String password){
		int index = 0;          
		User user = getUser(ID);
		//if(user != null){
		if(user.getUser_id() != null){
			if (user.getPassword().equals(MD5.toMD5(password)))
				index = 0;
			else 
				index = 2;
		}else
			index = 1;

		return index;
	}


/*	public int checkUser(String ID, String password){
		int index = 0;          
		User user = getUser(ID);
		//if(user == null)
		if (user.getUser_id()==null)
				index = 10;
		else 
				index = 2;
		
		//else
		//	index = 1;

		return index;
	} 
*/
}