package com.menu.dao.generic;



import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;



import com.menu.entities.Categories;

import com.menu.entities.Menu;

import com.menu.includes.DBConnect;



public class GenericCategories {

		

	public List SelectAllC() throws Exception {		

		List sac = new ArrayList();

		

		PreparedStatement ps = null;	

		ResultSet rs = null;

		PreparedStatement ps1 = null;	

		ResultSet rs1 = null;

		DBConnect db = new DBConnect();

		Connection con = db.getConnect();

		

		String sql = "SELECT id, category FROM categories";

		

		try {

			ps = con.prepareStatement(sql);

			rs = ps.executeQuery();		

			

			while(rs.next()){	

				Categories c = new Categories();

				

				c.setCategory(rs.getString("category"));

				c.setId(rs.getInt("id"));

				

				String sql2 = "SELECT m.id, m.menu FROM menu m, categories c WHERE c.id = m.cat AND m.cat = ?";

				ps1 = con.prepareStatement(sql2);

				ps1.setInt(1, c.getId());

				rs1 = ps1.executeQuery();				

				

				while(rs1.next()) {

					Menu m = new Menu();			

					

					m.setMenuid(rs1.getInt("id"));

					m.setMenu(rs1.getString("menu"));					

					

                ///// //     How can i code here ... ////////////

					

				}				

				

				sac.add(c);

			}					

		} finally {

			

		}		

		

		return sac;

	}	

	

}

package com.menu.entities;







public class Categories {

	private int id;

	private String category;	

	

	

	

	public int getId() {

		return id;

	}

	

	public void setId(int id) {

		this.id = id;

	}

	

	public String getCategory() {

		return category;		

	}

	

	public void setCategory(String category) {

		this.category = category;

	}	

}

package com.menu.entities;



public class Menu {

	private int menuId;

	private String menu;

	

	public int getMenuid() {

		return this.menuId;

	}

	

	public void setMenuid(int menuId) {

		this.menuId = menuId;

	}

	

	public String getMenu() {

		return this.menu;

	}

	

	public void setMenu(String menu) {

		this.menu = menu;

	}

}

package com.menu;



import java.io.*;

import java.util.*;



import freemarker.template.*;



import javax.servlet.*;

import javax.servlet.http.*;



import com.menu.dao.generic.GenericCategories;

import com.menu.dao.generic.GenericMenu;



public class Index extends HttpServlet {

private Configuration cfg;

	

	public void init() {

		cfg = new Configuration();

		cfg.setServletContextForTemplateLoading(getServletContext(), "templates");

		cfg.setObjectWrapper(ObjectWrapper.BEANS_WRAPPER);

	}	

	

	public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {

		res.setContentType("text/html");

		res.setCharacterEncoding("utf-8");

		Template t = cfg.getTemplate("demo.html");

		

		Map root = new HashMap();		

		

		GenericCategories gc = new GenericCategories();

		GenericMenu gm = new GenericMenu();	

		

		

		try {			

			root.put("allCategories", gc.SelectAllC());

		} catch (Exception e1) {

			System.out.println(e1);

		}		

		

		Writer out = res.getWriter();

		try {

			t.process(root, out);

		} catch (TemplateException te) {

			te.printStackTrace();

		}

	}

}

UserModel.findByName = SELECT user_id, username, user_email, user_regdate, user_posts, deleted \
        FROM jforum_users \
        WHERE UPPER(u.username) \
        LIKE UPPER(?)

public List findByName(String input, boolean exactMatch)
	{
		List namesList = new ArrayList();

		PreparedStatement p = null;
		ResultSet rs = null;
		try {
			p = JForumExecutionContext.getConnection().prepareStatement(SystemGlobals.getSql("UserModel.findByName"));
			p.setString(1, exactMatch ? input : "%" + input + "%");

			rs = p.executeQuery();
			while (rs.next()) {
				User u = new User();

                              u.setId(rs.getInt("user_id"));
                              u.setUsername(rs.getString("username"));
                              u.setColor(rs.getString("group_color"));
                              u.setEmail(rs.getString("user_email"));
                              u.setRegistrationDate(new Date(rs.getTimestamp("user_regdate").getTime()));
                              u.setTotalPosts(rs.getInt("user_posts"));
                              u.setDeleted(rs.getInt("deleted"));

				namesList.add(u);
			}
			return namesList;
		}
		catch (SQLException e) {
			throw new DatabaseException(e);
		}
		finally {
			DbUtils.close(rs, p);
		}
	}

