It is not a Struts problem. But, it is the problem I
encounter in my Struts application. Please help. I
am NOT showing all my code. For example, I skip the
DAO interface, and the class that returns a connection
object from the connection pool. Nonetheless, those
classes are irrelevant to my question.
The root of my problem is that I do not know how to
pass data that are wrapped in a business bean in
between classes. THE JAVA COMPILER DOES NOT RECOGNIZE
THE BUSINESS BEAN!
1. I have a controller Servlet that reads the
"username" that is supplied by a visitor of the web
site. I want to search the database by the "username"
and get some information about that user; such as
userrole, category, etc. A business bean sits in
between the controller servlet and the database. Here
is the partial code of the controller servlet:
[code]
// the statement below has problems
EditorBean editorData;
// Obtain username and password from web tier
String username = request.getParameter( username );
// find the editor's information via the business tier
// Again, the parameters that I supplied in the method
below have problems
EditorBean editor = EditorBean.findEditorData(
username, editorData );
// wrap the information found in the database in a
session object and go on
HttpSession session = request.getSession();
editor.setUserrole( request.getParameter( "userrole" )
);
editor.setCategory( request.getParameter( "category" )
);
session.setAttribute( "editor", editor );
[/code]
2. I have this EditorBean class. This EditorBean is a
business bean. I am struggling with how the EditorBean
pass the data in between the controller and the
database.
[code]
import org.apache.artimus.logon.dao.*;
public class EditorBean
{
private String username;
private String userrole;
private String category;
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; }
// the parameters in the method below have problems
public EditorBean findEditorData( String username,
EditorBean editorData )
{
// What do I do here?
ed.findEditor( String username, ?????? );
// I am not sure what to return here
return ?????;
}
}
[/code]
3. Here is my data access class:
[code]
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.exceptions.EditorDAOSysException;
import org.apache.artimus.ConnectionPool.DBConnection;
public class MySQLEditorDAO implements EditorDAO{
// the parameters of the method below have problems
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())
{
// something is wrong in returning the
information about that editor
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;
}
}
}
}
[/code]
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
