[liferay] My sample project

I am having trouble with my project. I want to create a simple input to output portlet that connects to my database. It will supposedly print out a list of records, but it just says "Request Processed Successfully". What am I doing wrong? I am a complete newbie.

view.jsp

<%@ include file="./init.jsp"%>
<portlet:defineObjects />
<!DOCTYPE html>
<html>
	<head>
		<title>A Sample Portlet</title>
		<script type="text/javascript">
			var isNN = (navigator.appName.indexOf("Netscape")!=-1);
			function autoTab(input,len, e) {
				var keyCode = (isNN) ? e.which : e.keyCode; 
		    	var filter = (isNN) ? [0,8,9] : [0,8,9,16,17,18,37,38,39,40,46];
		    	if(input.value.length >= len && !containsElement(filter,keyCode)) {
	    			input.value = input.value.slice(0, len);
		    		input.form[(getIndex(input)+1) % input.form.length].focus();
		    	}
				   
	    		function containsElement(arr, ele) {
	    			var found = false, index = 0;
    				while(!found && index < arr.length)
    				if(arr[index] == ele)
		    			found = true;
    				else
		    			index++;
	    			return found;
		    	}
				function getIndex(input) {
		    		var index = -1, i = 0, found = false;
	    			while (i < input.form.length && index == -1)
	    			if (input.form[i] == input)index = i;
	    			else i++;
	    			return index;
		    }
		    return true;
		}
		</script>
	</head>
	<body>
		<form name='<portlet:namespace />porma' action='<liferay-portlet:actionURL name="query"/>' method="post">
			Account Number: <input onKeyUp="return autoTab(this, 2, event);" autofocus="autofocus" required="required" type="text" name="<portlet:namespace />accno1" size="3" maxlength="2"/> - <input required="required" type="text" name="<portlet:namespace />accno2" size="7" maxlength="5"/><br/>
			<input type="submit" name='<portlet:namespace />inkwayr' value="Inquire"/> 
		</form>
	</body>
</html>

Samportlet.java

package com.sample;

import javax.portlet.ActionRequest;
import javax.portlet.ActionResponse;
import javax.portlet.ProcessAction;

import java.sql.*;
import javax.sql.*;
import java.io.IOException;

import com.liferay.util.bridges.mvc.MVCPortlet;

/**
 * Portlet implementation class Samportlet
 */
public class Samportlet extends MVCPortlet {
	@ProcessAction (name="query")
	public void query(ActionRequest paki, ActionResponse gawa) {
		try {
			String driver = "org.postgresql.Driver";
			String url = "jdbc:postgresql://192.168.1.4:5432/mydb";
			String username = "admin";
			String password = "password";
			String myDataField1 = null;
			String myDataField2 = null;
			String myDataField3 = null;
			String acct1 = paki.getParameter("accno1");
			String acct2 = paki.getParameter("accno2");
			String acctno = acct1+"-"+acct2;
			String myQuery = "SELECT acctno="+acctno+" FROM mmaster";
			Connection myConnection = null;
			PreparedStatement myPreparedStatement = null;
			ResultSet myResultSet = null;
			Class.forName(driver);
			myConnection = DriverManager.getConnection(url,username,password);
			myPreparedStatement = myConnection.prepareStatement(myQuery);
			myResultSet = myPreparedStatement.executeQuery();
			if(myResultSet.next())
			myDataField1 = myResultSet.getString("acctno");
			myDataField2 = myResultSet.getString("fname");
			myDataField3 = myResultSet.getString("lname");
			System.out.println(myDataField1+" "+myDataField2+" "+myDataField3);
			System.out.print("TEST");
		}
		catch(ClassNotFoundException e){e.printStackTrace();}
		catch (SQLException ex) {
			System.out.print("SQLException: "+ex.getMessage());
			System.out.print("SQLState: " + ex.getSQLState());
			System.out.print("VendorError: " + ex.getErrorCode());
		}
	}
}

I thank for any response,
Bite

Does it even hit the database. Did you try to debug the code flow ?

