Skip to main content

Insert Data in DB using ServerResource URL

Step 1. For Creating Liferay MVC and Insert Data in DB using Hibernate Read This

Step 2. Modify createOffer.jsp Page

Know we will send data in controller using Resource URL <portlet:resourceURL var="addNewOfferURL"/> not by Action URL

Copy this code

<%@ include file="/html/init.jsp" %>

<portlet:actionURL var="cancelCreateOfferURL" name="cancelCreateOffer"/>


<portlet:resourceURL var="addNewOfferURL"/>


<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/jquery.validate.min.js" charset="utf-8"></script>

<script>
    var gResourceURL = "<%= addNewOfferURL%>";
   
    function makeAJAXCall(url, ajaxParms, async) {
        console.log("home.jsp makeAJAXCall called with url=" + url + " and ajaxParms=" + JSON.stringify(ajaxParms) + " and async=" + async);

        if (undefined == async || "undefined"  == typeof async || null == async ) {
            async = true;
        }

        var currentAjaxRequest = $.ajax({
            url:url,
            dataType: "json",
            data: ajaxParms,
            type : "post",
            async : async,
            success : function(data) {
                                console.log("addNewOfferURL makeAJAXCall: success received data=" + JSON.stringify(data));
                              
                                },

            error : function(jqXHR, textStatus, errorThrown) {
                                console.log("addNewOfferURL makeAJAXCall: ERROR event with textStatus=" + textStatus + ", errorThrown=" + errorThrown + " and jqXHR="+JSON.stringify(jqXHR));
                               
                              
                    }
        });
    }
    function printJSON(div, jsonResult) {
        console.log("printJSON called with div=" + div + " and jsonResult=" + JSON.stringify(jsonResult));
    }
   
    function submitBtn(){
       //makeAJAXCall(gResourceURL, "methodName=addNewOfferURL&"+$('#addNewForm').serialize());
    }
   
    //makeAJAXCall(gResourceURL, {methodName:'findOffer', status: 'active', keyword:'mountaindew'});
</script>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.15/angular.min.js"></script>

<!-- CreateOffer Form start here -->
<form method="post" id="myForm" name="myForm" action="${addNewOfferURL}">
    <fieldset>
                <div class="fieldgroup">
            <label for="offerTitle"><liferay-ui:message key="offerTitle"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="offerTitle" id="offerTitle" />
        </div>

                <div class="fieldgroup">
            <label for="offerCode"><liferay-ui:message key="offerCode"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="offerCode" id="offerCode" />
        </div>
                <div class="fieldgroup">
            <label for="vendor"><liferay-ui:message key="vendor"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="vendor" id="vendor" />
        </div>
                <div class="fieldgroup">
            <label for="areaofDisplay"><liferay-ui:message key="areaofDisplay"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="areaofDisplay" id="areaofDisplay" />
        </div>
                <div class="fieldgroup">
            <label for="desc"><liferay-ui:message key="desc"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="desc" id="desc" />
        </div>
                <div class="fieldgroup">
            <label for="terms"><liferay-ui:message key="terms"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="terms" id="terms" />
        </div>
                <div class="fieldgroup">
            <label for="budget"><liferay-ui:message key="budget"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="budget" id="budget" />
        </div>
                <div class="fieldgroup">
            <label for="budgetType"><liferay-ui:message key="budgetType"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="budgetType" id="budgetType" />
        </div>
                <div class="fieldgroup">
            <label for="startDate"><liferay-ui:message key="startDate"/><em></em></label>
            <input tabindex="2" size="50" type="text" name="startDate" id="startDate" />
        </div>
                <div class="fieldgroup">
            <label for="endDate"><liferay-ui:message key="endDate"/><em></em></label>
            <input tabindex="2" size="50" type="text" name="endDate" id="endDate" />
        </div>
                <div class="fieldgroup">
            <label for="discount"><liferay-ui:message key="discount"/><em></em></label>
            <input tabindex="2" size="50" type="text" name="discount" id="discount" />
        </div>
                <div class="fieldgroup">
            <label for="discountType"><liferay-ui:message key="discountType"/><em></em></label>
            <input tabindex="2" size="50" type="text" name="discountType" id="discountType" />
        </div>
                </div>
                <div class="fieldgroup">
            <label for="limit"><liferay-ui:message key="limit"/><em></em></label>
            <input tabindex="2" size="50" type="text" name="limit" id="limit" />
        </div>
                </div>
                <div class="fieldgroup">
            <label for="upc"><liferay-ui:message key="upc"/><em>*</em></label>
            <input tabindex="2" size="50" type="text" name="upc" id="upc" />
        </div>
       
       
    </fieldset>
    <div class="buttonrow">
        <input tabindex="10" type="button" class="btn" value="Save" onclick="submitForm();" />
        <input tabindex="11" type="button" class="btn" value="Cancel" onclick="cancelAddNewCompany()"/>
    </div>
    <textarea id="offerResponseJSON" name="offerResponseJSON" style="visibility:hidden;"></textarea>
