I have a table "members" in the MySQL database. I am
going to supply a String "editor" and search the
"members" table. All those who are "editor" will be
picked up and their name will enter the array I want
to create.
How do I code it and return this array?
Here is a sketch of my code. I do not have any
confidence in my code. I tend to creat a bean for
this ArrayList.
EditorBean editorList = null;
try
{
conn = DBConnection.getDBConnection();
stmt = conn.createStatement();
String query = "SELECT user_name FROM members
WHERE user_role = '" + userrole + "'";
rs = stmt.executeQuery( query );
if ( start >= 0 && rs.absolute( start + 1 ) )
{
boolean hasNext = false;
List editors = new ArrayList();
do
{
editors.add(new EditorBean(
rs.getString( user_name ) );
} while ( ( hasNext = rs.next() ) && (
--count > 0 ) );
editorList = new EditorBean( editors,
start, hasNext );
}
else
{
editorList = null:
}
return editorList;
}
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
