private  String firstname;
	   
  public  String getFirstName(){
    return  firstname;
	   }
	   
  public   void  setFirstName(String value){
   firstname = value;
          }

 package  com.fidel;

 public   class  EmpBean  extends  FacesBean {

	     private   final  String DRIVER_CLASS;
	     private   final  String DB_HOST;
	     private   final  String DB_USER;
	     private   final  String DB_PASSWORD; 
	    

	    private  HtmlForm frmEmp =  new  HtmlForm();
	   
	    public  HtmlForm getFrmEmp(){
		    return  frmEmp;
	   }
	    
	    public   void  setFrmEmp(HtmlForm value){
		   frmEmp = value;
	   }
	    
	    

	    private  String firstname;
	   
	    public  String getFirstname(){
		    return  firstname;
	   }
	   
	    public   void  setFirstname(String value){
		   firstname = value;
	   }
	   
        private  String lastname;
	   
	    public  String getLastname(){
		    return  lastname;
	   }
	   
	    public   void  setLastname(String value){
		   lastname = value;
	   }
	   
	    private  String firstnameError;
	   
	    public  String getFirstnameError(){
		    return  firstnameError;
	   }
	   
	    public   void  setFirstnameError(String value){
		   firstnameError = value;
	   }
	   
	   
	    private  JdbcRowSetXImpl rowset;
	    public  JdbcRowSetXImpl getRowSet() {
		    return  rowset;
		     }    
	   
	    public   void  setRowSet(JdbcRowSetXImpl value){
		   rowset = value;
		    } 
	   
	   
	    public  EmpBean(){
		   // download db connect properties
	   DRIVER_CLASS =  this .getExternalContext().getInitParameter("driver_class");
	   DB_HOST =  this .getExternalContext().getInitParameter("db_host");
       DB_USER =  this .getExternalContext().getInitParameter("db_user");
       DB_PASSWORD =  this .getExternalContext().getInitParameter("db_password");
	   
           //  заполняем набор данных 
		// rowset = getDataSource();
		      
	   }
	   
	 	   
	  // button click handler
	   
	    public  String onClick(){
		    if (!validate())
			    return  "";
		   
		    boolean  result = saveToDatabase();
		   
		   // return value for navigation rules
		    if (result)
			      return  "success";
		    else 
			       return  "failure";
	   }
	   
	     private   boolean  validate(){
	    	// validating input values
	    	
	    boolean  result = true;
	    if  (firstname.equals("")){
		  firstnameError = "*";
		  result = false;
		  
	   }
	     // validating input last_name
	      if  (lastname.equals("")){
	    	  firstnameError = "*";
	    	  result = false;
	     }
	         return  false;
	    }
	   
	    // saving value into DB
	     private   boolean  saveToDatabase()
	    {
	         try 
	        {        
	             Class .forName(DRIVER_CLASS).newInstance();
	            Connection con = DriverManager.getConnection(DB_HOST, DB_USER, DB_PASSWORD);
	            Statement statement = con.createStatement();           
	            statement.execute("INSERT INTO emp (firstname, lastname) VALUES ('"+firstname+"', '"+lastname+"');");
	        }
	         catch (Exception e)
	        {
	             return  false;
	        }
	        
	            firstname = "";
	            lastname = "";
	           	        
	            return  true;
	      }
	  	
	    }