</form>
<!-- Offer Portlet Form end here -->

<script>

function submitForm() {
    //$("#name_error_message").remove();
    var validator = $("#myForm").validate({
        rules : {                           
            offerCode : {required : true, maxlength : 25 },
            offerTitle : {required : true, maxlength : 25 },
            upc : {required : true, maxlength : 80 },
            vendor : {maxlength : 25},
            areaofDisplay : {maxlength : 25},
            desc : {maxlength : 25},
            terms : {maxlength : 25},
            budget : {maxlength : 25},
            budgetType : {maxlength : 25}           
        },           
        messages : {
            offerCode : { required : "<liferay-ui:message key='offerCode-required'/>",
                     maxlength : "<liferay-ui:message key='offerCode-maxlength'/>" },
            offerTitle : { required : "<liferay-ui:message key='offerTitle-required'/>",
                         maxlength : "<liferay-ui:message key='offerTitle-maxlength'/>" },
            upc : { required : "<liferay-ui:message key='upc-required'/>",
                             maxlength : "<liferay-ui:message key='upc-maxlength'/>" },
                           
            vendor : {maxlength :"<liferay-ui:message key='vendor-maxlength'/>"},
            areaofDisplay : {maxlength :"<liferay-ui:message key='areaofDisplay-maxlength'/>"},
            desc : {maxlength :"<liferay-ui:message key='desc-maxlength'/>"},
            terms : {maxlength :"<liferay-ui:message key='terms-maxlength'/>"},
            budget : {maxlength :"<liferay-ui:message key='budget-maxlength'/>"},
            budgetType : {maxlength :"<liferay-ui:message key='budgetType-maxlength'/>"},
           
           
           
        }
    });

    if(validator.form()) {
        console.log("Validate");
        var offer = {
                offerCode : $("#offerCode").val(),
                offerTitle : $("#offerTitle").val(),
                vendor : $("#vendor").val(),
                areaofDisplay : $("#areaofDisplay").val(),
                desc : $("#desc").val(),
                terms : $("#terms").val(),
                budget : $("#budget").val(),
                budgetType : $("#budgetType").val(),
                startDate : $("#startDate").val(),
                endDate : $("#endDate").val(),
                discount : $("#discount").val(),
                discountType : $("#discountType").val(),
                limit : $("#limit").val(),
                upc : $("#upc").val()
            } ;
            $("#offerResponseJSON").val(JSON.stringify(offer));
           
            makeAJAXCall(gResourceURL, {methodName:"addNewOfferURL",offerResponseJSON:JSON.stringify(offer)});
           
            //$('form#myForm').submit();
        }
    }

function cancelAddNewCompany() {
    window.location.replace("<%= cancelCreateOfferURL%>");
    }

</script>




Step 3-: Update Code for Controller

Now once user click on Create Offer on view.jsp Controller process action gets the input (method name)  and it passes same to doView where we have wrote logic for taking input and forwarding it to respective jsp(createOffer.jsp)

