Populate JavaBean With Data Fetched From the Database

[JiaPei Jen]

I have a bean. There are three field variables in the bean; username, userrole, and category. "username" is supplied by me. "userrole" and "category" in the bean gets populated by fetching data from the database. I am positive that data are present in the database. However, I got "blanks" when I later on tried to display the properties (userrole and category) of that bean. I would appreciate if anybody could help identifying the problem. The relevant codes are show below:

package org.apache.artimus.logon;
import org.apache.artimus.logon.dao.*;
public class EditorBean {
   private String username;
   private String userrole;
   private String category;
   static EditorDAO ed = new MySQLEditorDAO();
   public EditorBean() {}
   public EditorBean( String username, String userrole, String category )
   {
      setUsername( username );
      setUserrole( userrole );
      setCategory( category );
   }
   public String getUsername() {
      return username;
   }
   public void setUsername( String username ) {
      this.username = username;
   }
   public String getUserrole() {
      return userrole;
   }
   public void setUserrole( String userrole ) {
      this.userrole = userrole;
   }
   public String getcategory() {
      return category;
   }
   public void setCategory( String category ) {
      this.category = category;
   }
   public static EditorBean findEditorData( String username ) 
   {
      return ed.findEditor( username );
   } 
}

My data access code is show below:

package org.apache.artimus.logon.dao;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import org.apache.artimus.logon.EditorBean;
import org.apache.artimus.logon.exceptions.EditorDAOSysException;
import org.apache.artimus.ConnectionPool.DBConnection;
public class MySQLEditorDAO implements EditorDAO
{
   // Here the return type is EditorBean
   public EditorBean findEditor( String username ) 
       throws EditorDAOSysException 
   {
      Connection conn = null;
      Statement stmt = null;
      ResultSet rs = null;
      try 
      {
         conn = DBConnection.getDBConnection();
         stmt = conn.createStatement();
         String query = "SELECT user_role, journal_category FROM members WHERE user_name = '" + username + "'";   
         rs = stmt.executeQuery( query );
         if (rs.next()) 
         {
            return new EditorBean( username, rs.getString( "user_role" ), rs.getString( "journal_category" ) );
         }
         else
         {
            System.out.println( "invalid user name" );
            return null;            
         }
      } 
      catch (SQLException se)
      {
         throw new EditorDAOSysException("SQLException: " + se.getMessage());
      }
      finally
      {
         if ( conn != null )
         {
            try
            {
               rs.close();
               rs = null;
               stmt.close();
               stmt = null;
               conn.close();
            }
            catch( SQLException sqlEx )
            {
               System.out.println( "Problem occurs while closing " + sqlEx );
            }
            conn = null;
         }       
      }
   }
}

[ November 28, 2003: Message edited by: JiaPei Jen ]

[Andres Gonzalez]

I don't see anything wrong with your code (quick look though). What I recommend is to print to the log the values you get from the DB

if (rs.next())          
{            
  //how about printing it here?
  return new EditorBean( username, rs.getString( "user_role" ), rs.getString( "journal_category" ) );         
}

doing that you ensure that you're getting something from the DB, and not empty or null.
hope it helps

[JiaPei Jen]

The data table is created by me. I am positive that every field in the table has a value for every single record.
In my JSP, I am able to display the value of "username". It means that the session object can be found. The JSP does not display anything (it is blank) for "userrole" and "category".

[Gazi Peer]

Check to see whether the fieldnames of your jsp page are one and the same as in the properties of the java bean.

[Craig Jackson]

I agree. I would check and verify that your jsp/property attributeS are in synch with your get/set methods of your bean.
For example, I noticed that that the following methods are different. Because the
getc[atagory is not the same as the setCategory:

public String getcategory() {      
  return category;   
}   
public void setCategory( String category ) {     
 
  this.category = category;
}  

Check that with your jsp page.
Craig