public String getCustomerName(String userName) {
    	ConnectionUtility chd = new ConnectionUtility();
  		Connection con = null;
  		PreparedStatement ps = null;
  		ResultSet rs=null;
  		String customerName = null;
  		try {	    	
	         con = chd.create();	
	    	 ps =con.prepareStatement("select firstname,lastname from customer where username='"+userName+"' ");
	    	 rs=ps.executeQuery();	
	    	 while(rs.next()) {
                    customerName = rs.getString(1).concat(rs.getString(2));
	    	 }
	    } catch(Exception e) {
			 e.printStackTrace();
		} finally {
			 try {
				con.close();   
			 } catch(Exception e) {
				e.printStackTrace();
			 }
		}
		return customerName;	          
	}