In serveResource we get ResourceURL "addNewOfferURL"
In ServeResource add these line

    @Override
    public void serveResource(ResourceRequest resourceRequest, ResourceResponse resourceResponse) throws IOException, PortletException{
       
         log.info("serveResource called with ResourceRequest="+resourceRequest );
       
         String methodName = resourceRequest.getParameter("methodName");
       
         log.info("serveResource for OfferPortlet called with methodName="+ methodName);
            if (null == methodName) {
                String msg = "No methodName parameter passed to OffermanagementPortlet.serveResource!";
                NullPointerException e = new NullPointerException(msg);
                log.error(msg,e);
                throw e;
            }
            Gson gson = new Gson();
            HttpServletResponse httpServletResponse = PortalUtil.getHttpServletResponse(resourceResponse);
            PrintWriter writer = httpServletResponse.getWriter();
            resourceResponse.setContentType("text/html");
           
            if(methodName.equalsIgnoreCase("addNewOfferURL")){
                log.info("serveResource.addNewOfferURL called");               
               
             try {
                int offerId = (int)CounterLocalServiceUtil.increment();
                String responseData = resourceRequest.getParameter("offerResponseJSON");
               
                Gson gson2 = new Gson();
                JsonReader reader = new JsonReader(new StringReader(responseData));
                Offer offer = gson2.fromJson(reader, Offer.class);
                offer.setOfferId(offerId);
                reader.setLenient(true);
                log.info("------Entered in Save New offer Offer DAO Called ----");
                OfferDAO offerDAO = OfferFactory.create();
               
                int returnOfferId = offerDAO.addOffer(offer);
               
               
            } catch (SystemException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }   
               
                String status = resourceRequest.getParameter("status");
                ArrayList<Offer> offersJSON = getListOffer(status);
                writer.write(gson.toJson(offersJSON));
                log.info("serveResource. called"+gson.toJson(offersJSON));

            }
           
            super.serveResource(resourceRequest, resourceResponse);
    }


Rest Code will be same as my previous one http://liferayvishal.blogspot.in/2015/06/insert-datawithout-using-service.html

Comments

Post a Comment

Popular posts from this blog

Liferay 7.1 Topics Coming Soon stay connected

1. Liferay 7.1 Service Builder 2. Rest Service and Liferay 3. Consuming SOAP service with Liferay 7.1 4. Creating Theme With Liferay 7.1 Using Liferay IDE Using NPM 5. Create Angular NPM Module 6. Web Content Management 7. OSGI Basic 8. Liferay 7.1 with more than 1 DB 9. A sample project 10. Liferay Dev Ops
Post a Comment
Read more

How the portal page is loaded with respective portlets

How the portal page is loaded with respective portlets When a user requests a page with a URL, 1.    The browser sends the request to the Application Server (AS). 2.    Liferay gets the page name from the URL. 3.    It goes to the layout database table and finds the related        theme and page layout. 4.    Based on the page layout, Liferay finds the portlets added        into each area of the page layout. 5.    Liferay runs the portlet and adds the output in the        portlet.vm template. 6.    Liferay interprets the portlet.vm template and adds the output        in the page layout. 7.    Then Liferay interprets the page layout and adds the output in        the portal_normal.vm template. 8.    After that Liferay interprets the portal...
Post a Comment
Read more

Service Builder 1

Service Builder uses the spring and hibernate integration Data Access Objects implementation mechanism in short we can call it as DAO implementation. Here Service Builder Tool will use the spring and hibernate technology to develop service layer to Plugin portlet. Service Layer's -: Persistence/DAO classes: Persistence or DAO classes will provide the direct data base interaction like insert, delete and update the data in table. such kind of logic will be present in this classes. Conceptually for each table we have one persistence class that will interact with table. Here actual data base interaction code will be present. As we know that to interact with database we need hibernate/jdbc in java. Persistence/DAO classes we will get the session factory object and from that we will open session, with that session object we will do all database interactions, once we finish all tasks we will close the session. Model/POJO -: The model or POJO classes wi...
Post a Comment
Read more