public CustomerForm getCustomer(String userName) {
    	ConnectionUtility chd = new ConnectionUtility();
  		Connection con = null;
  		PreparedStatement ps = null;
  		ResultSet rs=null;
  		CustomerForm customer = new CustomerForm();
  		try {	    	
	         con = chd.create();	
	    	 ps =con.prepareStatement("select * from customer where username='"+userName+"' ");
	    	 rs=ps.executeQuery();	
	    	 while(rs.next()) {
                  customer.setFirstName(rs.getString(1));
                  customer.setLastName(rs.getString(2));
                  customer.setUserName(rs.getString(3));
                  customer.setStreet(rs.getString(4));
                  customer.setCity(rs.getString(5));
                  customer.setPinCode(Integer.valueOf(rs.getInt(6)));
                  customer.setMobileNum(rs.getLong(7));
	    	 }
	    } catch(Exception e) {
			 e.printStackTrace();
		} finally {
			 try {
				con.close();   
			 } catch(Exception e) {
				e.printStackTrace();
			 }
		}
		return customer;        
	}