Ankur Srivastav wrote:Does it even hit the database. Did you try to debug the code flow ?

It does. I changed the SELECT statement because it erroneous.

It still doesn't display? What am I doing wrong?

One simple observation by looking at the code, just want to make sure you have the if block

if(myResultSet.next())
myDataField1 = myResultSet.getString("acctno");
myDataField2 = myResultSet.getString("fname");
myDataField3 = myResultSet.getString("lname");
System.out.println(myDataField1+" "+myDataField2+" "+myDataField3);
System.out.print("TEST");

I dont see the braces in there ..

Ankur Srivastav wrote:One simple observation by looking at the code, just want to make sure you have the if block

if(myResultSet.next())
myDataField1 = myResultSet.getString("acctno");
myDataField2 = myResultSet.getString("fname");
myDataField3 = myResultSet.getString("lname");
System.out.println(myDataField1+" "+myDataField2+" "+myDataField3);
System.out.print("TEST");

I dont see the braces in there ..

Ah yes! I remedied that:

But the problem persists. I saw some code that does not put "System" before the "out", but I always get an error if I don't put "System", even if I imported java.io.*.

Are you still facing issue ? Can you put Exception trace ?

Ankur Srivastav wrote:Are you still facing issue ? Can you put Exception trace ?

I don't know if I can still find those Exception traces, as I do not know how to find it in the logs, but I finally found out how to output results in my portlet! Thanks for helping!
This is my sample portlet...
-------------------------------------------------------------------
view.jsp

<%@ include file="./init.jsp" %>
<portlet:defineObjects />
<!DOCTYPE html>
<html>
	<head>
		<title>A Sample Portlet</title>
		<script type="text/javascript">
			var isNN = (navigator.appName.indexOf("Netscape")!=-1);
			function autoTab(input,len, e) {
				var keyCode = (isNN) ? e.which : e.keyCode; 
		    	var filter = (isNN) ? [0,8,9] : [0,8,9,16,17,18,37,38,39,40,46];
		    	if(input.value.length >= len && !containsElement(filter,keyCode)) {
	    			input.value = input.value.slice(0, len);
		    		input.form[(getIndex(input)+1) % input.form.length].focus();
		    	}
				   
	    		function containsElement(arr, ele) {
	    			var found = false, index = 0;
    				while(!found && index < arr.length)
    				if(arr[index] == ele)
		    			found = true;
    				else
		    			index++;
	    			return found;
		    	}
				function getIndex(input) {
		    		var index = -1, i = 0, found = false;
	    			while (i < input.form.length && index == -1)
	    			if (input.form[i] == input)index = i;
	    			else i++;
	    			return index;
		    }
		    return true;
		}
		</script>
	</head>
	<body>
		<form name='<portlet:namespace />porma' action='<liferay-portlet:actionURL name="query"/>' method="post">
			Account Number: <input onKeyUp="return autoTab(this, 2, event);" autofocus="autofocus" required="required" type="text" name="<portlet:namespace />accno1" size="3" maxlength="2"/> - <input required="required" type="text" name="<portlet:namespace />accno2" size="7" maxlength="5"/><br/>
			<input type="submit" name='<portlet:namespace />inkwayr' value="Inquire"/> 
		</form>
		<br/>
		<%  String fldacno = (String) renderRequest.getParameter("fldacno"); %>
		<%  String fldfnam = (String) renderRequest.getParameter("fldfnam"); %>
		<%  String fldbday = (String) renderRequest.getParameter("fldbday"); %>
		<%  String fldresadd = (String) renderRequest.getParameter("fldresadd"); %>
		<%  String datacno = (String) renderRequest.getParameter("datacno"); %>
		<%  String datfnam = (String) renderRequest.getParameter("datfnam"); %>
		<%  String datlnam = (String) renderRequest.getParameter("datlnam"); %>
		<%  String datbday = (String) renderRequest.getParameter("datbday"); %>
		<%  String datresadd = (String) renderRequest.getParameter("datresadd"); %>
		<% if(fldacno!=null){
			out.print(fldacno);
		} else {}
		%>
		<% if(datacno!=null){
			out.print(datacno);
		} else {}
		%>
		<% if(fldfnam!=null){
			out.print(fldfnam);
		} else {}
		%>
		<% if(datfnam!=null){
			out.print(datfnam);
		} else {}
		%>
		<% if(datlnam!=null){
			out.print(datlnam);
		} else {}
		%>
		<% if(fldbday!=null){
			out.print(fldbday);
		} else {}
		%>
		<% if(datbday!=null){
			out.print(datbday);
		} else {}
		%>
		<% if(fldresadd!=null){
			out.print(fldresadd);
		} else {}
		%>
		<% if(datresadd!=null){
			out.print(datresadd);
		} else {}
		%>
	</body>
