Struts Listing Problem

I have it listed now, but I still receive the same result:

Here is the java class (ListHqsunitAction.java) the request.setAttribute is set. What have I missed? I'm new to this and right smack in the middle of it.

ListHqsunitAction.java

package scenario.action;

import scenario.dao.HqsunitDAO;

//import scenario.dao.DAOException;

import scenario.dao.DAOFactory;

import scenario.form.HqsunitForm;

import scenario.to.HqsunitTO;

import java.io.IOException;

import java.sql.SQLException;

import java.util.Collection;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.ServletException;

import org.apache.struts.action.Action;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionForward;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.action.ActionMessage;

import org.apache.struts.action.ActionMessages;

public class ListHqsunitAction extends Action {

public ActionForward execute(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response) {

ActionMessages actionMessages = new ActionMessages();

HqsunitTO hqsunit = null;

//String disentity = request.getParameter("disentity");

HqsunitDAO hqsunitDAO = DAOFactory.getInstance().getHqsunitDAO();

try {

int disentity = Integer.parseInt(request.getRemoteUser());

//WLM 20060308 changed 1 line below : uncommented 1 line

Collection collection = hqsunitDAO.findAll(disentity);

request.setAttribute("listHqsunitdata", collection);

return (mapping.findForward("success"));

}

catch (Exception ex) {

actionMessages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("failed.get"));

saveMessages(request, actionMessages);

return (mapping.findForward("failed"));

}

}

}

Thanks a million for your help.

tclyndella at 2007-7-13 13:47:41 >

You have me jumping around grabbing bits and pieces of the application, and that's good. I'll know what I need to present the next time I'm stuck on stupid. I don't believe that hqsunitDAO.findAll(DisEntity) = null. However, I have been wrong, so here are the other pieces of code that I fail to present earlier:

In the HqsunitDAO.java:

package scenario.dao;

import scenario.to.HqsunitTO;

import java.util.ArrayList;

import java.util.Collection;

public interface HqsunitDAO {

public void createHqsunit(HqsunitTO hqsunit) throws DAOException;

public void updateHqsunit(HqsunitTO hqsunit) throws DAOException;

public HqsunitTO getHqsunit(int disentity) throws DAOException;

public void deleteHqsunit(int disentity) throws DAOException;

public Collection findAll(int disentity) throws DAOException;

}

In the HqsunitPostgresImpl.java:

package scenario.dao;

import java.sql.SQLException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.Collection;

import scenario.dao.DAOException;

import scenario.dao.DBUtil;

import scenario.to.HqsunitTO;

public class HqsunitDAOPostgreImpl extends DAOBase

