內容 |
|
Wow, thank you very much andowson
|
|
|
I tried .... and it does not run
|
|
|
I have problem, this is my code :
file GenericCategories.java
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;
}
}
and my Categories.java:
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;
}
}
file Menu.java
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;
}
}
and index.java
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();
}
}
}
I want list categories two level, i need you help, thank you very much ...
|
|
|
Hi, i am learning java servlet + freemarker, and i have a problem like this subject,
This is my source, i want to show all categories in browser like file categories.txt in file testmenu.zip, how can i do next step?? my english is bad , i need your help ...
this is my testmenu.zip
http://www.mediafire.com/?qvq9r3wjg27dhch
thank you very much
|
|
|
In file generic_queries.sql:
UserModel.findByName = SELECT user_id, username, user_email, user_regdate, user_posts, deleted \ FROM jforum_users \ WHERE UPPER(u.username) \ LIKE UPPER(?)
In file GenericUserDAO:
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); } }
In file view/forum/UserAction:
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(); } }
In file user_list.htm (not in admin/user_list.htm):
<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>
|
|
|
Thank you very much, andowson !!
|
|
|
newbiejforum wrote:Hi andowson,
When i add this line in the PostAction.java, and compline to class, i get an error:
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();
I find in WEB-INF\lib ( all .jar file), but this file javax/servlet/ServletOutpitStream.class not found,
How can i do next step ??
thank you very much !!
It is not show new last post title too
|
|
|
Hi andowson,
When i add this line in the PostAction.java, and compline to class, i get an error:
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();
I find in WEB-INF\lib ( all .jar file), but this file javax/servlet/ServletOutpitStream.class not found,
How can i do next step ??
thank you very much !!
|
|
|
Hello everybody, i want to show the groupname in the posts/list..., Ex image
http://www.flickr.com/photos/56316793@N03/5652960036
How can i do that???
thank you very much !!!
|
|
|
my english is bad
Hi andowson and everybody, i like jforum, i using jforum 2.1.9, but this version not show last post title in .../forums/list.. , and I did the following:
In file \WEB-INF\config\database\generic\generic_queries.sql, i edit
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
In file \net\jforum\dao\generic\GenericForumDAO.java, i edit it and compile to class file
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;
}
In file \net\jforum\entities\LastPostInfo.java, i edit it and compile to class file:
/**
* @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;
}
In the forum_list.htm, :
<#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>
I restart tomcat, and it show title , but, when i post a new topic, it show old title (, when i restart tomcat, it show new title,
I need your help, thank you very much :">
|
|
|
|
|