</html>

--------------------------------------------------------------------
init.jsp

------------------------------------------------------------------
Samportlet.java

package com.sample;

import javax.portlet.ActionRequest;
import javax.portlet.ActionResponse;
import javax.portlet.ProcessAction;

import java.sql.*;
import com.liferay.util.bridges.mvc.MVCPortlet;

/**
 * Portlet implementation class Samportlet
 */
public class Samportlet extends MVCPortlet {
	@ProcessAction (name="query")
	public void query(ActionRequest paki, ActionResponse gawa) {
		try {
			String driver = "org.postgresql.Driver";
			String url = "jdbc:postgresql://192.168.1.4:5432/mytable";
			String username = "myusername";
			String password = "mypassword";
			String myDataField1 = null;
			String myDataField2 = null;
			String myDataField3 = null;
			String myDataField4 = null;
			String myDataField5 = null;
			String acct1 = paki.getParameter("accno1");
			String acct2 = paki.getParameter("accno2");
			String acctno = acct1+"-"+acct2;
			String myQuery = "SELECT acctno,fname,lname,res_adr,bdate FROM mmaster WHERE acctno='"+acctno+"'";
			Connection myConnection = null;
			PreparedStatement myPreparedStatement = null;
			ResultSet myResultSet = null;
			Class.forName(driver);
			myConnection = DriverManager.getConnection(url,username,password);
			myPreparedStatement = myConnection.prepareStatement(myQuery);
			myResultSet = myPreparedStatement.executeQuery();
			if(myResultSet.next()){
			myDataField1 = myResultSet.getString("acctno");
			myDataField2 = myResultSet.getString("fname");
			myDataField3 = myResultSet.getString("lname");
			myDataField4 = myResultSet.getString("bdate");
			myDataField5 = myResultSet.getString("res_adr");
			String fieldacno = "<b>Account Number:</b> ";
			String fieldfnam = "<b>Full Name:</b> ";
			String fieldbday = "<b>Date of Birth:</b> ";
			String fieldresadd = "<b>Residential Address:</b> ";
			String datacno = myDataField1+"<br />";
			String datfnam = myDataField2+" ";
			String datlnam = myDataField3+"<br />";
			String datbday = myDataField4+"<br />";
			String datresadd = myDataField5+"<br />";
			gawa.setRenderParameter("fldacno", fieldacno);
			gawa.setRenderParameter("fldfnam", fieldfnam);
			gawa.setRenderParameter("fldbday", fieldbday);
			gawa.setRenderParameter("fldresadd", fieldresadd);
			gawa.setRenderParameter("datacno", datacno);
			gawa.setRenderParameter("datfnam", datfnam);
			gawa.setRenderParameter("datlnam", datlnam);
			gawa.setRenderParameter("datbday", datbday);
			gawa.setRenderParameter("datresadd", datresadd);
			}
		}
		catch(ClassNotFoundException e){e.printStackTrace();}
		catch(SQLException ex) {
			System.out.print("SQLException: "+ex.getMessage());
			System.out.print("SQLState: " + ex.getSQLState());
			System.out.print("VendorError: " + ex.getErrorCode());
		}
	}
}

I know this may be crude looking to most of you, but it somehow worked for me.