private void commonData()
	{			
		this.setTemplateName(TemplateKeys.USER_LIST);		
	}
        
public void search()
	{
		String search = this.request.getParameter("username");		
		
		if (search != null && !"".equals(search)) {
            List users;
			users = DataAccessDriver.getInstance().newUserDAO().findByName(search, false);
			
			this.commonData();
			
			this.context.put("users", users);
			this.context.put("search", search);
		}		
		else {
			this.list();
		}
	}

<table width="100%">        
        <tr>
		<td class="gen" align="center">
			<form id="formusersearch" action="${JForumContext.encodeURL("/jforum")}" accept-charset="${encoding}" method="post">
			<span class="gensmall">
			${I18n.getMessage("User.searchByUsername")}: 
			<input type="hidden" name="action" value="search" />
			<input type="hidden" name="module" value="${moduleName}" />

			<input type="text" name="username" value="${search?default("")}" />

			<input type="submit" value="${I18n.getMessage("ForumBase.search")}" class="mainoption"/>
			</form>
		</td>
	</tr>
        
</table>

PostAction.java:1052: cannot find symbol
symbol : variable StringUtils
location: class net.jforum.view.forum.PostAction
if (StringUtils.isBlank(p.getSubject())) {
^
PostAction.java:1437: cannot access javax.servlet.ServletOutputStream
class file for javax.servlet.ServletOutputStream not found
os = response.getOutputStream();

ForumModel.lastPostInfo = SELECT post_time, p.topic_id, t.topic_replies, post_id, u.user_id, username, t.topic_title \
FROM jforum_posts p, jforum_users u, jforum_topics t, jforum_forums f \
WHERE t.forum_id = f.forum_id \
AND t.topic_id = p.topic_id \
AND f.forum_last_post_id = t.topic_last_post_id \
AND t.topic_last_post_id = p.post_id \
AND p.forum_id = ? \
AND p.user_id = u.user_id \
AND p.need_moderate = 0

if (rs.next()) {
lpi.setUsername(rs.getString("username"));
lpi.setUserId(rs.getInt("user_id"));

final SimpleDateFormat sdf = new SimpleDateFormat(SystemGlobals.getValue(ConfigKeys.DATE_TIME_FORMAT), Locale.getDefault());
lpi.setPostDate(sdf.format(rs.getTimestamp("post_time")));
lpi.setPostId(rs.getInt("post_id"));
lpi.setTopicId(rs.getInt("topic_id"));
lpi.setPostTimeMillis(rs.getTimestamp("post_time").getTime());
lpi.setTopicReplies(rs.getInt("topic_replies"));
lpi.setTitle(rs.getString("topic_title"));
lpi.setHasInfo(true);


// Check if the topic is consistent
TopicDAO topicDao = DataAccessDriver.getInstance().newTopicDAO();
Topic topic = topicDao.selectById(lpi.getTopicId());

if (topic.getId() == 0) {
// Hm, that's not good. Try to fix it
topicDao.fixFirstLastPostId(lpi.getTopicId());
}

tryFix = false;
}

/**
* @return Returns the title.
*/
public String getTitle() {
return this.topicTitle;
}

/**
* @param title The title to set.
*/
public void setTitle(final String title) {
this.topicTitle = title;
}

<#assign url = JForumContext.encodeURL("/posts/list/${startPage}${lpi.topicId}") + "#p" + lpi.postId/>
<a href="${url}" class="last_title"><img src="${contextPath}/templates/${templateName}/images/icon_latest_reply.gif" border="0" alt="[Latest Reply]" />${lpi.title}</a>