implements HqsunitDAO {

/* code omitted to shorten length */

private static final String LIST_HQSUNIT_SQL =

"SELECT * from rtmuser.s_hq_unit WHERE disentity = ?";

public void createHqsunit(HqsunitTO hqsunit) throws DAOException {

Connection connection = null;

PreparedStatement pStatement = null;

try {

connection = getConnection();

//Prepare a statement to insert a record

pStatement = connection.prepareStatement(CREATE_HQSUNIT_SQL);

pStatement.setInt(1, hqsunit.getDisentity());

pStatement.setString(2, hqsunit.getUic());

pStatement.setString(3, hqsunit.getName());

pStatement.setInt(4, hqsunit.getRadio());

pStatement.setString(5, hqsunit.getAlias());

pStatement.setString(6, hqsunit.getTfAddress());

pStatement.setString(7, hqsunit.getDevice());

pStatement.setString(8, hqsunit.getHqsObserver());

pStatement.setInt(9, hqsunit.getGridzone());

pStatement.setInt(10, hqsunit.getMmEast());

pStatement.setInt(11, hqsunit.getMmNorth());

pStatement.setString(12, hqsunit.getIType());

pStatement.setString(13, hqsunit.getCommo());

pStatement.setString(14, hqsunit.getIpAddress());

pStatement.setString(15, hqsunit.getUrn());

pStatement.executeUpdate();

pStatement.close();

}

catch (SQLException ex) {

throw new DAOException();

}

finally {

try {

connection.close();

}

catch (SQLException ex) {

throw new DAOException();

}

}

}

public void updateHqsunit(HqsunitTO hqsunit) throws DAOException {

Connection connection = null;

PreparedStatement pStatement = null;

try {

connection = getConnection();

// Prepare a statement to insert a record

pStatement = connection.prepareStatement(UPDATE_HQSUNIT_SQL);

pStatement.setInt(1, hqsunit.getDisentity());

pStatement.setString(2, hqsunit.getUic());

pStatement.setString(3, hqsunit.getName());

pStatement.setInt(4, hqsunit.getRadio());

pStatement.setString(5, hqsunit.getAlias());

pStatement.setString(6, hqsunit.getTfAddress());

pStatement.setString(7, hqsunit.getDevice());

pStatement.setString(8, hqsunit.getHqsObserver());

pStatement.setInt(9, hqsunit.getGridzone());

pStatement.setInt(10, hqsunit.getMmEast());

pStatement.setInt(11, hqsunit.getMmNorth());

pStatement.setString(12, hqsunit.getIType());

pStatement.setString(13, hqsunit.getCommo());

pStatement.setString(14, hqsunit.getIpAddress());

pStatement.setString(15, hqsunit.getUrn());

pStatement.executeUpdate();

pStatement.close();

}

catch (SQLException e) {

throw new DAOException();

}

finally {

try {

connection.close();

}

catch (SQLException ex) {

}

}

}

public HqsunitTO getHqsunit(int disentity) throws DAOException {

Connection connection = null;

PreparedStatement pStatement = null;

ResultSet rs = null;

HqsunitTO hqsunit = new HqsunitTO();

try {

connection = getConnection();

// Prepare a statement to insert a record

pStatement = connection.prepareStatement(GET_HQSUNIT_SQL);

pStatement.setInt(1,disentity);

rs = pStatement.executeQuery();

if (rs.next()) {

hqsunit.setDisentity(rs.getInt("disentity"));

hqsunit.setUic(rs.getString("uic"));

hqsunit.setName(rs.getString("name"));

hqsunit.setRadio(rs.getInt("radio"));

hqsunit.setAlias(rs.getString("alias"));

hqsunit.setTfAddress(rs.getString("tfaddr"));

hqsunit.setDevice(rs.getString("device"));

hqsunit.setHqsObserver(rs.getString("hqs_observer"));

hqsunit.setGridzone(rs.getInt("gridzone"));

hqsunit.setMmEast(rs.getInt("mm_east"));

hqsunit.setMmNorth(rs.getInt("mm_north"));

hqsunit.setIType(rs.getString("i_type"));

hqsunit.setCommo(rs.getString("commo"));

hqsunit.setIpAddress(rs.getString("ipaddress"));

hqsunit.setUrn(rs.getString("urn"));

}

rs.close();

pStatement.close();

}

catch (SQLException ex) {

throw new DAOException();

}

finally {

try {

connection.close();

}

catch (SQLException ex) {

}

}

return hqsunit;

}

public void deleteHqsunit(int disentity) throws DAOException {

Connection connection = null;

PreparedStatement pStatement = null;

try {

connection = getConnection();

pStatement = connection.prepareStatement(DELETE_HQSUNIT_SQL);

pStatement.setInt(1, disentity);

pStatement.executeUpdate();

pStatement.close();

}

catch (SQLException e) {

throw new DAOException();

}

finally {

try {

connection.close();

}

catch (SQLException ex) {

}

}

}

public Collection findAll(int disentity) throws DAOException {

Connection connection = null;

PreparedStatement pStatement = null;

ResultSet rs = null;

ArrayList list = new ArrayList();

HqsunitTO hqsunit = new HqsunitTO();

try {

connection = getConnection();

// Prepare a statement to insert a record

pStatement = connection.prepareStatement(LIST_HQSUNIT_SQL);

pStatement.setInt(1,disentity);

rs = pStatement.executeQuery();

while(rs.next()) {

hqsunit.setDisentity(rs.getInt(1));

hqsunit.setUic(rs.getString(2));

hqsunit.setName(rs.getString(3));

hqsunit.setRadio(rs.getInt(4));

hqsunit.setAlias(rs.getString(5));

hqsunit.setTfAddress(rs.getString(6));

hqsunit.setDevice(rs.getString(7));

hqsunit.setHqsObserver(rs.getString(8));

hqsunit.setGridzone(rs.getInt(9));

hqsunit.setMmEast(rs.getInt(10));

hqsunit.setMmNorth(rs.getInt(11));

hqsunit.setIType(rs.getString(12));

hqsunit.setCommo(rs.getString(13));

hqsunit.setIpAddress(rs.getString(14));

hqsunit.setUrn(rs.getString(15));

list.add(hqsunit);

}

return list;

}

catch (SQLException e) {

throw new DAOException();

}

}

}

tclyndella at 2007-7-13 13:47:41 >

So, what you are saying is that my action which currently reads:

<action path="/listHqsunitdata" forward="/pages/hqsunitdata.jsp"/>

needs more in to respond correctly.

I don't know what to add at this point. What guidance do you have? I'm looking at the attributes of the action element, now. What should I add?

Thanks!

Warren

tclyndella at 2007-7-13 13:47:42 >