List not found error [Solved] (JSP forum at Coderanch)

Vic Hood

Ranch Hand

Posts: 477

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Friends,
Im trying to develop a CRUD application using JSP's and javabeans , as a start to that I have to use a jstl tag to populate a dropdown box from the database . Im using 2 bean classes and the list is loaded from a particular table. Im trying to store the values that i obtain from the query into a list and then retreive them . Im relative newbie to programming so any help would be appreciated.Thanks!!
My DAO Class.

package com.jspcrud.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.jspcrud.bean.*;

public class DAO {

public static List loadDomainType() throws Exception {
        Connection con = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;
        System.out.println("loadDomaintype DAO");

DomainTypeBean bean = null;
        ArrayList<DomainTypeBean> dtList = new ArrayList<DomainTypeBean>();

try {
            con= DBConnector.getConnection();
            if (con != null){

System.out.println("loadDomaintype DAO try block");

System.out.println("Connected");
                String query= " SELECT CODE,DESCRIPTION,OBJECTID FROM DOMAINTYPE " ;
                stmt = con.prepareStatement(query);
                rs = stmt.executeQuery();
                System.out.println("inside loadDomainType");
                while (rs.next()){
                    bean = new DomainTypeBean();
                    bean.setCode(rs.getString("CODE"));
                    bean.setObjid(rs.getInt("OBJECTID"));
                    bean.setDescription(rs.getString("DESCRIPTION"));
                    
                    System.out.println("DomainType code="+bean.getCode()+", objid="+bean.getObjid()+", description="+bean.getDescription());                  
                    dtList.add(bean);
                }

}
        } catch (SQLException sqe) {
            sqe.printStackTrace();

} finally {
            DBConnector.closeResultSet(rs);
            DBConnector.closeStatement(stmt);
            DBConnector.closeConnection(con);
        
        }

return dtList;
    }

}

JSP file.

My error is..
SEVERE: Servlet.service() for servlet jsp threw exception
org.apache.jasper.el.JspPropertyNotFoundException: /Main.jsp(16,8) '${domaintype.dtList}' Property 'dtList' not found on type com.jspcrud.dao.DAO
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:104)
at org.apache.jsp.Main_jsp._jspx_meth_c_005fforEach_005f0(Main_jsp.java:124)
at org.apache.jsp.Main_jsp._jspService(Main_jsp.java:96)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

Any help would be much appreciated .

Learning and Learning!-- Java all the way!

Vic Hood

Ranch Hand

Posts: 477

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Mike,
Thanks for replying . I changed my DAO class to somewhat like what you said , but the error persists

. Am i missing something more glaring?Please help
The modified code is as below.

package com.jspcrud.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.jspcrud.bean.*;

public class DAO {

public static List getDtList() throws Exception { //changed to getter of 'dtList', yet no respite
        Connection con = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;
        System.out.println("loadDomaintype DAO");

DomainTypeBean bean = null;
        ArrayList<DomainTypeBean> dtList = new ArrayList<DomainTypeBean>();

try {
            con= DBConnector.getConnection();
            if (con != null){

System.out.println("loadDomaintype DAO try block");

System.out.println("Connected");
                String query= " SELECT CODE,DESCRIPTION,OBJECTID FROM DOMAINTYPE " ;
                stmt = con.prepareStatement(query);
                rs = stmt.executeQuery();
                System.out.println("inside loadDomainType");
                while (rs.next()){
                    bean = new DomainTypeBean();
                    bean.setCode(rs.getString("CODE"));
                    bean.setObjid(rs.getInt("OBJECTID"));
                    bean.setDescription(rs.getString("DESCRIPTION"));
                    
                    System.out.println("DomainType code="+bean.getCode()+", objid="+bean.getObjid()+", description="+bean.getDescription());                  
                    dtList.add(bean);
                }

}
        } catch (SQLException sqe) {
            sqe.printStackTrace();

} finally {
            DBConnector.closeResultSet(rs);
            DBConnector.closeStatement(stmt);
            DBConnector.closeConnection(con);
        
        }

return dtList;
    }

}

Learning and Learning!-- Java all the way!

Robin John

Ranch Hand

Posts: 281

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

you can keep the old method name 'loadDomainType' and create "getters and setters" for the variable named "dtList" and move the declaration "Arraylist dtList" outside the method to make it an instance variable.

Time is what we want the most, but what we use the worst. -- William Penn