how to to retrive data in jsp from MySQL using Liferay?

Question

I want to retrieve data from and insert data in mysql.

I m providing 3 file one java file and two jsp file edit.jsp and view.jsp to edit and view the data respectively.

I have created table using ServiceBuilder, I have put my portal-ext.properties in classes folder, tell me is this the perfect method? m I doing it the correct way?

I want to first insert data and then I want to retrieve data from database.

I m inserting data through the following jsp file - edit.jsp

<%@ taglib uri="http://java.sun.com/portlet" prefix="portlet" %>











    
        
            Subject:
            
        
        
            
            Write Your Testimonial
            
            
            
        
        
            Name:
            
        
        
            Email:
            
        
        
            Company:
            
        
        
            Designation:

I have written my insertion logic in following java file - Testimonial1:

package com.liferay.portlet;

import java.io.IOException;
import javax.portlet.ActionRequest;
import javax.portlet.ActionResponse;
import javax.portlet.GenericPortlet;
import javax.portlet.PortletException;
import javax.portlet.PortletMode;
import javax.portlet.PortletPreferences;
import javax.portlet.PortletRequestDispatcher;
import javax.portlet.PortletURL;
import javax.portlet.RenderRequest;
import javax.portlet.RenderResponse;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.liferay.counter.service.CounterLocalServiceUtil;
import com.liferay.portal.kernel.exception.SystemException;
import com.liferay.portlet.model.testimonial;
import com.liferay.portlet.service.testimonialLocalServiceUtil;

public class Testimonial1 extends GenericPortlet {

    public void init()throws PortletException 
    {
        editJSP = getInitParameter("edit-jsp");
        viewJSP = getInitParameter("view-jsp");
    }

    public void doEdit(RenderRequest renderRequest,RenderResponse renderResponse)
            throws  IOException, PortletException 
    {
        renderResponse.setContentType("text/html");
        PortletURL addNameURL = renderResponse.createActionURL();
        addNameURL.setParameter("addName", "addName");
        renderRequest.setAttribute("addNameURL", addNameURL.toString());
        include(editJSP, renderRequest, renderResponse);
    }

    public void doView(RenderRequest renderRequest,RenderResponse renderResponse)throws 
    IOException, PortletException
    {
        PortletPreferences prefs = renderRequest.getPreferences();
        String username = (String) prefs.getValue("name", "");
        String area=(String)prefs.getValue("area", "testimonial");
        String email=(String)prefs.getValue("email", "");
        String subject=(String)prefs.getValue("subject", "");
        String company=(String)prefs.getValue("company", "");
        String designation=(String)prefs.getValue("designation", "");

    if (username.equalsIgnoreCase ("")) 
    {
        username = "";
    }
        renderRequest.setAttribute("userName", username);
        renderRequest.setAttribute("area",area);
        renderRequest.setAttribute("email",email);
        renderRequest.setAttribute("subject",subject);
        renderRequest.setAttribute("designation",designation);
        renderRequest.setAttribute("company",company);

        include(viewJSP, renderRequest, renderResponse);
    }

    public void processAction(ActionRequest actionRequest, ActionResponse actionResponse)
            throws IOException, PortletException 
    {
        String addName = actionRequest.getParameter("addName");

        if (addName != null)
        {
            PortletPreferences prefs = actionRequest.getPreferences();
            prefs.setValue("name", actionRequest.getParameter("username"));
            prefs.setValue("area",actionRequest.getParameter("area"));
            prefs.setValue("email",actionRequest.getParameter("email"));
            prefs.setValue("subject",actionRequest.getParameter("subject"));
            prefs.setValue("designation",actionRequest.getParameter("designation"));
            prefs.setValue("company",actionRequest.getParameter("company"));

            prefs.store();

            testimonial testimonial = null;

            try {
                testimonialLocalServiceUtil.createtestimonial(CounterLocalServiceUtil.increment());
                testimonial.setSubject(actionRequest.getParameter("subject"));
                testimonial.setArea(actionRequest.getParameter("area"));
                testimonial.setUsername(actionRequest.getParameter("username"));
                testimonial.setEmail(actionRequest.getParameter("email"));
                testimonial.setCompany(actionRequest.getParameter("company"));
                testimonial.setDesignation(actionRequest.getParameter("designation"));
                testimonialLocalServiceUtil.addtestimonial(testimonial);
            } catch (SystemException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            actionResponse.setPortletMode(PortletMode.VIEW);    
        }
    }

    protected void include(String path, RenderRequest renderRequest, RenderResponse renderResponse)
            throws IOException, PortletException 
    {
        PortletRequestDispatcher portletRequestDispatcher = getPortletContext().getRequestDispatcher(path);

        if (portletRequestDispatcher == null) 
        {
            _log.error(path + " is not a valid include");
        }
        else
        {
            portletRequestDispatcher.include(renderRequest, renderResponse);
        }
    }
    protected String editJSP;
    protected String viewJSP;
    private static Log _log = LogFactory.getLog(Testimonial1.class);
}

I have written my view logic in following file - view.jsp and I want to retrive data from database in following file:

<%@ taglib uri="http://java.sun.com/portlet" prefix="portlet" %>









This is the Testimonial portlet......... how are u all ..........

Subject is ....<%=subject %>
Testimonial is .....<%=area %>
Hello <%= userName %>!
your Email ......<%=email %>
your company .....<%=company %>
You are .......<%=designation %>

My service.xml file





    ubuntu
    perception

My portal-ext.properties file:

#
# MySQL 
#

jdbc.default.driverClassName=com.mysql.jdbc.Driver 
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEn
coding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=ubuntu123

schema.run.enabled=true
schema.run.minimal=true

I have put all my files, now please tell me what I have to do for data insertion and retrieval.

Pls tell am I right in insertion code? and how to retrive data from database?

rkosegi · Accepted Answer

You may take a look at liferay's service builder.

If your data is not in same database as liferay, you can still use service builder as well

http://liferaytrends.blogspot.com/2012/05/blog-post.html

how to to retrive data in jsp from MySQL using Liferay?

Answers (2)

Related Questions