package com.zkdz.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import zk.jni.JavaToBiokey;

import com.zkdz.actionForm.UserinfoForm;
import com.zkdz.core.ChStr;
import com.zkdz.core.ConnDB;

public class UserinfoDAO {
	  ConnDB conn = new ConnDB();
	  ChStr chStr = new ChStr();
	 
	//將用戶的信息和指紋保存到數據庫
	public int addUserinfo(UserinfoForm userinfoForm) {
		int ret = 0;
		String sex = userinfoForm.getSex();
		String name = userinfoForm.getName();
		String userid = userinfoForm.getUserid();
		String template = userinfoForm.getTemplate();
		// 判斷一個人最多添加10枚指紋
		String sql1 = "insert into userinfo values(null,'" + sex + "','" + name
				+ "','" + userid + "','" + template + "')";
	//	System.out.println(sql1);
		ret = conn.executeUpdate(sql1);
		conn.close();
		return ret;
	}
    //指紋比對
	public int vertemplate(UserinfoForm userinfoForm) {
		
		int ret = 0;
		int i=1;    //計算第幾枚指紋
		String userid=userinfoForm.getUserid();
		//System.out.println("DAO函數獲取比對的號碼："+userid);
		String ver=userinfoForm.getTemplate();//比對指紋
		//System.out.println("DAO函數獲取用戶比對指紋："+ver);
		String sql="select template from userinfo where userid='"+userid+"'";
		//System.out.println(sql);
		ResultSet rs=conn.executeQuary(sql);
		try {
			 JavaToBiokey myboikey=new JavaToBiokey(); //調用指紋比對，這是個類
			  myboikey.ToSetThreshold(10, 10);
			while(rs.next()){
				String reg=rs.getString(1); //獲取用戶登記指紋
			//	System.out.println("DAO用戶登記第"+i+"枚指紋："+reg);
				boolean verok=myboikey.ToProcess(reg, ver);
			//	System.out.println("比對結果："+verok);
				if(verok){
					ret=1;
			//	  System.out.println("用戶號碼:"+userid+",第"+i+"枚指紋比對成功");
				 //System.out.println(reg);
					
					break; //如果有其中一枚指紋比對成功，則退出循環，不再比對本人的下一枚指紋否則繼續
				}else{
					ret=0;
			//		System.out.println("用戶號碼:"+userid+",第"+i+"枚指紋比對失敗");
					i++;
					continue;
				}
			}

	  //這里可以把用戶信息
		} catch (SQLException e) {
		//	System.out.println("比對指紋出錯");
		}finally{
			conn.close();
		}
		return ret;
	}
	
	//通過userid查詢用戶的其他信息
	public UserinfoForm query_from_userid(String userid){
		UserinfoForm userinfo=new UserinfoForm();
		String sql="select id,sex,name,userid from userinfo where userid='"+userid+"'";
		ResultSet rs=conn.executeQuary(sql);
		try {
			while(rs.next()){
			    userinfo.setId(rs.getInt(1));
			    userinfo.setSex(rs.getString(2));
			    userinfo.setName(rs.getString(3));
			    userinfo.setUserid(rs.getString(4));
			  //System.out.println("比對指紋時得到的號碼"+userinfo.getUserid());
			    break;//因為userid不是唯一可能重復
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			conn.close();
		}
		return userinfo;
	}
}