public String createOrder(String userName,OrderBean orderItem) throws SQLException, ClassNotFoundException {
	    	ConnectionUtility chd = new ConnectionUtility();
			Connection con = null;
			PreparedStatement ps = null;
			PreparedStatement ps1 = null;
			Statement st = null;
			ResultSet rs=null;
			String orderNo = null;
			try  {
		        con = chd.create();	
		        st = con.createStatement();
		        rs = st.executeQuery("select orderno_seq.nextval from dual");
		        rs.next();
		        int i = rs.getInt(1);
		        orderNo = "Order"+i;
		        Double totalAmount = orderItem.getTotalAmount();
		    	ps =con.prepareStatement("insert into orderdetails values('"+orderNo+"',sysdate,'"+userName+"',"+totalAmount+",'In Process') ");
		    	int result = ps.executeUpdate();	
		    	if(result > 0) {
                  ps1 = con.prepareStatement("Delete from Cart");
                  int result1 =  ps1.executeUpdate();
                  System.out.println(result1);
                }
			} catch(Exception e) {
				e.printStackTrace();
			}
			finally {
				 try  {
					 con.commit();  
					 con.close();   
				 } catch(Exception e) {
					 e.printStackTrace();
				 }
			}
			return orderNo;						
	    }