package model.condition.visitor;
import java.sql.SQLException;
import model.condition.test.TestByRadom;
import model.connection.Connectable;
import model.connection.ConnectionAccess;
import model.persistency.*;
import model.exception.*;
import javax.swing.JOptionPane;
/**
 *
 * <p>Title: </p>
 * 訪問類
 * <p>Description: </p>
 * 繼承訪問接口，對各個方法實現
 */
public class SingleVisitor implements Visitor{
	ItemMapper itemMap;
        /**
         *  構造函數
         *  連接數據庫
         */
        public SingleVisitor() {
    	try{
		Connectable con = new ConnectionAccess("sun.jdbc.odbc.JdbcOdbcDriver");
		//itemMap = ItemMapper.getInstance(con);
                itemMap = new ItemMapper(con);
		}catch(SQLException e){
			System.out.println("sql exception");
		}
		catch(ClassNotFoundException l){
			System.out.println("class not found");
		}
    }
    public void add(PersistentItem item)throws AddFailedException,SQLException{
    //   JOptionPane.showConfirmDialog(null,"ADD VISITOR");
   	itemMap.add(item);
    }
    public void update(PersistentItem item)throws SQLException,UpdataFailedException,FindFailedException{
    	itemMap.update(item);
    }
    public void remove(String id)throws SQLException{
    	itemMap.remove(id);
    }
    public PersistentItem FindItem(String id)throws SQLException,FindFailedException{
       PersistentItem it = itemMap.getItemById(id);
       return it;
    }
     public void FindId(String id)throws SQLException,FindFailedException{
      if(itemMap.findItem(id))
         throw new AddFailedException("id exist, please insert the other id");
   }
}